What I would like to do build my logic with a SQL stored procedure and just drop those fields on the report.
The report runs with the embedded SQL datasource/dataset but I can’t find a way to join the 2 datasets together.
The RDD parameter values inputted will drive the report.
The fields where I would like to drop the fields are in the Page Footer and gives me an odd Expression error about an aggregated expression.
Is this even possible in SSRS? (scratching my head).