locked
ssrs 2008 using lookup feature RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I am changing an existing ssrs 2008 report. I need to add 2 value to the bottom of the existing report. The ssrs report uses a stored procedure that is extremely complex. I would prefer to obtain the data for the 2 extra columns need from accessing a second dataset. If there a way that I can use a 'lookup' feature to another dataset to obtain the data?

    Would you let me know if this is a possibility or not? If so,  would you show me how to accomplish this goal?

    Could I use a hidden parameter to obtain the required data needed for the report? I would just use one of the required parameters to obtain the data that I need.

    Thanks of your assistance!

    Sunday, June 4, 2017 9:52 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi midnight_car,

    To add 2 extra columns from the second dataset, it is possible to use the 'lookup' feature. To accomplish this, you need to match up two datasets using a field from each of the field. For example, I have two datasets as below:

    Now I would like to add the column "salesperson" to the table from dataset1, so I can use the expression:

    =Lookup(Fields!week.Value,Fields!week2.Value,Fields!salesperson.Value,"DataSet2")

    When Previewing, we can get

    For details of 'lookup' feature, you could refer to https://docs.microsoft.com/en-us/sql/reporting-services/report-design/report-builder-functions-lookup-function

    In terms of using hidden parameter to obtain the required data, I am afraid it is not possible because parameter is only used for filtering the data and cannot be used to render a data field in the report. 

    If you have any questions, please feel free to ask.

    Best Regards,

    Henry 



    • Edited by Henry Jiang Monday, June 5, 2017 2:14 AM
    • Proposed as answer by Henry Jiang Wednesday, June 7, 2017 8:44 AM
    • Marked as answer by midnight_car Thursday, June 8, 2017 3:31 AM
    Monday, June 5, 2017 2:13 AM