Detail band - 1/2 fixed, 1/2 columns. Possible?

rbuser

Hi there,

I'm going to try and describe what I want to achieve without attaching
an image. Hopefully someone will be able to give me some ideas as to
how to approach this. I'm guessing it will be a hack, so I'm looking
for the "cleanest" hack...

This is just how I want the report to LOOK. Terms like "detail band"
and "master/detail" are just for reference. The actual implementation
is completely up for grabs. That includes the structure of the
underlying data.

I need each detail band in my report to have a "half n half" layout.
The left half is a regular detail band with some fields from the master
row in a master/detail relationship. The right half is a dynamic number
of columns showing the detail records for that master record. The
columns are in pairs - ie. 2 columns showing 2 fields for each detail
record. So if there are 3 detail rows, and the fields are A and B, the
6 columns will go A|B|A|B|A|B. Make sense?

I await enlightenment from the RB gurus...

Thanks in advance,
Andrew

nicocizik

Hi Andrew,

I have personally never seen this but it should be possible. I would start
by placing a child style subreport inside your detail band and adjusting the
width so it only fills half the band. The subreport is where the columns
will be defined so it will need to connected to the detail data. To define
the columns dynamically, you will need to use the Subreport.Report.Columns
property. This is only if you need to use ReportBuilder style columns. You
may only need to drop your field values inside the subreport (manually or
dynamically), then as the data is traversed, it will appear to form columns.
I hope this gives you a good starting point.

--