Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Services / Reporting Services / July 2008

Tip: Looking for answers? Try searching our database.

How to show one dataset

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Robin9876 - 30 Jul 2008 13:53 GMT
In a SSRS 2005 report that has multiple datasets/tables. Is it
possible to only run or display a particular dataset based on a report
parameter?
Robin9876 - 31 Jul 2008 15:09 GMT
I have been able to set the hidden property on the report element.
However it still executes both datasets. Is it possible to control
which dataset is run?

> In a SSRS 2005 report that has multiple datasets/tables. Is it
> possible to only run or display a particular dataset based on a report
> parameter?
Bruce L-C  [MVP] - 31 Jul 2008 16:03 GMT
No it is not. The best you can do is to send a bogus value to the dataset
you don't want to run so that it returns 0 records. Keep in mind that
although Reporting Services creates a one to one mapping between query
parameters and report parameters you can change this to an expression. In
the dataset go click on ... go to the parameters tab. Create the expression
for one of your query parameters that causes it to return 0 records when you
are not displaying it. In this way at least it will execute quickly.

Signature

Bruce Loehle-Conger
MVP SQL Server Reporting Services

>I have been able to set the hidden property on the report element.
> However it still executes both datasets. Is it possible to control
[quoted text clipped - 3 lines]
>> possible to only run or display a particular dataset based on a report
>> parameter?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.