columns pushing subreport off page 1

[mmarino]

I've search this forum for this, but I can't find an answer to this particular question.
I would like my report to look like this:
code1 desc1 coden descn
code2 desc2
code3 desc3 subtitle
code4 desc4 codeA descA
code5 desc5 codeB descB
.
.
.

I have formatted my report with colums. I don't know if there is a way to make the codeA, code B part follow in the second column (values come from a separate table and I need to put the subtitle to separate the data). So instead I put that part in a subreport. The problem is this:
code1,2 and so for, writes all the way down to the page before it does the accross, leaving no room for the subreport which then gets printed on a separate page. It looks silly having all this space under the second column and having the subreport on the next page. I've tried putting the subreport in the report footer section and I get the same results. When I put it in the page footer section I get it to print on the same page, but then it repeats on every page which is not what I want (I get a blank page with just a footer on it).
Any help will be appreciated,

Monica

I'm using CR11

 

[lbass]

If you have a group field and have also checked "Format groups with multiple columns" in the layout tab, then you can place the subreport (linked on the group field) in the group footer. Make sure in design view that the subreport fits within the column.

If you have no groups, create a formula that is true for all records, like:

{table.ID} > 0

Or, you could use:

whilereadingrecords;
1

Then insert a group on this formula, suppress the group header, and place the subreport in the group footer.

-LB

 

[mmarino]

Thank you LB, that is exactly what I was looking for!

mm