How to show the runnnig total or total summary on Report header/Group

[vega83]

Friends ,
Right now I am showing running totals in report footer which is working fine. I am doing counting no of SKU no which has condition so in evaluate section i am using condtion DEPT no = 1 then only ia counting.
But now users want to see the toal summmary on repot header instead of report footer. Is there any way to achive this.

Thanks for your time friends,
V.

 

[vega83]

I know we can use subreports, but anyother shortcut?

 

[IanWaterman]

You can not display Variables or RTs in a Group Header.

How about moving all the items in Group Header into Group footer, then suppress Grp Header. Normal summaries etc can display in both header or footer.

Ian

 

[lbass]

You could insert a crosstab in the report header that uses a conditional formula:

if {table.deptno} = 1 then
{table.SKU} else
{@null}

...where {@null} is a new formula that is opened and closed without entering anything.

Place this as the summary in your crosstab and insert a count on it (or distinctcount, depending upon your needs), and add your group field as the row field in the crosstab.

-LB

 

[vega83]

LB thank you so much. Thats a nice trick.

V.