Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Report not saving database information Post Reply Post New Topic
Author Message
mtgwks
Newbie
Newbie


Joined: 11 May 2012
Online Status: Offline
Posts: 1
Quote mtgwks Replybullet Topic: Report not saving database information
    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.
IP IP Logged
Chid
Newbie
Newbie
Avatar

Joined: 19 Jun 2012
Location: India
Online Status: Offline
Posts: 3
Quote Chid Replybullet 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
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.