Hi All,
When I was trying to get a sparkine report for monthwise data using the matrix report in report builder 3.0 and SSRS....i would not get the right order....i,e instead of Aug, Sep, Oct and Nov....I would get Sep, Nov, Oct and Aug.
After 2 days of struggle for this issue I finally found a link which gave a solution for this and the solution is listed below
In textbox which binds to Date fireld, I changed its expression to =MonthName(Month(Fields!QDate.Value), False). Now, Month name is displayed in table. Also I changed group's group and sort expression to =Month(Fields!QDate.Value).
When I was trying to get a sparkine report for monthwise data using the matrix report in report builder 3.0 and SSRS....i would not get the right order....i,e instead of Aug, Sep, Oct and Nov....I would get Sep, Nov, Oct and Aug.
After 2 days of struggle for this issue I finally found a link which gave a solution for this and the solution is listed below
In textbox which binds to Date fireld, I changed its expression to =MonthName(Month(Fields!QDate.Value), False). Now, Month name is displayed in table. Also I changed group's group and sort expression to =Month(Fields!QDate.Value).
No comments:
Post a Comment