Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Student Roster Post Reply Post New Topic
Page  of 2 Next >>
Author Message
shefe
Groupie
Groupie


Joined: 09 Feb 2008
Online Status: Offline
Posts: 48
Quote shefe Replybullet Topic: Student Roster
    Posted: 22 Jun 2011 at 5:50am
Hello All,

I need help with setting up a student roster, i wanted to use the cross-tab method but i was wondering if someone else have another idea about.
I want it to look like this below 

Names
7/5 7/6 7/7 7/8 7/11 7/12 7/13 7/14
  Tue Wed Thu Fri Mon Tue Wed Thu
 1.  a                        
 2.  b                        
 3.  c                        
 4.  d -  -  -  -             
 5.  e -  -  -  -             

IP IP Logged
Keikoku
Senior Member
Senior Member


Joined: 01 Dec 2010
Online Status: Offline
Posts: 386
Quote Keikoku Replybullet Posted: 22 Jun 2011 at 7:01am
Cross tab would be the easiest way in crystal since you're looking for a table-like structure.
IP IP Logged
shefe
Groupie
Groupie


Joined: 09 Feb 2008
Online Status: Offline
Posts: 48
Quote shefe Replybullet Posted: 22 Jun 2011 at 11:47am
Yea, but  i want to show the the dates so what formula do  i use for that.

the student name and days of the week shows up but i don't know what when it comes to dates
IP IP Logged
shefe
Groupie
Groupie


Joined: 09 Feb 2008
Online Status: Offline
Posts: 48
Quote shefe Replybullet Posted: 27 Jun 2011 at 4:42pm
Does anyone know how to show dates from July 5 to auG 12TH on cross bar??
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 28 Jun 2011 at 3:38am
your data for the source has to include all of those dates,
set the columns to use that date field
set the date group to be daily
in the crosstab right click on the date header and select Format Field
select the Date and Time tab
select the 3/1 option
select custom
for day of week section select short and position as trailing
IP IP Logged
shefe
Groupie
Groupie


Joined: 09 Feb 2008
Online Status: Offline
Posts: 48
Quote shefe Replybullet Posted: 28 Jun 2011 at 6:39am
The  database don't have a start date or end date, only has academic year, start term
may be i can use date formula but don't know what how to use it

IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 28 Jun 2011 at 6:49am
if your database has no dates in it then what are you puttin in the crosstab as there is no data that can reference a day anyway?

Edited by DBlank - 28 Jun 2011 at 6:50am
IP IP Logged
shefe
Groupie
Groupie


Joined: 09 Feb 2008
Online Status: Offline
Posts: 48
Quote shefe Replybullet Posted: 28 Jun 2011 at 7:01am
I have a database name that shows day of  the week.
it shows mon, tues, wed, thurs and fri

IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 28 Jun 2011 at 7:07am
but how do you know that that monday in the DB is = 7-11?
IP IP Logged
shefe
Groupie
Groupie


Joined: 09 Feb 2008
Online Status: Offline
Posts: 48
Quote shefe Replybullet Posted: 28 Jun 2011 at 7:15am
When  i browse field data, the field type says string and length says 255 and it displays Mon, Tues, weds, Thurs and Fri

IP IP Logged
Page  of 2 Next >>
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.