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
JDL129Asked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
Can you open the reports in the designer and try a VERIFY DATABASE?

mlmcc
0
 
mlmccConnect With a Mentor Commented:
What version of Crystal?
By the code I am guessing it is CR9

Do the 2 reports that fail have a subreport?

mlmcc
0
 
JDL129Author Commented:
mlmcc!!!  Thanks for the post!!

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
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
JDL129Author Commented:
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
0
 
JDL129Author Commented:
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
0
 
JDL129Author Commented:
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!!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.