OraFAQ Forum: Reports & Discoverer » add fields at different frequencies

Home » Developer & Programmer » Reports & Discoverer » add fields at different frequencies

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

add fields at different frequencies [message #269127]

Thu, 20 September 2007 15:09

deahayes3
Messages: 203
Registered: May 2006

Senior Member

I would like to add values from a field(f_total, in a repeating frame) and place the result in another field (f_grand_total)located in another frequency, is this possible? Is there a way I can do a sum(f_total) and place in f_grand_total?

Report message to a moderator

Re: add fields at different frequencies [message #269139 is a reply to message #269127]

Thu, 20 September 2007 16:13

Soumen Kamilya
Messages: 128
Registered: August 2007
Location: Kolkata

Senior Member

Yes this is possible.
Place a summery column on this record group before designing the Layout of your report and at designing time you can the total sum of the field.

Cheers
Soumen

Report message to a moderator

Re: add fields at different frequencies [message #269300 is a reply to message #269139]

Fri, 21 September 2007 09:57

deahayes3
Messages: 203
Registered: May 2006

Senior Member

Thanks for the reponse but my problem is a little more in debt.
The problem is my field (f_total) the calculation is done in the fields format trigger, not in the data model, is there a way I can place a summary column on the field itself, not the record.

Report message to a moderator

Re: add fields at different frequencies [message #269301 is a reply to message #269300]

Fri, 21 September 2007 10:09

Soumen Kamilya
Messages: 128
Registered: August 2007
Location: Kolkata

Senior Member

Then calculate the summary first and then do the same calculation with the summary result & show that result in the report.

Cheers
Soumen

Report message to a moderator

Re: add fields at different frequencies [message #269367 is a reply to message #269301]

Fri, 21 September 2007 16:59

deahayes3
Messages: 203
Registered: May 2006

Senior Member

Im sorry i am not follwing my field(f_total) actually returns a null value until the format trigger is rendered and the value from the calculation is placed on the report by using srw.set_field_char(0, grand_total), so will using the summary column still work here?

Report message to a moderator

Re: add fields at different frequencies [message #269369 is a reply to message #269367]

Fri, 21 September 2007 17:06

Soumen Kamilya
Messages: 128
Registered: August 2007
Location: Kolkata

Senior Member

Why not?
Summary column works on formula column also.

Cheers
Soumen

Report message to a moderator

Previous Topic:	Lexical reference/parameter
Next Topic:	I Have Problem in Convert Report To PDF Format

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 04 12:13:17 CDT 2024