asked on

Crystal Report Error formula when change from indows 2000 professional to Windows 2000 server.

Dear developper,

I have successed creating my web appliaction in Windows 2000 professionnal and it work well. It can display my report that I have done in Crystal Report. I have builded a web setup to deploye this application on other server(Windows 2000 professionnal). Great I got sucess to deploy it on that new server. But I got an error of formula in CR when I install and run it on Windows 2000 server. I try to take the original source that I use to build that setup file to rebuild in Windows 2000 server but I still get the same error.

The following message are the error that I got when I try to open page contained Crystal Report :

Server Error in '/AirportSca' Application.
--------------------------------------------------------------------------------

Error in File C:\WINNT\TEMP\temp_ae14af68-27c6-4ba6-97d2-080dd6f9ef90.rpt: Error in formula <Total_Kh_Passenger>. 'If isnull({#nb_total_kh_passenger_notblanck}) AND isnull({#nb_total_kh_passenger_blanck}) then ' String length is less than 0 or not an integer.
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:\WINNT\TEMP\temp_ae14af68-27c6-4ba6-97d2-080dd6f9ef90.rpt: Error in formula <Total_Kh_Passenger>. 'If isnull({#nb_total_kh_passenger_notblanck}) AND isnull({#nb_total_kh_passenger_blanck}) then ' String length is less than 0 or not an integer.

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:\WINNT\TEMP\temp_ae14af68-27c6-4ba6-97d2-080dd6f9ef90.rpt:
Error in formula <Total_Kh_Passenger>.
'If isnull({#nb_total_kh_passenger_notblanck}) AND isnull({#nb_total_kh_passenger_blanck}) then
'
String length is less than 0 or not an integer.]
.K(String
, EngineExceptionErrorID ) +610
.F(Int16 , Int32 ) +491
CrystalDecisions.CrystalReports.Engine.FormatEngine.GetLastPageNumber(ReportPageRequestContext reqContext) +187
CrystalDecisions.ReportSource.LocalReportSourceBase.GetLastPageNumber(ReportPageRequestContext reqContext) +174
CrystalDecisions.Web.ReportAgent.get_LastPageNumber() +34
CrystalDecisions.Web.ReportAgent.v(Boolean `) +90
CrystalDecisions.Web.CrystalReportViewer.OnPreRender(EventArgs e) +108
System.Web.UI.Control.PreRenderRecursiveInternal() +62
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Page.ProcessRequestMain() +1447

I do need your help,

Best regards,
Veasna

Dabas

Hi veasnamuch:
Please give more information about #nb_total_kh_passenger_notblanck
Type?

Dabas

veasnamuch

ASKER

Ok, I will tell you in detail about #nb_total_kh_passenger_notblanck. In fact #nb_total_kh_passenger_notblanck is "running total field" which is calculate the "Count" function. The same for #nb_total_kh_passenger_blanck.

My main idea is to eliminate ,00 at the end the Total_Kh_Passenger when it is display.
I have place a Text Field on a report by putting a Formula Fields named "Total_Kh_Passenger" which have a formule like this :

If isnull({#passenger_total_kh_null}) AND isnull({#passenger_total_kh_notnull}) then
"0"
Else
If isnull({#passenger_total_kh_null}) Then
left(cstr(-{#passenger_total_kh_notnull}),instr(cstr(-{#passenger_total_kh_notnull}),",")-1)
Else
If isnull({#passenger_total_kh_notnull}) Then
left(cstr(-{#passenger_total_kh_null}),instr(cstr(-{#passenger_total_kh_null}),",")-1)
Else
left(cstr({#passenger_total_kh_null}-{#passenger_total_kh_notnull}),instr(cstr({#passenger_total_kh_null}-{#passenger_total_kh_notnull}),",")-1)

I got succcessed in running these formula on Windows 2000 professional but not for Windows 2000 server.

Dabas

veasnamuch:
I do not think that the problem is OS related, rather in the data behind the report.
When you ran it successfully, were you accessing the same data?

But apart from that, if what you want is to change the display, would you not be able to do so by formatting your formula?

Dabas

veasnamuch

ASKER

I am agree on your idea but as you know I am new to Crystal Report and I don't know where shoud I do to perform that formating.
Could you guide me the right way to do that?.

Best regards,
Veasna

ASKER CERTIFIED SOLUTION

Dabas

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

veasnamuch

ASKER

Ok, I a gree on what you said. This would be in case where the field we want to format is the type number. In fact the Total_Kh_Passenger is a formula not a DataSet field and this formula I put it in a TextField.
When I right click on that Field I didn't see the Number Tab.

Regards,

Veasna

Dabas

veasnamuch:
what is the formula inside Total_KH_Passenger?

Dabas

Bob Learned

No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:

Accept: Dabas {http:#9863338}

Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

TheLearnedOne
EE Cleanup Volunteer