Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: report showing each day of month?? Post Reply Post New Topic
Author Message
jbalbo
Senior Member
Senior Member
Avatar

Joined: 17 Feb 2011
Online Status: Offline
Posts: 219
Quote jbalbo Replybullet Topic: report showing each day of month??
    Posted: 06 Oct 2011 at 4:20am
Hi,
 
I know im not going to explain this correctly the first time, but here I go...
 
I have a report that has 6 fields that can happen six times each with an effective date.
 
looks like
                 1    2    3    4    5   6
-------------------------------------------
#of cues   3 |  4  | 5  | 6  | 7  |8
------------------------------------------
# of att     7 | 8   |  9  |10| 2  | 4
---------------------------------------------
 
etc .. for 4 more fields  each set 6 * 6  has  the same date associated with it
 
 
so the above table is for 10/1/11
 
I want to display a report with days of the month 1 thru 31 across
 
so day1 would have
#of cues (1) =3
#of att(1) = 7
# of cues (2) = 4
# of att(2) = 8
 
etc...
 
any ideas or examples would be great
 
Thx
Joe
 
IP IP Logged
FrnhtGLI
Senior Member
Senior Member
Avatar

Joined: 22 May 2009
Online Status: Offline
Posts: 347
Quote FrnhtGLI Replybullet Posted: 06 Oct 2011 at 10:37am
Could you group by date then by the 6 "times" fields, then maybe by something else to get the grouping right?

Not sure exactly how it would work. If I had the data in front of me and I could run some tests I could probably tell you better as I'm more hands on. But I think your solution definitely has something to do with grouping.

|< /\ '][' ( )
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.