Monday, September 15, 2008

Login Error in subreports with Crystal Reports

I am a fan of crystal reports. When ever it is feasible i want to use the Crystal report in my .net application whether it is window or web application. 
While working with one of my window application i got this weird error. It ask me for login in the database. That also happened with my reports which i changed recently.  The reports were working good till they were on my development system. It started giving problem when they are deployed on client machine. 
My client enviourment we have VS 2008 IDE too. So i opened the Report and went in the Dataset and check if it is pointing to correct XSD or not. I am using XSD (Type data set) in  all my crystal reports. Now when i click on the verify database the message came up "Data base is up to Date" . But after that the message box came up for selecting the XSD. I have selected the XSD and then the report start working as expected. 
With all these exercise i came to know that there is some problem with the XSD. The only way to find out the problem is this way
1) Open the .rpt file
2) Go to field Explorer
3) Right Click on database field and then Database Expert
4) Create New connection 
5) Click On ADO.net 
6) It will ask you to select the class
7) If you have some table already  selected then you can just right click the table and see the properties. if Visual Studio Data Class name  is set for the Local directory something like c:\project..
that is the root of the problem. So you have to make it from the project not from the local directory.

 

No comments: