Unable to resize a subreport

[Former Member]

Hi,

I have fields License Number, Award Date, Drug Action Classification, International Birth Date which can grow. When I set the property fo the field to 'Can Grow' = true, then this layout breaks and next field is overlapped. I also tried putting fields in different sections, but then layout of 'Name of the Product', Trade Name, Generic Name, etc. all breaks and I am not able to have a layout as per client requirement. Kindly sugges a work around this problem.

Thanks in advance.

Rahul

[Former Member]

You will need to change font size of field in subreport so it fits space allocated.

Also make sure all sections that are not required in subreport are suppressed.

You can dynamically change font size depending on length of field if that helps.

In format field click on formula icon and enter formula something like

If length({subreportfield} >25 then 8 else 10

Ian