I installed today. Reports without parameters run fine. Reports with parameters in supreports when viewed in Crystal look good. When run through CRD there is no data. I am not getting any db errors. I am entering my db connection info for report and subreports and entering parameters for each subreport. Any clue? Help is appreciated.
The report is five subreport in add in five detail sections. The remainder of the report does not call the db. Just showing standard fields, date, time, company info. These fields do populate.
I will try a few more export options. Been trying only with PDF.
sorry dave. not a good post on my part. main report uses only standard fields within crystal like test, print time, page number etc. This populates fine.
None of the subreport data comes through. One thing I can tell you is that my connection for the main report DID NOT work until I took out the server name and db name. I have tried doing the same on the subreports, but it does not seem to want to hold the setting (once i open it to see if the setting is saved the server name and db name are back in the fields).
I am not sure that the problem is actually to do with CRD. I think it is to do with your ODBC connection. I have seen this before. Are you connecting to a SQL server database?
If so, check that the default database in the ODBC is not left as "Master" and is definitely set to the database you want to connect to. Also, if possible, use NT authentication or trusted connection in the ODBC. Then delete credentials and uncheck the option in CRD.
This fixed it for me. I have discovered that the CRD database credentials are for when you are using native Crystal connectivity (i.e. not through an ODBC connection). If you are using ODBC, then the ODBC driver does all the work - in terms of security and connectivity so that's where to look first.