Posted inDynamics NAV & BC Tips & tricks
SQL Sever reporting services (SSRS) links and NAV demo reports
SQL Sever reporting services (SSRS) links and NAV demo reports: Bron : Roberto Stefanetti NAV Blog Lees meer...
Posted inDynamics NAV & BC Tips & tricks
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…
Posted inDynamics NAV & BC Tips & tricks
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…
Posted inDynamics NAV & BC Tips & tricks
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…
Posted inDynamics NAV & BC Tips & tricks
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…
Posted inDynamics NAV & BC Tips & tricks
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.…
Posted inDynamics NAV & BC Tips & tricks
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,…