Sources

As described in Working with Data Sources, if you plan on generating XSLT for your XML Publisher report you must have specified at least one default source. (Sources are not required for generating XQuery, though it is considered good practice to specify one.)

Additional Sources

You can specify multiple sources for an XML Publisher report. The first source is specified in the XSLT/XQuery Scenario Properties dialog box as shown in the following table.

The expression associated with these variable names is displayed on the Parameter Values page of the Scenario Properties dialog box, like the one shown for XQuery scenarios in Figure 526.

As you can also see, Figure 526 shows how data sources specified in XML Publisher are represented in the XQuery (and XSLT) editor. This XQuery uses three XML sources:

More About Relational Sources

Relational sources, like the one shown in Figure 526, are referenced in different ways by XSLT and XQuery:

document('xquery:///jdbc:xquery:sqlserver://ntstylus-dev:1433;table=companies;user=sa;xmlforest=true;schema=dbo;DatabaseName=pubs;urltype=.xml')"

collection('pubs.dbo.companies')/companies/ticker

See Working with the XQuery collection() Function for more information.

 
Free Stylus Studio XML Training: