Skip to main content

RADplus 2022 Update 50

Product Requirements / Recommendations

RADplus required

Product Update Form Description

Report definitions are enhanced to support the addition of ODBC data sources for myAvatar NX.

Included Updates

7

Required Updates

None

Details

NEW1 CHANGED0 FIXED0
New (1)
Report Definition - Avatar NX
The "Additional ODBC Connections" functionality in form "Report Definition" is enhanced for Avatar NX, to allow connections to external databases
Value Added: Provides greater functionality for users, when extracting data from external databases
Topics
• NX • Query/Reporting
 
Acceptance Tests

AV-79276 Summary | Details
Report Definition - Avatar NX
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • Report Definition (PM)
Scenario 1: Report Definition (Avatar NX) - Create and launch a report requiring an External ODBC Connection
Specific Setup:
  • An external database server [ServerA] exists, that that contains table data [TableA]. For example, an external "SQL" server
  • Using form "NX External ODBC Data Sources", have an "ODBC Data Source" created [DataSourceA] configured to use an ODBC driver to connect to the external database server [ServerA]
  • Have a Crystal Report [ReportA] created, that connects to the external database [ServerA] using [DataSourceA] in order to display data in [TableA].
Steps
  1. Open form "Report Definition"
  2. Click [New Avatar Report]
  3. Populate the "Report Name" field with a name for the report [ReportDefA]
  4. Click [Select Report]
  5. In the "Windows Explorer" window, navigate to the directory that contains [ReportA]
  6. Click [Save]
  7. Click to the "Report Parameters" section
  8. Click [Add New Item] in the "Report Parameters" grid to add any desired parameters. For example "PATID" and "Episode"
  9. Click the [Additional ODBC Connections] section
  10. Click [Add New Item]
  11. Click the "Connection Type" field
  12. Select "myAvatar NX"
  13. Click the "myAvatar NX Connection" field
  14. Select the [DataSourceA] connection created in the set up
  15. Click [Submit]
  16. Validate the form files successfully
  17. Return to the form
  18. Select [ReportA]
  19. Click each section populated in steps 1 thru 3
  20. Validate all fields are populated as expected
  21. Close the form
  22. Search form [ReportDefA]
  23. Populate any parameters required to run the report
  24. Click [Process]
  25. Validate the report results, are as expected
Topics
• NX • Query/Reporting

 

  • Was this article helpful?