locked
Generate Dynamic Report in SSRS RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi - I was wondering if you could provide some insight my struggles with creating a dynamic report within SSRS. I am doing a compare between 2 result sets and need to display all data and specify the difference in the results.

    Customer 1 (Edward) displays items: Pink, Blue, Yellow

    Customer 2 (Peter) displays items: Pink, Blue, Green

    I would like to be able to get results: Columname/Header: Edward with 4 rows and Green displayed as either "missing" or "NO"

    I would like to be able to get results: Columname/Header: Peter with 4 rows and Yellow displayed as either "missing" or "NO".

    This final result set is generated by dynamic pivot sql.

    When trying to display this in visual studio the data does not display I either get blanks or a repetition of the name headers for my results. I just can't seem to get the matrix setup correctly to accurately display.

    Hopefully I make sense and thanks in advanced for any responses...

    Thanks

    LB

    Monday, November 30, 2015 12:20 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi LegallyBlonde,

    Based on my understanding, you want to make different users see different report items, right?

    In your scenario, you can achieve your requirement on reporting services level. In Reporting Services, there is a built-in field called UserID which returns ID of the user running the report. You can specify values for the Yellow and Green based on the UserID field. For example, you can specify expression like below for Yellow values:

    =IIF(User!UserID="Edward",Fields!Date.Value,"missing")

    Reference:
    Using the User Collection
     
    If you have any question, please feel free to ask.

    Best regards,
    Qiuyun Yu

    Qiuyun Yu
    TechNet Community Support


    Monday, November 30, 2015 9:26 AM