Column Left To Right with Full Page Width Group Headers

rbuser

With RB7.02 D6 End User Reporting:

I have one dataview and I need a two column report with FULL page
width group headers on the same page if room. That is:

===============================================
Company Name Number1 Company Phone Number1
===============================================
Person 1 information here : Person 2 information here :
Person 3 information here :


===============================================
Company Name Number2 Company Phone Number2
===============================================
Person 1 information here : Person 2 information here :
Person 3 information here : Person 4 information here :
Person 5 information here :

What is my best approach.

Thanks.


Rick Matthews
Dartek Systems Inc.

nicocizik

Hi Rick,

Try placing a child style subreport in your main report's detail band.
Inside the subreport set up your column structure and use the Title band of
the suberport to show the company name/number etc. You could also create a
group in the main report and place this information inside the group header
band.

--

rbuser

Thanks Nico but I only have one dataview and I don't have any
flexibility on that. So I can't use a subreport in the detail band.

If I put a group on the main report and set the main report to two
columns then I can't size the group heading to be full page width.

If I put a subreport in the group header and set its width then
sometimes I get the header overtop of some of the columns.

What else can I try?

Thanks

nicocizik

Hi Rick,

Would it be possible for you to have your main report not connected to any
data and a subreport connected to your single dataset? This way you could
use the subreport's title band as the column header with the correct data
connected. If you are constructing a more complex report, you may need to
re-design your dataset so you have a master-detail relationship. Using
subreports is the only way I can see accomplishing this type of report.

--

rbuser

Thanks Nico,

So are groups not supported with left to right columns? If I use the
subreport as the group header I can define a full width header but it
is printed over top of the column details sometimes?

nicocizik

Rick,

Unfortunately, the left to right column capability in ReportBuilder is very
simplistic. In order for groups to work with left to right columns, we
would need an idea of a "row header" and "row footer". If you would like to
send a small example of the subreport printing over your detail, I will take
a look at it. Please send it in .zip format to
support@digital-metaphors.com.

--