I need some help with regards to bringing the amounts from a proforma Invoice to a main report.
I have attached the zip file for the main report(PM652500.rpx) and the subreport. (PM652500CI.rpx)
I have the below parameters on the main report.
Below is the external parameter for the sub report.
Parameters on the subreport
My problem is, I can’t figure out how to populate the amounts for [PMProformaLineWithPrevious.CuryLineTotal] on the main report which on the below column.
Best answer by BenjaminCrisman
@pauledpalina66 Am I understanding correctly that the amounts display correctly in the subreport, it’s only when the column is used in the main report that it fails?
If this is the case, you will need to set the value in the subreport as a variable and then use the following format to use subreport variables in the main report; if subreport variable name is $LineTotal, then you would use $[SubreportName]_LineTotal.
This will call the value from the subreport into the main report
@pauledpalina66 Am I understanding correctly that the amounts display correctly in the subreport, it’s only when the column is used in the main report that it fails?
If this is the case, you will need to set the value in the subreport as a variable and then use the following format to use subreport variables in the main report; if subreport variable name is $LineTotal, then you would use $[SubreportName]_LineTotal.
This will call the value from the subreport into the main report