Dynamic SQL statement

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.
Thanks in advance.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.
>--Original Message--
>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.
>Thanks in advance.
>.
>