Skip to Content
author's profile photo Former Member
Former Member

Showing sums for different groups in one text field


This is my first post. I've searched through the forums, but I haven't found anything helpful. That could be due to lack of experience, and not exactly knowing what I'm looking for, but here goes...

My problem is this:

I want to put a sum field in a text field, and also want the sum of the previous year to appear in the same text field. Something like this:

So far this year we have approved 1 234 (1 092) persons...

The sum inside the brackets being the corresponding sum for the same period the previous year.

I've made 2 parameter fields, one for setting the current period, and one for setting the period the previous year.

Based on these parameter fields I can assign the rows to different groups, and this works fine. The group sums that I have put in the group headers also show the correct numbers.

The problem is I want both of these sums in ONE text field for example in the report header, but I can't figure out how to make that happen.

I'm running Crystal Reports 2008.

Any help would be greatly appreciated.

Thanks in advance!


Mattias Elm

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 12, 2009 at 02:35 PM

    You can write a formula and try to do the concatenation there and put this formula field in a text box.

    Hope this helps!!

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.