Atul, You should first try to run the report from the designer itself. As Shafqat mentioned, there should be a verify database and a refresh/update database option. The refresh/update option used to be in the older versions of Crystal Report (not sure if this is still there). If you are able to pull out the report, that would mean that your report's connectivity to the backend is fine. And that the issue is somewhere between the MT and Crystal Report engine. HTH.
Prijit Debnath Product Manager, Remedy A R System BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Shafqat Ayaz Sent: Saturday, July 24, 2010 8:15 AM To: arslist@ARSLIST.ORG Subject: Re: Crystal Report error ** You could also open the report in Crystal and do Verify Database. It is possible that the table name has been messed up in the report, so checking the database will fix the issue. thanks Shafqat Ayaz --- On Fri, 7/23/10, Lammey, Peter A. <peter.a.lam...@espn.com> wrote: From: Lammey, Peter A. <peter.a.lam...@espn.com> Subject: Re: Crystal Report error To: arslist@ARSLIST.ORG Date: Friday, July 23, 2010, 1:18 PM Does your Remedy User client have ODBC use underscores checked? This can be found in the menu Tools -> Options and in the Advanced tab. Also verify that your Remedy application server name is listed in Report Server field (and includes TCP if necessary in the TCP field next to that field). Thanks Peter Lammey ESPN IT Packaging and Automation 860-766-4761 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG</mc/compose?to=arsl...@arslist.org>] On Behalf Of Atul Vohra Sent: Friday, July 23, 2010 2:01 PM To: arslist@ARSLIST.ORG</mc/compose?to=arsl...@arslist.org> Subject: Crystal Report error We are using Business Objects 11.5 with ARS 7.5 When I try to run pre-canned reports in Incident Manager, I get the following eror The table 'HPD_Help_Desk' could not be found. Error in File C:\WINDOWS\TEMP\HPD5fAssigee5fModifed1 {E5FBF338-ED6F-4707-8B9E-E3BA1E0309AB}.rpt: The table could not be found. Have to confess am not a experienced crystal report person so need some help. Thanks _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" Please consider the environment before printing this e-mail. _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"