You may just need to update the "Datasource Location" properties in the sub report and re-save it again.
Check the setting in (Database | Set Datasource Location | Properties) called "Use DSN Default Properties". If the value there is set to "False", try setting it to "True". HTH Leonard Neely. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Friday, May 15, 2009 1:21 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** One other thing I noticed. if I run this from the fat client it works fine. Both the main report and subreport display. If I run it from the Mid tier I am prompted for ID/password for the sub report. Even if I put in proper id/password the window just pops back up again. _____ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lammey, Peter A. Sent: Friday, May 15, 2009 2:50 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** In that sub report are you using a parameter field that is set with List of Values set to "Dynamic"? Thanks Peter Lammey ESPN IT Client Architecture and Automation 860-766-4761 _____ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Friday, May 15, 2009 2:25 PM To: arslist@ARSLIST.ORG Subject: Crystal report Question ** We are using Crystal 10 here for reporting. I recently retired my old server and moved Crystal over to a new server. Everything works Ok except one thing. I have a report which contains a sub report. When I try to run the report I get the pop up below asking for credentials. If I put in a valid ID and password the screen keeps popping back up. The report worked ok on the old server. Other reports (without sub reports) print OK. Anyone point me in the right direction? The pop up says enter your user ID and password for the database used by the sub report: po report Details.rpt there are fields for ID and password. There is also a field for database Name. this field is also blank but is grayed out. Brian Sokol Manager, Desktop Services and IT Customer Care Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 <http://www.scholastic.com/> http://www.Scholastic.com _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _____ Please consider the environment before printing this e-mail. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
