Multicolumn & single column subreports

[Guest]

Hi,

I need some suggestions as to the best way to do this.

The end result I would like to look like:

------------------------------Pge Header--------------------------------
-------Segment 1 ------- -------Segment 2 -------- etc->
Date Current | Target | Total Current | Target | Total
1/10/2006 # # # # # #
1/17/2006 # # # # # #
etc...
12/31/2006 # # # # # #

for a total of 33 segments

How can I accomplish this? I have a subreport with the columns (4 to a
page) that seems to require being set at "Down then Across" otherwise it
looks so convoluted. Also, since I don't want the dates to appear beside
every column (only at the left of each page) I have the dates on a separate
subreport. I can't seem to get this to work out. Any guidance?

TIA

 

[Guest]

Kabaka:

I think you may be pretty close to what is necessary to make something like
this work. However, you will want to move your dates to the Primary report
and then you can use the Master/Child relationship, to link the data from
your subreports.

Good luck.

Sharkbyte

 

[Guest]

Thanks for the encouragement - and I am almost there. I now have the data
displayed as I'd like with one exception: the dates show up beside every
column - how can I get them to only display on the leftmost?

 

[Guest]

Display your dates on the main report, and hide the columns on your sub
reports. The field doesn't have to exist (I don't believe), on the
subreport, to link to it. It just needs to exist in the Data Source.

Sharkbyte

 

[Guest]

That is the set up I currently have - with the dates showing in each column.
On the subreport I have my data (not the dates displayed - although they are
in the data source). On the form in the date header section I have the date
field and beside it the subreport (linked via the date & segment).
Everything is fine except the date is displayed beside each column. The
report is set to 3 columns "Down then Across".

Thanks for the help!