Multiple columns in Group header?

[ndp]

Hi,

I want to have a report with multiple columns. Yes, I can have multiple columns in detail section. But I want to use group headers and if there are 10 records in a group, I want to show each group of 10 records with the header title in three columns! Is it possible?
Can any body suggest a way to do it?

Thanks
ndp

 

[FVTrainer]

Please show a sample of the exact layout you want.

 

[vidru]

Are you planning to print your Detail columns a) Across then down, or b) Down then across?

You'll have to add your field labels 3 times each, then figure out a means to suppress them (if you don't want them to show unless it's necessary).

-dave

 

[ndp]

Here is what I am trying to do...



CountyName
SchoolName
OrderID

Contents
8837477 xyza A
9394384 uyed B
8347373 idjd A
10 records like this...

So, the CountyName, SchoolName and OrderID goes in to header section. Contents goes in to detail section. I want to have labels of 4 x 8. It somehow doesn't work!

I hope I could explain it enough to make my point. Please let me know if more clarification needed.

Thanks
ndp

 

[FVTrainer]

Yes, more clarification, please: 1) What do you mean by 4 x 8 labels? Is that 4" high by 8" wide? That is the normal way of referencing label dimensions, and that doesn't seem right given your requirements. 2) From your first post, it sounded like you wanted:

CountyName CountyName CountyName
SchoolName SchoolName SchoolName
OrderID OrderID OrderID

data data data
data data data
data data data
data data data
data data data
data data data
data data data
data data data
data data data
data data data

is that right? If so, is "data" layed out horizontally as in your example:

CountyName SchoolName OrderID

Where each row represents a unique record?

3) Do you always have exactly 10 records?

 

[ndp]

1) Actually, I meant 4x8 by 4" width and 8" height.

It should look like this....

County Name: CountyName
School Name: SchoolName
Order: OrderID
Contents
Title1 Title2 Title3
data data data
data data data
data data data
data data data
data data data
data data data
data data data
data data data
data data data
data data data

data portion comes in detail section. Rest goes in to header section.
2)Yes, I always have to have 10 records.

Thank you for responding. This is a report I am trying to convert in to labels.
Do you think there is any way I can print it like labels?

Any suggestion will be welcome!
ndp

 

[FVTrainer]

Ok, I'm almost certain we can do this, but I still don't completely understand your example above. My confusion is in the correlation between your label layout (4x8) and the columns on your report. How many labels are there across the page? (for example, in a normal mailing label scenario, there are often 3 labels across the page. Of course, at 4x8, there shouldn't be more than 2) Do you want one column per label or 3 columns per label? In total (# of labels times columns per label), how many columns would want across the report?

 

[vidru]

I've got a messy solution that might work that would have no groups, two details sections, and a subreport.

Data
------
The main report would return only the header information (one record for each Order), and the subreport would contain the order details.

Layout
--------
I set it up as landscaped 8.5 X 11 paper.
ReportHeader - suppressed
PageHeader - 1/2 inch, with nothing in it
Details - Format with Multiple Columns checked, Width = 3.50, Printing Direction = Down then Across
Details A - Height is about 1 inch. Contains the header information (County Name, School Name, OrderID)
Details B - Height is about 6.5 inches, with Print at Bottom of Page checked. Contains the Order Details subreport.
ReportFooter - suppressed
PageFooter - suppressed

As I said, messy, but I've got a test version working that's what I think you're looking for.

-dave

 

[ndp]

Yesss! It's working.
Thank you all for giving me ideas which made me try more and more.
Actually, I didn't have to do much. Dave! I wanted 3 labels across. Sorry, forgot to mention!
Since I was converting a report to labels, I had to have header section the way I needed. There was a check box in layout tab for 'Format group with multiple column' which I checked. Also, adjusted margins(left and right) and width to get what I wanted.

It works perfectly now!

Thanks
ndp