M
matt
[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.DataSourceException: 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
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.DataSourceException: 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