Error: CrystalDecisions.CrystalReports.Engine.FormulaException: Error in File C:\DOCUME~1\

Hello,

I am having a crystal report using datastored in a dataset. When I select one of items in a dropdownlist, it gives me this error message. Note that I used that code before in another web page using a different crystal report and a different dataSet and it worked successfully, but this time it doesn't work...anyone can tell me what causes this error and how to solve it?

NOTE: I am using a vb code behind in my .aspx page

Error in File C:\DOCUME~1\AM-TK-~1\ASPNET\LOCALS~1\Temp\temp_03ca344b-568e-4ea1-bea8-94f3ef92bbcd.rpt: Error in formula <Record_Selection>. '{StProd2.ItemDescription}' The result of selection formula must be a boolean.

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.FormulaException: Error in File C:\DOCUME~1\AM-TK-~1\ASPNET\LOCALS~1\Temp\temp_03ca344b-568e-4ea1-bea8-94f3ef92bbcd.rpt: Error in formula <Record_Selection>. '{StProd2.ItemDescription}' The result of selection formula must be a boolean.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[FormulaException: Error in File C:\DOCUME~1\AM-TK-~1\ASPNET\LOCALS~1\Temp\temp_03ca344b-568e-4ea1-bea8-94f3ef92bbcd.rpt:Error in formula <Record_Selection>. '{StProd2.ItemDescription}'The result of selection formula must be a boolean.]  . F(String  , EngineExceptionErrorID  )  . A(Int16   , Int32   )  . @.(Int16  ) CrystalDecisions.CrystalReports.Engine.FormatEngine.GetPage(PageRequestContext reqContext) CrystalDecisions.ReportSource.LocalReportSourceBase.GetPage(PageRequestContext pageReqContext) CrystalDecisions.Web.ReportAgent.u(Boolean  N) CrystalDecisions.Web.CrystalReportViewer.OnPreRender(EventArgs e) System.Web.UI.Control.PreRenderRecursiveInternal() System.Web.UI.Control.PreRenderRecursiveInternal() System.Web.UI.Control.PreRenderRecursiveInternal() System.Web.UI.Page.ProcessRequestMain()

Dear Frnd',

It will nice if you provied more info, like in drop you are selecting which report to get or some value on which parameter it get the dataset.

or what are the datatype in database & on report.

Some more detail need to get it root.

Error: connection is busy with results for another hstmt

Good Afternoon. I have a Crystal report that accesses a sql 2000 server. W
hen I run the report twice with the same parrameters. I get the following e
rror:
crystal reports connection is busy with results for another hstmt
As I understand it, this has to do with multiple record sets, and something
to the effect that my report is not consuming everything and therefore leavi
ng a cursor.
And while I understand that for the most part, I can't even begin to think h
ow to troubleshoot the report and find the problem. It's a HUGE report with
excess of 30 subreports. It is designed to only return 1 record, with nume
rous fields from throughout
the database placed on the report. Like I said it has numerous subreports,
and all are linked to the same URN. Anyway, is there anything I can do shor
t of upgrading the server to 2005?
From http://www.developmentnow.com/g/111...server-odbc.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.comafter nearly 30 hours of searching, I finally posted my question here.
What's funny is that 2 hours later I found my answer:
http://support.microsoft.com/kb/173410
From http://www.developmentnow.com/group...
=995268
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com

Error: connection is busy with results for another hstmt

Good Afternoon. I have a Crystal report that accesses a sql 2000 server. When I run the report twice with the same parrameters. I get the following error:
crystal reports connection is busy with results for another hstmt
As I understand it, this has to do with multiple record sets, and something to the effect that my report is not consuming everything and therefore leaving a cursor.
And while I understand that for the most part, I can't even begin to think how to troubleshoot the report and find the problem. It's a HUGE report with excess of 30 subreports. It is designed to only return 1 record, with numerous fields from throughout the database placed on the report. Like I said it has numerous subreports, and all are linked to the same URN. Anyway, is there anything I can do short of upgrading the server to 2005?
From http://www.developmentnow.com/g/111_2007_7_0_0_0/sql-server-odbc.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com
after nearly 30 hours of searching, I finally posted my question here.
What's funny is that 2 hours later I found my answer:
http://support.microsoft.com/kb/173410
From http://www.developmentnow.com/groups/viewthread.aspx?newsgroupid=111&threadid=995268
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com

Error with MSDE with Crystal Report - From VB

Hi groups,
(1) How can i pass MSDE connection Parameter -> Crystal Report from VB...?
Let say, While designing cr.report - the server name & DB name is embedded
in report. But now we removed the server & DB name from the Table Name.
After doing this the report does'nt show anything eventhough we pass the
connection strings from VB.
Is there any solution to achieve my connection with DB from VB.
Mahehskumar.R
"? Mahesh Kumar" wrote:

> Hi groups,
> (1) How can i pass MSDE connection Parameter -> Crystal Report from VB...?
> Let say, While designing cr.report - the server name & DB name is embedded
> in report. But now we removed the server & DB name from the Table Name.
> After doing this the report does'nt show anything eventhough we pass the
> connection strings from VB.
> Is there any solution to achieve my connection with DB from VB.
>
> Mahehskumar.R
>
Try this:
Dim Report As CRAXDRT.Report
Dim crxDBT As CRAXDRT.DatabaseTable
For Each crxDBT In Report.Database.Tables
crxDBT.SetLogOnInfo ServerName, DatabaseName, UserName, Password
Next
Bye
Nedi Freguglia

Error while verifying database on crystal report

I am using crystal report 7 to connect with stored proc on a sybase 11 server. I am getting the following error when tried to refresh the database.
ODBC error:[intersolv][odbc sql server driver]optional feature not implemented. Error in parameter 1.
How can this be resolved? :confused: Stored proc is fine and it runs perfectly when executed. But when refreshed thru the crystal report, I get the error. :( The changes made on the database are not reflected because of this error. :oFor SQL Server database, an error file is created at the location

C:\WINDOWS\Crystal\SQLSvr.err

This file gives the reason for the errors occuring in the report. Check if such a file is created for Sybase. Prob this would help you.

Rashmi