| Author |
Message |
shefe
Groupie
Joined: 09 Feb 2008
Online Status: Offline
Posts: 48
|
   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
|
 IP Logged |
|
|
Keikoku
Senior Member
Joined: 01 Dec 2010
Online Status: Offline
Posts: 386
|
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 Logged |
|
shefe
Groupie
Joined: 09 Feb 2008
Online Status: Offline
Posts: 48
|
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 Logged |
|
shefe
Groupie
Joined: 09 Feb 2008
Online Status: Offline
Posts: 48
|
Posted: 27 Jun 2011 at 4:42pm |
|
Does anyone know how to show dates from July 5 to auG 12TH on cross bar??
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
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 Logged |
|
shefe
Groupie
Joined: 09 Feb 2008
Online Status: Offline
Posts: 48
|
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 Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
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 Logged |
|
shefe
Groupie
Joined: 09 Feb 2008
Online Status: Offline
Posts: 48
|
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 Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 28 Jun 2011 at 7:07am |
|
but how do you know that that monday in the DB is = 7-11?
|
|
IP Logged |
|
shefe
Groupie
Joined: 09 Feb 2008
Online Status: Offline
Posts: 48
|
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 Logged |
|
|
|
a