Blog

Can I access two datasets in one Tablix?

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

we were 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.