Processing Method and report processing method of adding datasets to the rundry report

Processing Method and report processing method of adding datasets to the rundry report

Added the dataset function in the rundry report. Multiple datasets can be associated in a cell (main cell). After Association, multiple datasets are used as one dataset. When a large number of datasets need to be correlated, or even multiple datasets come from different databases, you can use additional datasets to quickly complete association and achieve higher report performance.

The added dataset function is removed from the compiled report. Instead, you can use the cube or script dataset to associate multiple datasets, you can use the hierarchical dataset returned by the script to quickly develop such reports.

The following is an example to compare the differences between the two.

Add dataset to rundry report

In a report, data from three datasets (ds1: Order, ds2: customer, ds3: Shipping Service) must be used. You can use an additional dataset in the rundry report as follows:

Add the "Additional dataset expression" in the A2 format ":

Ds2.select (customer ID, customer ID = ds1. customer ID)

Ds3.select (freight provider ID, freight provider ID = ds1.), showing:

After completion, add the expression of the B2-F2, directly use the value expression, using the same way as the primary dataset ds1.

Solutions for collecting computing reports

Create a report in the Set Computing report and add the script dataset ds1. The script content is as follows:

After three tables are obtained, the Association is completed in the script and the associated result set is returned to the report. It is worth noting that the result set associated with the script dataset has a hierarchical dataset. The format in the report is:

Compile a report expression and use the hierarchical dataset returned by the script:

You can see how to process multi-data source association through the script dataset in the Set Computing report. If you still need to use the edit debugging function during the script writing process, you can use an independent set computing Script Editor, the compiled script file can be called in the "dataset" of the Set Computing report.

 

The report results are as follows: