Author Topic: Add new report to DMS Inventory 7.0  (Read 978 times)

mwinn

  • Newbie
  • *
  • Posts: 5
    • View Profile
Add new report to DMS Inventory 7.0
« on: April 01, 2010, 04:33:55 pm »
I have created a custom report using Access 2007 which runs fine from the Navigation Panel. I would like to add this to the reports menu. When I add the report to the menu using TOOLS - CUSTOMIZE - REPORTS, I can enter the information in but it apparently does not store it. any suggestions.

Thanks,
Michael D. Winn

Glen

  • Jr. Member
  • **
  • Posts: 25
    • View Profile
Re: Add new report to DMS Inventory 7.0
« Reply #1 on: April 08, 2010, 03:30:43 pm »
Customized reports created in MS Access may be added to the application at the Customize Reports form (Tools > Customize > Reports). After the report is added to the Customize Reports form, perform the following steps in order for the report to appear as a selection in the the Reports form (Reports > Report):

--1-- Open the Reports table in MS Access and find the ReportID value for the new report.

--2-- Open the Modules table in MS Access and find the ModuleID value for your IntelliTrack application.

--3-- Open the ModuleReports table and add a new record using the ReportID and ModuleID from steps 2 and 3 for the ReportID and ModuleID fields in the ModuleReports table, respectively.

--4-- In your IntelliTrack application, open the Reports form (Reports > Reports). The new report should be listed as a selection in the Reports form.

mwinn

  • Newbie
  • *
  • Posts: 5
    • View Profile
Re: Add new report to DMS Inventory 7.0
« Reply #2 on: April 12, 2010, 11:29:50 am »
Thank You that worked.