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"
