by Brainvire Infotech Pvt. Ltd

BV Report Tweaks Integration offers enhanced data customization capabilities within SuiteCRM, empowering users to generate insightful reports.

Free 30 day trial
Try it Now

User Guide

Step: 1. Click on Report Module---- Create a Report.

1. Put a name of the Report-- Select the Report Module-- Select the Module Tree.: Users can search for a particular field for which data needs to be shown in the box.

In the Module Tree selection interface, users can now easily search for particular fields to include. For instance, users can search for fields such as "First Name" and "Date Created" to display relevant data.

Report.png.

Step: 2. Customizing Field Visibility in Reports from Studio.

In Studio, the default for all module fields is set to "Yes," so all fields appear when a module is selected. Users can change this to "No" in Studio if they don't want certain fields to show in the report. This allows customization of the report to display only relevant fields.

Report 1.png

Report Module Field Tree Default Value is Set to "Yes".

Report 2.png

Customize Field Visibility: Select "No" from the Dropdown.

If a user doesn't want a particular field to appear for a selected module, they can set the field to "No" from the dropdown and save. This field will then be excluded from the generated report.

Report 3.png

In the snapshot below, you can observe that once "No" is selected from the dropdown for a specific field, the module tree selection disappears.

Report 5.PNG

Step: 3. Condition Update for Field in Box.

Users can now apply conditions based on filtering the fields within the designated box. For instance, users can specify conditions related to the "Date Created" field, allowing for dynamic filtering.

Conditions.PNG

Step: 4. Custom Date Range Selection option.

Users now have the capability to define their own date ranges, empowering them to narrow down data analysis to specific timeframes according to their needs.

Custom Date Range Selection.png

Step: 5. Excluding Data type functionality---- Fields which Contain Varchar/ Text Field---- Operator added for "Does Not Contain."

users can now specify particular data type for which data should be excluded from the report. An option has been added in Operator for "Does Not Contain" and by inputting a specific data in the value section, such as "Test," users can ensure that any data associated with this value will be excluded from the generated report.

Excluded Data.png

Step: 6. Final Report-- After applying the specified customizations and parameters, the generated report is as follows:

This report reflects the refined data selection, including the exclusion of entries based on specified names and the application of custom date ranges.

Final Report.png

Step: 7. Scheduled Report Generation and Email Distribution:- Users can now schedule reports using the scheduler feature and send them to selected recipients via email. Users can set the time from advance section to receive the report via email.

A). Creating Scheduled Reports.- Under the generated report, you'll find a subpanel for scheduled reports. Click on it to create a new scheduled report.

Report 6.png

B). Setting Up Scheduled Reports.- To create a scheduled report, specify the schedule time, recipient email IDs, and select the email format checkbox.

Report 10.png

C). Scheduler Status Check.- Make sure your scheduler is active and running successfully.

Report 8.png

D). Confirmation of Scheduled Report Delivery.- Scheduled reports are successfully delivered to recipients whose email addresses are added. Multiple scheduled reports can be created for different modules as needed.

Report 9.png

E). CSV Format Reports.- To receive reports in CSV format via email, uncheck the email format checkbox.

Report 11.PNG

F). Scheduled Report Received in CSV Format.- The snapshot confirms that the recipient has successfully received the scheduled report in CSV format.

Report 12.png

Saving Comment Saving Comment...