Get subreport Can Grow to repeat upwards instead of downwards?

[jbrumbau]

Hello,

I'm trying to generate a report with a subform, with the Can Grow property set to Yes. In the attached picture, the list of bidders is the subform, to the right of where you see the row with the dates with "P" next to them. My problem is that the bidders cascade down instead of cascading up, resulting in a gap between the "P" row and the "F" row. The reason is because I'd rather have the gap be between individual packages (they're separated by the colored, blank rows), so that it doesn't look like the "P" row for one package is associated with the package above it.

[IMG]C:\Jesse\ProcStatusReport.JPG[/IMG]

In design view, the "P" row occupies exactly one row, with the subreport inserted into that row. I have noticed that if I double the height of the row and place the subreport above the "P" data that it will cascade upwards. However, I want it to start on the same row as the "P" data instead of one row above it and cascading upwards so I don't waste a row for each package. Is there a way to do this?

Thanks in advance.

[jbrumbau]

Sorry for double post, how do I attach the image?

Thanks.

[jbrumbau]

Attempting to attach an image after I screwed up the first time...

[IMG]ProcStatusReportVSmall2[/IMG]

[Scott Price]

After posting your reply in the thread, you have one hour to edit/delete your own post. Within this time limit, click on the Edit/Delete button on the bottom of your post. Scroll down until you see the Additional Options frame. Click on Manage Attachments, and you'll see the dialog box to browse to your image, and upload it to the server.

Regards,
Scott

[jbrumbau]

My question is still unanswered, could somebody please answer it?

Thanks.

[Scott Price]

No one has answered this question yet likely because most people think it can't be done, but have been waiting to see if someone really smart will come along and show some whizz-bang way to accomplish it.

Personally, I have never attempted to do this. However, if I were to try, I would first of all experiment with making your controls invisible and using the Me.Print method to print the text directly to the underlying report.

You can feed the Me.Print method the x and y coordinates, the font, etc. It takes a considerable amount more programming but can be quite flexible.

This is the method that I am currently using in a subreport for printing a small booklet.

Regards,
Scott