Home » Developer & Programmer » Reports & Discoverer » Resseting Place Holder Value (Report 6i)
Resseting Place Holder Value [message #409055] Fri, 19 June 2009 02:01
Messages: 28
Registered: March 2008
Location: Mumbai ,India
Junior Member
Hi All,
I have one report which contains three group
1] Main Group
Here i fetch customer related info.
CP_Cost,CP_Rev,CP_GOP Placeholder
2] Revenue group
Which calculates revenue related to file number found in main query.
Total Revenue is calucalated using summary column CS_Total_revenue
then this CS_Total_revenue value stored in to CP_Rev column

3] Cost Group
Which calculates cost related to file number found in main query.
Total Cost is calualateed using summary column CS_Total_Cost
then this value is stored in to CP_cost column

And CP_GOP =CP_Rev-CP_Cost

Now my problem is
For perticular customer there is revenue value but cost value is not there.
In that casewhile calulating GOP by GOP formula ,it taking CP_cost Value from Previous customer.
SO now i have to reset this Placeholder value of CP_Cost for every new customer.
As Cost group query is not returning any row, so i can not reset this value in this group.

Now i tried to initialised it in main group but it is not giving required effect

Can you poeple give me some idea
For refrence i am attaching RDF file
Previous Topic: Adding upto get 1 record
Next Topic: LongRaw Picture in report
Goto Forum:

Current Time: Wed Oct 26 20:05:03 CDT 2016

Total time taken to generate the page: 0.09345 seconds