Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1410
  • Last Modified:

How to Show running total value in Report Header Section

Hello

We are using Crystal Reports XI. We created a report for the table given below:

SO                    TC                  Q          
A                      0,1                  6
A                      0,2                  6
B                      0,3                  3
C                      0,4                  1


We want to get the data from the table:

SO                      TC                    Q          
A                      0,3(0,1+0,2)         6
B                      0,3                       3
C                      0,4                       1

So grouped column SO, Added a sum to column TC and added a running total value to column Q.

We tried to use running total again (in group header) we get the data below:

SO                      TC                  Q          
A                      0,3                    6
                                                6
B                      0,3                    3
                                                9
C                      0,4                   1
                                               10

The problem is We to see the total value of column Q (10) in as a summary in the report header.

Tried to use "maximum" of running total field but got the message "can't summarize this field).

Wbr
0
TAI-
Asked:
TAI-
  • 2
  • 2
1 Solution
 
mlmccCommented:
You can't because the Running Total is caluclated while the report is being printed and the total isn't available when the Report Header is printed.



Since you are combining fields and not summing all the data, I assume the Summary functions return the wrong value.

mlmcc
0
 
TAI-Author Commented:
is there any other way to do it?
0
 
mlmccCommented:
You could create a subreport to calculate the value and return it to the main program.

mlmcc
0
 
TAI-Author Commented:
We asked to our IT department to create a "view" from the tables we re using to solve this and it worked.

i could not be able to do it by using a sub-report.

Anyway, thanx for your answer.

Wbr
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now