problem with formula column in reports

[bilalch]

hi dear frends,

plz help. i've a field named "F_1" in the report
i want this field to display the product of two columns
named "QTY1" & "PRC1". for this i've created a formula column "CF_1" which " return :QTY1*RC1 " and "F_1" is sourced by "CF_1", but when i run the report it returns error.(i've three such fields in the report F_1,F_2,F_3)

rep-1517 : column CF_1 references column QTY1 which has incompatible frequency.

i'm unable to resolve this problem plz help me.

thanx
bye

 

[malleykr]

Make sure that the placement of your CF field in the data model allows it to see the data it is using in the formula. For example, if your QTY1 and PRC1 fields are within the G_SALES group, try putting the CF field within the G_SALES group as well.

Good luck.

 

[bilalch]

thanx malleykr, it's working now.

can u tell me plz wut's the placeholder column for and also abt the summary column.

bye
thanks again

 

[malleykr]

Summary columns are what they sound like - a column that contains the sum of one of the other columns. Say you have a field F_TOTAL that is a column formula that multiplies QTY and PRICE. You could create a summary column CS_GRAND_TOTAL that sums the F_TOTAL field. Then you could put the CS_GRAND_TOTAL field outside of the repeater that contains the F_TOTAL field to allow something like this:

Item         Qty    Price      Total
Widget #1    2      $12.00     $24.00
Widget #2    3      $10.00     $30.00

                  Grand Total: $54.00

I've never used placeholder columns, but here is what Oracle has to say about them:

A placeholder is a column for which you set the datatype and value in PL/SQL that you define. Placeholder columns are useful when you want to selectively set the value of a column (e.g., each time the nth record is fetched, or each time a record containing a specific value is fetched, etc.). You can set the value of a placeholder column in the following places:

- the Before Report Trigger, if the placeholder is a report-level column
- a report-level formula column, if the placeholder is a report-level column
- a formula in the placeholder's group or a group below it (the value is set once for each record of the group)