JDL129
asked on
SQL Server 2005 Crystal Report is unable to connect: Incorrect log on parameters
Hey guys,
I have about 10 crystal reports that I created in VS 2008 C# version of Crystal Reports. I have a code snippet attached that I run 5 reports by only changing the report name. They use the same stored procedure and the same code except for the report name. Two of the reports give the error: Unable to connect: Incorrect log on parameters.
There must be something wrong with the reports but they work perfectly when run in the Main Report Preview.
Print.txt
I have about 10 crystal reports that I created in VS 2008 C# version of Crystal Reports. I have a code snippet attached that I run 5 reports by only changing the report name. They use the same stored procedure and the same code except for the report name. Two of the reports give the error: Unable to connect: Incorrect log on parameters.
There must be something wrong with the reports but they work perfectly when run in the Main Report Preview.
Print.txt
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
mlmcc!!
Yes, and it shows all the data when I run it in the designer mode. I am creating a new stored procedure. Maybe I just missed a field in the one I am currently using.
Thanks for your assistance!!!!!!!!!! Keep thinking!!!!
Jerry
Yes, and it shows all the data when I run it in the designer mode. I am creating a new stored procedure. Maybe I just missed a field in the one I am currently using.
Thanks for your assistance!!!!!!!!!! Keep thinking!!!!
Jerry
ASKER
mlmcc!!
I created a new stored procedure and created a new label but am still getting the same error.
I changed the name of the report to one that works and it still does. The only thing different in the procedure is the report name. :-(
Keep Thinking!!!
Jerry
I created a new stored procedure and created a new label but am still getting the same error.
I changed the name of the report to one that works and it still does. The only thing different in the procedure is the report name. :-(
Keep Thinking!!!
Jerry
ASKER
mlmcc!!!
What I did to create the report was to replace the fields on a report that was working with the new ones I needed. I haven't a clue why that would work and the new ones wouldn't.
Thanks for the assist!!!
What I did to create the report was to replace the fields on a report that was working with the new ones I needed. I haven't a clue why that would work and the new ones wouldn't.
Thanks for the assist!!!
ASKER
They were all built with whatever CR comes with VS2008 C#.
No subreport on any of the 5 reports. I can just change the report name in the code and three will run correctly and two of them won't. They all have the same data source which is a stored procedure in sql server 2005.
Thanks,
Jerry