Dynamic Report Fields

[Rohan_Powle]

Hi There,

I want to create Dynamic Report using CR9, Query for report display can have 1/2/3/4/5/6/7/8/9/10 any no. of fields as per user selection from the vb interface.

Here is a example which matches my req
Eg:- based upon user selection of fields report will be display

VB Interface :- check boxes with each field name

- User Selects All (Select * From Product)
> All Fields From Product Table should be displayed

- User Selects (Select ID, Name From Product)
> Report should display on 2 fields

- User Selects (Select Name,Specification,RatePerUnit From Product)
> Report should display on 3 fields


- User Selects (Select Name,Specification,RatePerUnit,ManufacturedAt,Desc From Product)
> Report should display on 5 fields


This just an example, fields in my report will vary from 1 to 30.
Please help me out, making this customize report is very urgent I am really blank abt displaying fields dynamically.


All Gurus please help
Help will be appriciated

[Super^Blooser]

why no answers ?

[RobDog888]

You could use an ADO recordset and set the .DataSource property of your report to it. This will bind your selected fields to the report.

To get only certain fields to display in the report nicely, you can either do it from the report design time by making multiple Details sections each with your different setups and show/hide depending on your needs at runtime by passing a parameter and using the selection formula to evaluate it. Or you can use the CR object library to obtain access to the textfield controls and show/hide each depending on the users selections but you will also have to position them too then blindly or noe their positions in the designer.