Forum Discussion

Karolina411's avatar
Karolina411
Helper V
2 years ago

Displaying 2 datsets on one page using Monthyear Parameter

Greetings! I have a Paginated Reports (I am using a tabular model from our analysis server) question as I have 2 datasets joined by a common Parameter which is the DateColumn MonthYear- I have these ...
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi  Karolina411 ,

 

In the table, you can try to use the lookup function to extract data from the second dataset based on the key fields in the first dataset. The syntax is shown below:

=Lookup(Fields!CommonField.Value, Fields!CommonField.Value, Fields!DesiredField.Value, "Dataset2")

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Karolina411's avatar
    Karolina411
    Helper V
    2 years ago

    Thank you. I tried that but get this error= The 'Value' expression for the text box 'Textbox10' has a scope parameter that is not valid for a lookup function. The scope parameter must be set to a string constant that is the name of a dataset.
    ----------------------------
    The definition of the report '' is invalid.
    ----------------------------
    An error occurred during local report processing.