With edited SQL in a pipeline, how can I add an autosearch variable to the report on that pipeline?

rbuser

?I have a pipeline in which I have edited the SQL. Now, of course, the
autosearch variables that were there are gone. How can I add them back? I
have looked all through the docs, but came up empty...

Thanks,

Bill



--- posted by geoForum on http://www.newswhat.com

nicocizik

Hi Bill,

For ReportBuilder 11, you can use parameters to do this. This would involve
first creating a parameter using the Report Tree. Next you can set up its
autosearch properties using the object inspector. Finally you use the
parameter in your edited SQL code as you would in Delphi...

Parameter : MyValue

SELECT *
FROM MyTable
WHERE MyField = :MyValue

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com