reporting-services – Tarik Billa

Reports are blank in Safari and Chrome

February 16, 2024 by Tarik

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

Implementing Target lines, in SSRS column Charts

January 5, 2024 by Tarik

Adding a StripLine may do what you want. They are a little hard to find, but here is how: 1) Make sure that the properties window is open beforehand. If it isn’t, either hit F4 or go to the View Menu -> Properties Window. 2) Left click on your vertical axis to select it. 3) … Read more

Listing all Data Sources and their Dependencies (reports, items, etc) in SQL Server 2008 R2

January 5, 2024 by Tarik

The following (which was modified from what beargle posted earlier) does what I was looking for. This will list all the data sources by their actual name, and all their dependent items: SELECT C2.Name AS Data_Source_Name, C.Name AS Dependent_Item_Name, C.Path AS Dependent_Item_Path FROM ReportServer.dbo.DataSource AS DS INNER JOIN ReportServer.dbo.Catalog AS C ON DS.ItemID = C.ItemID … Read more

SSRS – Changing tab name when exporting to excel

January 3, 2024 by Tarik

You need to set the PageName of the Tablix Member (group), NOT the PageName of the Tablix itselfs. If you got the right object, if will say “Tablix Member” (Tablix-Element in German) in the title box of the properties grid. If it’s the wrong object, it will say only “table/tablix” (without member). Also, be advised … Read more

Copy and paste a table (tablix) in SSRS

December 25, 2023 by Tarik

You are likely getting the error message Report Builder was unable to paste successfully because somewhere in the grid there is a cell that uses Custom Code From the Report i.e. you cannot copy a textbox with this custom code: “Code.MyCustomeCode()” – Report Builder was unable to paste successfully This has been a reported bug … Read more

First and Last day of current month

December 21, 2023 by Tarik

Just a guess based on your code working. –previous month last =DateSerial(Year(Now()), Month(Now()), “1”).AddDays(-1) –previous month first =DateSerial(Year(Now()), Month(Now()), “1”).AddMonths(-1)

How to get named excel sheets while exporting from SSRS

December 14, 2023 by Tarik

Necromancing, just in case all the links go dark: Add a group to your report Also, be advised to set the sort order of the group expression here, so the tabs will be alphabetically sorted (or however you want it sorted). ‘Zeilengruppe’ means ‘Target group’ ‘Gruppeneigenschaften’ means ‘Group properties’ Set the page break in the … Read more

Value expression error: “[BC30456] ‘RdlObjectModel’ is not a member of ‘Reporting Services’

December 10, 2023 by Tarik

Found this bug report which exactly explains the problem I had: http://connect.microsoft.com/SQLServer/feedback/details/757358/pasting-objects-with-expressions-pastes-fully-qualified-functions Summary of the above: When you copy/paste reporting services expressions from one place to another (I copied an entire tablix, with expressions in it) all the pieces of that expression get expanded to their full names. There is a bug specific to when … Read more

SSRS – Checking whether the data is null

September 19, 2023 by Tarik

try like this = IIF( MAX( iif( IsNothing(Fields!.Reading.Value ), -1, Fields!.Reading.Value ) ) = -1, “”, FormatNumber( MAX( iif( IsNothing(Fields!.Reading.Value ), -1, Fields!.Reading.Value ), “CellReading_Reading”),3)) )

How do I best display CheckBoxes in SQL Server Reporting Services?

September 17, 2023 by Tarik

I, along with others in my shop, have used images, toggling the hidden attribute based on the field value (true or false). We haven’t had any problems with blurring or scaling, unless we tried to increase the scale of the image beyond 100% obviously. Another option I’ve used is similar to the wingdings idea, but … Read more