August 21st, 2003, 11:28 AM
CrystalReport 3-level sales report - missing data if no row at level3
This should be a simple thing to do with Crystal.
Haven't found answer despite many forum searches
- but this is only my 2nd night playing with Crystal.
Consider a sales report fetching data from 3 tables;
with simple 1-to-many relationships:
REGION --> SALESFORCE --> DEALS
Goal is to produce report looking like this:
If I take the simple grouping approach with deals in
REGION A (details + stats)
SALESMAN X (details + stats)
DEAL M (details)
DEAL N (details)
SALESMAN Y (details + stats)
REGION B (details + stats)
REGION C (details + stats)
SALESMAN Z (details + stats)
"details" view, and salesforce and region as groups
then the end report is missing SALESMAN Y, REGION B
and REGION C (because there is no deal there). But I
still want them to appear (for completeness and statistics
If I take subreport approach, well... I cannot have
a subreport within subreport so can't go beyond
So what are my options? I am most likely missing
something obvious... Many thanks in advance for your
Last edited by dl29200; August 21st, 2003 at 01:46 PM.
Click Here to Expand Forum to Full Width
This is a CodeGuru survey question.