on 09-18-2008 1:13 PM
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
Regards
Jehanzeb
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, you can't merge the two datasets in Crystal, although you can make them appear to be one continuous recordset if you line up the columns and remove extra whitepace. If you do it right, the only way you would be able to tell that they are not from the same dataset is the sorting. You won't be able to sort the recordsets together, only seperately.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.