on 04-01-2008 10:44 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
96 | |
11 | |
11 | |
10 | |
9 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.