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

Thread: Crystal Report formula

Hybrid View

  1. #1
    Join Date
    Mar 2014
    Posts
    6

    Crystal Report formula

    I want to create a report like below layout:

    Name:  Capture.JPG
Views: 352
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
    Location
    England
    Posts
    6,918

    Re: Crystal Report formula

    Please don't multi-post the same question http://forums.codeguru.com/showthrea...eports-formula.

    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 https://creativecommons.org/publicdomain/zero/1.0/ 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.4.0)

  3. #3
    Join Date
    Mar 2015
    Location
    Bangladesh
    Posts
    18

    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)