Skip to main content

RADplus 2023 Update 96

  1. Last updated
  2. Save as PDF

Product Requirements and Recommendations

RADplus required

Recommended Update Level

RADplus 2023 Monthly Release 2023.03.00

Product Update Description

An intermittent issue where external ODBC connections would authenticate but fail to return any data is resolved.

Required Updates

None

Included Updates

None

Details
NEW0 CHANGED0 FIXED1
Fixed (1)
Data reports/queries
An issue is resolved to ensure that external and internal "ODBC" connections made to run reports/queries, authenticate and return data as expected
Topics
• Import Reports • Query/Reporting • SQL Data Access
 
Acceptance Tests
AV-90633 Summary | Details
Data reports/queries
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • Admission Data Report (Results)
  • Command Button Report
  • CW Patient Notes Table Report
  • Daily Dispensing Activity
  • Daily Dispensing Activity Report
  • Daily Dispensing Activity Report (Report Results)
  • Document Routing Crystal Report
  • Post Filing Report
  • Report Definition Test Report
  • SYSTEM.cw_patient_notes.rpt
Scenario 1: Validate data results from reports generated using an ODBC login connection
Specific Setup:
  • Create a new user in form "User Definition" [TestUserA] and assign the user permissions to a table, for example table "SYSTEM. patient_current_demographics" is used
  • Have a "Crystal Report" [ReportA] created to display data in that table using and ODBC connection configured for [TestUserA]
  • Have a second user [TestUserB] who that already has access to that same table as [TestUserA]
  • Have a "Crystal Report" [ReportB] created to display data in that table using and ODBC connection configured for [TestUserB]
  • In form "Import Reports"
  • Using the "Import Report as Form" option, have a report [ReportC] imported configured to run from a menu
  • [TestUserC] has access to "Report Definition" form type report [ReportD] for testing. For example, product form "Admits By Program, Zip Code, Ethnicity" can be used
  • Have three modeled forms available for testing
  • [FormA] is enabled for document routing set in form "Document Routing Setup", to use a crystal report [ReportE] as a template to display the document image. (Note: The "Import Report for Document Routing" option in form "Import Reports", can be used to import the report into the system for use)
  • [FormB] configured with a "Post Filing" report [ReportF] that will run at form submission
  • [FormC] configured with a "Command Button" on the form that will run a report [ReportG]
  • [TestUserC] has access to all forms stated in the setup and has the "Crystal Report" application on their desktop
Steps
  1. In application "Crystal Reports"
  2. Open [ReportA], that has the "ODBC" connection configured for [TestUserA]
  3. Click to process the report
  4. Validate the report display all data as expected
  5. Close the report
  6. Repeat step 1a again to regenerate the report
  7. Validate results are as expected
  8. Open [ReportB], that has the "ODBC" connection configured for [TestUserB]
  9. Click to process the report
  10. Validate the report display all data as expected
  11. Close the report
  12. Repeat step 1c again to regenerate the report
  13. Validate results are as expected
  14. Log in Avatar
  15. Search for and open [ReportC], the report imported to run from a menu
  16. Validate when selected form the menu, the report launches successfully
  17. Validate the report display all data as expected
  18. Close the report
  19. Repeat step 2a again to regenerate the report
  20. Validate results are as expected
  21. Close the report
  22. Search for and open [ReportD], the "Report Definition" report
  23. Populate any prompts on the form
  24. Click to process the report
  25. Validate the report display all data as expected
  26. Close the report
  27. Repeat step 2b again to regenerate the report
  28. Validate results are as expected
  29. Search for and open [FormA], the document routing enabled modeled form set to use a "Crystal Report" [ReportE] as template to display the document image
  30. Populate the form
  31. Submit the form as "Final"
  32. Validate the document image is displayed using the format of [ReportE] and data is displayed, as expected
  33. Approve/ route and submit the document
  34. Validate submission is successful
  35. Repeat step 2c again
  36. Validate results are as expected
  37. Search for and open [FormB], the form configured with a post filing report
  38. Populate the fields on the form
  39. Submit the form
  40. Validate the form files successfully
  41. Validate the post filing report [ReportF] is launched
  42. Validate the data is displayed as expected
  43. Repeat step 2e again to regenerate the report
  44. Validate results are as expected
  45. Search for and open [FormC], the form configured with the command button report
  46. Populate the fields on the form
  47. Navigate to the "Command Button" field
  48. Click the field to launch the report
  49. Validate [ReportG] is launched
  50. Validate data is displayed as expected
  51. Submit the form
  52. Validate the form submits successfully
  53. Validate the command button report [ReportF] is launched
  54. Validate the data is displayed as expected
  55. Submit the form
  56. Validate the form files successfully
  57. Repeat step 2g again to regenerate the report
  58. Validate results are as expected
Topics
• Import Reports • Query/Reporting • SQL Data Access