It appears that SSRS has an issue(at leastin version 2008) – I’m studying this website that explains it Where it says if you have two columns(from 2 diff. tables) with the same name, then it’ll cause that problem. From source: SELECT a.Field1, a.Field2, a.Field3, b.Field1, b.field99 FROM TableA a JOIN TableB b on a.Field1 = … Read more
Ultimate solution (works in SSRS 2012 too!) Append the following script to “C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportManager\js\ReportingServices.js” (on the SSRS Server): function pageLoad() { var element = document.getElementById(“ctl31_ctl10”); if (element) { element.style.overflow = “visible”; } } Actually I don’t know if the div’s name is always ctl31_ctl10: in my case it is (instead over SQL … Read more
Ultimate solution (works in SSRS 2012 too!) Append the following script to the following file (on the SSRS Server) C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportManager\js\ReportingServices.js function pageLoad() { var element = document.getElementById(“ctl31_ctl10”); if (element) { element.style.overflow = “visible”; } } Note: As azzlak noted, the div’s name isn’t always ctl31_ctl10. For SQL 2012 tryctl32_ctl09 and for … Read more
The problem here is that if there are too many data bars the labels will not show. To fix this, under the “Chart Axis” properties set the Interval value to “=1”. Then all the labels will be shown.
=Format(Now(), “MM/dd/yyyy hh:mm tt”) Output: 04/12/2013 05:09 PM Full list of format options might be found here. Kudos to @MattGibson.
In BIDS or SSDT-BI, do the following: Click on Report > Report Properties > Layout tab (Page Setup tab in SSDT-BI) Make a note of the values for Page width, Left margin, Right margin Close and go back to the design surface In the Properties window, select Body Click the + symbol to expand the … Read more