Auto filter of distinct values on columns in SQL Server Reporting Services?

Tags:
SQL Server Reporting Services
SSRS
Is there a way to have an auto filter of distinct values on columns in SQL Server Reporting Services?

Answer Wiki

Thanks. We'll let you know when a new response is added.

In SSRS you can have the multi-value and hidden Report Parameter, which get values FromQuery..

Create a dataset.. (SampleDS)
Query:

Select distinct ProductName from Tbl_Product

Create a Report Parameter Product.
select the option Multi-value and Hidden
In the available value option
select FromQuery ->

Choose SampleDS as Dataset and Value &l abel as ProductName

Create Resultant Dataset (FinalDS)
Query:

Select * from Tbl_Product where ProductName in (@Product)

hope this would be a way..:-)

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Adamantish
    That's great,

    What if your boss has an overwhelming fear of making views or tables and insists that you paste all your SQL straight into the dataset? Then I've got to get a distinct on the DS. Is that possible?
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following