Report: how do I seed the week number? RRS feed

  • Question

  • I have a report which I am working on in Visual Studio 2010.

    I have a count of records by week in which I am using datgrouping="week".

    How do I seed the week number to match a financial year rather than Jan-Dec?

    I tried to change the start of the financial year in CRM to April, thinking that it would adjust the number but it has not.  Maybe I did it wrong or there is another way.  I though the Fiscal Year Settings were for precisely this sort of thing.

    Tuesday, November 4, 2014 3:14 PM

All replies

  • Hi Gordon,

    Change in Fiscal Year settings affects only Goals in CRM.

    For your requirement you need to create a custom ssrs report. There are 13 weeks in a quarter so week Offset will be 13. 

    You can write a function for calculation of weeks.

    Regards, Saad

    Wednesday, November 5, 2014 9:04 AM