I need to perform a calculation and show the result in the Page Header of my report.
The calculation comes from 3 different data sources: The report-scoped data source, and 2 separate data sources that are being bound to 2 tables in the Report Footer.
I'm able to get the values I need from the report-scoped data source, as follows:
= exec("ReportName", sum(Fields.Amount))
I have not been able to determine how to access the fields from the other 2 data sources. I've tried numerous ways to access the scope, but I always get "invalid scope" error. I've tried:
= exec ("My2ndDataSourceName", sum(Fields.Amount))
= exec ("My2ndTableName", sum(Fields.Amount))
= exec ("ReportName.My2ndTableName", sum(Fields.Amount))
I can't find good examples in the documentation that describe how to access scopes other than the top-level "report" scope.