First check tools, options and the advance tab to see if the report settings are correct. Do other reports work aside from this one? Query Engine errors tend to be an ODBC Driver issue. Within Crystal, try selecting database then set datasource and repoint your data to the ODBC driver you're using. Save and try reattaching the report. If all else fails, create a very simple report from scratch with one or two fields and see if that will run.
There are issues with certain versions of Remedy and Crystal, but your combination should be ok. I hope this helps, I'm out for tonight. Ben Cantatore Remedy Administrator Avon (914) 935-2946 "Pargeter, Christie" <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 05/31/2007 05:58 PM Please respond to [email protected] To [email protected] cc Subject Re: Crystal Report Not Showing Data ** The original report was in the reporting form. I cleared the attachment then saved. Re-attached and saved. That actually gives me an error "Error in File D:\Docume~1\cpargete\Locals~1\Temp\For Mills.rpt: Query Engine Error" If I copy the RPT file into my ARCMDS folder and open the join then try to display the report I do not get my fields. I even started to recreate the report and it is giving the error message. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ben Cantatore Sent: Thursday, May 31, 2007 2:53 PM To: [email protected] Subject: Re: Crystal Report Not Showing Data ** If the report is embedded in the active link, point to a bogus report, save and then point to the correct report. This will cause the active link to reimport the new version of the report. If the report is being run from the report form, make sure that you've updated the attachment portion. If the above suggestions don't resolve the problem, please identify how the report was originally setup and accessed. Ben Cantatore Remedy Administrator Avon (914) 935-2946 "Pargeter, Christie" <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 05/31/2007 05:25 PM Please respond to [email protected] To [email protected] cc Subject Crystal Report Not Showing Data ** Hi All - I had to delete a join that I had some Crystal reports built against this join. I then recreated the join (with the exact same name) and all the reports are now broken. I have been trying to rebuild these reports from scratch but for some reason the reports are not showing any data when I run them in the user tool. Note there is no search criteria on the report. I then when to the actual join and brought up one record then tried to bring up the Crystal report and it is still not showing any data. Right now the report has 2 fields on it and some static text. The static text is showing but not the fields. Any ideas? The report runs just fine when I use Crystal Developer. ARS 6.3 Crystal 9 Win 2000 ____________________________________________ Christie Pargeter Weyerhaeuser Documentation & Training [EMAIL PROTECTED] Portland, OR tel: 503-553-8512 fax: 503-553-8479 __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
