How to Display Report Execution Time in SSRS (milliseconds)https://www.joellipman.com/articles/microsoft/ssrs/how-to-display-report-execution-time-in-ssrs.html

17 November 2011 it took for a report to execute... I decided to do a database level calculation using two datasets: -- Oracle 10g: DataSet1 -- your normal dataset query with an added field (ReportStartTime) SELECT field1, field2, TO_CHAR(systimestamp, 'HH24:MI:SS.FF6')...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Alternate row background colour in Reporting Serviceshttps://www.joellipman.com/articles/microsoft/ssrs/alternate-row-background-colour-in-reporting-services.html

04 February 2011 pane, you can do the following: BorderColor: #efefef, , , White, =IIF(RowNumber(Nothing)=Count(Fields!Field1.Value, "DataSet1"), "Black", "LightGray") BorderStyle: None, , , Solid, =IIF(RowNumber(Nothing)=Count(Fields!Field1.Value, "DataSet1"),...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

SSRS: Performance Improvements: SELECT TOPhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-performance-improvements-select-top.html

07 March 2014 few days worth of other solutions dotted about the web but the biggest improvement was the "SELECT TOP 100" brain wave: -- DataSet1: SELECT TOP 100 Reference, Forenames, Surname, DOB FROM PersonsTable WHERE (Reference = @GivenRef OR @GivenRef ='') AND...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Report Builder 2.0 - Hide Series1https://www.joellipman.com/articles/microsoft/ssrs/report-builder-20-hide-series1.html

06 May 2010 "solution" to my situation and environment. Our setup is: SQL Server 2008 Report Builder 2.0 BMC Service Desk Express 9.8 DataSet1: Incident # Group Name Close Date & Time Assigned to Full Name Incident Type The objective of this article is to explain...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

SSRS Report Builder 2.0 - Error during processinghttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-report-builder-20-error-during-processing.html

06 May 2010 during local report processing. An error has occurred during report processing. Query execution failed for dataset 'DataSet1'. The variable name '@GroupName' has already been declared. Variable names must be unique within a query batch or stored...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Error during processing - Converting Date/Timehttps://www.joellipman.com/articles/database/t-sql/error-during-processing-converting-datetime.html

13 July 2010 local report processing. An error has occurred during report processing. Cannot read the next data row for the dataset DataSet1. Conversion failed when converting date and/or time from character string. Basically I had to look at a previous report and...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *