SQL Parameters
Hi
We want to use an Advantage Full Text Search in the SQL selection of a
report, i.e.
select * from contract
WHERE CONTAINS( *, '*BAKE*' )
When written like this in SQL the Search works exactly as expected.
Is there anyway I can pass the *BAKE* as a user parameter to the
report? rather than it being hard coded into the SQL?
Many Thanks
Philip L Jackson
We want to use an Advantage Full Text Search in the SQL selection of a
report, i.e.
select * from contract
WHERE CONTAINS( *, '*BAKE*' )
When written like this in SQL the Search works exactly as expected.
Is there anyway I can pass the *BAKE* as a user parameter to the
report? rather than it being hard coded into the SQL?
Many Thanks
Philip L Jackson
This discussion has been closed.
Comments
For manually edited SQL text, you can use :ParamName where ParamName
corresponds to a Report.Parameters[ ] item. Here is an rbWiki article with
details on using Report Parameters.
http://www.digital-metaphors.com/rbWiki/End-User/Fundamentals/Report_Parameter_Fundamentals
Best regards,
-
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com