How to creat a month from a date to use in an crosstab
? Hello there,
I am kind of new to this forum and I have a question about reportbuilder.
I want to creat a CROSSTAB with on the left all month calculated.
And across the type of Complication (A report I have to creat for an
Hospital) and then a calculation of the ammount of complications.
I visualize it like this:
Complications
Complication1 Complication2 Complication3
Month
1 50 10 20
2 60 15 30
3 70 18 40
4 55 12 20
5 59 19 50
6 65 10 20
Well the Crostab I can figure out.
But an expression how to make de date of the complication registration an
month value... well that is a *&^@^$
I have been a whole day trying to figure that one out.
But unfortunatly my knwoledge of Reportbuilder isn't that great
I have been searching the internet for an expression
But no luck.
I Found one expression:
Extract (Month from complication.Date)
But it doesn't work.
Can anybody help me with that one.
Thanx,
Nordin
Rportbuilder
--- posted by geoForum on http://delphi.newswhat.com
I am kind of new to this forum and I have a question about reportbuilder.
I want to creat a CROSSTAB with on the left all month calculated.
And across the type of Complication (A report I have to creat for an
Hospital) and then a calculation of the ammount of complications.
I visualize it like this:
Complications
Complication1 Complication2 Complication3
Month
1 50 10 20
2 60 15 30
3 70 18 40
4 55 12 20
5 59 19 50
6 65 10 20
Well the Crostab I can figure out.
But an expression how to make de date of the complication registration an
month value... well that is a *&^@^$
I have been a whole day trying to figure that one out.
But unfortunatly my knwoledge of Reportbuilder isn't that great
I have been searching the internet for an expression
But no luck.
I Found one expression:
Extract (Month from complication.Date)
But it doesn't work.
Can anybody help me with that one.
Thanx,
Nordin
Rportbuilder
--- posted by geoForum on http://delphi.newswhat.com
This discussion has been closed.
Comments
You have two options in this case.
1. Depending on which database you are connecting to, you could use the
Extract() function. You mentioned that this does not work so perhaps your
DB does not support this function. Check the documentation for the DB you
are using and see if there is a similar function you can use.
2. If you have a DateTime field, you can right click over the Month row in
the CrossTab designer and set the display format to 'mmmm'. This will only
display the month part of the datetime.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com