SSW Foursquare

Data Layout - Do you show change in your reports?

Last updated by Jeoffrey Fischer [SSW] 10 months ago.See history

It is important to show previous and current data, as well as the changes between the two.

badNoChange
Figure: Bad example - Does not show the change between the previous and current data

goodChangeVisible
Figure: Good example - Shows the change between the previous and current data

There will be cases in which the Change column has no meaning then you'd better to make this column invisible in your reports. In one of our reports we use an expression on Hidden property of this column to determine whether to show it based on the value of a parameter.

=iif(Parameters!ComparedExtractionID.Label = "N/A",true,false)

Expression for Hidden property

Jeoffrey Fischer
Reporting Services
We open source.Loving SSW Rules? Star us on GitHub. Star
Stand by... we're migrating this site to TinaCMS