Change Objects' Height On Report.

[cyanidem]

Hi All,

In my project I got report that I would like to resize depending on sizes of some elements. Because one picture is worth more than 1000 words, here's the picture:

Selected textbox PONumber can contain just one 7-character PO number or 10 of them. Its Can Grow property is set to Yes and that works as expected. Now, let's have a look at another picture:

I would like selected "border" around all Supplier information to grow as well. But because it's just a rectangle, it doesn't have Can Grow property.
I tried to read PONumber.Height property @On Format event of report detail but it shows height BEFORE it grows - is it normal? How can I read its property when its grown already and set height of rectangle according to it?
Or is there other way (I bet there is...) to achieve that?

Thanks in advance

Edit: wrong attachments, sorry.

 

[GinaWhipp]

Hmm, why not just put that section in a Subreport which you can then put a Border around and set the Subreport to Can Grow?

 

[cyanidem]

I didn't think about it as I don't have any experience with subreports really. But it is some idea worth digging around, thanks!

 

[GinaWhipp]

No problem and not that hard, if you get stuck, post back... we're to help.

 

[cyanidem]

So... I took a bite yesterday and you were absolutely right, subreports were the way to go and it's piece of cake using them. Thanks a lot Gina!

One more question though - do you know if it's possible to have a control (label for example) shared between detail and header on report? Like top half on header, bottom on detail? I'm sure I've seen it somewhere but can't find it now...

 

[GinaWhipp]

No problem, glad to help...

Now that you cannot do and I know of no sneaky way to do that Perhaps if you show another image and describe what/why you want to do I can come up with something.

 

[cyanidem]

I tried to achieve this look:

while using subreport borders but then I realised it wouldn't work anyway as border is drawn around whole subreport. There's also no way to put a label on main report on top of subreport (afaik) so I had to get rid of subreport border and draw lines around manually, but I got it

 

[GinaWhipp]

Glad you figured it out! Sometimes just the act of *playing* around leads to the solution.