Page break in a report

[Gicu]

Can you upload a sample?


Cheers,

[Dropout]

I stripped most things out - can't get small enough - any tricks?

[Gicu]

Run a compact and repair then zip it.

[Dropout]

OK, I hope I didn't strip too much.

[Gicu]

Here you go. You had a sort order on part number before the Group By Bin #.
Cheers,

[Dropout]

Hi Vlad.

Could you please let me know where to look for the change? I'm trying to compare what you sent with what I have and can't find the difference.

[Gicu]

Here you go.The Sort on the Part Number was the first line (above Group On Bin #.
Cheers,

[Dropout]

Awesome! Thanks again.

[Gicu]

You're welcome!

[CarlettoFed]

I replied I hadn't seen that there was page 2, sorry.

[Dropout]

No sure if I should open another thread but:

How do it get this report to total - see part 1841 and PO 160657.

Same query - same report.

Thanks.

[Gicu]

You mean to show 5 for quantity?
See attached.
Cheers,

[Dropout]

Thanks.

I had already tried that but get this:

[Gicu]

Look at the file I've sent you where I renamed that field Total_Quantity:sum(Quantity) in the query and changed the control source on the report to Total_Quantity. If you don't want to do that open the report in design view and change the control source of the Quantity textbox to SumOfQuantity (select it from the drop down).

Cheers,

[CarlettoFed]

In the attachment you will find an example of how you can dynamically manage the data filter and its prints.