Accessing Two datasets in a Tablix Report

In this example, PTS was uplifting a BAQ Crystal Report to SSRS. We had a need where we needed to use a parameter from the BAQ Report Parameter Dataset when my main Tablix was using the BAQ Report Result Dataset. Why did I need the parameter? There was a complex expression that HAD to be created in a textbox expression field. Due to this, I had no other option than to bring the Number01 Field.

I was able to use a subquery in the Select statement to reference the BAQ Report Parameter Table with the same GUID. This data didn’t need to be linked on anything specific because the Parameters table applies to all fields. The below was a simple yet elegant solution to the common one dataset per Tablix problem.