cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to display data of the formula fields in the reports after pointing to the new database

samratmuddasani
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Experts,

We are using CR XI R2 and recently we have changed the database and pointed to the new database which us Oracle10g. I can run few reports without any issue but few reports are displaying the blank reports as the formula fields are not responding. Can Anyone help me with the reason? Any suggestions to fix it??

Thanks,

Samrat Muddasani

Accepted Solutions (0)

Answers (1)

Answers (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Samrat,

What do you mean by 'formula fields are not responding'?

-Abhilash

samratmuddasani
Product and Topic Expert
Product and Topic Expert
0 Kudos

In the reports there are formula fields which should be displayed in the reports. The reports is unable to display those formula fields.

abhilash_kumar
Active Contributor
0 Kudos

So, you don't get an error messages, just blanks?

Do you have an example formula that doesn't work?

Are those formulae supposed to return values? Are you explicitely handling NULL conditions in those formulas?

-Abhilash

samratmuddasani
Product and Topic Expert
Product and Topic Expert
0 Kudos


No I don't get any error messages.

There are many formulas in the report.

For Eg: maximum({RPRTG_ACTIVITY.ACTY_CNFDC_LVL_CD},{RPRTG_ACTIVITY.NAME})

Yes these formulas are supposed to return values. I'm sorry how to check whether I'm explicitly handling NULL conditions in those formulas or not?

Thanks,

Samrat

abhilash_kumar
Active Contributor
0 Kudos

Is the entire report blank or just these formula fields?

-Abhilash

samratmuddasani
Product and Topic Expert
Product and Topic Expert
0 Kudos

Just the formula fields.. I'm just getting text info on the report.

abhilash_kumar
Active Contributor
0 Kudos

Did you look into one of the {RPRTG_ACTIVITY.NAME} groups and see if this field {RPRTG_ACTIVITY.ACTY_CNFDC_LVL_CD} has any rows with data?

-Abhilash

samratmuddasani
Product and Topic Expert
Product and Topic Expert
0 Kudos

Yes Abhilash. It does have data in that column.

abhilash_kumar
Active Contributor
0 Kudos

Strange. Could you attach this report with saved data if that's possible?

-Abhilash

samratmuddasani
Product and Topic Expert
Product and Topic Expert
0 Kudos

Ya sure... How can I send you coz I don't want to share with everyone..

abhilash_kumar
Active Contributor
0 Kudos

You may send it to my e-mail.

-Abhilash