Some problem, when i implements the CR XI over CR 10.. errors are like.

[Former Member]

Hi all,

Acuatally, when i implemeted the CR XI over CR 10( i used the IDE - IBM WSADIE 5.1.1). i managed properly documentaion all requrements in my project. When run the report, report run successfully but some errors are comes( ifeel formulass errors). All errors are gives belows:

SystemErr R Assertion Failed: Formula context returned the wrong type of value for a field.

[9/3/08 16:45:48:635 IST] 6587706c SystemErr R java.lang.Throwable

[9/3/08 16:45:48:635 IST] 6587706c SystemErr R at com.crystaldecisions.reports.common.j.b.a(Unknown Source)

[9/3/08 16:45:48:635 IST] 6587706c SystemErr R at com.crystaldecisions.reports.formulas.al.if(Unknown Source)

[9/3/08 16:45:48:635 IST] 6587706c SystemErr R at com.crystaldecisions.reports.formulas.ab.if(Unknown Source)

[9/3/08 16:45:48:635 IST] 6587706c SystemErr R at com.crystaldecisions.reports.formulas.al.if(Unknown Source)

[9/3/08 16:45:48:651 IST] 6587706c SystemErr R at com.crystaldecisions.reports.formulas.ab.case(Unknown Source)

[9/3/08 16:45:48:651 IST] 6587706c SystemErr R at com.crystaldecisions.reports.formulas.ab.if(Unknown Source)

[9/3/08 16:45:48:651 IST] 6587706c SystemErr R at com.crystaldecisions.reports.formulas.al.if(Unknown Source)

[9/3/08 16:45:48:651 IST] 6587706c SystemErr R at com.crystaldecisions.reports.formulas.ab.e(Unknown Source)

[9/3/08 16:45:48:651 IST] 6587706c SystemErr R at com.crystaldecisions.reports.formulas.ab.if(Unknown Source)

[9/3/08 16:45:48:651 IST] 6587706c SystemErr R at com.crystaldecisions.reports.formulas.al.if(Unknown Source)

[9/3/08 16:45:48:651 IST] 6587706c SystemErr R at com.crystaldecisions.reports.formulas.al.if(Unknown Source)

[9/3/08 16:45:48:651 IST] 6587706c SystemErr R at com.crystaldecisions.reports.formulas.ab.if(Unknown Source)

[9/3/08 16:45:48:651 IST] 6587706c SystemErr R at com.crystaldecisions.reports.formulas.al.if(Unknown Source)

[9/3/08 16:45:48:651 IST] 6587706c SystemErr R at com.crystaldecisions.reports.formulas.al.if(Unknown Source)

[9/3/08 16:45:48:651 IST] 6587706c SystemErr R at com.crystaldecisions.reports.formulas.ab.if(Unknown Source)

[9/3/08 16:45:48:651 IST] 6587706c SystemErr R at com.crystaldecisions.reports.formulas.al.if(Unknown Source)

[9/3/08 16:45:48:651 IST] 6587706c SystemErr R at com.crystaldecisions.reports.formulas.al.a(Unknown Source)

[9/3/08 16:45:48:651 IST] 6587706c SystemErr R at com.crystaldecisions.reports.formulas.al.if(Unknown Source)

[9/3/08 16:45:48:667 IST] 6587706c SystemErr R at com.crystaldecisions.reports.formulas.al.long(Unknown Source)

[9/3/08 16:45:48:667 IST] 6587706c SystemErr R at com.crystaldecisions.reports.formulas.n.a(Unknown Source)

[9/3/08 16:45:48:667 IST] 6587706c SystemErr R at com.crystaldecisions.reports.formulas.FormulaInfo.for(Unknown Source)

[9/3/08 16:45:48:667 IST] 6587706c SystemErr R at com.crystaldecisions.reports.formulas.FormulaService.evaluate(Unknown Source)

Now i am help less as much as i trying. Kindly Help me,

Thanks & Regards

Sanjay

[Former Member · Accepted solution]

Hi Ted Ueda,

I checked the Java Reporting Component as suggested by you. I found that the application used JRC of CR 11. The reported error is coming primarily when the report query seeking data from database returns numerical values. The error

is not coming whenever the database query returns string or date data type. It should also be noted that while the reported error comes up in the WSAD 5.1.1 console, the report comes up properly in the application. However, since the thread writing the error in the console is not getting released till all the

errors(one error for every numeric field) are written,I am unable to open a new report.

Thanks & Regards,

Sanjay Biswal

[ted_ueda · Accepted solution]

I would first check the types in your report formulas, and ensure explicit type conversions are being used.

Sincerely,

Ted Ueda

[Former Member]

Hi Ted Ueda,

As per your suggestion, I had saw the formula field in my Report. There are not useing any explicit type conversions. So I am giveing you details, how to crteae the formula in my report and comes errors.

Step 1 : First created the JNDI connection and accepted some fields through Commoand Object.

Step 2 : This Commoand object returns some string and integer type field.

Ex:

Command{

ID Number type

Name String type

Address String type

}

Step 3 : Now, I created the Formula field and inserted the formula field in report.

Ex:

Formula field name : newDatabaseID

contains :

{@commoand.ID}

The Report Page Designe : -

New ID Name Address

{@newDatabaseID} {@commoand.Name} {@commoand.Address}

Step 4 : The report running sucessfuly in CR11 software, but when this report run in my

application, The errors are comes.

Ex : Assertion Failed: Formula context returned the wrong type of value for a field.

Please give your suggestion.

Thanks & Hot Regards,

Sanjay Biswal

[ted_ueda]

There's not much info to go on here.

Are you using the Java Reporting Component version 10 to display XI version Crystal Reports?

Sincerely,

Ted Ueda