get values from report footer and place then in report header

[maas]

Hello All,

I am having difficulties where I did a formula in the details section which is calculating the cost Price for each deal which contains @Cost Price:
if {@Groups}<>"DEPOSITS" then
{MMDEALS.CAPITAL_Amount}
else
100

{@Groups} is a group which having a list of names and I kept it as a group

Now for my concern is that I need to get the total for each group the sum of {@Cost Price} and in the report footer the total sum of {@Cost Price} for the total groups. So, I did the answer which lbass advised me and it worked:

http://www.tek-tips.com/viewthread.cfm?qid=1567866&page=2

Now, the total which is in the report footer, the user requested to be in the page header and a new formula will be created to Add this total with other fields.

So, how can I manage this?

Thanks

 

[lbass]

Do you really mean Report Header or Page Header--an important clarification.

-LB

 

[maas]

Sorry for this mistake

Page Header

Thanks lbass

 

[lbass]

I'm concerned about your statement your plan to "add this total with other fields". What other fields? What type of amounts would you be using in the page header? Do they relate to specific groups or what? If so, we need to know the specific group structure. How is your report set up in the section expert? Do you have New page after set on any group footers?

-LB

 

[maas]

Hello lbass,

Yeah. The problem is that the user wants the grand total amount which is in the report footer added by it a total which I am getting it from a sub-report.

In the sub-report, I am prompting the user to enter start date and end date and in that report, it will show the deal numbers and amounts and fnally the sum of th amounts. I suppressed all the fields and now it is showing only the total. The total I am getting it from the sub-rport.

So, the user wants that grand total + the amount which I am getting in from the sub-report in the first page only. Currently,in the section expert, there aren't any conditions.

And about the groups, there aren't any specific conditions.

When we return to our example inthe previous link

http://www.tek-tips.com/viewthread.cfm?qid=1567866&page=2

I want the formula {@displaygt} which you have taught me to use in the page header. Now, when I place it, it is showing zero value.

Thanks

 

[lbass]

You are still being unclear about the placement. If the result is ONLY supposed to be on the first page, it should be in a report header section, NOT a page header.

The problem is that you are using a subreport to get the total in the report footer. You cannot have a nested subreport within a subreport, so you cannot just save the report as a subreport and place it in the report header. If it is really important to have the grand total in the report header, then you will have to find a different way of coming up with the grand total in the main report that does not require a subreport.

-LB

 

[maas]

To be mre clear:

What I am looking for is how to bring the value of the formula {@displaygt} in your example in the report header?

Thanks

 

[lbass]

I guess you could save the main report as subreport to be place in the report header_a and then also insert the current subreport in another RH_b section (since it won't work if nested within the main report), and then recalculate the result to be displayed in RH_c.

-LB