Upgraded to TS2017 from TS2012, now having issues with some reports.

We recently upgraded to Timeslips 2017 from 2012. Now we're having issues trying to get some of our custom reports to work. It seems like the problematic reports are those that try to access data from Inactive clients; however, some do work, while others do not.

For example, we have a report that lists all Inactive clients along with some custom client fields. So in the Report Entry the only filter we have is Client Classification, which is set to Inactive. However, when I run the report I get the "No data was selected. Either there is no data available or the Selection filters exclude all records." message. Not note, this report did work in TS2012.

Thinking it could have been something in the database update that simply broke the reports, I even tried creating a new one from scratch by:

  1. Clicking Reports -> Create a Report...
  2. In the first window I selected Create a completely new user-defined Report.
  3. In the Select Style window, I selected Data: Client & Style: Detail Listing
  4. In the Select a starting template window, I chose Empty report.
  5. I then gave it a name, assigned it to a group and opened the report entry.
  6. In the Report Entry, I selected the Client group and added Client Classification.
  7. In the Filter for Client Classification window, I selected only Inactive.
  8. I then opened the designer and added a few fields to the report (Nickname 1, Full Name and some custom client fields).

It's at this point I saved, clicked the preview tab, and received the above message. Consequently, this is also true for every other report I have tried to run setting the Client Classification to Inactive only, with 1 exception: the Client Nickname Listing under the Client tab of the Report List. If I open the Report Entry window, select Client Classification and set to Inactive only, it will generate the report correctly. This is essentially the same report as above, but with the added custom client fields

Another example: One of the custom client fields is Client #. If I try generating a report for a specific client #, it will only show me active clients. Even when including Inactive in the client classification.

Any help is greatly appreciated!