How do I get a query from a Crystal Reports

[Barin]

Hi,

I need to get a inittial report query in the Crystal and set a new query in the report.
Example:

A inittial query is: SELECT REGION_NAME FROM REGION WHERE CITY = @1@

I want to get the query,change the "@1@" mnemonic and set a new query: SELECT REGION_NAME FROM REGION WHERE CITY = "SAO PAULO". ( in ASP using RDC )

But I don´t know how do get the inittial query.

Thanks

 

[StevenK]

This sounds like a situation where you could use a parameter within the Crystal Report itself.
Create a parameter (call it 'SearchCity') and then pass the appropriate string to the parameter when you generate the report - so in this case you would set 'SearchCity' to be "SAO PAULO&quot.
Hope that this helps.
Steve

 

[Barin]

SteveK,

I need to get a query from report because I need to work with many reports ( generic ). It´s possible get a query from report.

Thanks,

Bruno

 

[StevenK]

Try reading the 'SQLQueryString' property against the CRReport object through code.
Steve

 

[Barin]

StevenK,

I try to read a SQLQueryAtribute, but when I execute this operation the Crystal Reports downs in visualization of report. I read a article in Crystal Decision that in version 8.0 exists a problem in RDC.
I will try to get a patch...
But, if SQLQueryString is read, the SQLQueryString original is returned?

Thanks very much!

Bruno