Page 1 of 1

Dynamic query in report

Posted: Thu Jun 29, 2006 10:10 am
by magicang
Hi

Can i add dynamic query in report ?

Similiar like a delphi report product call "FastReport" ?

TQ~~~ :blush:

Dynamic query in report

Posted: Thu Jun 29, 2006 11:57 am
by Vital
What do you mean "dynamic query in report" ? Query with parameters? Change text of query?

Thanks.

Dynamic query in report

Posted: Thu Jun 29, 2006 9:10 pm
by magicang
I mean, did i can dymanic change the text of query in my report ?

TQ

Dynamic query in report

Posted: Fri Jun 30, 2006 2:22 am
by Vital

You can use string variable directly in query. For example:

select * from {myvariable}

select * {myvariable}

{myvariable}

After then you fill variable using standard methods.
If you change variable in internal Dialog Forms then you need use method
Connect of datasource and need set property ConnectOnStart of DataSource to false.

Thanks.