How to use Sharedvar
Dear all, I have two reports of which I would like to merge the Records, however the problem is that both reports look at the totally different databases and date fields.
I have created one report using one database and added a subreport on the report header with other database records.
Now I would like to sharedvar formula so that I can add both report records togeather. Both reports are running total manually with the formula.
How can I get my main report work with sharedvar? That is the question
Brian Reed replied
In this situation you would typically let the subreport display the data from its datasource, and then let the main report display the data from the other datasource. You wouldn't typically use a shared variable to pass all the fields from the one subreport back to the main report. You would use a shared variable if you need to calculate a subtotal or some other summary from the subreport, so that you could pass it to the main report to add or display next to some other totals that are calculated in the main report.