SQL Server Reporting Services - assign dynamic dataset > Module Master Support Forums

Unanswered Active Topics

Forums Search

Subject: SQL Server Reporting Services - assign dynamic dataset

You are not authorized to post a reply.

Author

Messages

muniappan

Posts:53

07/05/2007 16:13
I am using VS 2005, DotNetNuke, SSRS 2005. When I am creating report using SSRS, It is allowing me to create static dataset. But In my situation I have the dataset created using C#. I have to pass this dataset dynamically to report instead of using static dataset. I am not finding any examples in the web. Can anybodies help me in this?

host

Posts:502

07/06/2007 09:50
I am not certain we can offer any help on this matter. The datasource and dataset needs to be defined in the report in order for it to work in our module. We do not allow in the current 2.0 version passing datasets dynamically.

clement

Posts:2

05/06/2008 11:20
Hi, I am using VS 2005 and SSRS. My data source is an Oracle database. I have 1 static dataset that feeds an SSRS parameter's possible values. I have a query to do which depends on this parameter value. So, I would like to include the SSRS parameter into my PL/SQL query. That means building a dynamic dataset. e.g. something like : ...where myAttribute='=Parameters!myParameter.Value'... (i did not test this) Does someone know how can I do this please ? a+, =) -=Clément=-

host

Posts:502

05/06/2008 12:04
Can you post your PL/SQL query? I'm not sure I'm following how you are wanting to substitue the value dynamically.

clement

Posts:2

05/06/2008 13:35
Hi, I think I have found the solution since, elsewhere. Here is what I wanted to do : -1st dataset : "FooValues" : select foo from t_foobar -SSRS Parameter : FooParameter, values obtained from query FooValues, display "Please select the Foo value you want Bar for" in the report -2nd dataset : "Bar" : select bar from t_foobar where foo=@FooParameter Thanks anyway, I will test it tomorrow. a+, =) -=Clément=-

You are not authorized to post a reply.

Forums > Module Masters Forum > SQL Reporting Services > SQL Server Reporting Services - assign dynamic dataset