Thank you Jiri you led me down the right path. Although all the subreports were from the same table the master report kept failing saying it could not find the table. Made no sense.
I found in the Set Datasource Location that at some point the table name changed from HPD:HelpDesk to HPD_HelpDesk_. That appeared to cause the problem. I did an update on each subreport and of course was required to map fields on subreports 5, 6, and 7. The report is now running automatically from Crystal Reports Server XI !!! Yipppeeee !!! Thanks again for your help, Susan On Fri, Feb 12, 2010 at 8:20 AM, Jiri Pospisil < jiri.pospi...@lchclearnet.com> wrote: > ** > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Please Read The Disclaimer At The Bottom Of This Email > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > > > Susan, > > > > We are definitely running Crystal reports containing a number of > sub-reports higher than just 1 (even using different forms). > > The reports are scheduled to run, but we use Business Objects server rather > than CRS, but not sure how much of a difference this makes. > > I have seen similar issues before and in most cases it was down to the ‘use > underscore’ setting, which in some sub-reports was used while in others was > not. > > To fix this, all sub-reports needed to have the same setting. To correct > the report source, you can use the Set Datasource Location option and login > to Remedy using the correct setting for ‘use underscore’. > > In some cases, even this left a value hanging inside objects such as graphs > or formulas. These then needed to be fixed manually. > > > > Hope this is of some help. > > > > Regards > > Jiri Pospisil > > > > Remedy Specialist > > LCH.Clearnet <http://www.lchclearnet.com/> > > > > > > > > *From:* Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org] *On Behalf Of *Susan Palmer > *Sent:* 11 February 2010 19:30 > *To:* arslist@ARSLIST.ORG > *Subject:* Crystal Reports Server XI running reports with subreports > > > > ** > > Hi Everyone, > > > > We have been using CRS XI for a year now and automatically run between > 60-100 reports each night successfully. Some of the reports do have a > subreport, not a problem. > > > > We have a new summary report which is actually a master with 6 subreports > that runs successfully using CR XI desktop but will NOT run on CRS XI. We > get a 'Table not found error.' All the re(sub)ports are reporting on the > same table. > > > > I've pretty well recreated the whole thing thinking something was > internally wrong with the report. Then I suppressed all the subreports and > make them available one by one bringing the new report object into CRS. > Successful until I reached the report that contained subreport #5. I > thought it was the culprit. So I brought that object only into CRS and it > ran successfully. > > > > I get the error when again it's part of the master report. > > > > This is the first time I've tried to schedule a report with more than 2 > subreports. Does anyone know if there actually is a limit or some setting > to be modified. I have searched everywhere within the tool itself and the > help text. > > > > I even went so far as to go to SAP's support site and submit a 'message' > (they don't even call them issues or problem .. lol ... and anyone who > spends time on that site should receive a medal of honor!). Then the next > day I spent on hour on a remote session doing everything I had already done > with the same results. > > > > This report needs to run every two hours and right now I'm that automation, > but some would say with a flaky clock. > > > > Please shed some light on this if you can. > > > > With appreciation, > > Susan > > > > Susan Palmer > > ShopperTrak > > 200 W Monroe St 11th Floor > > Chicago, IL 60606 > > 312-529-5325 > > 312-502-7687 > > spal...@shoppertrak.com > > > > Crystal Reports Server v11.5 > > Crystal Reports Professional v11.0.0.2 > > Remedy v 7.0.1P2 > > Oracle 10g2 > > > > Separate server with CRS > > Database server separate from application server > > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ > > > ************************************************************************************************* > > > > This email is intended for the named recipient(s) only. Its contents are > confidential and may only be retained by the named recipient(s) and may only > be copied or disclosed with the consent of LCH.Clearnet Limited. If you are > not an intended recipient please delete this e-mail and notify > postmas...@lchclearnet.com. > > > > The contents of this email are subject to contract in all cases, and > LCH.Clearnet Limited makes no contractual commitment save where confirmed by > hard copy. LCH.Clearnet Limited accepts no liability, including liability > for negligence, in respect of any statement in this email. > > > > LCH.Clearnet Limited, Registered Office: Aldgate House, 33 Aldgate High > Street, London EC3N 1EA. Recognised as a Clearing House under the Financial > Services & Markets Act 2000. Reg in England No.25932 > > Telephone: +44 20 7426 7000 Internet: http://www.lchclearnet.com > > > > > ************************************************************************************************* > > > _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"
