My report has in the footer section two conditional text fields, one to display if no records are returned and one to display at the end of the report. Only one text field should display based upon record count returned. I use a running total as the basis of the condition and it's just a simple count of records - no evaluation, no reset.
On this report if filtered to show only a certain station which does contain data, both text fields display but if no filter is set for a specific station (all stations) and there is data, only the 'correct' end of report text is displayed. I checked the database to see if there was an issue with this particular station in the db and everything checked out correct. On a fluke and having seen this happen before, I moved one of the text fields up about 1/8 of an inch but still within the same section and this made the report work correctly.
Does anyone have any ideas why this happens?
On this report if filtered to show only a certain station which does contain data, both text fields display but if no filter is set for a specific station (all stations) and there is data, only the 'correct' end of report text is displayed. I checked the database to see if there was an issue with this particular station in the db and everything checked out correct. On a fluke and having seen this happen before, I moved one of the text fields up about 1/8 of an inch but still within the same section and this made the report work correctly.
Does anyone have any ideas why this happens?