Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Help is it possible Post Reply Post New Topic
Author Message
jeremybme
Newbie
Newbie


Joined: 14 Aug 2007
Online Status: Offline
Posts: 1
Quote jeremybme Replybullet Topic: Help is it possible
    Posted: 14 Aug 2007 at 2:14pm
I'll admit i am new to cyrstal reports, here is what i need to do and i dont know if it is possible
 
We have a database that tracks appointments by type of appointment and a coresponding appointment date.
The date is in a standard Date Time Field.
 
I need to sum the appointments for the current month, grouped by type of appointment and then in the column next to the sum, show a sum of appointments by type for this month 1 year ago.
 
 
So ideally it would look like a cross tab
 
                    Aug 2007   Aug 2006
Eye Dr                 12             44
Foot Dr                31              22
 
 
etc etc, and it should always be current month and same month last year.
 
is this possible?
 
 
 
 
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 14 Aug 2007 at 9:22pm
Since you are new to CR, this will be a bit of a challenge and it will be hard to answer on a forum without being able to actually do it all (sorry).

First you need to just get the necessary records. This requires setting up a record selection filter that picks the dates for the current month of this year and last year. It will look something like this:
Month({table.field})=Month(Now) and (Year({table.field}=Year(Now) Or Year({table.field}=Year(Now)-1)

You might have to play with this to make it perfect. But ideally it will only return the records for August 2006 and 2007. Put some dummy data on the report to test if the proper fields are shown.

Then to display this data, add a cross-tab object and put the date filed in the column section and the Eye Dr field in the row section.

Try that and see how close you get. If you can get your filter to work then you should be doing good.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
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.047 seconds.