Report columns

  • Thread starter Thread starter rob p
  • Start date Start date
R

rob p

I group by Client ID. Each client can have 1 to 100 items numbers. I want
the group header to contain the client id. In the detail section I want the
item number to list across the page, 8 a row, then a new row below if more
and so on.

CLient ID
1 2 4 5 6 7 8
9 10 11 12
Client ID
1 2

What doesn't work is:
I can change page setup for the columns but that also includes the client ID
in the columns. And clients run together with the items with no client
grouping.

Client ID 1 2 3 4 5 6 7
8 9 10 11 12 Client ID 1 2

Is there a way to do this? I looked at crosstab querys but that didn't seem
to work unless I am doing something wrong.
thanks.
 
rob said:
I group by Client ID. Each client can have 1 to 100 items numbers. I want
the group header to contain the client id. In the detail section I want the
item number to list across the page, 8 a row, then a new row below if more
and so on.

CLient ID
1 2 4 5 6 7 8
9 10 11 12
Client ID
1 2
Click to expand...


This is best done by using a subreport. Create a report
based on a query that has fields for the Client ID and the
items. Set this report to use 8 columns using Across then
Down snaking. The detail section will have a text box for
the item field and an invisible text box for the Client ID.

Now, create another report base on a query with just a
single row for each Client ID and other client data, but no
item info. This report would have the client fields in the
detail section.

Finally, add the item report from above as a subreport in
the client report's detail section. Make sure the subreport
control's Link Master/Child properties are set to the Client
ID field.
 
Back
Top