Generating Reports from the Report Library

Intro

The “Report Library” page allows you to run built-in reports deployed by DFIN or custom, client-defined reports (future functionality).

One or more reports can be executed at once, whose results are sent to the Output Queue in either Excel (XLS), PDF or Word (DOC) format.

Tasks

• Generating a Fund-Class Information Report

  1. Expand the ArcFiling “Reports” menu.

     1. Click the “Home” button at the top of the application window to return to the landing page.

     2. Select “ArcFiling” from the components list.

        

     3. Click the “Filings Workspace” tab at lower-left of the screen.

        

     4. Click the “Reports” menu to view available items.

        If the “Account Period”, “Complex” and “Fund” relevant to the data you wish to view are not currently selected, choose them using the either selection button at upper-left of the screen or the selection bar across the top of the window.

        • Using the selection bar

          1. Click the “[Select Date]” text or “»” symbol.

             All open account periods associated with a project, and to which you have access, are displayed.

             

          2. Click the “[Select Complex]” text or “»” symbol.

             Complexes with projects associated with the specified date are displayed.

             

             If only one complex is available based on the specified date, the complex is automatically chosen.

          3. Click the “[Select Group]” text or “»” symbol.

             Groups associated with the specified complex with active projects for the specified date are displayed.

             

             Alternatively, you can specify “All Fund Groups”, which automatically fills in “All Funds” in the step below. Some pages in Arc Suite (e.g., “Fund Holdings”), allow you to view information for more than one fund simultaneously. If a page does not support multiple fund display, then no information displays when “All Fund Groups » All Funds” is specified.

             

             If only one fund group is available based on the specified complex, the group is automatically chosen.

          4. Click the “[Select Fund]” text or “»” symbol.

             Funds associated with the specified group with active projects for the specified date are displayed.

             

             Alternatively, you can specify “All Funds”.

             

             If only one fund is available based on the specified group, the fund is automatically chosen.

          When all elements of the fund selection bar are specified, you have several options available in terms of viewing different sets of data for open pages.

          

          • Change the specified date. The list of dates is filtered for active projects for the specified fund. Changing the date refreshes the data for all open pages.
          • Change the complex. Changing the complex resets the group, and you’ll need to return to Step 3 above.
          • Change the group. Changing the group resets the fund, and you’ll need to return to Step 4 above.
          • Change the fund. Changing the fund refreshes the data for all open pages.
          • Reset the fund selection bar. Click the “Reset” button at any time to return to Step 1 above.

        • Using the selection button

          1. Click the selection button at upper-left of the window.

             All open account periods associated with a project, and to which you have access, are displayed.

             

             If an account period has already been specified via the fund selection bar (see above), the list under the fund selection button automatically expands that date.

             

          2. Click the arrow at left of the desired account period to display the available complex(es) and associated fund group(s) and fund(s).
          3. Specify the “Complex”, “Fund Group” and “Fund” relevant to the project you wish to view.

  2. Expand the ArcReporting “Reports” menu.

     1. Click the “Home” button at the top of the application window to return to the landing page.

     2. Select “ArcReporting” from the components list.

        

     3. Click the “Reporting Workspace” tab at lower-left of the screen.

        

     4. Click the “Reports” menu to view available items.

        If the “Account Period”, “Complex” and “Fund” relevant to the data you wish to view are not currently selected, choose them using the either selection button at upper-left of the screen or the selection bar across the top of the window.

        • Using the selection bar

          1. Click the “[Select Date]” text or “»” symbol.

             All open account periods associated with a project, and to which you have access, are displayed.

             

          2. Click the “[Select Complex]” text or “»” symbol.

             Complexes with projects associated with the specified date are displayed.

             

             If only one complex is available based on the specified date, the complex is automatically chosen.

          3. Click the “[Select Group]” text or “»” symbol.

             Groups associated with the specified complex with active projects for the specified date are displayed.

             

             Alternatively, you can specify “All Fund Groups”, which automatically fills in “All Funds” in the step below. Some pages in Arc Suite (e.g., “Fund Holdings”), allow you to view information for more than one fund simultaneously. If a page does not support multiple fund display, then no information displays when “All Fund Groups » All Funds” is specified.

             

             If only one fund group is available based on the specified complex, the group is automatically chosen.

          4. Click the “[Select Fund]” text or “»” symbol.

             Funds associated with the specified group with active projects for the specified date are displayed.

             

             Alternatively, you can specify “All Funds”.

             

             If only one fund is available based on the specified group, the fund is automatically chosen.

          When all elements of the fund selection bar are specified, you have several options available in terms of viewing different sets of data for open pages.

          

          • Change the specified date. The list of dates is filtered for active projects for the specified fund. Changing the date refreshes the data for all open pages.
          • Change the complex. Changing the complex resets the group, and you’ll need to return to Step 3 above.
          • Change the group. Changing the group resets the fund, and you’ll need to return to Step 4 above.
          • Change the fund. Changing the fund refreshes the data for all open pages.
          • Reset the fund selection bar. Click the “Reset” button at any time to return to Step 1 above.

        • Using the selection button

          1. Click the selection button at upper-left of the window.

             All open account periods associated with a project, and to which you have access, are displayed.

             

             If an account period has already been specified via the fund selection bar (see above), the list under the fund selection button automatically expands that date.

             

          2. Click the arrow at left of the desired account period to display the available complex(es) and associated fund group(s) and fund(s).
          3. Specify the “Complex”, “Fund Group” and “Fund” relevant to the project you wish to view.

  3. Click the “Report Library” item.

     The “Report Library” page displays.

     

  4. Do not specify any search criteria (i.e., complex, fund group, etc.) or date range via the controls in the top portion of the page. These settings are irrelevant for this particular system report.
  5. Select the “Fund-Class Information Report” check box in the “Reports” grid.
  6. Specify the desired “Output Format” (i.e., “PDF” or “Word”).

  7. Click the “Generate output” button at lower-right of the page.

     The report is sent to Output Queue.

