none
Report builder 3.0 How to display all months in x-asis

    Question

  • I can't get a chart to display all months on the x axis when there is data only for some months. I have data only for September and October, but I want to display all the other months too. I have to do this same thing for year, day, and quarter.


    I would like to have in the x axis all the months from January to December even tho there is no data registered.

    Part of my code:

    =SWITCH
    (
    Parameters!Grouping3.Value = "Month", Monthname(Month(SWITCH(
    Parameters!Grouping2.Value = "StartDate",Fields!StartDate.Value,
    Parameters!Grouping2.Value = "DueDate",Fields!DueDate.Value,
    Parameters!Grouping2.Value = "ProposedResolutionDate", Fields!ProposedResolutionDate.Value
    ))).ToString() & " " & Year(SWITCH(
    Parameters!Grouping2.Value = "StartDate",Fields!StartDate.Value,
    Parameters!Grouping2.Value = "DueDate",Fields!DueDate.Value,
    Parameters!Grouping2.Value = "ProposedResolutionDate", Fields!ProposedResolutionDate.Value
    )).ToString()

    Tuesday, October 15, 2013 7:39 PM

Answers

All replies