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
When you work with a report, based on an dimensional model, it can occur that the result shows a lot of empty values.
This is not what you would like to see. Instead you would like to see only the rows that have a value.
To achieve this you can use the following solution:
– In the report choose filter
– Click on the icon to add a new filter
– Put a filter on the Amount [Aantal] column of the FACT
– In the Expression Definition you put: [Aantal] IS NOT NULL