• Generating a Reference Data Report

  • Custom, site-specific database components must be deployed to make this report available in the “Reports” grid of the “Report Library” page.
  • Although a report of this type can be run from any environment that is associated with a given site, the results returned are limited to data contained within the environment from which the report is run.

  1. Expand the ArcReporting “Reports” menu.

     1. Click the “Home” button at the top of the application window to return to the landing page.

     2. Select “ArcReporting” from the components list.

        

     3. Click the “Reporting Workspace” tab at lower-left of the screen.

        

     4. Click the “Reports” menu to view available items.

        If the “Account Period”, “Complex” and “Fund” relevant to the data you wish to view are not currently selected, choose them using the either selection button at upper-left of the screen or the selection bar across the top of the window.

        • Using the selection bar

          1. Click the “[Select Date]” text or “»” symbol.

             All open account periods associated with a project, and to which you have access, are displayed.

             

          2. Click the “[Select Complex]” text or “»” symbol.

             Complexes with projects associated with the specified date are displayed.

             

             If only one complex is available based on the specified date, the complex is automatically chosen.

          3. Click the “[Select Group]” text or “»” symbol.

             Groups associated with the specified complex with active projects for the specified date are displayed.

             

             Alternatively, you can specify “All Fund Groups”, which automatically fills in “All Funds” in the step below. Some pages in Arc Suite (e.g., “Fund Holdings”), allow you to view information for more than one fund simultaneously. If a page does not support multiple fund display, then no information displays when “All Fund Groups » All Funds” is specified.

             

             If only one fund group is available based on the specified complex, the group is automatically chosen.

          4. Click the “[Select Fund]” text or “»” symbol.

             Funds associated with the specified group with active projects for the specified date are displayed.

             

             Alternatively, you can specify “All Funds”.

             

             If only one fund is available based on the specified group, the fund is automatically chosen.

          When all elements of the fund selection bar are specified, you have several options available in terms of viewing different sets of data for open pages.

          

          • Change the specified date. The list of dates is filtered for active projects for the specified fund. Changing the date refreshes the data for all open pages.
          • Change the complex. Changing the complex resets the group, and you’ll need to return to Step 3 above.
          • Change the group. Changing the group resets the fund, and you’ll need to return to Step 4 above.
          • Change the fund. Changing the fund refreshes the data for all open pages.
          • Reset the fund selection bar. Click the “Reset” button at any time to return to Step 1 above.

        • Using the selection button

          1. Click the selection button at upper-left of the window.

             All open account periods associated with a project, and to which you have access, are displayed.

             

             If an account period has already been specified via the fund selection bar (see above), the list under the fund selection button automatically expands that date.

             

          2. Click the arrow at left of the desired account period to display the available complex(es) and associated fund group(s) and fund(s).
          3. Specify the “Complex”, “Fund Group” and “Fund” relevant to the project you wish to view.

  2. Click the “Report Library” item.

     The “Report Library” page displays.

     

  3. Select the appropriate search criteria (i.e., complex, fund group, etc.) and the desired date range using the controls in the top portion of the page.

  4. Select the “Reference Data Report” check box in the “Reports” grid.
  5. Specify the desired “Output Format” (i.e., “PDF” or “Word”).

  6. Click the “Generate output” button at lower-right of the page.

     The report is sent to Output Queue.

     The Reference Data Report will return all securities that meet the specified “Report Results Filters” criteria on four separate worksheets in the Excel spreadsheet.

     • “Holdings”

       • Contains current holdings information, as seen on the “Holdings” tab of the “Fund Holdings” page, excluding categorization.

     • “Primary Security”

       • Contains the client’s underlying security information from their accounting software data feed.

     • “Security Enhancement”

       • Contains the client’s security enrichment information, which comes from sources other than the accounting software data feed.

     • “Categorization”

       • Contains categorization information for the securities currently in Arc Suite, as seen on the “Holdings” tab of the “Fund Holdings” page, and the category load codes from the first and last dataload/data import for the securities.

         Only data that has been loaded in version 2.0.0 and later will be shown.

