Creating alternating columns in a report

I have a report that requires column #1 to have members 1 to 5 and column #2 to have members 6 to 10 (if any). What is the approach I would use to setting this up -- this is using Actuate, Microsoft SQL Server.

Can this be done in BIRT itself or do I have to set it up as two individual queries.

What is the layout, rules, etc. that should be used?

Thanks and Regards,
Bryan

Find more posts tagged with

Comments

bhanley

I need some more background to figure this one out. How would you represent numbers 1-5 on column one and 6-10 on column two? Are they numeric and can be aggregated? The only other option I can see is some kind of stacked chart?

Do the two groups come from different queries?

bzarnett

Currently the query comes back as a list of ten entries. A single query in a data set and I need to splice them out so that half go into column 1 and the other half go into column two.

These would be individuals names.

I would get back.

John Doe
Jane Doe
Sam Spade

in my result set and then I would want to see it in the report as

John Doe Jane Doe
Sam Spade

Does that help?

Bryan