Relative Content

Tag Archive for reporting-services

In SSRS how can you make the y-axis height be dynamic on the number of bars in the graph?

I would like to have the height be dynamic according to how many bars are displayed in the graph of an ssrs report. I’ve set the width and height property of the chart to be 7in, and 5in. The graph looks proportional if I have several bars, but if I only have one bar its still the same height. Its not that bad, but it would be nice to control that a bit more by the number of bars. Is there an auto setting I’m missing? Or is that something I need to write an expression for? Thanks!

SSRS Visual Studio data source issue

We have an SSRS report server with a data source called “DS123”, which contains the data source and initial catalog that most of our reports use.
When I create a new report in Visual Studio I create the data source in VS with the exact string that DS123 uses but when I deploy the report to the SSRS server I always have to manually select “A shared data source” and point it to the DS123 data source on the SSRS server, even though “A custom data source” has the exact same connection string. I get an “anonymous login” error if I don’t manually set it to the data source on the SSRS server.

SSRS Header issue

I’m new to SSRS and currently working on some reports. I’ve set the header to 3.5 inches and configured it to “print on the first page only.” However, I notice that a 3.5-inch blank space appears on the other pages. If anyone has any suggestions for dynamically removing this extra white space from the subsequent pages, I would appreciate your help.

Set Page Name in Excel export of SSRS based on Column Value

I am exporting a report from SSRS to Excel. I have grouped the data into two (2) pages in SSRS based on whether the value of a single column is less than zero (0) or not. I want to name one sheet in Excel “Less than zero” and the other “Between zero and 180”.