Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Report format question Post Reply Post New Topic
Author Message
nicke
Newbie
Newbie
Avatar

Joined: 16 Nov 2007
Location: United Kingdom
Online Status: Offline
Posts: 1
Quote nicke Replybullet Topic: Report format question
    Posted: 16 Nov 2007 at 9:52am
I have not used Crystal for a long long time, I would love someone to answer the following question about if something is possible to produce in Crystal.  I can easily do it in Excel, but if I move to Crystal I need to be able to reproduce it.
 
Down the left I have the metrics, e.g. Calls Offerered, Calls Answered
 
Along the top I have Monday to Sunday columns, then a weekly total, then a monthly total, then quarterly etc.
 
The totals then appear in the intersection of the metric and the column if that makes sense.
 
Sorry if I am sounding dense and asking a simple question, its just not something I ever wanted to do when using Crystal in the distant past.
 
I can send a visual example if anyone wants it.
 
Ta muchly
IP IP Logged
jkwrpc
Senior Member
Senior Member


Joined: 19 Jun 2007
Location: United States
Online Status: Offline
Posts: 432
Quote jkwrpc Replybullet Posted: 16 Nov 2007 at 10:58am

There are ways to do what you want. How much you can do in the data query will depend on the data you have in the database. If it has the right structure you may easily be able to do most of  this in the data grouping.

If not possible you could create formulas to read the data and plug it into the correct spot.
 
Finally you may consider a cross tab report since it appears you want summary kinds of data. Brian and others on the forum are more skilled in cross tab reporting than I am. Brian has a free book on the this website that includes chapters on cross tab reports as well as formulas and other info. Here is the link:
 
Hope some of this will get you started.
 
Regards,
 
John W.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.