sql stored procedure parameters

[Former Member]

Post Author: sharonmtowler

CA Forum: Data Connectivity and SQL

i created a stored procedure to use as my datasource.

i have 2 parameters that i would like to have the option of selecting ALL when the report is run. I would prefer have that in the stored procedure instead of the report selection. I am not clear on the syntax i should use. Currently i have

field= that only returns distinct value

can anyone help?

thanks

[Former Member]

Post Author: Mark_BAA

CA Forum: Data Connectivity and SQL

When I use procs I don't add filters to the report. The sp parameters are called by the report (and therefore the enduser) at runtime. Try taking them out of any filters.