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