Condensing subreports in print preview to eliminate extra space

[bigalpha]

I have a report with an embedded subreport. It's set up in two columns, ordered across then down.

My problem is when column 1, row 1 section is taller than column 2, row 1 section. It creates a lot of extra white space as I fill in the rest of the report. Is there a way to eliminate that space or am I stuck?

 

[JHB]

.. It creates a lot of extra white space as I fill in the rest of the report. Is there a way to eliminate that space or am I stuck?

For me your report looks ok, can you elaborate exact what you want?

 

[bigalpha]

Right under 'Fluted Elizabeth Broach' (row 1, column 2), there is a block of white space because 'Fluted Elizabeth Ring' (row 1, column 1) is a taller record.

I have the columns set up to fill in across, then down. Is there a way to eliminate that block of white space underneath 'FLuted Elizabeth Broach' (r1, c2) or am I stuck with it?

 

[JHB]

Do you have a grouping/sorting in your report.
Could you post the database with some sample data + name of the report?

 

[bigalpha]

There is no grouping or sorting in my reports. See the attached database. It's a 2007 version and when I saved it as a 2003 version, it stripped everything but the tables!

The main report is: rptLineSheet.

There are three nested subforms inside of rptLineSheet: rptJewelryPiece, rptJewelryPieceGem, rptJewelryPieceMetal.

 

[JHB]

I got this error when I open your database, so I'll leave it here.

 

[bigalpha]

Idk what's going on now. I added everything to a new database and redid the subreports and now I'm getting a 'query is too complex' message when trying to open the main report.

I narrowed it down to which subreport is causing the issue but I don't know why. grrr.

 

[bigalpha]

I was able to re-do some stuff. I *just* tested this and rptLineSheet loads with no errors.