Showing posts with label note. Show all posts
Showing posts with label note. Show all posts

Thursday, March 29, 2012

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.

Friday, February 24, 2012

Error While starting SQL Server 2000

Im getting this error when starting the Mssql server 2000
SuperSocket Info: Bind failed on TCP port 1433.
please advise
also note thta it is only MSDE not the whole SQL Sever
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/Connect-Erro...ict195117.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=660630
Hi
Looks like something else is listening on port 1433 by the time you are
trying to start the service.
Before you start MSDE, run "NETSTAT -a"to see what is listening on 1433.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"mujeeb" <UseLinkToEmail@.dbForumz.com> wrote in message
news:1109uoa2fg07p33@.news.supernews.com...
> Im getting this error when starting the Mssql server 2000
> SuperSocket Info: Bind failed on TCP port 1433.
> please advise
> also note thta it is only MSDE not the whole SQL Sever
> --
> Posted using the http://www.dbforumz.com interface, at author's request
> Articles individually checked for conformance to usenet standards
> Topic URL:
http://www.dbforumz.com/Connect-Erro...ict195117.html
> Visit Topic URL to contact author (reg. req'd). Report abuse:
http://www.dbforumz.com/eform.php?p=660630
|||"Mike Epprecht" wrote:
> Hi
> Looks like something else is listening on port 1433 by the
> time you are
> trying to start the service.
> Before you start MSDE, run "NETSTAT -a"to see what is
> listening on 1433.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "mujeeb" <UseLinkToEmail@.dbForumz.com> wrote in message
> news:1109uoa2fg07p33@.news.supernews.com...
> standards
> http://www.dbforumz.com/Connect-Erro...ict195117.html
> abuse:
> http://www.dbforumz.com/eform.php?p=660630
I did all that and the netstat part of output is here
TCP 193.9.200.243:1361 193.9.200.244:139 TIME_WAIT
TCP 193.9.200.243:1363 193.9.200.51:139 TIME_WAIT
TCP 193.9.200.243:1383 193.9.200.244:139 TIME_WAIT
TCP 193.9.200.243:1433 0.0.0.0:0 LISTENING
UDP 0.0.0.0:135 *:*
UDP 0.0.0.0:445 *:*
UDP 0.0.0.0:1026 *:*
UDP 0.0.0.0:1434 *:*
regards

Error While starting SQL Server 2000

Im getting this error when starting the Mssql server 2000
SuperSocket Info: Bind failed on TCP port 1433.
please advise
also note thta it is only MSDE not the whole SQL Sever
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/Connect-Err... />
95117.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz
.com/eform.php?p=660630Hi
Looks like something else is listening on port 1433 by the time you are
trying to start the service.
Before you start MSDE, run "NETSTAT -a"to see what is listening on 1433.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"mujeeb" <UseLinkToEmail@.dbForumz.com> wrote in message
news:1109uoa2fg07p33@.news.supernews.com...
> Im getting this error when starting the Mssql server 2000
> SuperSocket Info: Bind failed on TCP port 1433.
> please advise
> also note thta it is only MSDE not the whole SQL Sever
> --
> Posted using the http://www.dbforumz.com interface, at author's request
> Articles individually checked for conformance to usenet standards
> Topic URL:
http://www.dbforumz.com/Connect-Err...pict195117.htmlreen">
> Visit Topic URL to contact author (reg. req'd). Report abuse:
http://www.dbforumz.com/eform.php?p=660630|||"Mike Epprecht" wrote:
> Hi
> Looks like something else is listening on port 1433 by the
> time you are
> trying to start the service.
> Before you start MSDE, run "NETSTAT -a"to see what is
> listening on 1433.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "mujeeb" <UseLinkToEmail@.dbForumz.com> wrote in message
> news:1109uoa2fg07p33@.news.supernews.com...
> standards
> http://www.dbforumz.com/Connect-Err...17.htm
l
> abuse:
> http://www.dbforumz.com/eform.php?p=660630
I did all that and the netstat part of output is here
TCP 193.9.200.243:1361 193.9.200.244:139 TIME_WAIT
TCP 193.9.200.243:1363 193.9.200.51:139 TIME_WAIT
TCP 193.9.200.243:1383 193.9.200.244:139 TIME_WAIT
TCP 193.9.200.243:1433 0.0.0.0:0 LISTENING
UDP 0.0.0.0:135 *:*
UDP 0.0.0.0:445 *:*
UDP 0.0.0.0:1026 *:*
UDP 0.0.0.0:1434 *:*
regards