Quey builder

[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.

[Antonio]

What if you build a cube?

-----Original Message-----
Hi,
I like to create a query builder to allow the user to create his statisticsand see them using Cristal report

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


.

[touf]

what's a "Cube"??
"Antonio" <ju********@mabe.com.mx> wrote in message
news:00****************************@phx.gbl...

What if you build a cube?

-----Original Message-----
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.


.

[William Ryan]

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
"touf" <to******@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

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.