Search - Joel Lipman .Com

1. SSRS: Performance Improvements: SELECT TOP: / SQL Server Reporting Services /; ... 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 ...; Created on 07 March 2014
2. How to Display Report Execution Time in SSRS (milliseconds): / SQL Server Reporting Services /; ... milliseconds 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, ...; Created on 17 November 2011
3. Alternate row background colour in Reporting Services: / SQL Server Reporting Services /; ... "DataSet1"), "Black", "LightGray") BorderStyle: None, , , Solid, =IIF(RowNumber(Nothing)=Count(Fields!Field1.Value, "DataSet1"), "Double", "Solid") BorderWidth: 1pt, , , , =IIF(RowNumber(Nothing)=Count(Fields!Field1.Value, ...; Created on 04 February 2011
4. Error during processing - Converting Date/Time: / Transact-SQL /; ... reports though. The error I'd get was An error occurred during local report processing. An error has occurred during report processing. Cannot read the next data row for the dataset DataSet1. ...; Created on 13 July 2010
5. Report Builder 2.0 - Hide Series1: / SQL Server Reporting Services /; ... Server 2008 Report Builder 2.0 BMC Service Desk Express 9.8 DataSet1: Incident # Group Name Close Date & Time Assigned to Full Name Incident ...; Created on 06 May 2010
6. SSRS Report Builder 2.0 - Error during processing: / SQL Server Reporting Services /; ... 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 procedure. The ...; Created on 06 May 2010