We can easily add in any custom tab fields that are not part of a cascade into ProLaw® reports. (Cascade fields require a Lookup function or a Subreport — both advanced techniques.)
Enabling Custom Tab Fields for Reports
- Open any matter.
- Go to Custom tabs…
- Check the Reports checkbox next to each custom tab you would like to make available.
- Click OK.
Adding the Fields to Your Report Dataset
- Go back into design of your report.
- Expand Datasets and double-click the Matters dataset.
- In the Dataset properties window, if Stored Procedure is selected, click Refresh Fields.
- Click OK.
Your custom fields will now be available. Each custom field will be prefaced with the name of the custom tab it comes from.
Fixing Field Ordering (Alphabetical)
If the fields aren't in alphabetical order:
- Go back into the Dataset properties.
- Switch to Text for Query type.
- Enter
SELECT 1and hit Refresh Fields. - Switch back to Stored Procedure and hit Refresh Fields again.
The fields will now be in alphabetical order.
