Crystal Report Problems ?
-
Hello, Plz go through this and let me know the answer. This problem deals with asp.net,c#,Crystal reports,Sql Server 1.My first problem is i have to create an report in asp.net application by passing parameters to a stored procedure, and i have to call this report in windows C# application. 2.My second problem is when i am executing the exe in some other system it is not working. In my first problem I am getting the error u can't add more than one table/storedprocedure when i am calling this report in c# windows application(where both this stored procedure and table r already added in webapplication (becz in my stored procedure i have to pass table name as parameter and i am retreiving some values from stored procedure so i have to get both stored procedure and table ). It is prompting that the table is not available can i remove it if i say yes now the report is executing but no records can be seen becz all the fields on the report are brought from this table if i say no "i am getting an error table not found". So what i did is i just created an stored procedure with hard coded values and now i am able to generate the report and i got the exe file.Now if i am executing this exe file on some other system of different server.Its not working becz i cant change the servername which is in disabled state just its prompting only for userid and password if i give this userid and password it is prompting the message "Invalid password". I came to a conclusion regarding my second problem that is executing the exe file on other server that i should take the servername,userid and password dynamically. I cant understand onemorething i.e i am setting the servername,userid,password at the time of report creation i.e selecting add/remove database there i am setting the servername userid ,password and geting the fields onto the report now how can we change the servername,username,password at runtime and get it. Somewhere i have seen that they have taken .XSD file and they have taken the dynamic logon info and binded th table to this .xsd and this .xsd is binded to the report but this is working fine. plz let me know the answer as soon as possible i can understand the difficulties Thanks and best regards, |Muhamad Waqas Butt| waqasb4all@yahoo.com www.sktech.freewebspace.com
-
Hello, Plz go through this and let me know the answer. This problem deals with asp.net,c#,Crystal reports,Sql Server 1.My first problem is i have to create an report in asp.net application by passing parameters to a stored procedure, and i have to call this report in windows C# application. 2.My second problem is when i am executing the exe in some other system it is not working. In my first problem I am getting the error u can't add more than one table/storedprocedure when i am calling this report in c# windows application(where both this stored procedure and table r already added in webapplication (becz in my stored procedure i have to pass table name as parameter and i am retreiving some values from stored procedure so i have to get both stored procedure and table ). It is prompting that the table is not available can i remove it if i say yes now the report is executing but no records can be seen becz all the fields on the report are brought from this table if i say no "i am getting an error table not found". So what i did is i just created an stored procedure with hard coded values and now i am able to generate the report and i got the exe file.Now if i am executing this exe file on some other system of different server.Its not working becz i cant change the servername which is in disabled state just its prompting only for userid and password if i give this userid and password it is prompting the message "Invalid password". I came to a conclusion regarding my second problem that is executing the exe file on other server that i should take the servername,userid and password dynamically. I cant understand onemorething i.e i am setting the servername,userid,password at the time of report creation i.e selecting add/remove database there i am setting the servername userid ,password and geting the fields onto the report now how can we change the servername,username,password at runtime and get it. Somewhere i have seen that they have taken .XSD file and they have taken the dynamic logon info and binded th table to this .xsd and this .xsd is binded to the report but this is working fine. plz let me know the answer as soon as possible i can understand the difficulties Thanks and best regards, |Muhamad Waqas Butt| waqasb4all@yahoo.com www.sktech.freewebspace.com
Well ai didnt exactly get the hang of your problem , but creating a Crystal Report in AS.Net using stored procedures is not so much of a problem. You just have to use the report expert , which will automatically look at the output of you Stored proc and then retrieve the values . the only work involved is placing the fields on the report...And if you are accessing the same DB server from all machines ( provided these machines has access to the DB server ) there wont be any error or anything because the credentilas you gave at design time will always work..