Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gnorro
Starting Member
3 Posts |
 Posted - 2008-06-24 : 05:58:07
|
| HiI need to set a stored procedure as source for a report. how can it be done?thanks |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-06-24 : 06:09:50
|
| On the report design, on the data tab, you can choose your data source as text ot stored procedure. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-24 : 06:43:39
|
| if using text mode give it as,exec spname param1value,param2value...and if using sp mode just give onlyspname |
|
|
|
gnorro
Starting Member
3 Posts |
Posted - 2008-06-24 : 07:06:25
|
| ok thanks. how can I tell it that one parameter can have a null value? if my sp accepts 2 params, but their value can also be null or empty, how can specify inside the report?thanks |
|
|
|
|
|
|
how to use stored procedures in report