Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Break down the values Post Reply Post New Topic
Author Message
khaty
Newbie
Newbie
Avatar

Joined: 15 Jul 2008
Location: Malaysia
Online Status: Offline
Posts: 4
Quote khaty Replybullet Topic: Break down the values
    Posted: 28 Jul 2008 at 9:37pm
Hi All,
 
I really need help on this problem:
 
On of My Table called Day. It's indicate:
 
1   = Sun
2   = Mon
3   = Sun, Mon
4   = Tue
5   = Sun, Tue
6   = Mon, Tue
7   = Sun, Mon, Tue
8   = Wed
9   = Sun, Wed
10 = Mon, Wed
11 = Sun, Mon, Wed
12 = Tue, Wed
13 = Sun, Tue, Wed
14 = Mon, Tue, Wed
15 = Sun, Mon, Tue, Wed
16 = Thu
.
.
.
32 = Fri
64 = Sat
 
 
I want to make a report that list all the days that occured. For example, I have to attend training on every:
 
 Day                         Time  
   1                           10:00
   3                           09:00
  15                          11:00
 
Expected output: 
 
 Day                         Time  
 Sun                       10:00 -----> 1 = Sun
 Sun                       09:00  -----> 3 = Sun, Mon
 Sun                       11:00  -----> 15 = Sun, Mon, Tue, Wed  
 Mon                       09:00  -----> 3 = Sun, Mon
 Mon                       11:00 -----> 15 = Sun, Mon, Tue, Wed  
 Tue                        11:00 -----> 15 = Sun, Mon, Tue, Wed  
 Wed                      11:00 -----> 15 = Sun, Mon, Tue, Wed  
 
 
I'd try to use subreport (7 subreport per days), but it really takes time to view the output.
 
Please help...
 
Cheers
 
 
 
 
kt
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 29 Jul 2008 at 5:30am
Hi,
 
Can you list the columns and Data in your Day Table...
 
cheers
Rahul
IP IP Logged
khaty
Newbie
Newbie
Avatar

Joined: 15 Jul 2008
Location: Malaysia
Online Status: Offline
Posts: 4
Quote khaty Replybullet Posted: 29 Jul 2008 at 7:00pm
Hi Rahul,
These are the column and data for Day Table (same as above):
 
Day                     Time  
  1                       10:00
  3                       09:00
 15                      11:00
 
Expected Output (sorted by Day [Sun to Sat]):
 
 Day                         Time
 Sun                        09:00   
 Sun                        10:00
 Sun                        11:00 
 Mon                        09:00 
 Mon                        11:00
 Tue                         11:00
 Wed                       11:00
 
Hope this make sense..
 
Thanks
KT
 
 
kt
IP IP Logged
venkatesha
Newbie
Newbie


Joined: 29 Jun 2008
Online Status: Offline
Posts: 35
Quote venkatesha Replybullet Posted: 29 Jul 2008 at 10:56pm
Hi

Try to use this formula.

I hope this will help not sure


Left(WeekdayName (<Your Column Name> mod 7),3)

Cheers



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.000 seconds.