Formula fields in Crystal Reports

Discussion in 'ASP .Net' started by Michelle Stone, Jan 10, 2004.

  1. I have bound a Crystal Report to a dataset that contains
    two fields "var1" and "var2" both of which are of DOUBLE
    type.

    I want to display the sum of the two on my report.

    So i created a FORMULA field in which i typed MySet.var1
    + MySet.var2

    where MySet is the name of the dataset added to the
    crystal report.

    Surprisingly (though there are no errors displayed),
    nothing shows up in the report after i dragged and
    dropped the new formula field onto the report.

    What could be the issue? I confirmed that the values are
    there (i mean var1 and var2 exists with proper values).

    Thank you.
     
    Michelle Stone, Jan 10, 2004
    #1
    1. Advertisements

  2. Michelle Stone

    rahul.chitte

    Joined:
    Feb 25, 2008
    Messages:
    1
    Likes Received:
    0
    ur solution

    whatever u r doing is something like concatinating 2 strings in Crystal report.
    Use sum() mathematical function available in formula editor..
    and simply provide the fields u require to compute in sum() function.
    I hope this will be helpful 4 u.
     
    rahul.chitte, Feb 25, 2008
    #2
    1. Advertisements

  3. Michelle Stone

    JohnPantoo

    Joined:
    Sep 19, 2011
    Messages:
    3
    Likes Received:
    0
    JohnPantoo, Sep 19, 2011
    #3
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.