Dynamic report (is it possible?)

  • Thread starter Thread starter Niklas Östergren
  • Start date Start date
N

Niklas Östergren

(NOTE! Multipost)

Hi!

I have a report with a recordsource from a QBF (Query By Form). In this QBF
the user can also select which field to display in the report. Now to my Q.

1.) Is it possible to, in the report, a control right next to another
control on the fly?
Lets say the report have 3 controls txtName, txtAddress and txtPhoneNo
(In reality I have more than 3 controls!).
When I create the report I locate the controls in the same order
(Position 1 = txtName, Position 2 = txtAddress and Position 3 =
txtPhoneNo). But if the user only select to display txtName and
txtPhoneNo I want to display txtPhoneNo in position 2.
If it was only these 3 controls it wouldnt bee any problem (I think).
But what happens if the user want to display 3, 4, 5 or 6 controls of
totally 15? I still want them to be next to eachother even if I have
placed them several controls apart.

2.) Is it possible to let a report´s detail section to shrink if one or more
controls are´n visible? OR Is it possible to move the control to
another position it´s property.visible = True?

TIA!
// Niklas
 
I believe in the on format event you can change the position of th
controls upper left corner which would allow you to functionally red
the entire report if you want
 
OK!

Which expression or property do I use to shrink a section (detail-sektion
for instance)?

If this is the only, or the best way, to do this it´s going to be a lot of
coding since ther´s a lot of combinations of controls the user can select!!!

Thank´s for your reply!

// Niklas
 
Hi Niklas,

You might want to take a look at the last download, titled "Customizable Reports", on J Street
Technology's web site:

http://www.jstreettech.com/Downloads.asp

Tom
_______________________________________


(NOTE! Multipost)

Hi!

I have a report with a recordsource from a QBF (Query By Form). In this QBF
the user can also select which field to display in the report. Now to my Q.

1.) Is it possible to, in the report, a control right next to another
control on the fly?
Lets say the report have 3 controls txtName, txtAddress and txtPhoneNo
(In reality I have more than 3 controls!).
When I create the report I locate the controls in the same order
(Position 1 = txtName, Position 2 = txtAddress and Position 3 =
txtPhoneNo). But if the user only select to display txtName and
txtPhoneNo I want to display txtPhoneNo in position 2.
If it was only these 3 controls it wouldnt bee any problem (I think).
But what happens if the user want to display 3, 4, 5 or 6 controls of
totally 15? I still want them to be next to eachother even if I have
placed them several controls apart.

2.) Is it possible to let a report´s detail section to shrink if one or more
controls are´n visible? OR Is it possible to move the control to
another position it´s property.visible = True?

TIA!
// Niklas
 
Thank´s Tom!

I havn´t read it yet but I will asap.!

Thank´s for the tip!

// Niklas
 
Back
Top