Print Page | Close Window

Report not saving database information

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=16655
Printed Date: 21 Apr 2025 at 10:12am


Topic: Report not saving database information
Posted By: mtgwks
Subject: Report not saving database information
Date Posted: 01 Jun 2012 at 8:06am
Hello,

I've created a report in Crystal Reports XI and the report pulls the correct information within the developer app but when I try to view it in the crystal report viewer it says:

"Logon Failed"

It appears the report is not connecting to the database. I've verified all the database credentials are correct, this started happening after I unchecked the "Save Data with Report" option. I need the report to generate current data from the database. I greatly appreciate any advice that can be given.


Replies:
Posted By: Chid
Date Posted: 19 Jun 2012 at 3:47am
Hi,
 
If your getting logon failed that means the report is not connected to the database. Also you have specified that you have done verify database even though your unsuccessful.
 
In the feild explorer select the database and right click on it, please choose "set data source selection" you can find the tables linked to your report. Please select one by one database and see the properties where the table name specified on the above and under the properties are one and the same.
 
If yes then please select the down the database under My Connection (or create a new connection - if the existing database is not there). Please select the table which is already used and try to update by selecting the right table (Select both tables which you have selected from the new connection or my connection and already existing table which is connected to the report) and click on update.
 
If you have n number of tables/query added to the report, please apply the same procedure and then try to run the report once again. Now you will be successful.
 
Regards,
Chid


-------------


Thanks and Regards,
Chid


Print Page | Close Window