Search - Joel Lipman .Com

1. SSRS Display question mark when date is blank: / SQL Server Reporting Services /; Applies to: Microsoft SQL Server Reporting Services 2012 Microsoft Visual Studio 2012 Premium Microsoft Windows 7 Enterprise What? So I have a column in an SSRS report which displays a date. ...; Created on 15 April 2014
2. SSRS No Delay for First Report of the Day: / SQL Server Reporting Services /; What? This article describes a solution our reporting server administrators found to cut the loading time of the first report of the day. Why? Take any SSRS report, if one of us was the first ...; Created on 11 April 2014
3. SSRS Change Background Color of Image: / SQL Server Reporting Services /; What? Sounds easy but actually if you use an image which has transparent areas, ie. has one color which will be transparent, the transparent pixels will be colored in with the page background color. ...; Created on 08 April 2014
4. SSRS Stop Scrolling Behind: / SQL Server Reporting Services /; Applies to: Microsoft SQL Server Reporting Services (SSRS) 2008 R2 Microsoft Visual Studio 2012 Microsoft Business Intelligence Development Studio What? I recently revamped our standard ...; Created on 08 April 2014
5. SSRS: Performance Improvements: SELECT TOP: / SQL Server Reporting Services /; What? This article details a method we used on a search form in a SQL Server Reporting Services (SSRS) environment. The requirement (amongst others) was that the report ran in less than a few seconds. ...; Created on 07 March 2014
6. SSRS Border Problem: / SQL Server Reporting Services /; What? A very quick note on why borders may be misbehaving in SSRS. This note corrects the situation at Design time. This is where you are trying to select a cell to have an outline border but then ...; Created on 20 January 2014
7. SSRS Subscriptions cannot be created: / SQL Server Reporting Services /; ... to other systems holding the images), then please refer to my article on SSRS External Images don't display. The answer to this error is your report needs to use a datasource with the credentials stored, ...; Created on 22 November 2013
8. Problem creating SSRS report subscriptions: / SQL Server Reporting Services /; What? A quick article on if you are trying to create a new subscription to a SQL Server Reporting Server (SSRS) report and you are getting a warning message similar to the following: Message from ...; Created on 11 November 2013
9. Returning Oracle Stored Procedure Resultset in SSRS: / SQL Server Reporting Services /; ... Services (SSRS). Well "non-productive" more than "fun" as most of the examples on the net are either half-complete or partially documented. So here goes... Using Business Intelligence Development Studio ...; Created on 19 January 2012
10. SSRS Dropdown parameter cannot be blank!: / SQL Server Reporting Services /; What? I have created an SSRS report which can compare 4 reports side by side and brings up their latest execution times to the nearest millisecond. The report has 4 parameters. Each parameter is a ...; Created on 14 December 2011
11. How to Display Report Execution Time in SSRS (milliseconds): / SQL Server Reporting Services /; ... us as SSRS performance is always rubbish anyway. Here's a breakdown of the MDX expressions and how I tweaked each one to return the final result: -- to get just the time value =( CDate(Last(Fields!REPORTENDTIME.Value, ...; Created on 17 November 2011
12. SSRS Zero Padding: / SQL Server Reporting Services /; Quick Reminder I didn't want to do this at the database level, mainly because it meant modifying the SQL query. The zero padding would need to be applicable within an MDX query. The Situation We ...; Created on 10 November 2011
13. SSRS AlphaNumeric Parameter Validation: / SQL Server Reporting Services /; ... retrieves (select) formatted parameter as a field value to use Report loads with changes based on returned value. The Gist Add database level parameter check Add IIF in SSRS to confirm ...; Created on 07 November 2011
14. SSRS Retrieving Oracle Stored Procedure Success or ErrorLevel: / SQL Server Reporting Services /; What? We have a report in SQL Server Reporting Services 2008 R2 (SSRS) reading from an Oracle 10g database which works great and lists all the details on a specific student. An additional request is ...; Created on 04 November 2011
15. Reminder on SSRS row separator: / SQL Server Reporting Services /; My Setup XP SP3 Workstation Business Intelligence Development Studio 2008 (BIDS) SQL Server Reporting Services 2008 R2 (SSRS) What do I want? I have a report displaying room bookings. Each ...; Created on 26 October 2011
16. SSRS Repeat Headers in PDF Report: / SQL Server Reporting Services /; ... - Business Intelligence Development Studio 2008 (BIDS) - SQL Server Reporting Services 2008 R2 (SSRS) - PDF generated to a Windows File Share The Fix Click on the down arrow icon near the ...; Created on 26 October 2011
17. SSRS External Images don't displa: / SQL Server Reporting Services /; ... Development Studio 2008 (BIDS) SQL Server 2008 R2 Reporting Server (SSRS) running on Windows Server 2003 Team Foundation Server 2010 (TFS) Problem #1: Image does not appear within SSRS When ...; Created on 19 September 2011
18. SSRS Parameters in Oracle Stored Procedure: / SQL Server Reporting Services /; ... to a SQL Server 2008 R2 Reporting Service (SSRS) with Team Foundation Server 2010. The database with our stored procedure is Oracle 10g. The Stored Procedure Rather than a returned dataset, our ...; Created on 02 September 2011
19. SSRS Redirect after a report is run: / SQL Server Reporting Services /; ... script code (requires change to ASP pages on the ReportingServer, ie. affects all reports on that server). Method #3 Use ASP instead of SSRS. Method #4 Use a TimeInterval refreshing the ...; Created on 12 August 2011
20. SSRS / MDX Date Queries: / SQL Server Reporting Services /; So I find myself using date ranges endlessly as I've been working in SSRS. The below is derived from a collection of various sources across the web as well as some of my own. These are what worked in ...; Created on 03 August 2011