Wednesday, 30 April 2014

SSRS: line chart is not displaying during integration in live server

Scenario: I created one SSRS (SQL Server Reporting Services) report which was containing few line charts. During quality check of these reports, it was observed that some graphs were not displaying which were containing less or no data.
(Refer the below screen shot: SSRS Chart)

We did some analysis on this and observed that an unwanted style sheet has been applied into this chart, which is affecting visibility of the graph.

This style sheet was containing the following properties -
(Refer the below screen shot)


We tried to override these CSS properties with custom style sheet but unfortunately it couldn't get succeed.

Then i tried to change height and width for chart components(Horizontal axis ) and found an easy solution.

Easy solution:
If font size would be increased in chart horizontal axis then charts were coming fine. So i changed in all the charts and it solved my problem.
(Refer the below screen shot)

Change in font size -
(Refer the below screen shot)



After changing the font size -
(Refer the below screen shot)

And also when checked the style now from developer tool- 
(Refer the below screen shot)

Please share your thoughts if you experienced the same kind of problem and found better solution. Your knowledge sharing will be appreciated.

Other links
SSRS: Use single transaction when processing the queries

2 comments:

  1. I was facing a similar kind of issue, thanks your solution helped

    ReplyDelete
  2. SSRS – LookUp, MultiLookUp and LookupSet Functions
    These beautiful features bring a lot of satisfaction to report writer and developers to marge values from two datasets. These functions are is playing a very handy role to combine data from two datasets in a single data region which was not possible in earlier versions of Reporting Services.
    SSRS – LookUp, MultiLookUp and LookupSet Functions

    ReplyDelete