Page 1 of 1

Calculated Fields Disappearing!

Posted: Thu Dec 14, 2006 5:58 pm
by Ann_E_(Guest)
I^m opening a user SQL report created in R&R v10.1.003 to add a new field to the SQL statement. When I click OK to the modified query, I get the message that over 30 calculated fields are going to be removed if I continue. I cancel and they remove anyway. I closed the report without saving then re-opened it. I clicked on one of the many fields -- they are total fields based on calculated fields. The underlying calculated field is no longer in the list. This report still runs just fine and displays all of the calculated fields. The report was last modified six months ago to add a footer and there were no issues at that time. The report is run against an Oracle 9i database. The fields that are disappearing are all on footer band lines. Any ideas what can be done so I can add one new field for my user without losing 30 others?

=> RE: Calculated Fields Disappearing!

Posted: Fri Dec 15, 2006 9:18 am
by Ann_E_(Guest)
By the way, the original fields that the calculated fields are based upon are still in the query.

==> RE: Calculated Fields Disappearing!

Posted: Tue Dec 19, 2006 10:24 am
by kfleming
Do you also see the same error if you go to the Select statement window and simply close it without making any changes?____Kathleen__R&R Support

===> RE: Calculated Fields Disappearing!

Posted: Tue Dec 19, 2006 11:46 am
by Ann_E_(Guest)
No, if I don^t modify the SQL statement, the message about removing fields does not appear. The fields that disappear after the SQL is modified are total fields based on calculated fields. Here^s an example. Total field is clmmedpay: sum(pay_med(), claim_number, every, running). The calculated field pay_med no longer displays in my calculated field list. When it was there, it was based on one of the fields in the SQL statement that is still in the SQL statement. The report still runs correctly when called from our Oracle 9i application, but why did the fields disappear? Is there any way to fix this so I can add a new field to the SQL without starting all over and recreating the 30 or so calculated fields? Is the report corrupt and should be recreated from scratch?

====> RE: Calculated Fields Disappearing!

Posted: Fri Jan 05, 2007 9:07 am
by Ann_E_(Guest)
Any possible solutions outside of recreating the report?

=====> RE: Calculated Fields Disappearing!

Posted: Mon Jan 08, 2007 12:09 pm
by kfleming
Since I have never seen this happen before, it could be a corruption in the particular report so doing a rebuild is probably the only way to solve things.____Kathleen__R&R Support

======> RE: Calculated Fields Disappearing!

Posted: Thu Jul 05, 2007 4:58 pm
by CP_BP
Using R&R 9____After using a complicate [for me] report for several weeks, it stops running [since its backup runs fine, I assume that it has become corrupted]. You mentioned "rebuild" a report. What is the process?

=======> RE: Calculated Fields Disappearing!

Posted: Fri Jul 06, 2007 9:16 am
by kfleming
The process would be to create a new report.____Kathleen__R&R Support