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 |
|
1sabine8
Posting Yak Master
130 Posts |
 Posted - 2007-12-13 : 05:57:23
|
| Hi, i have a dataset that has its data from a stored procedure. it returning data as one result set, so no fields. But i need fields to put them in a table in my report. How would i be able to access stored procedure fields? Please it's urgent... |
|
|
IceCreamWizard
Starting Member
11 Posts |
Posted - 2007-12-13 : 14:10:31
|
| When using a stored procedure in a dataset, the only information you can obtain is the data set (table) returned by the stored procedure. Reporting Services ignores any OUTPUT parameters.So, you'll have to build another query or stored procedure to get the information you want.Of course, there are workarounds by adding the data items you want to your table and then do some filtering in the Report Designer.Read here for more information about parameters in Reports.[url]http://msdn2.microsoft.com/en-us/library/ms155917.aspx[/url] |
 |
|
|
tm
Posting Yak Master
160 Posts |
Posted - 2007-12-17 : 16:27:42
|
| Your dataset using stored procedure should be able to return fields and use in your report.In your stored procedure at the end you should have a select statement.Example:select field1, field2, field3 from TableABCRefresh your datasets and you should see the fields to drag and drop into your report. |
|
|
|
|
|
|
Stored Procedure fields