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 |
|
kishoremcp
Starting Member
41 Posts |
 Posted - 2014-01-08 : 00:33:52
|
| Hi, I have a query which i have in SQL runs without any problem which is dynamic. When I put the same in SSRS, it is asking me to define the parameter. I have already declared and set the parameter in SQL query and even then i am facing the same issue. Please help me the workaround...RegardsKishore |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-01-08 : 06:45:59
|
| for ssrs to pick up fields and parameters correctly the query metadata has to be static. so what you need to do is first add static query as source and create the metadata and parameters. Once its all set replace static query with dynamic counterpart. I assume in nay case your resultset matadata will not change otherwise SSRS will break and start complaining of missing columns.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
Query Issue for SSRS