CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums
Results 1 to 3 of 3

Thread: Crystal Report formula

  1. #1
    Join Date
    Mar 2014

    Crystal Report formula

    I want to create a report like below layout:

    Name:  Capture.JPG
Views: 362
Size:  25.0 KB

    So basically I want to display those charges to a specific table: Charge #1, Charge #2 and Charge#3 with conditions stated below

    - Charge #1: Account ID is in (1,2 and 3)
    - Charge # 2: Account ID is in (4,5 and 6)
    - Charge # 3: Account ID is in(7,8 and 9)

    So, there are three fields that involve on the report, Account Description (A,B,C,D,E and F), Charges, and Account ID (1,2,3,4,5,6,7,8 and 9)

    So what I did, I created three formulas for charges field. Charge1, Charge2 and Charge3. I placed them on the detail fields and do the select expert on each charge.

    1. The Select expert on Charge1, I placed the Account ID is equal to 1,2 and 3.
    2. The Select expert on Charge2, I placed the Account ID is equal to 4,5 and 6
    3. The Select expert on Charge3, I placed the Account ID is equal to 7,8 and 9

    The report returned blank when I previewed it. I am wondering if you know how to write the formula to handle this case?

    I am using Crystal Report V 11.

    Anyone can help?

  2. #2
    2kaud's Avatar
    2kaud is offline Super Moderator Power Poster
    Join Date
    Dec 2012

    Re: Crystal Report formula

    Please don't multi-post the same question

    Any member who is going to reply will for the first post.
    All advice is offered in good faith only. All my code is tested (unless stated explicitly otherwise) with the latest version of Microsoft Visual Studio (using the supported features of the latest standard) and is offered as examples only - not as production quality. I cannot offer advice regarding any other c/c++ compiler/IDE or incompatibilities with VS. You are ultimately responsible for the effects of your programs and the integrity of the machines they run on. Anything I post, code snippets, advice, etc is licensed as Public Domain and can be used without reference or acknowledgement. Also note that I only provide advice and guidance via the forums - and not via private messages!

    C++17 Compiler: Microsoft VS2019 (16.7.4)

  3. #3
    Join Date
    Mar 2015

    Re: Crystal Report formula

    You report file screenshot is looking good. What's more information you need?

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

On-Demand Webinars (sponsored)