Drill Down Group header repeat problem 1

[sara07]

Hi, I am drilling down based on three groups

1st group: Organization Type
2nd group: Membership Type
3rd group: Customer Num

I am selecting organization type and then it goes to Membership type group which displays data and then I select Membership type group and it shows all the customer nums along with other data. Problem is that I would like to show headers along with the footer where data is at. The headers repeat as many times as group customer number changes. for example:

customer# account#
423222 3534343

customer# account#
4233432 3343

customer# account#
423533 353343

customer# account#
956565 867666

This is being a problem since when you drill down: there is no page header, report header just it shows Group header and group footer.

I would like to see
customer# account#
956565 867666
423533 353343
4233432 3343

So How can I just display group header to show up only once on group header etc?

 

[lbass]

This is unclear. Please try again.

-LB

 

[sara07]

Hi

What i mean is: when drilling down on my report based on groups. It is printing group header each time there is something on group footer. For example:

<b>This is group header:</b>
customer# account#
<b>
Group footer:</b>
423222 3534343
customer# account#
4233432 3343
customer# account#
423533 353343
customer# account#
956565 867666

I dont want it to print group header each time there is some data on group footer. I just want the group header to show on top of page <b>ONCE.</b>

Example:
<b> group header being showed only once.</b>
customer# account#
956565 867666
423533 353343
4233432 3343

Thanks!

 

[lbass]

What is the group you are drilling down on? You wouldn't get repeated group headers like then in a group you were drilling down on (since only one group instance would be displayed), so I think you need to explain how you have formatted these sections--did you use the drilldowngrouplevel function to conditionally suppress instead of hiding sections?

-LB

 

[sara07]

Hi! Sorry for the long delay. I am going to try to explain:

I am drilling down on MPC Organization Type group and then membership type group and then Customer Number group

When I preview the report the first page displays Organization types. I click on that and then I see Membership types . I click on membership type and I see Customers info such as customer #, account #.. but the problem is If I have group headers of customer # ,account#,... visible. It displays on the page many times every time there is a new customer like this:

group header: customer# account#
group footer: 423222 3534343

customer# account#
4233432 3343

customer# account#
423533 353343

customer# account#
956565 867666

I dont want to see group Header to come every time there is a change in a customer#. I just would like to see group header to come once. Since its a drill down report I cant put my headers on page/report headers. Is there a formula or something to show group header only once on the header itself? I hided all of the groups to have drill down ok.

I hope explained good this time..
Thank you!

 

[raja2008]

May be you can do this,If i got you right:

In the section expert :
Supress the group header :groupnumber>1

 

[sara07]

Wow it was that easy to do this... I didnt knoww.. Thank you so much!! It shows group header on first page but on the second page it does not show. I do have repeat group header on each page and keep group together selected. How can I have on every page for this situation. But yes this is what I wanted to show group headers once on a page...

Thanks again.

 

[lbass]

Instead of telling us what you see on drilldown, you should be going into design mode and telling us what report sections the headers are in and the fields you are displaying, including group fields. It looks like you might be using a detail_a section for the headers, which is what is causing the problem on drilldown.

-LB