3 Summary Reports (in portals?) with Grand Total?
I have a report which:
- finds field Kg1 = <0
- sorts by date (Sub-summary by Date1 (Leading)
- Body containing several fields
- (Sub-summary by Date1 (Trailing)
- Trailing Grand Summary (Kg1 plus other fields)
Now I need a report which does the same but includes data from Kg2 (by Date2) and Kg3 (by Date3) gathered from same records.
Finally I need to display Grand Total of Grand Summaries (Kg1 + Kg2 + Kg3) and same with a couple of other fields.
How do I do this?
Do I use portals? Also just saw mention on New Window in the scripts menu. ?