RDLC Advanced Mode

There is a feature in SSRS reporting that is not so easy to find when you have grouping in a report and need the headers and/or subsequent rows to repeat on each page. To accomplish this, you need to use a feature in the Report Designer called the “Advanced Mode”. To access it in the Visual Studio Report Designer, click on the arrow in the top right section of the Column Groups, and select “Advanced Mode”.

Bron : Advances Business Systems
Lees meer…

SSRS 2008 – Using Code to calculate totals in a report and not reset on each page

I recently had a co-worker ask me to assist in a SSRS report on how to calculate a running total based on a conditional expression of a field in the report. Using code in the report, we were able to keep a running total and return that value in the grouping for an employee, but had an issue with the running total resetting on each page of the report. The following code was used to successfully accomplish this goal:

Bron : Advanced Business Systems
Lees meer…

SSRS Report calculating dates in the wrong format

I was writing an SSRS report, or rather modifying one of the existing SSRS reports that come packaged with Assistance Software’s PSA for Microsoft Dynamics CRM 2011, and when trying to group entries by week number (working on a billable hours report), I noticed that the function was returning the week number based on the DAY of the month value, instead of the actual MONTH value.

Bron : Advanced Business Systems
Lees meer…

Transfooter and Transheader functionality in RDLC(SSRS) reports – revisited

In one of our previous blog post we discussed the possibility to do Transfooter and Transheader functionality in RDLC(SSRS) reports and describes a viable solution for this in RDLC.

In this blog post we would like to suggest an alternative, a bit more economical and easier to implement solution for the same problem.

Bron : Microsoft Dynamics NAV Team Blog
Lees meer…

Understanding Groups (Report Builder and SSRS)

In Report Builder, a group is a named set of data from the report dataset that is bound to a data region. Basically, a group organizes a view of a report dataset. All groups in a data region specify different views of the same report dataset.

To help visualize what a group is, refer to the following figure that shows the tablix data region in Preview. In this figure, the row groups categorize the dataset by product type and the column groups categorize the dataset by geographic region and year.

Bron : Microsoft Technet
Lees meer…

SSRS Tutorial: SQL Server 2008 Reporting Services Tutorial

For many years, SQL Server did not have a good answer for creating attractive reports that summarize information in ways that make sense to business users. Finally, Microsoft shipped SQL Server Reporting Services. Like Notification Services, Reporting Services was originally an add-on for SQL Server 2000, and now it’s a part of the core product. In this chapter, you’ll learn how to use Reporting Services to produce your own reports.

Bron : Accelebrate
Lees meer…