print values across the page

[Guest]

i have a simple list of values (in a sub-report) that i would like to print
across the page instead of down. when i produce a report for 1 project (cost
center) at a time, i was using a counter in a query to create a table, then
appending 1-20 (the maximum number of values at the time), created a
crosstab, then used the fixed values 1 through 20 as the sub-report detail
items. now i need to create a report with multiple projects (breaking on
project), and the number of values i am trying to print across the page can
vary widely, and exceed 20. i can't get the count feature to start over with
a new project number, and think that there must be a better way since i now
have projects that can have as many as 100 speedtypes (the value I am trying
to print across). i looked at the columns property in the page setup, but
the "across then down" option is always greyed out.

 

[Marshall Barton]

i have a simple list of values (in a sub-report) that i would like to print
across the page instead of down. when i produce a report for 1 project (cost
center) at a time, i was using a counter in a query to create a table, then
appending 1-20 (the maximum number of values at the time), created a
crosstab, then used the fixed values 1 through 20 as the sub-report detail
items. now i need to create a report with multiple projects (breaking on
project), and the number of values i am trying to print across the page can
vary widely, and exceed 20. i can't get the count feature to start over with
a new project number, and think that there must be a better way since i now
have projects that can have as many as 100 speedtypes (the value I am trying
to print across). i looked at the columns property in the page setup, but
the "across then down" option is always greyed out.

I think you should explore using a multicolumn subreport for
the values. Make sure the main report's record source query
does not join the table with the values and set the
subreport control's link master/child to the project id
field.