Need access to Two datasets in 1 Tablix
In this example, I was uplifting a BAQ Crystal Report to SSRS. I had a need where I needed to use a parameter from the BAQReportParameter Dataset when my main Tablix was using the BAQReportResult 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 BAQReportParameter 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.