Datepart?

Hi everyone, Im currently using SSRS 2000. I have a report that pulls
data since 2001. I used Datepart('m", Fields!Shipped_Date.Value)
to break it down into months. It works except that it doesnt separate
the year. It'll group all of january together but 2001,2002,2003, etc,
together. Then when I used Y to break it down by year, it does break
it by year but keeps all the months together....well what I want is
to be able to have it jan 2001, feb 2001, jan 2002, separately group.
Hope I didnt confuse anyone. All pointers welcomed.
Thanks,
AbnerOn Oct 9, 4:57 pm, abz <abz81s...@.gmail.com> wrote:
> Hi everyone, Im currently using SSRS 2000. I have a report that pulls
> data since 2001. I used Datepart('m", Fields!Shipped_Date.Value)
> to break it down into months. It works except that it doesnt separate
> the year. It'll group all of january together but 2001,2002,2003, etc,
> together. Then when I used Y to break it down by year, it does break
> it by year but keeps all the months together....well what I want is
> to be able to have it jan 2001, feb 2001, jan 2002, separately group.
> Hope I didnt confuse anyone. All pointers welcomed.
> Thanks,
> Abner
Have you tried concatenating them together for grouping? Grouping by
an expression similar to:
=DatePart("m", Fields!Shipped_Date.Value) + " " + DatePart("y", Fields!
Shipped_Date.Value)
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Oct 9, 6:12 pm, EMartinez <emartinez...@.gmail.com> wrote:
> On Oct 9, 4:57 pm, abz <abz81s...@.gmail.com> wrote:
> > Hi everyone, Im currently using SSRS 2000. I have a report that pulls
> > data since 2001. I used Datepart('m", Fields!Shipped_Date.Value)
> > to break it down into months. It works except that it doesnt separate
> > the year. It'll group all of january together but 2001,2002,2003, etc,
> > together. Then when I used Y to break it down by year, it does break
> > it by year but keeps all the months together....well what I want is
> > to be able to have it jan 2001, feb 2001, jan 2002, separately group.
> > Hope I didnt confuse anyone. All pointers welcomed.
> > Thanks,
> > Abner
> Have you tried concatenating them together for grouping? Grouping by
> an expression similar to:
> =DatePart("m", Fields!Shipped_Date.Value) + " " + DatePart("y", Fields!
> Shipped_Date.Value)
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
Thanks Enrique
Its up and running.
Abner|||On Oct 10, 10:09 am, abz <abz81s...@.gmail.com> wrote:
> On Oct 9, 6:12 pm, EMartinez <emartinez...@.gmail.com> wrote:
>
> > On Oct 9, 4:57 pm, abz <abz81s...@.gmail.com> wrote:
> > > Hi everyone, Im currently using SSRS 2000. I have a report that pulls
> > > data since 2001. I used Datepart('m", Fields!Shipped_Date.Value)
> > > to break it down into months. It works except that it doesnt separate
> > > the year. It'll group all of january together but 2001,2002,2003, etc,
> > > together. Then when I used Y to break it down by year, it does break
> > > it by year but keeps all the months together....well what I want is
> > > to be able to have it jan 2001, feb 2001, jan 2002, separately group.
> > > Hope I didnt confuse anyone. All pointers welcomed.
> > > Thanks,
> > > Abner
> > Have you tried concatenating them together for grouping? Grouping by
> > an expression similar to:
> > =DatePart("m", Fields!Shipped_Date.Value) + " " + DatePart("y", Fields!
> > Shipped_Date.Value)
> > Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
> Thanks Enrique
> Its up and running.
> Abner
You're welcome. Glad that I could be of assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

DateDiff: Calculating working days

I am trying to use the DateDiff function to calculate the difference between two dates in working days only... Is this possible in SSRS 2005, or can anyone suggest an alternate solution?

Yes, this is possible; however, normally you must account for holidays and when all is said and done I would suggest that you give a look to this article:

http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html

This discusses establishing a calendar table which ought to help with computing "working days".

( Adolf: what does "NB" stand for? )

|||NB this article doesn't discuss different sets of holidays

e.g. england, wales, scotland, ireland

have different public holidays despite being in the UK

you may wish to add extra columns to cater for this|||thank you.. I've decided to pinch the calendar table off another db and will try to follow the examples.

DateDiff: Calculating working days

I am trying to use the DateDiff function to calculate the difference between two dates in working days only... Is this possible in SSRS 2005, or can anyone suggest an alternate solution?

Yes, this is possible; however, normally you must account for holidays and when all is said and done I would suggest that you give a look to this article:

http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html

This discusses establishing a calendar table which ought to help with computing "working days".

( Adolf: what does "NB" stand for? )

|||NB this article doesn't discuss different sets of holidays

e.g. england, wales, scotland, ireland

have different public holidays despite being in the UK

you may wish to add extra columns to cater for this|||thank you.. I've decided to pinch the calendar table off another db and will try to follow the examples.

DateDiff + Where am I going wrong?

Hi,

I'm creating a sample report in Visual Studio 2005 to be used in SSRS 2005.

I'm attempting to do some conditional formatting like so:

=IIF(DateDiff("Day", Fields!Jobseeker.Last Interview.Value, NOW()) > 14, "Red", "Transparent"

When ever I try and preview the report, VS throws a wobblie and closes down. The format of the Last Interview column is dd/mm/yyyy.

Any suggestions

Thanks, Steve

Hi, Steve,

Use VB parameters to DateDiff - ... try 'd' instead of "Day".

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vafctdatediff.asp

Also verify that the "Last Interview" field name has an underscore "Last_Interview" - that should have happened automatically when you created a dataset from the query.

_

This posting is provided "AS IS" with no warranties, and confers no rights.