Duplicate Reports in List

Duplicate Reports in List

Ostendo is duplicating all standard reports.

The customer has standard Ostendo installation and noticed that on Reports & Views developer list screen, they have two 'System' level records for each report / view.

This will have been caused by someone using the 'Import' and then pointing to the 'ReportData.dat' file within the Ostendo directory

- the simplest way to delete the duplicate reports is to query the OUTPUTMASTER table for all SYSTEM reports and sort by the sysuniqueid field (using Data Spreadsheet)

- then find the sysuniqueid for the first report duplicated and delete all reports from that sysuniqueid and greater for SYSTEM level only.

You should also be able to tell who imported the reports and what date & time

    • Related Articles

    • Operations Centre - To Do List

      There are four types of events along with their associated Follow Up dates that drive the contents of the Operations Centre To Do List. History Note Followup: This event is assigned to the Ostendo User Name that created the History Note. Therefore ...

    • Cannot see Reports Folder - Virtualising Directorys

      We have had some support tickets regarding users not being able to see the Ostendo Reports folders from Windows Explorer, however they can see them from the Ostendo Report & View Developer. After some investigative work on this it appears to be ...

    • Reports and Views not Updated When Appling Update

      On occasions when running an Ostendo Update, the dbupdate may hang when it tries to update all System Reports and Views. To resolve this, follow these steps: 1. Do a validation, followed by backup & restore of the Database. 2. Use the attached script ...

    • How do I prevent a User from amending a list screen layout?

      Go into File>System Configuration>User Security and Options and click on the ‘User Options’ tab. Two options are available: ‘Check’ the ‘List Customizing’ checkbox to prevent the user form adding extra fields to the list ‘Check’ the ‘Save Grid ...

    • Landscape Reports only printing the .pdf in Portrait format

      Check the PC's Display Settings. ie: Font Size settings (Should be 'Medium') and DPI Settings (should be 96)