Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Problems with SQL Report and Access Sub Report Post Reply Post New Topic
Author Message
flanman
Senior Member
Senior Member
Avatar

Joined: 04 Nov 2009
Online Status: Offline
Posts: 123
Quote flanman Replybullet Topic: Problems with SQL Report and Access Sub Report
    Posted: 28 Dec 2009 at 2:46pm
I have a report I created that uses MS Sql and it works fine. I created a sub report that pulls data from a local Access DB and that works fine. When I test the final report with both in Crystal that works fine and I get all my data. However, I am testing several 3rd party viewers for my users that allows them to view and refresh the reports data since Crystal's own viewer will not allow refreshing of data. When I open the final report in the viewer I am now getting prompted for a login into the Access DB. I have not ever created a login and never asked for it when I run it in Crystal itself. I am also prompted for the login into the SQL for the first report, which is normal and that works fine. What is even stranger is if I run the sub report alone in the 3rd party viewer it works fine without any login prompts.  I have downloaded and tested three different 3rd party viewers and I am having the same issue with all of them.  Currently the reports, access file, Crystal reports, and the 3rd party viewer are all local on my workstation. There are no links between any fields or data between the main and sub-report.  Has anyone seen this before, or have any suggestions on how to fix this?

Thanks,

Flanman
IP IP Logged
flanman
Senior Member
Senior Member
Avatar

Joined: 04 Nov 2009
Online Status: Offline
Posts: 123
Quote flanman Replybullet Posted: 29 Dec 2009 at 7:41am
I actually found another third party crystal reports viewer that works fine with this report and does not prompt for any type of login for the access file. I am all set.

flanman
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.