we have a report that has many dataset
but only one store procedure.
is there a way we can do some kind of filter and groups to use one
store procedure instead of 6 store procedure for each dataset
Reporting design with dataset and store procedure
Hot Topic
- BI Portal 2003 on a 64 Bit Machine
- Installing SQL Server Express
- Deadlock problem? 3 way conditional split of data from one table to another never completes
- Sql2005 standard to Sql2005 enterprise edition
- IMPORTANT: "Unexpected Error occured" When trying to view calculations tab
- fields cannot be used in page headers or footers.
- Difficult T-SQL query (for me anyways)
- SQL Server 2005 Database Tuning Advisor DTA tuning SQL Server 2000 FAILS
- Increase # of chars Query Editor when looking at large varchar field
- SessionTrace during XMLA execution?
SQL Server
- matrix formatting
- Exporting SQL DB files
- Which tool can be used to format the codes?
- Show dimension members only if there is data associated with them
- Newbie question about installation
- data mining : associate rules
- YTD summation after a pivot.
- Same cube, different answers.
- comparing nvarchar(max) column using like to non-ASCII range
- Failed to connect to sql server problem - a strange one!
Reporting design with dataset and store procedure
Sundaraguru
e.g. Dataset1 pass in 1, Dataset2 pass in 2, etc...
And see if you can share the codes in the SP, and differentiate the code ONLY IF necessary
Scherild
can you go a bit more detail for me
not sure how i do that on the SP with dataset
Everything will be one report pages
Tony P Brightman