[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
2  8617 
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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Starbuck |
last post by:
OK, first let me say that I am no DB person.
But I have a user here who keeps getting this error
whenever she does, whatever it is she does, with
databases...
A google search takes me to...
|
by: Rob R. Ainscough |
last post by:
Can anyone tell me how to debug this error?
I'm using VB.NET 2003 with CR.NET 2003 (came with VS.NET) -- I've used:
Try
cr_Report.ReportSource = m_SourceReport
Catch ex As Exception
...
|
by: Mike Bridge |
last post by:
I am using MS Access 2003, and I typed in a query in SQL view which was working fine. Now when I open it, it gives me
the error "Join expression not supported". Apparently, Access "fixed" it for...
|
by: drisso |
last post by:
Hello,
I have searched that error on these message boards, msdn and
crystaldecisions.com. I found tutorials that showed how to export a
crystal report to pdf, but like many others I am getting...
|
by: touf |
last post by:
Hi,
I'm having this error when I try to open a report (Crystal reports) on the
client machine (It works fine on my developpement machine)
It's a window application (not a web), On the client...
|
by: Florian G. Pflug |
last post by:
Hi
Since sometime yesterday, my postgresql (7.4.5) reports
"ERROR: cannot compare arrays of different element types",
when I analyze a specific table in my database.
Here is the tables...
|
by: Hardy Wang |
last post by:
Hi,
I have a console application to export crystal reports result to PDF.
For one of my report file, when i call Export() function from my code, I get
"unknown query engine error". I have Crystal...
|
by: AccessIdiot |
last post by:
Hi all,
I have this function in an unbound textbox on my form:
=DSum("SpecimenCount","tbl_Specimen_Entrainment","Entrainment_ID = " & )
It does a wonderful job, except when I go to a new...
|
by: Sunshine |
last post by:
The report generated correctly into the rpt but the abover error
appeared when the report was exported (through crystal) into excel.
Exporting into pdf worked as well. After two days of searching...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM)
The start time is equivalent to 19:00 (7PM) in Central...
|
by: Aliciasmith |
last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
|
by: tracyyun |
last post by:
Hello everyone,
I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
|
by: NeoPa |
last post by:
Hello everyone.
I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report).
I know it can be done by selecting :...
|
by: Teri B |
last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course.
0ne-to-many. One course many roles.
Then I created a report based on the Course form and...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM)
Please note that the UK and Europe revert to winter time on...
|
by: nia12 |
last post by:
Hi there,
I am very new to Access so apologies if any of this is obvious/not clear.
I am creating a data collection tool for health care employees to complete. It consists of a number of...
|
by: NeoPa |
last post by:
Introduction
For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
|
by: isladogs |
last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, Mike...
| |
