Thursday, January 27, 2011

The weekly tip

Sometimes you need to bring duplicated data from your Data Source using union in order to bring all requested information.
Last post I`ve showed you how to remove duplicated detail line from the report.
Today I`ll show you what to do when you need to sum the actual lines.
If you`ll create a new running total fields formula you`ll get all the lines including null for the duplicated lines.
If you want only to count the not null rows select "Use a formula" and click the formula button.

And then enter the formula as below:
not isnull({TableFieldName})

Now the total will bring you only the not null row.

Good luck

No comments:

Post a Comment