Search code examples
reporting-servicesgraphssrs-2008ssrs-tablix

Can I exclude information from SSRS Graph X Axis

I have a graph in SSRS that displays information for a user taken over a year. I successfully have the graph showing the data grouped by month so that there are 12 points on the X-Axis (Jan; Feb; ... Dec).

The problem is that SSRS is automatically adding the user name to the x axis as well which I do not want so that it shows in two lines(User A, Jan; User A, Feb; ... User A, Dec;).

I do not want the user name on the x axis. Normally I would resolve this by stripping the user name from the dataset but the dataset is attached to a Tablix and the graph is in the data cell of the tablix, so that the tablix has a row for every user in the dataset and a chart showing the data for that user, so unfortunately the user name has to exist in the dataset or else the Tablix could not do the required grouping.

Thank you for any support you can give.

an example of the problem
(source: cbih.co.uk)

Solution

  • Thank you to Aditya for the support I have received so far, it appears that I have worked it out now. The series of 'Shift Logs Raised' had the User Namefield as a category and that was why the name was being pulled into the X axis.

    This option can be found by clicking on the axis on the graph, then right clicking, going to [Series Property], [Serie Data] and then [Category Field].

    Thank you, I hope this helps others in future.