• Generating a Role Information Report

  1. Expand the ArcFiling “Reports” menu.

     1. Click the “Home” button at the top of the application window to return to the landing page.

     2. Select “ArcFiling” from the components list.

        

     3. Click the “Filings Workspace” tab at lower-left of the screen.

        

     4. Click the “Reports” menu to view available items.

        If the “Account Period”, “Complex” and “Fund” relevant to the data you wish to view are not currently selected, choose them using the either selection button at upper-left of the screen or the selection bar across the top of the window.

        • Using the selection bar

          1. Click the “[Select Date]” text or “»” symbol.

             All open account periods associated with a project, and to which you have access, are displayed.

             

          2. Click the “[Select Complex]” text or “»” symbol.

             Complexes with projects associated with the specified date are displayed.

             

             If only one complex is available based on the specified date, the complex is automatically chosen.

          3. Click the “[Select Group]” text or “»” symbol.

             Groups associated with the specified complex with active projects for the specified date are displayed.

             

             Alternatively, you can specify “All Fund Groups”, which automatically fills in “All Funds” in the step below. Some pages in Arc Suite (e.g., “Fund Holdings”), allow you to view information for more than one fund simultaneously. If a page does not support multiple fund display, then no information displays when “All Fund Groups » All Funds” is specified.

             

             If only one fund group is available based on the specified complex, the group is automatically chosen.

          4. Click the “[Select Fund]” text or “»” symbol.

             Funds associated with the specified group with active projects for the specified date are displayed.

             

             Alternatively, you can specify “All Funds”.

             

             If only one fund is available based on the specified group, the fund is automatically chosen.

          When all elements of the fund selection bar are specified, you have several options available in terms of viewing different sets of data for open pages.

          

          • Change the specified date. The list of dates is filtered for active projects for the specified fund. Changing the date refreshes the data for all open pages.
          • Change the complex. Changing the complex resets the group, and you’ll need to return to Step 3 above.
          • Change the group. Changing the group resets the fund, and you’ll need to return to Step 4 above.
          • Change the fund. Changing the fund refreshes the data for all open pages.
          • Reset the fund selection bar. Click the “Reset” button at any time to return to Step 1 above.

        • Using the selection button

          1. Click the selection button at upper-left of the window.

             All open account periods associated with a project, and to which you have access, are displayed.

             

             If an account period has already been specified via the fund selection bar (see above), the list under the fund selection button automatically expands that date.

             

          2. Click the arrow at left of the desired account period to display the available complex(es) and associated fund group(s) and fund(s).
          3. Specify the “Complex”, “Fund Group” and “Fund” relevant to the project you wish to view.

  2. Expand the ArcReporting “Reports” menu.

     1. Click the “Home” button at the top of the application window to return to the landing page.

     2. Select “ArcReporting” from the components list.

        

     3. Click the “Reporting Workspace” tab at lower-left of the screen.

        

     4. Click the “Reports” menu to view available items.

        If the “Account Period”, “Complex” and “Fund” relevant to the data you wish to view are not currently selected, choose them using the either selection button at upper-left of the screen or the selection bar across the top of the window.

        • Using the selection bar

          1. Click the “[Select Date]” text or “»” symbol.

             All open account periods associated with a project, and to which you have access, are displayed.

             

          2. Click the “[Select Complex]” text or “»” symbol.

             Complexes with projects associated with the specified date are displayed.

             

             If only one complex is available based on the specified date, the complex is automatically chosen.

          3. Click the “[Select Group]” text or “»” symbol.

             Groups associated with the specified complex with active projects for the specified date are displayed.

             

             Alternatively, you can specify “All Fund Groups”, which automatically fills in “All Funds” in the step below. Some pages in Arc Suite (e.g., “Fund Holdings”), allow you to view information for more than one fund simultaneously. If a page does not support multiple fund display, then no information displays when “All Fund Groups » All Funds” is specified.

             

             If only one fund group is available based on the specified complex, the group is automatically chosen.

          4. Click the “[Select Fund]” text or “»” symbol.

             Funds associated with the specified group with active projects for the specified date are displayed.

             

             Alternatively, you can specify “All Funds”.

             

             If only one fund is available based on the specified group, the fund is automatically chosen.

          When all elements of the fund selection bar are specified, you have several options available in terms of viewing different sets of data for open pages.

          

          • Change the specified date. The list of dates is filtered for active projects for the specified fund. Changing the date refreshes the data for all open pages.
          • Change the complex. Changing the complex resets the group, and you’ll need to return to Step 3 above.
          • Change the group. Changing the group resets the fund, and you’ll need to return to Step 4 above.
          • Change the fund. Changing the fund refreshes the data for all open pages.
          • Reset the fund selection bar. Click the “Reset” button at any time to return to Step 1 above.

        • Using the selection button

          1. Click the selection button at upper-left of the window.

             All open account periods associated with a project, and to which you have access, are displayed.

             

             If an account period has already been specified via the fund selection bar (see above), the list under the fund selection button automatically expands that date.

             

          2. Click the arrow at left of the desired account period to display the available complex(es) and associated fund group(s) and fund(s).
          3. Specify the “Complex”, “Fund Group” and “Fund” relevant to the project you wish to view.

  3. Click the “Report Library” item.

     The “Report Library” page displays.

     

  4. Select the appropriate search criteria (i.e., complex, fund group, etc.) and the desired date range using the controls in the top portion of the page.

  5. Select the “Role Information Report” check box in the “Reports” grid.
  6. Specify the desired “Output Format” (i.e., “PDF” or “Word”).

  7. Click the “Generate output” button at lower-right of the page.

     The report is sent to Output Queue.

