Forum Discussion

simona0808's avatar
simona0808
Helper I
4 years ago
Solved

SSRS Report

Hello everyone. I am working on an SSRS report(not very complicated). In a nutshell, I have one dataset(including 4 columns I want to display in the table in the report) and a second dataset called...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi simona0808 ,

     

    It is feasible to use two datasets for two parameters.

    If you want to use one dataset, you can use VB code to remove duplicate filter values from parameter drop-down. Please refer to this article for the exact steps.

    SSRS: Remove Duplicate Filter Values from Parameter Drop-down using VB code 


    Here are the results of my tests. Note that you should move the DummyNamesFilter parameter to the top of the NamesFilter parameter.

     

     

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-kkf-msft's avatar
v-kkf-msft
Community Support
4 years ago

Hi @simona0808 ,

 

Has your problem been solved? If it is solved, please mark a reply which is helpful to you.

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.


Best Regards,
Winniz