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