Reporting4Act! uses database views to report against Act! databases. In some circumstances, these database views are not created properly by the Act! installer, or they are corrupted in some way. In these cases, the views need to be recreated using the Act! Diagnostics program, as follows.
Launch the Act! Diagnostics program. This is an Act! utility program installed in your Act! program folder. The name of this program depends on your version of Act!. For Act! 2005, the program file is Act7Diag.exe; for Act! 2006 it is Act8Diag.exe; for later versions of Act! it is ActDiag.exe. You can run this program by choosing Run from your Windows Start menu, and entering the program file name.
Click the Databases tab on the left side of the Act Diag window. In later versions of Act!, this item is available through a Databases menu item at the top of the Act Diag window.
In the grid of databases, right-click your Act! database.
If you are running Act! 2013 (15.0) or earlier, choose Rebuild OLE/DB Report Objects from the Database Rebuild menu item. Later versions of Act! do not have this item available.
You will be prompted to verify that you want to rebuild these objects; choose Yes. After a short time, a message box will appear indicating that the database rebuild is complete.
If you are using Act! 2010 or later, you should also run the Rebuild OLEDB v2.0 Report Objects item from the Database Rebuild menu item, as shown in the screenshot below. In later versions of Act!, this item is available directly on the right-click menu, rather than in a Database Rebuild submenu.
© Keystroke.ca, 2018 • Updated: 04/27/18
Comment or report problem with topic