suppress group headings (but not the first) 1

[surfnfrog]

I have hit a small (yet critical) formatting snag, however am not sure I am heading down the right trail by using 2 groups. if i should try another approach, please let me know.

My report has 2 groups:
Group #1 displays a single project item (1 line).
Group #2 displays a list of budget ammounts available to that project for the next few years. (0, 1 or more lines)

the report output looks like this:

Page Header: Proj Mgr. Proj Nbr. Budget Code
__________________________________
Group #1 Header: John 001111 99999
Group #2 Header: Year Calendar Year Budget
Detail: 2 2006 $500,000

Group #2 Header: Year Calendar Year Budget
3 2007 $450,000
Group #2 Header: Year Calendar Year Budget
4 2008 $600,000
__________________________________
Group #1 Header: Jane 002222 88888
Group #2 Header: Year Calendar Year Budget
Detail: 2 2006 $650,000
Group #2 Header: Year Calendar Year Budget
3 2007 $550,000
__________________________________
Group #1 Header: Bob 003333 77777
Group #2 Header: Year Calendar Year Budget
__________________________________
Group #1 Header: Mary 004444 88888
Group #2 Header: Year Calendar Year Budget
Detail: 2 2006 $200,000
Group #2 Header: Year Calendar Year Budget
3 2007 $300,000
Group #2 Header: Year Calendar Year Budget
4 2008 $400,000

...
And I would like it to look like this ->


Page Header: Proj Mgr. Proj Nbr. Budget Code
__________________________________
Group #1 Header: John 001111 99999
Group #2 Header: Year Calendar Year Budget
Detail: 2 2006 $500,000
3 2007 $450,000
4 2008 $600,000
__________________________________
Group #1 Header: Jane 002222 88888
Group #2 Header: Year Calendar Year Budget
Detail: 2 2006 $650,000
3 2007 $550,000
__________________________________
Group #1 Header: Bob 003333 77777
__________________________________
Group #1 Header: Mary 004444 88888
Group #2 Header: Year Calendar Year Budget
Detail: 2 2006 $200,000
3 2007 $300,000
4 2008 $400,000
...

I have figured out how to suppress the Group #2 Headers, using :

Go to the section expert->detail->suppress->x+2 and enter:

{table.field} = previous({table.field})

However this unfortunately wipes out ALL of the Group #2 headers, and I still need the 1st occurance.
I have also tried variations on the formula, with "previous" and I've managed to turn off the 1st one, and leave on all the others, but this is opposite of what I need.
I have also almost had success with using "OnFirstRecord", but that only works for the 1st project.

 

[lbass]

Create two formulas

//{@cnt} to be placed in the group #2 header:
whileprintingrecords;
numbervar cnt := cnt + 1;

//{@reset} to be placed in the Group#1 header:
whileprintingrecords;
numbervar cnt := 0;

Then go to the section expert->group header #2->suppress->x+2 and enter:

{@cnt} <> 1

-LB

 

[MrBillSC]

It looks to me like group header 2 is just column headings, so why not place them in group header 1 and suppress group header 2?

MrBill

 

[surfnfrog]

Thanks lbass! this is exactly the logic i needed.

it still printed the Header Group #2 for the projects that had no budget info, but I fixed that by adding another field check:

{@cnt} <> 1
or ({Table.ProjYear} < 0)

---
MrBillSC - I did try your solution [if only it were that easy...] however I end up with the Header Group #2 for the projects that had no budget info. close, but the clients start asking why there's no budget data if there's a title line.