• Generating a User Information Report

  1. Expand the ArcFiling “Reports” menu.

     1. Click the “Home” button at the top of the application window to return to the landing page.

     2. Select “ArcFiling” from the components list.

        

     3. Click the “Filings Workspace” tab at lower-left of the screen.

        

     4. Click the “Reports” menu to view available items.

        If the “Account Period”, “Complex” and “Fund” relevant to the data you wish to view are not currently selected, choose them using the either selection button at upper-left of the screen or the selection bar across the top of the window.

        • Using the selection bar

          1. Click the “[Select Date]” text or “»” symbol.

             All open account periods associated with a project, and to which you have access, are displayed.

             

          2. Click the “[Select Complex]” text or “»” symbol.

             Complexes with projects associated with the specified date are displayed.

             

             If only one complex is available based on the specified date, the complex is automatically chosen.

          3. Click the “[Select Group]” text or “»” symbol.

             Groups associated with the specified complex with active projects for the specified date are displayed.

             

             Alternatively, you can specify “All Fund Groups”, which automatically fills in “All Funds” in the step below. Some pages in Arc Suite (e.g., “Fund Holdings”), allow you to view information for more than one fund simultaneously. If a page does not support multiple fund display, then no information displays when “All Fund Groups » All Funds” is specified.

             

             If only one fund group is available based on the specified complex, the group is automatically chosen.

          4. Click the “[Select Fund]” text or “»” symbol.

             Funds associated with the specified group with active projects for the specified date are displayed.

             

             Alternatively, you can specify “All Funds”.

             

             If only one fund is available based on the specified group, the fund is automatically chosen.

          When all elements of the fund selection bar are specified, you have several options available in terms of viewing different sets of data for open pages.

          

          • Change the specified date. The list of dates is filtered for active projects for the specified fund. Changing the date refreshes the data for all open pages.
          • Change the complex. Changing the complex resets the group, and you’ll need to return to Step 3 above.
          • Change the group. Changing the group resets the fund, and you’ll need to return to Step 4 above.
          • Change the fund. Changing the fund refreshes the data for all open pages.
          • Reset the fund selection bar. Click the “Reset” button at any time to return to Step 1 above.

        • Using the selection button

          1. Click the selection button at upper-left of the window.

             All open account periods associated with a project, and to which you have access, are displayed.

             

             If an account period has already been specified via the fund selection bar (see above), the list under the fund selection button automatically expands that date.

             

          2. Click the arrow at left of the desired account period to display the available complex(es) and associated fund group(s) and fund(s).
          3. Specify the “Complex”, “Fund Group” and “Fund” relevant to the project you wish to view.

  2. Expand the ArcReporting “Reports” menu.

     1. Click the “Home” button at the top of the application window to return to the landing page.

     2. Select “ArcReporting” from the components list.

        

     3. Click the “Reporting Workspace” tab at lower-left of the screen.

        

     4. Click the “Reports” menu to view available items.

        If the “Account Period”, “Complex” and “Fund” relevant to the data you wish to view are not currently selected, choose them using the either selection button at upper-left of the screen or the selection bar across the top of the window.

        • Using the selection bar

          1. Click the “[Select Date]” text or “»” symbol.

             All open account periods associated with a project, and to which you have access, are displayed.

             

          2. Click the “[Select Complex]” text or “»” symbol.

             Complexes with projects associated with the specified date are displayed.

             

             If only one complex is available based on the specified date, the complex is automatically chosen.

          3. Click the “[Select Group]” text or “»” symbol.

             Groups associated with the specified complex with active projects for the specified date are displayed.

             

             Alternatively, you can specify “All Fund Groups”, which automatically fills in “All Funds” in the step below. Some pages in Arc Suite (e.g., “Fund Holdings”), allow you to view information for more than one fund simultaneously. If a page does not support multiple fund display, then no information displays when “All Fund Groups » All Funds” is specified.

             

             If only one fund group is available based on the specified complex, the group is automatically chosen.

          4. Click the “[Select Fund]” text or “»” symbol.

             Funds associated with the specified group with active projects for the specified date are displayed.

             

             Alternatively, you can specify “All Funds”.

             

             If only one fund is available based on the specified group, the fund is automatically chosen.

          When all elements of the fund selection bar are specified, you have several options available in terms of viewing different sets of data for open pages.

          

          • Change the specified date. The list of dates is filtered for active projects for the specified fund. Changing the date refreshes the data for all open pages.
          • Change the complex. Changing the complex resets the group, and you’ll need to return to Step 3 above.
          • Change the group. Changing the group resets the fund, and you’ll need to return to Step 4 above.
          • Change the fund. Changing the fund refreshes the data for all open pages.
          • Reset the fund selection bar. Click the “Reset” button at any time to return to Step 1 above.

        • Using the selection button

          1. Click the selection button at upper-left of the window.

             All open account periods associated with a project, and to which you have access, are displayed.

             

             If an account period has already been specified via the fund selection bar (see above), the list under the fund selection button automatically expands that date.

             

          2. Click the arrow at left of the desired account period to display the available complex(es) and associated fund group(s) and fund(s).
          3. Specify the “Complex”, “Fund Group” and “Fund” relevant to the project you wish to view.

  3. Click the “Report Library” item.

     The “Report Library” page displays.

     

  4. Select the appropriate search criteria (i.e., complex, fund group, etc.) and the desired date range using the controls in the top portion of the page.

  5. Select the “User Information Report” check box in the “Reports” grid.
  6. Specify the desired “Output Format” (i.e., “PDF” or “Word”).

  7. Click the “Generate output” button at lower-right of the page.

     The report is sent to Output Queue.