|
-
August 21st, 2003, 11:28 AM
#1
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:
Code:
REGION A (details + stats)
SALESMAN X (details + stats)
DEAL M (details)
DEAL N (details)
SALESMAN Y (details + stats)
<null>
REGION B (details + stats)
<null>
REGION C (details + stats)
SALESMAN Z (details + stats)
<null>
etc.
If I take the simple grouping approach with deals in
"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
calculation purpose).
If I take subreport approach, well... I cannot have
a subreport within subreport so can't go beyond
SALESFORCE.
So what are my options? I am most likely missing
something obvious... Many thanks in advance for your
suggestions.
Dave
Last edited by dl29200; August 21st, 2003 at 01:46 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|