Solved

Change and existing report

Posted on 2012-03-22
5
192 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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
C# InstallShiled - Multiple Projects 3 67
Multiple Parameters in Crystal 11 76
Crystal Reports Server, Unable to remove users 8 42
Sum not calculating correctly 22 30
Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
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 …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
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…

776 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