Dynamic query in report

magicang · Post by **magicang** » Thu Jun 29, 2006 10:10 am

Hi

Can i add dynamic query in report ?

Similiar like a delphi report product call "FastReport" ?

TQ~~~

Post by **Vital** » Thu Jun 29, 2006 11:57 am

What do you mean "dynamic query in report" ? Query with parameters? Change text of query?

Thanks.

magicang · Post by **magicang** » Thu Jun 29, 2006 9:10 pm

I mean, did i can dymanic change the text of query in my report ?

TQ

Post by **Vital** » Fri Jun 30, 2006 2:22 am

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.