Insert Link dialog for page report

The dialog appears when you select a specified object in the design area in a page report, right-click it and select Link from the shortcut menu, or click the button in the value cell of the Link property or Detail Report property in the Report Inspector. It helps you to link the object to a report, a detail report, a website, an e-mail address or a Blob data type field as required.

Conditional Link

Specifies whether it is a conditional link. If checked, the object can be linked to different targets based on different conditions.

• 
  Adds a new condition in the Edit Conditions dialog.
• 
  Edits the selected condition.
• 
  Removes the selected condition.
• 
  Moves the selected condition one step up.
• 
  Moves the selected condition one step down.
• Others
  If checked, you can define to which target the object will be linked when none of the conditions you have specified is met.

Link Type

Specifies the type of the link target for the object if it is not a conditional link or for the object under the selected condition if it is a conditional link. It can be one of the following:

• Report
• Master/Detail Report
• URL
• E-mail
• Content

More

Displays more link options. Available only for the Report, Master/Detail Report and Content link types.

OK

Accepts the linking result and closes the dialog.

Cancel

Cancels the linking process and exits the dialog.

Help

Displays the help document about this feature.

Report

It helps you to link the object to a report. See the dialog.

Report

Specifies the report in which the linked report tab is. Click the Browse button to select the desired report in the Select a Report dialog.

Report Tab

Specifies the linked report tab.

Target

Specifies the window or frame in which to load the linked report. Applied only when the link is triggered in Page Report Studio.

• <Server Setting>
  Loads the linked report according to setting of the Pop Up New Window for Links option in the Profile > Configure Profile > Page Report Studio > Properties > Default tab on JReport Server.
• Same Frame
  Loads the linked report into the same frame as the primary report.
• Whole Window
  Loads the linked report into the full browser window.
• New Window
  Loads the linked report into a new window. This window is not named.
• Parent Frame
  Loads the linked report into the parent frame of the frame in which the primary report is.
• Other Frame
  Loads the linked report into some other specified frame. If the frame name does not exist, the linked report will be loaded into a new window.

Filter tab

Specifies the filter conditions based on which the link relationship between the primary report and the linked report is set up.

• Components
  Specifies the components in the linked report that will be interlinked with the primary report.
  • 
    Adds a component in the linked report to be interlinked with the primary report.
  • 
    Edits the component in the linked report to be interlinked with the primary report.
  • 
    Removes the selected component from the Component in Report Tab box.
• Default Linked Component
  Specifies the default linked component in the linked report.
• Field Conditions
  Lists the filter conditions between the primary report and the linked report.
  • Fields(Primary)
    Lists the selected fields of the primary report.
  • OP
    Specifies the operator to compose the condition. It can be "=", "<>", "<", ">", "<=", ">=" or "IN".
  • Fields(LinkedReport)
    Lists the DBFields in the datasets of the linked report which are of the same data type as the selected fields in the primary report.
  • 
    Adds a new condition line.
  • 
    Removes the selected condition.

Parameters tab

This tab is available when the linked report uses parameters. It helps you to assign values to the parameters of the linked report automatically.

• Parameters
  Lists all parameters contained in the datasets of the linked report.
• Value
  Lists all the DBFields, formulas, summaries and parameters in the datasets of the primary report which are of the same data type as the parameters of the linked report. Select the field the value of which you want to assign to parameter of the linked report from the drop-down list.

Advanced tab

Specifies to pass the values of the filter objects such as filter controls and sliders in the primary report to those in the linked report.

• Primary Report Property/Object
  Displays the filter objects in the primary report the values of which will be passed to those in the linked report. Click to select a filter object in the primary report in the Select Value dialog.
• Linked Report Property/Object
  Displays the filter objects in the linked report which will adopt the values passed from filter objects in the primary report. Click to select a filter object in the linked report in the Select Value dialog. You need to make sure that values of the filter object in the primary report can be applied to the filter object in the linked report in the same line.
• 
  Adds a new line to pass values between the filter objects in the primary report and the linked report.
• 
  Removes the selected line.

Pass style group information down to linked report

Specifies whether or not to apply the style group of the primary report to the linked report.

Master/Detail Report

It helps you to link the object to a detail report. See the dialog.

Report

Specifies the report in which the detail report tab is. Click the Browse button to select the desired report in the Select a Report dialog.

Report Tab

Specifies the target detail report tab.

Component

Specifies the component in the detail report tab that will be interlinked with the master report. Click the Browse button to add the components. You can add more than one component as long as the components are based on the same dataset.

Target

Specifies the window or frame where to load the detail report.

• <Server Setting>
  Loads the detail report according to setting of the Pop up New Window for Links option in the Profile > Configure Profile > Page Report Studio > Properties > Default tab on JReport Server.
• Same Frame
  Loads the detail report into the same frame as the master report.
• Whole Window
  Loads the detail report into the full browser window.
• New Window
  Loads the detail report into a new window, which is not named. If this is selected, the detail report will be opened independently when you click the trigger in Page Report Studio, that is to say the join and filter conditions you set between the master report and detail report will not be applied.
• Parent Frame
  Loads the detail report into the parent frame of the frame in which the master report is.
• Other Frame
  Loads the detail report into some other specified frame. If the frame name does not exist, the detail report will be loaded into a new window.

Anchor

Specifies the relationships between the master report and the detail report.

• Column in Detail Report
  Specifies the field in the detail report which will be used to link the detail report with the master.
• OP
  Specifies the operator. It can be "=", "<>", "<", ">", "<="or ">=".
