Using 3.0 Webi . I have a report that is at least 30 pages long everytime it is run and I have data tracking enabled. The issue is that the user has to scroll through multiple pages of data to search for any changes that have occured between refresh dates. I wanted to know if there is a way to force Webi to only display the items that have changed, instead of showing all of the records? I have tried using a Variable that calculates the difference between current value and RefValue and then using a Report/Block filter on the variable. The problem with this method is that only the current value shows and the RefValue is blank.
For a simple example, lets say my report displays a store and it’s employee count. With data tracking enabled, my report shows store A with a current employee count of 100 and RefValue of 100 and store B has 100 and 75 respectively. My variable calculates 0 for store A and 25 for Store B. I add a report filter on the variable to <> 0. The report brings back only store B but only shows the current employee count of 100 and is blank for RefValue and Variable amount is 100. I need the report to show 100 for current 75 for prior and variable amount 25.
Is there any ay to accomplish this?
billo83 (BOB member since 2007-01-16)
(BOB member since 2008-03-04)