Reports Do Not Display Data
Symptom
No data is displayed when viewing a report (though the report appears to render correctly).
Cause
SQL Server based versions of Preactor (prior to Preactor 11.0.1) do not automatically refresh the view of the Orders table and associated data.
Solution
Exit the configuration and open SQL Server Management Studio.
In Management Studio there are 2 options. Either:
- Click the relevant database in the list of available databases;
- Press the New Query button from the tool bar;
- Paste EXEC sp_refreshview 'dbo.OrdersView' into the query window;
- Press the Execute button from the tool bar.
or
- Expand the relevant database in the Object Explorer;
- Expand the Views folder;
- Find the dbo.OrdersView item, right-click and choose Edit;
- Press the Execute button from the tool bar.
After the Execute button is pressed, 'Command(s) completed successfully.' should appear in the Messages window.
Management Studio can now be exited. Preactor should be able to render the reports including data.