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 |
|
Dance Doll
Yak Posting Veteran
54 Posts |
 Posted - 2007-01-29 : 17:51:53
|
| I got problem after I setup a dataset for my stored procedure. The stored procedure is using dynamic query to return data. And the (Q)columns are dynamically changing depending on the data from a table.for ex: EmployeeID, name, Q1, Q2, Q3.....It's fine when I run the dataset within the report service. But the Fields is showing only Q1.Does someone help me how to display every columns in the report?Thanks! |
|
|
ARC
Starting Member
10 Posts |
Posted - 2007-02-07 : 07:58:08
|
sounds scary to me, I suspect that the problem is because RS cannot decide how many columns are going to be returned and cannot therefore bind to 'possibly there' columns'I think the only way round it is to use a temp table which has enough columns to satisfy every eventuality and then use the visability feature to show only the ones that are there.Added:Though having said that you may be able to fudge it with a code module, but that is proberbly a lot more work.  |
 |
|
|
balajii78
Starting Member
13 Posts |
Posted - 2007-02-08 : 01:22:08
|
| Go to the report designer statically create columns u use in the final select query in the stored proc then run the report all the cols will b displayed |
|
|
|
|
|
|
Dynamic query in reporting services