Put Some Images On Those SSRS Reports

by Valentino Vranken 7 July 2010 16:05

On the forums I now and then encounter questions regarding images on SSRS reports. Instead of re-inventing the wheel each time, I decided to write an article about the subject. So in this article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: reporting services, sqlserverpedia syndication, data, reporting services 2008, ssrs, tutorial

A Developer's Blog

Implementing Data Bars In A Grouped Table

by Valentino Vranken 27 May 2010 20:16

Earlier I wrote an article about the new lookup functions that ship with SQL Server 2008 R2. Today I’m going to show you another new feature of SSRS 2008 R2, this time in the visualization department. This feature is the Data Bar. With this new component it’s fairly easy to make your tabular data a [...]
Click here to see the original post

Currently rated 5.0 by 1 people

Currently 5/5 Stars.
1
2
3
4
5

Tags: reporting services, sqlserverpedia syndication, data, reporting services 2008 r2, sql server 2008 r2, ssrs, tutorial

A Developer's Blog

Looking Up Data On Different Sources

by Valentino Vranken 16 May 2010 12:41

Almost a year ago I wrote a small blog post to ask everyone to vote on a certain Connect item related to the linking of two datasets in a Reporting Services report. At this moment there have been 87 positive votes on the request. Now that SQL Server 2008 R2 has been RTM’ed, it’s time to [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: reporting services, sqlserverpedia syndication, data, reporting services 2008 r2, sql server 2008 r2, ssrs, tutorial

A Developer's Blog

Parent-Child hierarchies in Reporting Services

by Davy Knuysen 16 April 2010 10:28

Reporting Services 2008 is a great reporting tool, but displaying Analysis Services data with Reporting Services doesn’t always display the data as you would expect. A Parent-child hierarchy is one example of this: When you browse Parent-child hierarchy from an Analysis Services cube with Excel, Excel automatically displays it with nice drill-down functionality. But when [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: analysis services, mdx, reporting services, sql server, data, reporting

Davy Knuysen

Reporting Services Timeout in Sharepoint

by Davy Knuysen 3 March 2010 07:05

Recently someone asked me to check a Reporting Services report that always resulted in an Unexpected Error. The report server was configured for Sharepoint Integrated Mode. I came to the conclusion that the server always returned this error after exactly 2 minutes, so it had to be a timeout exception. The report was kind of big, so [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: bi, moss, reporting services, sql server, data, sharepoint

Davy Knuysen

Memory Dumps And Crazy Code Samples

by Valentino Vranken 6 February 2010 10:53

I usually don’t write posts just to mention a link to another site. Except when I’ve come across articles which are so good that I want everyone to know about them. Here are a couple of articles in that particular category. What Does Microsoft Do With Those Memory Dumps? The first one is written by Adam W. [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: reporting services, t-sql, data, fun, memory dump, ssrs

A Developer's Blog

Your First OLAP Report

by Valentino Vranken 24 January 2010 14:28

Introduction This article is aimed at report developers who are used to develop reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Server Reporting Services 2008 with data coming from an OLAP cube running on SQL Server Analysis Services 2008. The OLAP [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: analysis services, reporting services, data, mdx, reporting services 2008, ssas, ssrs, tutorial

A Developer's Blog

SQL Server Day 2009 videos now available on Chopsticks

by Davy Knuysen 16 December 2009 10:10

Microsoft has made the sessions presented on SQL Server Day 2009 available on Chopsticks Opening Keynote by Wesley Backelant and Ritchie Houtmeyers Best Practices for SQL Server Consolidation by Tom Van Mulders Breaking the ETL world record with Integration Services by Henk van der Valk Designing Effective Aggregations in Analysyis Services 2008 by Chris Webb [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: .net, analysis services, bi, event, events, excel services, integration services, mdx, moss, office, powerpivot, reporting services, sql 2008 r2, sql server, sqlug.be, chopsticks, sharepoint

Davy Knuysen

Reporting On Data From Stored Procedures (part 2)

by Valentino Vranken 21 November 2009 20:59

Introduction In a previous article I announced that I would write a sequel covering how to pass multiple-value parameters from a SQL Server Reporting Services report to a stored procedure. So that’s what I will be writing about in this article. As usual, I will be using the AdventureWorks2008 sample database (running on SQL Server 2008 SP1), [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: reporting services, data, reporting services 2008, ssrs, tutorial

A Developer's Blog

Reporting On Data From Stored Procedures (part 1)

by Valentino Vranken 10 November 2009 12:35

Introduction The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source. The dataset can use a SELECT query, which is the most common way of retrieving data and one that you’re probably already familiar [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: reporting services, data, reporting services 2008, ssrs

A Developer's Blog

Blog N-Technologies

Put Some Images On Those SSRS Reports

Implementing Data Bars In A Grouped Table

Looking Up Data On Different Sources

Parent-Child hierarchies in Reporting Services

Reporting Services Timeout in Sharepoint

Memory Dumps And Crazy Code Samples

Your First OLAP Report

SQL Server Day 2009 videos now available on Chopsticks

Reporting On Data From Stored Procedures (part 2)

Reporting On Data From Stored Procedures (part 1)

RecentPosts

Blog N-Technologies

Tag cloud

RecentPosts