Fundriver made improvements to the User Defined Reporting Tool (12/3/17).  This tool is easy to use and versatile. Watch the demo video here!

At the main page REPORT User-Defined Reports Data Source users can select to EDIT OR COPY EXISTING REPORT or CREATE NEW REPORT FROM DATA SOURCE.
1.png

If the user chooses to create a new report you can select any of the following sources: Activity Summary, Profile Data, Transactions or Estimated
2.png

For a complete list of fields available in the Standard Data Sources, click here!

This is the new format where users can add fields, sort by, group by and filter options all from this one tab.
7.png

The first accordion allows the user to select fields to display on the report. Depending on the data source that was chosen on the first tab, all available fields to select from will be automatically populated.
8.png

There's an option to select and delete all fields so the user can start from scratch if they'd like.
9.png

Here the user can also click Add Field to choose specific fields to add to the report. This drop down list of available fields will appear.
11.png

Once the user chooses a field from the drop down, the required fields (Label, Width, Decimal) populate automatically.
12.png

Users have the ability to change Field Labels in this window. Users can also select the Hide Zero Activity checkbox, this will hide a column if there are zeroes in all rows.

13.png

To reorder the columns, click the number corresponding with the field and move the cursor to the desired location - wait for the blue bar to show up and click to drop the field into the new location.
15.png



16.png

The second accordion allows the user to choose sort options for the report.

17.png


Choose from the drop down different fields to sort the report by.


For fields that do not have the check option for selecting multiple values, the user will need to type out the value(s) and use a comma for separating multiple values.


For example, when setting up a filter on GLID with multiple values, the user will need to enter the text: 100,101,102. This will build a filter with the 3 GLIDs referenced. 

18.png

19.png

The third accordion allows the user to choose group options for the report.

For fields that do not have the check option for selecting multiple values, the user will need to type out the value(s) and use a comma for separating multiple values.


For example, when setting up a filter on GLID with multiple values, the user will need to enter the text: 100,101,102. This will build a filter with the 3 GLIDs referenced. 

20.png


Choose from the drop down different fields to group the report by.
21.png

22.png

The fourth accordion allows the user to choose filter options for the report.

*Please Note: There is a section under the Reports tab which allows the user to create a stand alone filter that can be applied to standard reports and user defined reports when they are run.  For more information on the Manage Filters feature check out this article.


For fields that do not have the check option for selecting multiple values, the user will need to type out the value(s) and use a comma for separating multiple values.


For example, when setting up a filter on GLID with multiple values, the user will need to enter the text: 100,101,102. This will build a filter with the 3 GLIDs referenced. 

23.png

Choose from the drop down different fields to filter the report by.
24.png

Through this filter option the user is able to add Operators and/or Expressions as well.
25.png

Selecting IN will populate a drop down to select specific items to filter IN to the report.
26.png

Selecting NOT IN will populate a drop down to select specific items to filter NOT IN to the report (or to exclude from the report).
27.png

Selecting LIKE will populate a text field where the user can enter a key word or part of a word to filter into the report.
28.png

To add more than one filter the user will be given options for AND or OR under the Extend Filter drop down. There is no limit to the number of filters that can be added.30.png31.png

On the Title tab, users can title the reports. This page defaults to "Save as new report" unless the user chooses to edit an existing report on the Data Source tab.

32.png


On this tab, users can also choose the Report Lock button which prevents any other user from modifying this specific report- only the creator will have the access to do so.

33.png


Users can upload logos by clicking Browse on the Report Logo line.

There are also a number of different formats the user can choose to have the date display as.  Please note: the date will display in the footer (run date) and in the header (selected report dates) however this format is selected.
35.png

Click the dropdown in Report Category to choose a folder to save the report to.

Once the user clicks Publish, this page is displayed.

37.png


To view the report which was created; navigate to the corresponding folder and the reports will be listed alphabetically.38.png39.png