Change in Record Selection Formula Detected

[kalnkato]

I have a report that displays the following message when I scroll forward after the report completes processing page 1:

Change in Record Selection Formula Detected

I am prompted to Use Saved Data or Refresh Data. I get the correct results on the report regardless of how I respond to the message prompt. I believe the message happens because I have a parameter in the main report that I only use in the sub report. I have set up the parameter correctly in Edit Sub report Links. The message only displays when I have more than one page of information. If I remove the parameter from the Select Expert in the sub report, the message doesn't display. Do I have the parameter setup incorrectly? Thank you in advance for your assistance.

 

[paulmarr]

Hi,

I suspect that you dont use the parameter in the main report - that exists for the subreport - you need to link the subreport to a field from the main report instead of a parameter.

I hope this helps!

paulmarr

 

[kalnkato]

Here is a little more background on the problem:

The main report is list of Employees who do not have an approved timesheet. The sub report is a listing of the Employees with a specific hourly code on their timesheet. The sub report is linked to the main report using the Employee Number and Pay Period Dates from the main report. The Pay Period Dates is the parameter not used on the main report. Both parameters are used on the sub report. The sub report is in the Report Footer of the main report and needs to look at the range of data selected in the parameters passed from the main report.

Thank you!

 

[lbass]

How about an explanation of what you are trying to do? Is your goal to identify employees with missing timesheets, or does your report already successfully do this and you are trying to do a breakout with the subreport to further analyze which employees have not submitted timesheets? There might be another approach.

-LB

 

[kalnkato]

The problem has been resolved. On my report, the TIMESHEET_DATE field is defined as a DateTime field in the database. When I set up the sub report link, I linked the ?TimesheetDate parameter (defined as only Date) from the main report to a formula in the sub report(@TimesheetDate) that defined TIMESHEET_DATE field as a Date field (Date(TIMESHEET_DATE)). I then incorrectly used @TimesheetDate in my select statement. By changing my select in my sub report from:

@TimesheetDate = ?TimesheetDate
To:
TIMESHEET_DATE = ?TimesheetDate

the message no longer appears when scrolling forward.