CrystalReport 3-level sales report - missing data if no row at level3
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 1 of 1

Thread: CrystalReport 3-level sales report - missing data if no row at level3

  1. #1
    Join Date
    Aug 2003
    Posts
    2

    Question 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
  •  


Windows Mobile Development Center


Click Here to Expand Forum to Full Width

This is a CodeGuru survey question.


Featured


HTML5 Development Center