Solved

Change and existing report

Posted on 2012-03-22
5
193 Views
Last Modified: 2012-05-09
Hi All,

Ive got the attached report which pulls totals of various suppliers so it outputs like this.

Supplier Name            Total
Supplier No1               6
Supplier No2               17
Supplier No3               9
Supplier No4               4
Supplier No5               8
Supplier No6               7
Supplier No7               5


Now I want to add Previous 5 days (1 column for each day) to the right of and a grand total of all totals at the end so it would look like this

Supplier Name            1st      2nd      3rd      4th      5th      Total
Supplier No1               6         3            5         3         4          21
Supplier No2               17       5            3         8         6          39
Supplier No3               9         5            4         7         7          32
Supplier No4               4         3            5         3         4          21
Supplier No5               8         8            9         3         3          31

What do I need to do with the report to achieve this?

Thank you
D
Leads-by-Source-Summary-v1.0.rpt
0
Comment
Question by:daiwhyte
  • 3
5 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 37752260
Have you tried a cross tab and changing the selection criteria

{CONTACT1.CREATEON} >= {?Run Date} - 5
AND
{CONTACT1.CREATEON} = {?Run Date}

Cross tab
COlumn - CreateOn - for each day
Row - Country
Cells - Count of Country

mlmcc
Leads-by-Source-Summary-rev1.rpt
0
 

Author Comment

by:daiwhyte
ID: 37776246
Ive implemented your suggestions and Im waiting for feedback from my line manager but it looks good apart from a bit of format which needs to be done.

Will post a reply once I have heard back.

Thanks
D
0
 

Author Comment

by:daiwhyte
ID: 37836428
Still waiting on feedback on this - sorry for delay.
0
 

Author Closing Comment

by:daiwhyte
ID: 37948726
Thank you.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question