Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Daily Census Report Post Reply Post New Topic
Author Message
AMJacks
Newbie
Newbie
Avatar

Joined: 27 Oct 2009
Location: United States
Online Status: Offline
Posts: 3
Quote AMJacks Replybullet Topic: Daily Census Report
    Posted: 05 Mar 2010 at 7:25am
Hello,
I am trying to create a report that will show the days of a month as columns and my groups by selections and counts as rows.
 
So for the month of Dec
                                 Days-1  2 3 4 5 6 7 8 9 10...29 30 31
programname           Total  7  8
Aetna                                  4  5
BCBS                                   2  1
CIGNA                                 1   2
 
Any ideas?
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 05 Mar 2010 at 7:43am
My first thought is a cross tabs report, but I haven't used them much in CR.  I have used them more in Reporting Services.  The trick, I think is to a)make sure that there is an entry for EVERY date and b) make all the dates the same format (if they have a time component, strip it off so that the report can group by just the date. (At least this is what is needed in Reporting Services).  I am sure that if I got something wrong, someone will chime in and correct me.
 
HTH
IP IP Logged
AMJacks
Newbie
Newbie
Avatar

Joined: 27 Oct 2009
Location: United States
Online Status: Offline
Posts: 3
Quote AMJacks Replybullet Posted: 05 Mar 2010 at 8:02am
I may not have an entry for every date. But I will give the cross-tab a try, thanks.
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.