Search code examples
sql-serverreporting-servicesssrs-2008

SSRS Column Chart (Bar Chart) needs to appear more clear

I have an SSRS chart with a lot of values on the x axis. I have a requirement that the charts need to be exported to a pdf .

My Column/bar chart looks something like this :

enter image description here

If I have the chart any wider than this , the chart doesnt look good on the pdf , after being exported to a pdf.

Please let me know if there is a way I can make the chart look clear to people reading it. One thing that I would like to do is make the chart into two charts , one appearing below the other whenever there are more number of values on the x axis. But I do not know how I can achieve this ? Is this at all possible ? Please let me know if there is a way I can solve the problem.

Solution

  • As requested, I've updated my answer to show how you can create multiple graphs inside a table.

    To demonstrate this I wrote a sample dataset. The Sql is at the bottom in case anyone is interested.

    dataset view

    • I set up a parameter to set the amount of items I want on the graph. parameter view

    • Then set up a calculated field on the dataset for the graph group calculated field view

    • Set up a table with a single cell and row group using our calculated field table view

    • Add a graph to the report graph view

    • Drag the graph into the table, into the grouping we made. graph table view

    • Then we can get multiple graphs based on our table row group report view

    report view2

    --Generate random dataset
--
declare @date datetime
declare @count int
set @count = 1
set @date = getdate()
declare @values table
(rowNumber int, value int, dateValue datetime)


while @count <= 250
begin

insert into @values(rowNumber, value, dateValue)
select @count, CAST(RAND() * 100 AS INT), @date

set @count = @count + 1
set @date = dateadd(day,-1,@date)
end

select * from @values