Quey builder

  • Thread starter Thread starter touf
  • Start date Start date
T

touf

Hi,
I like to create a query builder to allow the user to create his statistics
and see them using Cristal report

Any idea about how to do this, is there any controls that can help me.

Thanks.
 
Probably the easiest way to do this is create a screen and use GetSchemTable
to show the fields of the DB. WHen the User Drags them over or whatever,
add them to the list. I don't know how complex you want to make this, but
you can use a grid and let them add in restrictions and order by's like
Access without too terribly much hassle.

Then, creat a Static Crystal report with all fo the available fields, and
hide /show them as appropriate. If you havea lot of fields, this probably
won't work very elegantly and you may want to use HTML or a Grid.

What Statistics are you plotting? The Data Itself or the DB statistics?

Bill
 
Back
Top