How do I format date and time on ssrs report?
=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.
ssrs-2008
divide by zero/null workaround in SSRS 2008 report
Jamie F’s answer is correct. As a tip, you can add a function to your report code to make the division a bit easier to implement in multiple cells, e.g. Public Function Divider (ByVal Dividend As Double, ByVal Divisor As Double) If IsNothing(Divisor) Or Divisor = 0 Return 0 Else Return Dividend/Divisor End If End … Read more
SSRS 2008 – Dealing with division by zero scenarios
IIf will always evaluate both results before deciding which one to actually return. Try =IIf(Fields!SomeField.Value = 0, 0, Fields!SomeOtherField.Value / IIf(Fields!SomeField.Value = 0, 1, Fields!SomeField.Value)) This will use 1 as the divisor if SomeOtherField.Value = 0, which does not generate an error. The parent IIf will return the correct 0 for the overall expression.
Access Page number in report body In SSRS
Create functions in the code under the report properties: Page Number: Function PageNumber() As String Return Me.Report.Globals!PageNumber End Function Total Pages: Function TotalPages() As String Return Me.Report.Globals!TotalPages End Function Access it in the body via an expression: =code.PageNumber & ” of ” & code.TotalPages Check out Sample Usage of the Concat Function
Need help in calculation using two Datasets using Expression SSRS
You would need to restrict your dataset to the desired month and then sum the results. LookupSet is used to retrieve data from another dataset based on criteria. A VBA function, SumLookup is needed to add the results from the LookUp. This VB would go into the CODE section of the report (this can be … Read more
Changes to parameter not showing on Report Server after deployment
This is “by design”: When you first deploy reports, parameters are uploaded with all their settings. Administrators of those reports are then allowed to tweak the way report parameters function in the report web manager: change whether they accept null values, defaults, etc. If you redeploy reports later, nothing is changed to existing parameters (the … Read more
SSRS 2008 R2 – SSRS 2012 – ReportViewer: Reports in Safari/Chrome but works fine in Firefox/Internet Explorer 8… why?
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
SSRS 2008 R2 – SSRS 2012 – ReportViewer: Reports are blank in Safari and Chrome
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
How to get rid of blank pages in PDF exported from SSRS
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