Change and existing report

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
daiwhyteAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
daiwhyteAuthor Commented:
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
daiwhyteAuthor Commented:
Still waiting on feedback on this - sorry for delay.
0
daiwhyteAuthor Commented:
Thank you.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.