Sizing a reports detail section through code

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Hi all,

I have a report that I would like to resize through code.
In the detail section of the report I have two types of
fields (Inpatient information and Outpatient
information). Instead of having two separate reports I
have both IP and OP fields on the same report. So, when
the user opens the report they are prompted (query runs)
to enter a reference number. The reference number is
either IP data or OP data. So, in the detail section of
the report under format I have placed code to make the OP
fields visible=false if the IP data is being showed and
made the IP fields visible=false if the OP data is
showed. However, when the OP data is showed their is a
blank space I would like to shrink... to account for the
report's detail section height.

I know it would be easy to have the IP and OP data broken
out into two reports. But it would just as easy at this
point to have the report's detail section format height to
be a different size based on if the OP data is displayed.

I've tried a couple of ways to write this one line piece
of code, but cannot get this to work.

Thanks for the help!!!
 
Mark said:
Hi all,

I have a report that I would like to resize through code.
In the detail section of the report I have two types of
fields (Inpatient information and Outpatient
information). Instead of having two separate reports I
have both IP and OP fields on the same report. So, when
the user opens the report they are prompted (query runs)
to enter a reference number. The reference number is
either IP data or OP data. So, in the detail section of
the report under format I have placed code to make the OP
fields visible=false if the IP data is being showed and
made the IP fields visible=false if the OP data is
showed. However, when the OP data is showed their is a
blank space I would like to shrink... to account for the
report's detail section height.

I know it would be easy to have the IP and OP data broken
out into two reports. But it would just as easy at this
point to have the report's detail section format height to
be a different size based on if the OP data is displayed.

I've tried a couple of ways to write this one line piece
of code, but cannot get this to work.
Click to expand...

Perhaps I'm wrong, but I thought you could just make the controls' height
very small with [CanGrow] set to Yes.

Then, if there is nothing in the controls, you won't notice the small
space they take up.

David
 
Back
Top