Common Hyperlink FAQs

This document introduces the problems you may encounter when using various hyperlinks and the corresponding solutions.

Problem

Set the URL of the web link to the help document address https://help.fanruan.com/finereport-en/.

Click a hyperlink during the report preview, the content of the help document web cannot be displayed correctly, as shown in the following figure.

Cause

When parsing web links for reports, a timestamp will be automatically added. There is an issue with the jump after the timestamp is added to the link for the help document, but no other problematic links have been found so far.

Solution

When setting the hyperlink to the help document, use JavaScript instead of the web link. The code is as follows:

window.open("https://help.fanruan.com/finereport-en/")

Array Error Report

Problem

If the parameter of a dynamic parameter type hyperlink is an array type, click this hyperlink, an error message "Error code: 11300001. Dataset configuration error." will be displayed as shown in the following figure.

Cause

During the hyperlink process, dynamic parameters of array type will be converted to string type, causing such errors.

Solution

When adding a hyperlink with the dynamic parameter type, you cannot use an array type of dynamic parameter. You need to convert the array to a string with the joinarray function.

Null Value Log Error Report

Problem

For example, in the template of the document Multi-column Dynamic Sort, when the dynamic parameter$asc is set to Cell in the report, and a formula, for example, $a[!0] (to get the value of the expanded cell) is used, and an error message "ERROR [standard] The error statement is: [!0]" will be displayed in the designer log.

Note:

The use of the template remains normal.

Cause

When the page is initialized for the preview, the dynamic parameter $asc is null. If the default value for the asc parameter is not set, it will not be assigned until you click the hyperlink. Therefore, the formula parsing fails, reporting an error.

Solution

You can set a parameter with the same name in Template Parameter and assign a default value (any cell with a hyperlink) to the parameter, as shown in the following figure.

Since the problem does not affect the normal use of the template, you can also ignore the error messages in the log.

First Page Returning After the Special Effect Click

Problem

You can achieve expansion and collapse effects through dynamic parameters during the template creation. After you click the special effect, the page will return to the first page.

Cause

After you click the dynamic parameter of the hyperlink, the global refresh will be triggered, equivalent to performing another preview operation, returning to the first page.

Solution

Change the preview method to Data Analysis Preview or modify the dynamic parameter setting.

Problem

You may wonder how to remove the underline automatically generated after adding a hyperlink to a cell, as shown in the following figure.

Solution

This underline is added to the text of the cell. Therefore, just remove the underline from the text.

The following figure shows the effect of removing the underline.

When the date formula is transferred as a hyperlink parameter, it will transfer the original value of the Date type (a value with hours, minutes, and seconds) in the format YYYY-MM-DD HH:MM:SS.

However, if the date formula is directly displayed in the cell, the Date type will be converted to a string (a value without hour, minute, or second) when the cell is converted to HTML for preview in the format YYYY-MM-DD.

For example, a template is set with a hyperlink that links to another template, and the parameter is the formula Today().

In another template, in one cell the formula TODAY() is written directly, and the set parameter today() is referenced in another cell.

The following figure shows the preview effect after the final hyperlink jump.

Problem

The address in the web link can be directly accessed in the browser, but after this address is mounted to the hyperlink of the FRM chart, click the hyperlink area when previewing the FRM chart, and a rejection dialog box pops up.

Cause

This problem is caused by iframe restrictions on the browser and server. Visit the site and set X-Frame-Options to ensure that the website is not embedded in other sites. The template page and the pop-up dialog box are from different sources. Therefore, the dialog box cannot access links to this type of web normally.

Solution

1. Open on a new page with a hyperlink instead of a dialog box. This method has high security and does not require closing any configuration.
2. Disable Security Headers in Security Management in the FineReport project. Besides, the X-Frame-Options should be removed from each application server that needs to be accessed by the dialog box. (Currently, the security risks of deleting this configuration for other non-FineReport applications cannot be confirmed.)