Assuming business is required, and intelligence is required, the following 24 results were found.
-
I trying to achieve? I've written this article because this is how I connected to a MySQL database from within the Business Intelligence Development Studio (BIDS) IDE from Microsoft. Required: Windows XP (ODBC Data Source Administrator) MS Business...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
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 we would like this linked to events in a database. I'm...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
Well I tried and I spent a few hours searching the net for a solution which displays the hours in the top columns, and undefined number of rooms in the rows. No all I was looking for was a calendar showing 1 day with the hours on the top. Working hours...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
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 people on the net, I've been given a datasource with names and addresses all...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
solution is a reboot, then this tool may be for you. In my environment, I am working with a Visual Studio 2008 IDE (Business Intelligence Development Studio - BIDS) along with Microsoft's Team Foundation Server (TFS). Sometimes I'll check out an item...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
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 2.0 and when previewing the report, the parameters are not accounted...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
(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 button next to it to edit. Visit...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
blank? The long way of doing 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 boy what a mouthful,...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
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 Foundation Server (TFS VS2010) and connecting to an Oracle database (ie....
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
ORA-06512: at "SYS.DBMS_UTILITY", line 114 ORA-06512: at line 1 (System.Data.OracleClient) The Situation I'm using Business Intelligence Development Studio 2008 to develop a Reporting solution on a Windows XP workstation. We are connecting to a SQL...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
issues with this if the image is available to anonymous users - eg. Google Logo). Our Setup Windows XP Workstation Business Intelligence Development Studio 2008 (BIDS) SQL Server 2008 R2 Reporting Server (SSRS) running on Windows Server 2003 Team...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
"fun" as most of the examples on the net are either half-complete or partially documented. So here goes... Using Business Intelligence Development Studio v2008 (BIDS) SQL Server Reporting Services v2008 R2 (SSRS) Oracle SQL Developer v3 (you can use any...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
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 close without warnings or notifications. We found that if...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
to: Microsoft SQL Server Reporting Services (SSRS) 2008 R2 Microsoft Visual Studio 2012 Microsoft Business Intelligence Development Studio What? I recently revamped our standard report with a new template comprising of a single Tablix which contained...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
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 rest of my colleagues installed it however, they decided to...
- Type: Article
- Author: Joel Lipman
- Category: Team Foundation Server
- Language: *
-
for setup) Why? Our work has group policies and two of our programs, Visual Studio 2010 Ultimate (VS2010) and Business Intelligence Development Studio (BIDS), require elevated or administator rights/privileges when run. This is so that these programs...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
guessing the same error would happen in Report Builder 2.0 which I've stopped using as my day job wants us to use Business Intelligence Development Studio for all our SQL Server Analysis Service (SSAS) and Reporting Service (SSRS) projects/solutions....
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
Solved by changing SQL statement to t1.Date AS Month This will return the SQL date but using your report builder or business intelligence development studio, you can specify in the report designer how to format the returned value to a more user-friendly...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
Basically, I've started using so much more SQL in our new Business Intelligence projects that I've been revising all my scripts to see what SQL I can optimize. One of my systems is a MediaWiki CMS which is used for the official Bournemouth University...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
they refer to SQL Server 2000 or SQL Server 2005. This 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...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB