Maybe a simple Mid Tier Flush cache will do the trick?
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 Nicky Madjarov Sent: Monday, May 18, 2009 12:40 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** .... and the midtier must have access to the crystal's report directory - shared access, etc. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com ----- Original Message ----- From: Lammey, Peter A.<mailto:peter.a.lam...@espn.com> Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Sent: Monday, May 18, 2009 12:19 PM Subject: Re: Crystal report Question ** Ah...I think I know. The Mid Tier has its own storage of the reports from the Report form I think. I havent worked with the Mid Tier setup for web reporting much but I think that might be your issue. I think when you configure the Crystal Enterprise server to run reports from the web there is a Reports directory on the server that will store the reports locally on that server. 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: Monday, May 18, 2009 10:48 AM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** Ok it was set to False. I changed it to true. When I went to make this change I was prompted for credentials. I logged in and made the change. I ten went into the Report form and deleted the old attached report and attached the new version. After that it still works in the fat client but not the Mid Tier. the sub report is still asking to log in. even if I give my credentials it prompts again and does not load the sub report. Any other ideas? I don't see why it would work in the fat client but not the web. ________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Leonard Neely - FOJ Sent: Saturday, May 16, 2009 4:42 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** 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"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _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"