create dataset for an existing SQL statement

[duanecwilson]

I have some complicated SQL Statements with Case statements, grouping, etc in the SQL. I want to know how to create a dataset for this SQL.

Then, I would like to know the best way to use that query in Reporting Services to create a report. Do I leave the grouping, having, order by in the query itself or do I do that in the report design itself?

Even if you can't answer all of this, any input would be appreciated. Thank you.

Duane Wilson

 

[Crowley16]

encase your complicated sql statements in a stored procedure, and then in SSRS, just call the stored procedure.

You can use a view or udf if they are more suitable...

Generally, leave the ordering off the source if you're going to be ordering on the report as well. As for grouping, well, that very much depends on your report since grouping can affect the actual data you get.


--------------------
Procrastinate Now!