• Column in Master Report
  Specifies the field in the master report.

Conditions tab

Specifies the filter conditions between the master report and the detail report.

• Field Conditions
  Lists all the filter conditions.
  • Fields(MasterReport)
    Lists the selected fields of the master report.
  • OP
    Specifies the operator to compose the condition. It can be "=", "<>", "<", ">", "<="or ">=".
  • Fields(DetailReport)
    Lists the DBFields in the datasets of the detail report which are of the same data type as the selected fields in the master report.
  • More
    Specifies relations between two conditions. Can be AND or OR.
  • 
    Adds a new condition line.
  • 
    Removes the selected condition.

Parameters tab

This tab is only available when there is at least one parameter applied in the filters of the queries that the detail report uses. It helps you to assign values to the parameters of the detail report automatically.

• Parameters (Detail Report)
  Lists all parameters contained in the datasets of the detail report.
• Column (Master Report)
  Lists all the DBFields, formulas and summaries in the datasets of the master report which are of the same data type as the parameters of the detail report. Select the field the value of which you want to assign to parameter of the detail report from the drop-down list.

Use the same encoding and DB setting for the detail report as that of the master report

Specifies whether the detail report uses the same encoding and DB settings as per the master report.

URL

It helps you to link the object to a location specified by a URL. See the dialog.

Hyperlink

Specifies the URL of the location that the object will be linked to. Fields can work in the hyperlink only when they are inserted via the Add Dynamic Field option.

• Add Dynamic Field
  Opens the Select Field dialog to insert a field into the URL.

Target

Specifies the window or frame in which to load the location specified by the URL. Applied only when the link is triggered in Page Report Studio.

• <Server Setting>
  Loads the linked file according to setting of the Pop Up New Window for Links option in the Profile > Configure Profile > Page Report Studio > Properties > Default tab on JReport Server.
• Same Frame
  Loads the linked file into the same frame as the link.
• Whole Window
  Loads the linked file into the full browser window.
• New Window
  Loads the linked file into a new window. This window is not named.
• Parent Frame
  Loads the linked file into the parent frame of the frame that contains the link.
• Other Frame
  Loads the linked file into some other specified frame. If the frame name does not exist, the linked file will be loaded into a new window.

E-mail

It helps you to link the object to an e-mail address. See the dialog.

Hyperlink

Specifies the e-mail address that the object will be linked to. Then after you click the trigger object, an e-mail will be popped with the information specified in the Hyperlink box. You can then further customize the e-mail and send it.

Enter the e-mail address in the Hyperlink box using the syntax sAddress[sHeaders]. The following are details about the syntax:

• sAddress
  One or more valid e-mail addresses separated by a semicolon. You must use Internet-safe characters, such as %20 for the space character.
• sHeaders
  Optional. One or more name-value pairs. The first pair should be prefixed by a "?" and any additional pairs should be prefixed by a "&". The name can be one of the following strings:
  • CC
    Addresses to be included in the "cc" (carbon copy) section of the message.
  • BCC
    Addresses to be included in the "bcc" (blind carbon copy) section of the message.
  • subject
    Text to appear in the subject line of the message.
  • body
    Text to appear in the body of the message.

Hyperlink examples:

• user@example.com
• user1@example.com;user2@example.com
• Customer Name@jinfonet.com, here Customer Name is a field name.
• salesmanager@Country.jinfonet.com, here Country is a field name.
• user@example.com?CC=user1@example.com&BCC=user2@example.com&subject=TestLinkToEmail&Body=Version%20x.x%0D%0A%0D%0ATest%20Link%20To%20E-mail

  Here is the e-mail result:

  

Add Dynamic Field

Opens the Select Field dialog to insert a field into the e-mail address.

Content

It helps you to link the object to a Blob data type field. The Blob data type field will be bound to the object and displayed as a hyperlink. You can download the Blob content by clicking this hyperlink. In JReport, Blob could be image, Binary, Blob, Clob, LongBlob, LongClob, Varbinary, Longvarbinary, and so on. See the dialog.

Query

Specifies the query which contains the required Blob data type field. Only queries from the same data source connection as the current report are listed.

When you set the link type to Content, JReport will check whether there are such kind of queries available. If not, options for this link type will be disabled.

Content Type

Specifies the content type for the Blob type data. You can click the button to bind it with a field column or a record level pass one formula in the selected query.

File Name

Specifies the file name for the linked Blob type data. You can click the button to bind it with a field column or a record level pass one formula in the selected query.

Content

Specifies the Blob data type field in the selected query.

Filter tab

Specifies the link conditions between the query used by the current report and the query that contains the linked Blob content.

• Field Conditions
  Lists the filter conditions between the two queries.
  • Fields(Primary)
    Lists the selected fields of the query used by the current report.
  • OP
    Specifies the operator to compose the condition. It can be "=", "<>", "<", ">", "<=", ">=" or "IN".
  • Fields(Linked)
    Lists the DBFields in the datasets of the query that contains the linked Blob content, which are of the same data type as the selected fields in the query used by the current report.
  • 
    Adds a new condition line.
  • 
    Removes the selected condition.

Parameters tab

This tab is available when the query that contains the linked Blob content uses parameters. It helps you to assign values to the parameters automatically.

• Parameters
  Lists all the parameters the query that contains the linked Blob content uses.
• Value
  Lists all the DBFields, formulas, summaries and parameters in the query used by the current report, which are of the same data type as the parameters the query that contains the linked Blob content uses. Select the field the value of which you want to assign to a parameter from the drop-down list.

Related topic:

• Binding a link to a label