I have done a verify database. It says the database is up to date. I have created the report from scratch and it doesn't work for Arrival Time either. I will check about the Crystal hotfixes. Although, everything else with Crystal works just fine.
On Apr 23, 12:33 pm, Ben Cantatore <[EMAIL PROTECTED]> wrote: > 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 atwww.arslist.orgARSlist:"Where > the Answers Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:"Where the > Answers Are"- Hide quoted text - > > - Show quoted text - _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
