467,912 Members | 1,752 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,912 developers. It's quick & easy.

Crystal Reports - .rpt - "Query Engine Error"

[btw -- does anyone know of any plain old CR groups?]

hello,

i have an .RPT file that i am using to load a report via the ASP.NET
CrystalReportViewer control. i dont include my .RPTs as embedded
resources...instead i load the absolute path of the .rpt (on the file
system) to the control's ".ReportSource" property. i do this because i
like to move new versions of the reports w/o having to rebuild the
site.

then i pass in filter criteria to the control's ".SelectionFormula"
property. my reports use an Oracle view as their datasource, and
passing in critieria forumulas allow me to filter returned rows
appropiately.

ive noticed one thing... if i attempt to use a formula criterion that
is a member of the underlying view, but is *not* a field ive included
in the report (via the layout designer) -- then it craps out. the
report fails to load, with:
Query Engine Error: 'D:\projects\xxx\reports\changeHistory.rpt'

Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.

Exception Details:
CrystalDecisions.CrystalReports.Engine.DataSourceE xception: Query
Engine Error: 'D:\projects\xxx\reports\changeHistory.rpt'
....no further info is given. if i remove the offending criterion, or
add its column to the report via the designer, the problem is
eliminated and things work normally.

whaaa? is this expected behavior (ie, is it a feature or a bug?)
thanks!
matt

Nov 20 '06 #1
  • viewed: 8340
Share:
2 Replies
re:
[btw -- does anyone know of any plain old CR groups?]
Try microsoft.public.vb.crystal

Also, see :
news://news.cogniza.com/public.seaga...eports.general
news://news.cogniza.com/public.seaga...s.connectivity
news://news.cogniza.com/public.seaga...ts.programming
news://news.cogniza.com/public.seaga...orts.webaccess

For general CR info, see :
http://aspalliance.com/crystal/

Also, see :
"Licensing and support for Crystal Reports for Visual Studio .NET and for Visual Studio 2005" :
http://support.microsoft.com/kb/317789/

Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
===================================
<ma**@mailinator.comwrote in message news:11**********************@h54g2000cwb.googlegr oups.com...
[btw -- does anyone know of any plain old CR groups?]

hello,

i have an .RPT file that i am using to load a report via the ASP.NET
CrystalReportViewer control. i dont include my .RPTs as embedded
resources...instead i load the absolute path of the .rpt (on the file
system) to the control's ".ReportSource" property. i do this because i
like to move new versions of the reports w/o having to rebuild the
site.

then i pass in filter criteria to the control's ".SelectionFormula"
property. my reports use an Oracle view as their datasource, and
passing in critieria forumulas allow me to filter returned rows
appropiately.

ive noticed one thing... if i attempt to use a formula criterion that
is a member of the underlying view, but is *not* a field ive included
in the report (via the layout designer) -- then it craps out. the
report fails to load, with:
Query Engine Error: 'D:\projects\xxx\reports\changeHistory.rpt'

Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.

Exception Details:
CrystalDecisions.CrystalReports.Engine.DataSourceE xception: Query
Engine Error: 'D:\projects\xxx\reports\changeHistory.rpt'
...no further info is given. if i remove the offending criterion, or
add its column to the report via the designer, the problem is
eliminated and things work normally.

whaaa? is this expected behavior (ie, is it a feature or a bug?)
thanks!
matt

Nov 20 '06 #2

Juan T. Llibre wrote:
Try microsoft.public.vb.crystal
thanks. i saw that, but the "vb" scared me off -- is that group
dedicated to VB windows apps usage? or are general, web, and designer
posts welcomed as well?
Also, see :
news://news.cogniza.com/public.seaga...eports.general
news://news.cogniza.com/public.seaga...s.connectivity
news://news.cogniza.com/public.seaga...ts.programming
news://news.cogniza.com/public.seaga...orts.webaccess
im not sure if ill be able to open anything other than usenet groups,
as im on a locked down work machine. those are the types of groups i
would expect to find on usenet tho (wonder why there arent?), so if i
can ill check them out.
thanks,
matt

Nov 20 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Starbuck | last post: by
reply views Thread by Rob R. Ainscough | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.