Search - Joel Lipman .Com

1. SSRS Templates in BIDS 2008: / SQL Server Reporting Services /; Open a Windows Explorer and make a duplicate of the report that you want to use as a template. Rename the copy (suffix with template?) Remove objects unique to the report and leave elements for all ...; Created on 01 April 2011
2. SSRS: Performance Improvements: SELECT TOP: / SQL Server Reporting Services /; ... working!?) and eventually would display circa 3000 matching results. If I attempted to check this in "preview" mode using Business Intelligence Development Studio (BIDS / VS2008), the IDE would crash and ...; Created on 07 March 2014
3. SSRS Border Problem: / SQL Server Reporting Services /; ... cells around it without a border. You may find that BIDS or Report Builder (however you're building your report) will apply the border to some cells and sometimes a whole section of the report with just ...; Created on 20 January 2014
4. SSRS Subscriptions cannot be created: / SQL Server Reporting Services /; Applies to: Microsoft Business Intelligence Development Studio 2008 (BIDS) Microsoft SQL Server 2008 R2 What? This article describes solutions to the error: Subscriptions cannot be created ...; Created on 22 November 2013
5. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; Applies to: Microsoft Business Intelligence Development Studio (BIDS) Visual Studio 2008 Microsoft Windows 7 Microsoft .NET Framework 3.5 Microsoft Visual C# 2008 What? So like lots of ...; Created on 04 October 2013
6. Administrator Program Shortcut without Prompt: / Windows OS /; ... Ultimate (VS2010) and Business Intelligence Development Studio (BIDS), require elevated or administator rights/privileges when run. This is so that these programs can write back and forth to our C drive. ...; Created on 25 February 2013
7. How to change local folder for TFS: / Team Foundation Server /; What? I installed Business Intelligence Development Studio 2008 (BIDS) and connected it to a Team Foundation Server 2010 (TFS) instance and set my working local folder to my home directory. When the ...; Created on 08 March 2012
8. Returning Oracle Stored Procedure Resultset in SSRS: / SQL Server Reporting Services /; ... v2008 (BIDS) SQL Server Reporting Services v2008 R2 (SSRS) Oracle SQL Developer v3 (you can use any equivalent, eg. SQL*Plus) Why? I think this is one of those very rare occasions that Microsoft ...; Created on 19 January 2012
9. Joes DNS Correction (JDC): / Product Documentation /; ... Studio 2008 IDE (Business Intelligence Development Studio - BIDS) along with Microsoft's Team Foundation Server (TFS). Sometimes I'll check out an item from TFS and before I get to update it, my ...; Created on 25 November 2011
10. 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
11. SSRS Repeat Headers in PDF Report: / SQL Server Reporting Services /; ... which has been set to landscape with zero margins specified. Although BIDS acknowledges that I want this to output to A4 with the correct measurements, the report doesn't seem to have any page breaks. ...; Created on 26 October 2011
12. 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
13. SSRS / MDX Date Queries: / SQL Server Reporting Services /; ... my environment: WinXP, BIDS (vs2008), TFS (vs2010), SSRS 2008 R2. The following examples assume today's date is Wednesday 03 August 2011 @ 11:46: This Week: -- Start Date (US format - mm/dd/yyyy) =DateAdd("d", ...; Created on 03 August 2011
14. SSRS Querying on either of 2 Parameters: / SQL Server Reporting Services /; The situation is that we are replacing a website-application with a single SQL Server Reporting Services (SSRS 2008 R2) report. We're using Business Intelligence Development Studio (BIDS VS2008) with Team ...; Created on 19 July 2011
15. SSRS Hide results table if empty: / SQL Server Reporting Services /; ... this I would have called this article "Iteration within SQL Server Reporting Services Business Intelligence Development Studio (BIDS) version 2008 through combining Transact-SQL and MDX expressions" but ...; Created on 29 March 2011
16. Developer's Checklist: Taking over a projec: / Web-Development /; So I'm starting to get the impression that I no longer tender for brand new projects competing with time and cost in order to win the bids. Recently, more and more people have been asking if I can take ...; Created on 01 March 2011
17. SSRS Expand specific drilldown by default: / SQL Server Reporting Services /; ... is how to do it in SQL Server 2008 and creating a report in Business Intelligence Development Studio (BIDS) or MS Report Builder. Scenario I have a report that specifies some room bookings for a ...; Created on 23 February 2011
18. URL passed settings in Reporting Services: / SQL Server Reporting Services /; ... the Toolbar (Advanced) To enter custom code for a report, view the report properties, the first field in Report Builder or Business Intelligence Development Studio (BIDS) is "Code". Click on the browse ...; Created on 11 February 2011
19. SQL Calendar in Business Intelligence Development Studio: / Transact-SQL /; So I find myself searching the web for a way of producing an outlook-style calendar within Business Intelligence Development Studio (BIDS). Weekdays along the top and then dates inside. Additionally ...; Created on 14 January 2011
20. Parameters not being used in report processing: / SQL Server Reporting Services /; Once again I've spent a whole morning going in the wrong direction with a convincing SQL script. This article is just a note on when using Business Intelligence Development Studio (BIDS) or Report Builder ...; Created on 07 January 2011