Clear Parameter Values

When you are developing a report and run it to test, value are stored from filters or the source connection. This is done so you won’t have to fill them in every time you test.

Sometimes you want to select a different source. For example first you test on DEV connection and now you want to test with QA connection.

To achieve this you want to clear the reports cached values. This can be done in Report Studio by selecting File > Clear Parameter Values

Justify empty values

Case:

When you work with a report, based on an dimensional model, it can occur that the result shows a lot of empty values.

justify_empty_values_1

This is not what you would like to see. Instead you would like to see only the rows that have a value.

Solution:

To achieve this you can use the following solution:
– In the report choose filter
– Click on the icon to add a new filter

justify_empty_values_3

– Put a filter on the Amount [Aantal] column of the FACT

justify_empty_values_4

– In the Expression Definition you put: [Aantal] IS NOT NULL

justify_empty_values_2