How to show column headers from dynamic columns stored procedure result?
-
Hello.
I need to label the columns on SSRS RDL table without knowing the names at design time.
The stored procedure has a dynamic query so the resulting columns from the dataset are known at execution time.
How can I set the column headers on my report table?
Thanks!
Manu
-
Simplest thing would be you can have two dataset one returns header value and the other dataset return the coulmns
-
Just add another row above the details row and drag the column heading fields from the dataset.
Assuming the SP contains columns for both headers(labels) and detail rows, you could even group by and place the header columns (of the SP) on column labels (of table control) in the group's header row.
Yes, I agree, It reads so convoluted.
"Software changes. This is a rather obvious statement, but it is a fact that must be ever present in the minds of developers and architects. Although we tend to think of software development as chiefly an engineering exercise, the analogy breaks down very quickly. When was the last time someone asked the designers of the Empire State building to add ten new floors at the bottom, put a pool on the top, and have all of this done before Monday morning? " : Doug Purdy, Microsoft Corporation
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply