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 |
|
naveenjv
Starting Member
9 Posts |
 Posted - 2009-01-19 : 07:32:52
|
| Hi,I have created a report which fetches data from a stored procedure. Report has around 10 columns. Out of 10 columns first five columns are fixed, next five columns should be dynamic. My stored procedure (SP) retuns the number of columns based on input parameter. If my SP retuns 8 columns as output only 8 columns (5 fixed + 3 dynamic) have to be displayed and the other two columns to be hidden.How to achive this in Reporting Services 2005?Thanks & Regards,Naveen J V |
|
|
revelator
Starting Member
32 Posts |
Posted - 2009-01-19 : 08:58:22
|
| I've looked into this before, and I don't think it can be done.-----------------------------------Waiting for the Great Leap Forwards |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-19 : 09:22:49
|
| you need to bring all the columns from procedure at all times. then in report you need to write expression for hidden property of cells based on input value to conditionally hide them. |
|
|
|
sureshmandadi
Starting Member
1 Post |
Posted - 2009-08-18 : 07:07:41
|
quote:
Originally posted by naveenjv
Hi,I have created a report which fetches data from a stored procedure. Report has around 10 columns. Out of 10 columns first five columns are fixed, next five columns should be dynamic. My stored procedure (SP) retuns the number of columns based on input parameter. If my SP retuns 8 columns as output only 8 columns (5 fixed + 3 dynamic) have to be displayed and the other two columns to be hidden.How to achive this in Reporting Services 2005?Thanks & Regards,Naveen J V
Dear Naveen,I have the same problem like you mentioned above.If you got any solution please let me know. I have some deadlines.You can reach me suresh_recm@yahoo.co.in |
|
|
|
|
|
|
Can we have dynamic columns in Reporting Services