I am writing a report that uses alias tables. I am writing the report on the development server and need to move it to the production server. I am displaying report on ASP.Net using C# language.
My problem is that the production server doesn't recognize the alias table names. I have this code in the RunReport.cs
crTable.ApplyLogOnInfo(logOnInfo);
crTable.Location = crTable.Name;
I get an error that it doens't recognize the table. I am assuming this is because I am using alias user_1, when the actual table name is user. I have to use alias's for most of my reports because I have a user who is a manager, and a user who is assigned something therefore both user tables have to point to something different.
I hope I explained this right, please help if you can.
Thank You
My problem is that the production server doesn't recognize the alias table names. I have this code in the RunReport.cs
crTable.ApplyLogOnInfo(logOnInfo);
crTable.Location = crTable.Name;
I get an error that it doens't recognize the table. I am assuming this is because I am using alias user_1, when the actual table name is user. I have to use alias's for most of my reports because I have a user who is a manager, and a user who is assigned something therefore both user tables have to point to something different.
I hope I explained this right, please help if you can.
Thank You