x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 3 replies
  • Subscribers 76 subscribers
  • Views 825 views
  • Users 0 members are here
Browse Forums
Announcements
105
topics
32
replies
General Discussion
6k
topics
18k
replies
Paul C

Reports missing after upgrade

Posted By

Customer has upgraded from 2018 R3 to 2021 R2.  A lot of his custom reports now don't show up in the reports menu.  I ran a metadata refresh and one of the missing reports did then show up, but not the rest of them.

The reports are all still in the Custom_Reports table and the Custom_ReportBands and Custom_ReportFields records seem to be intact.

I've run out of ideas - does anyone have any pointers as to where I should look to debug this issue?

Thanks

  • 0

    Turns out it's not just custom reports but bundled reports too that are missing.  Eg there are no reports listed in the 'Activity' category, but the reports that should be listed are in the database.

    The checkbox to mark a view as a Reports View is not visible on this system.  Was this removed in 2021 R2?  It's still there in 2021 R1 - I don't have another 2021 R2 system to check.

  • 0 in reply to Paul C

    The option hasn't been removed. I've seen this before though can't remember the reason

    If the reports are missing, review the source view(s). The upgrade might have changed them in a way that makes them invalid for reporting.

    Correct them and maybe the report and tick box will reappear 

  • 0 in reply to Matthew Shaw

    Thanks Matthew - yes, the views for the problem reports all had the Account table joined presumably a hangover from the old Sage 200 integration.  I have updated them all which resulted in the 'Reports View' checkbox reappearing.  After ticking that box and saving the view the associated reports appeared in the menu.

*Community Hub is the new name for Sage City