Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
KlausEngel
Yak Posting Veteran
85 Posts |
 Posted - 2011-03-01 : 14:50:13
|
| I have an RS report that is gets its data from a SSSQL table with dynamically generated column headers. Is it possible to set up the report to reflect the change in column names in the db table? |
|
|
Randomluck
Starting Member
4 Posts |
Posted - 2011-03-01 : 19:04:02
|
| On way to do so is to create a second data source query. That query retrieves the column names, which are then referenced as labels. If looking for the table 'field names' as the labels, I'd recommend a stored procedure to retrieve the data as it may require accessing the system tables.It may require performing a PIVOT to make it easier to handle. |
 |
|
|
KlausEngel
Yak Posting Veteran
85 Posts |
Posted - 2011-04-14 : 16:23:02
|
| Would you mind explaining what you mean by 'referenced as labels'? How do I set up column names from a different data source? |
|
|
|
|
|
|
dynamically named column headers