Need to create benefit billing audit report that will capture adjustment data based on prior/ last run date.
Benefit billing report for the month of August 2013 already has the terminated staff for the month of August 2013 based on the prompt/ filter that's been created, but we also need to get the adjustment section/ data for terminated staff based on prior/ last run date. To clarify: August billing report was run on 8/15 (cut off date), report will capture terminated staff on the month of August that was processed on or before 8/15. For the other terminated staff that was processed after 8/15, will be on September billing under adjustment section.
Can someone help with creating the filter/ expression in cognos report studio. Can we use the "scheduling" tools to capture prior/ last run date data?