Can Shrink Problem, Couldn't Skip blank on Print preview (YELP!)

[radian89]

Hi All,



I have classic question, but I've tried all google solution, but i'm still confuse.
I want to skip blank in my reports, but i can't. here's what i've been doing

- set can shrink properties for all textboxes in detail part to YES
- set can shrink properties in detail to YES
- there's 1 textboxes to calculate total = sum ([Quantity]*[Price]) in the detail, set it Visible = NO, Can shrink = YES

here's the screenshot of my reports
this is displayed on report view


this is displayed on design view


this is displayed on print preview


what's to be the problem in my case? thanks a lot for the help

[cyanidem]

Uploading your database (without confidential data of course) would greatly help us to help you.

[radian89]

Uploading your database (without confidential data of course) would greatly help us to help you.

Hi cyanidem,

sorry not attaching it... here we goes... thanks for the help.

cheers

[cyanidem]

I'm not quite sure if I understood what you want to achieve, but if it's this:

then you need to move controls from page footer to report footer and of course set report footer can shrink/can grow to yes.
If not, then I may need some clearer explanation what is it you want to achieve.

[radian89]

I'm not quite sure if I understood what you want to achieve, but if it's this:

then you need to move controls from page footer to report footer and of course set report footer can shrink/can grow to yes.
If not, then I may need some clearer explanation what is it you want to achieve.

Ohh gosh, how silly of me... I didn't think of it... lols....
Thanks a lot cyanidem, that solve my problem... love u