Converting report to label

[510sx]

I created a report. This is a dynamic report and it is about printing the product code and serveral manufacturer information. You enter the product code and it returns a list of manufacturers. This report takes up the upper half of the paper. I would like to have it duplicate on the lower half of the paper.
I have tried to use the label wizard to do the same report. The label wizard will do the format I want, but the manufacturer field doesn't populate properly. The manufacturer 1 shows on the upper half of the paper, manufacturer 2 shows on the lower half and manufacturer 3 printed on 2nd page upper half and so for..

Since I got the report I want using the report wizard, can I convert it to the label report?

 

[stopher]

If I understand correctly, you want the lower half of the page to look exactly like the upper half of the page.

I think I would approach this by getting the source data to duplicate. This can be easily accomplished by doing a cartesian product query with a new table containing just two records (doesn't really matter what the records contain - a simple 1, 2 integer field called "PagePos" will suffice). Once you have this new query then you can group by "PagePos" in your report.

The only problem I can think of with this is that the second list will print at a position depending on the length of the list. So you need to adjust the group footer dynamically according to the length of the list. I did this using the group footer On Format event and a zero height text box containing the count of lines in the detail.

I've attached an example

Chris

 

[510sx]

The only problem I can think of with this is that the second list will print at a position depending on the length of the list. So you need to adjust the group footer dynamically according to the length of the list. I did this using the group footer On Format event and a zero height text box containing the count of lines in the detail.

Chris

Thanks for the sample, Chris.

I modified my query using your method, it did print the way I want it. However, like you said the second list will print at a position depending on the length of the list. I am using perforated paper, so the second print has to print right below the perforated line.

I am now digesting the the group footer event you wrote. I am wondering where you hided the text3.

 

[stopher]

I am now digesting the the group footer event you wrote. I am wondering where you hided the text3.

Text3 is in the group footer. However, it is zero height so difficult to see. If you have the formatting toolbar visible in design view then you can select it from the dropdown (usually on the far left). If you click on another control you'll see that controll name appear in the toolbar.

Anyway, text3 is just Count([manufacturers]). At the moment 1 detail record is height 240. So the count will tell us how many x 240 we have printed in the detail (and hence we can calculate how much we have to make up).

By the way, there may be better ways of doing this but it's the one that came to my mind and it does seem to work fine.

Ignoring my solution completely, is it not just a matter of changing the print paper size and printing the report twice i.e. 1 list printed twice?

hth
Chris