Column headings 2

[tsd30135]

I have my column headings directly above my detail fields, but they are in my group section and I suppress this section when it spans to multiple pages. Would it be best to use another group, and put the columns in it. Then only suppress the main group when spanning pages?

 

[synapsevampire]

People generally place column headings in the Page Header, so that they're displayed just once per report.

Where you place them would depend upon the required output, which you didn't share.

-k

 

[tsd30135]

My report is grouped on a customer id so the column headings would need to be above the detail section
The report will be printed and seperated for mailing.

Just a sample of report
Page section
"Title"

Group section

Idcustomer field (group field)
first name last name



Some text fields



Ticket# Ticket Date Ticket Amount

detail section
I would like everything suppressed except for the column headings when spanning to multiple pages.
It is currently suppressing everything and not showing the column headings

tsd

 

[synapsevampire]

Right click the group and select Change Group. Turn on the Repeat Group Headings on Each Page.

Now you'll need some code to check to see if you're in the same group at the beginning of each page.

You didn't state how you'll handle 2 groups on the same page?

Anyway a suppress formula might be:

not(onfirstrecord)
and
{table.groupfield} = previous({table.groupfield})

You can use this as the suppression for each group section thast you want suppressed, so a seperate section for the column headers would not use this.

Looks right, I'm afraid I can't test right now.

-k

 

[tsd30135]

synapsevampire

Thanks for your help

Qoute
"You didn't state how you'll handle 2 groups on the same page?"

I have a new page created for every new group so multiple groups on the same page should not happen, I think.

My report is like a packing \ invoice report. Each customer gets their own page or multiple pages based on the quantity of the detail items. I suppress the one group section that I have on the additional pages so the customer name etc do not print.

But this is where my column headings are so they are suppressed as well.

Do you still think your suggestion will help me?


Russ

 

[tsd30135]

Your suggestion worked like a champ Thanks very much. I created a second group and put in the suppression code you suggested.

Thanks

TSD