Hi!
I am trying to pass calculated numeric field data from the main report to the subreport. I also am passing field data to the subreport with no problem, it's only calculated data not working.
The data is from the calculated field is called YYYY0901. The calculation simply converts a 6 digit integer from another field into an 8 digit integer.
I created the parameter within the subreport properties matching it up to a field in the subreport called DUE_DATE (image below). This field is just an 8 digit integer representing a date, e.g., 20200901 translates to Sept 1st of 2020.

When I run the report, nothing is returned from the subreport. If I hardcode the DUE_DATE in the subreport with a known proper value and just pass an ID to the person's record from the main report, I get the data. So the sub report and main report are working, I am having trouble passing the calculated data. I verified the calculated data is valid by including it into the main report so I can see what it should be and it is correct.
I am using MS Report Builder in SQL Server 16.
TIA, Kevin




