Bring the report up in Crystal, then select Database/verify database from the menu. I suspect this will either fix the problem or give you more information about the problem.
Failing that, I'd create a report from scratch, use the same ODBC driver and point to the same view and create a simple report. Add in the arrival time as a selection criteria, check to see if that will run. Check that you have the latest hotfixes. I believe when I was using version 9, I needed them. Melissa Reed <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 04/23/2007 12:15 PM Please respond to [email protected] To [email protected] cc Subject Re: Error in Crystal Report on form HPD:HelpDesk_SLA The report does not have a subreport and it works great if you don't qualify on Arrival Time. There is something funny about that field that is not allowing the report to run properly. The out of the box SLA Performance reports which also use the same form don't work when qualifying on Arrival Time either. I haven't updated anything with my client or with my report. That's what is making this odd. I obvilously hadn't tested qualifying on that particular field. On Apr 23, 9:37 am, Ben Cantatore <[EMAIL PROTECTED]> wrote: > Query Engine Error makes me think there's a problem with the ODBC driver, > but it sounds like this report was working at one point. If the report > was working, and stopped working after you made a change, my question > would be what exactly did you change? If its the select criteria, cut and > paste it so we can see if there's something wrong with the syntax. > > Does this report have a subreport? Is the subreport dependent on anything > you've changed in the main? > > Melissa Reed <[EMAIL PROTECTED]> > Sent by: "Action Request System discussion list(ARSList)" > <[EMAIL PROTECTED]> > 04/23/2007 10:27 AM > Please respond to > [EMAIL PROTECTED] > > To > [EMAIL PROTECTED] > cc > > Subject > Error in Crystal Report on form HPD:HelpDesk_SLA > > When I try to qualify my report on Arrival Time, I'm getting an error > when I run the report through the client tool (ver 6.3 patch20) or > through Crystal (ver 9). The reports hangs for several minutes and > finally returns the error. > > Tool Error - Query Engine Error > Crystal Error - Query Engine Error: '42S:Driver]Cannot open catalog; > Message number = 94. SERVER NAME' > > (SERVER NAME = our production server name) > > Any clues? If I don't qualify on that field, the report runs fine. > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:"Where > the Answers Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
