Skip to main content

Desktop Enhancements

TX CBM002 Report Performance Improvement

The time it takes for this report to complete running has been significantly reduced.

Nested Reports for Advising Worksheet Need Recustomizing

Warning

You need to recustomize for Desktop, J1 Web, and JICS (Campus Portal), and make an additional change for Texas state reporting.

We added a new, 6th, parameter to the database function dbo.when_met_is_parent_met, which is used in the nested reports for the Advising Worksheet report.

The new parameter value is DEFAULT. Here is an example of the new call including the DEFAULT value:

dbo.when_met_is_any_parent_met(id_num, aim_label, adv_tree_req_cde, par_seq_num, link_lvl, DEFAULT)

Below are the details for the nested reports that you must recustomize to make the Advising Worksheet report work correctly.

Note

In addition to this database parameter change, the Texas-specific nested report "nr_advising_worksheet_requirement_detail_tsi" was renamed in J1 Web to shorten its name to less than 40 characters. See the Texas Schools section below for details.

For J1 Desktop Advising Worksheet

If you have customized any of the three reports below, and have used the custom version in your AV Worksheet (refer to the properties of the nested report dw_4), then you must recustomize your custom version to add the 6th parameter (DEFAULT) to the dbo.when_met_is_any_parent_met function in the WHERE clause tab.

  • nr_advising_worksheet_requirement_detail

  • nr_advising_worksheet_requirement_detail_tsi

  • nr_advising_worksheet_tsi_dev_status

For J1 Web Advising Worksheet

If you have customized any of the two reports below, and have used the custom version in your AV Worksheet (refer to the properties of the nested report dw_4), then you must recustomize your custom version to add the 6th parameter (DEFAULT) to the dbo.when_met_is_any_parent_met function in the WHERE clause tab.

  • nr_advising_worksheet_requirement_detail

  • nr_advising_worksheet_tsi_dev_status

    Note

    For Texas schools, the "nr_advising_worksheet_requirement_detail_tsi" report was renamed with the 2024.3 release to "nr_advising_worksheet_reqmnt_detail_tsi". You must use this renamed report in your AV Worksheet report. Refer to the "dw_4" properties mentioned in the Texas Schools section below.

For JICS (Campus Portal) Advising Worksheet

You must recustomize all reports that use the dbo.when_met_is_any_parent_met function. This includes the reports named below and their customized variations. Recustomize by adding the 6th parameter (DEFAULT) to call.

  • nr_advising_worksheet_requirement_detail

  • nr_advising_worksheet_requirement_detail_tsi

  • nr_advising_worksheet_tsi_dev_status

Texas Schools: Use the Shortened Name of the TSI  Nested Report in J1Web

The name of the "nr_advising_worksheet_requirement_detail_tsi" report is too long, so Advising Worksheets that use it fail to retrieve data in this nested report.

If you use the "nr_advising_worksheet_requirement_detail_tsi" nested report, do the following:

  1. Save the existing nested report (nr_advising_worksheet_requirement_detail_tsi) with the new, shortened name (nr_advising_worksheet_reqmnt_detail_tsi).

  2. Delete the old nested report (nr_advising_worksheet_requirement_detail_tsi).

  3. Change the main report to use the new nested report.

    1. In InfoMaker, open the main report (r_advising_worksheet_tsi)

    2. On the Control List, right-click on dw_4, and select Properties from the pop-up menu.

    3. Change the name of the nested report:

      1. From: nr_advising_worksheet_requirement_detail_tsi

      2. To: nr_advising_worksheet_reqmnt_detail_tsi

    The "rn_advising_worksheet_reqmnt_detail_tsi" nested report in InfoMaker