sql server reporting services: Dynamic SQL statement -- sql server reporting services

Dynamic SQL statement

aplearner
9/8/2004 2:39:02 PM

sql server reporting services: Hi all

I want to create a report with dynamic select statement. Does matrix
supports to pass a select statement as a parameter at runtime? I am
wondering[could not understand few reviews] how the matrix will support to
add dynamic columns and rows at runtime. I will have fixed columns of 5 .
But my select statement might change by "where" condition at runtime.
Expecting an earliest suggestion.

Dynamic SQL statement

Ravi
9/9/2004 5:59:01 AM

The matrix can have dynamic columns means that depending
on what your dataset contains you can show a particular
number of columns.
I didnt exactly get what you mean by your SP needs to be
dynamic.
In your select statement you can change the where clause
(as you say) and depending on the result you get from the
SP execution you can make your report dynamic.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.