Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <report xmlns="http://developer.cognos.com/schemas/report/15.5/" useStyleVersion="11.6" expressionLocale="en-us">
- <drillBehavior/>
- <layouts>
- <layout>
- <reportPages>
- <page name="Page1">
- <style>
- <defaultStyles>
- <defaultStyle refStyle="pg"/>
- </defaultStyles>
- </style>
- <pageBody>
- <style>
- <defaultStyles>
- <defaultStyle refStyle="pb"/>
- </defaultStyles>
- </style>
- <contents>
- <block>
- <contents>
- <textItem>
- <dataSource>
- <staticValue>West</staticValue>
- </dataSource>
- </textItem>
- </contents>
- <style>
- <CSS value="font-size:12pt;font-weight:bold;padding-top:2em"/>
- </style>
- </block>
- <block>
- <contents>
- <list horizontalPagination="true" refQuery="West" name="List2">
- <noDataHandler>
- <contents>
- <block>
- <contents>
- <textItem>
- <dataSource>
- <staticValue>No Data Available</staticValue>
- </dataSource>
- </textItem>
- </contents>
- <style>
- <CSS value="padding:16px;"/>
- </style>
- </block>
- </contents>
- </noDataHandler>
- <style>
- <CSS value="border-collapse:collapse"/>
- <defaultStyles>
- <defaultStyle refStyle="ls"/>
- </defaultStyles>
- </style>
- <listColumns>
- <listColumn>
- <listColumnTitle>
- <style>
- <defaultStyles>
- <defaultStyle refStyle="lt"/>
- </defaultStyles>
- </style>
- <contents>
- <textItem>
- <dataSource>
- <dataItemLabel refDataItem="Country"/>
- </dataSource>
- </textItem>
- </contents>
- </listColumnTitle>
- <listColumnBody>
- <style>
- <defaultStyles>
- <defaultStyle refStyle="lc"/>
- </defaultStyles>
- </style>
- <contents>
- <textItem>
- <dataSource>
- <dataItemValue refDataItem="Country"/>
- </dataSource>
- </textItem>
- </contents>
- </listColumnBody>
- </listColumn>
- <listColumn>
- <listColumnTitle>
- <style>
- <defaultStyles>
- <defaultStyle refStyle="lt"/>
- </defaultStyles>
- </style>
- <contents>
- <textItem>
- <dataSource>
- <dataItemLabel refDataItem="Province or state"/>
- </dataSource>
- </textItem>
- </contents>
- </listColumnTitle>
- <listColumnBody>
- <style>
- <defaultStyles>
- <defaultStyle refStyle="lc"/>
- </defaultStyles>
- </style>
- <contents>
- <textItem>
- <dataSource>
- <dataItemValue refDataItem="Province or state"/>
- </dataSource>
- </textItem>
- </contents>
- </listColumnBody>
- </listColumn>
- <listColumn>
- <listColumnTitle>
- <style>
- <defaultStyles>
- <defaultStyle refStyle="lt"/>
- </defaultStyles>
- </style>
- <contents>
- <textItem>
- <dataSource>
- <dataItemLabel refDataItem="Last name"/>
- </dataSource>
- </textItem>
- </contents>
- </listColumnTitle>
- <listColumnBody>
- <style>
- <defaultStyles>
- <defaultStyle refStyle="lc"/>
- </defaultStyles>
- </style>
- <contents>
- <textItem>
- <dataSource>
- <dataItemValue refDataItem="Last name"/>
- </dataSource>
- </textItem>
- </contents>
- </listColumnBody>
- </listColumn>
- <listColumn>
- <listColumnTitle>
- <style>
- <defaultStyles>
- <defaultStyle refStyle="lt"/>
- </defaultStyles>
- </style>
- <contents>
- <textItem>
- <dataSource>
- <dataItemLabel refDataItem="First name"/>
- </dataSource>
- </textItem>
- </contents>
- </listColumnTitle>
- <listColumnBody>
- <style>
- <defaultStyles>
- <defaultStyle refStyle="lc"/>
- </defaultStyles>
- </style>
- <contents>
- <textItem>
- <dataSource>
- <dataItemValue refDataItem="First name"/>
- </dataSource>
- </textItem>
- </contents>
- </listColumnBody>
- </listColumn>
- <listColumn>
- <listColumnTitle>
- <style>
- <defaultStyles>
- <defaultStyle refStyle="lt"/>
- </defaultStyles>
- </style>
- <contents>
- <textItem>
- <dataSource>
- <dataItemLabel refDataItem="Quantity"/>
- </dataSource>
- </textItem>
- </contents>
- </listColumnTitle>
- <listColumnBody>
- <style>
- <defaultStyles>
- <defaultStyle refStyle="lm"/>
- </defaultStyles>
- </style>
- <contents>
- <textItem>
- <dataSource>
- <dataItemValue refDataItem="Quantity"/>
- </dataSource>
- </textItem>
- </contents>
- </listColumnBody>
- </listColumn>
- <listColumn>
- <listColumnTitle>
- <style>
- <defaultStyles>
- <defaultStyle refStyle="lt"/>
- </defaultStyles>
- </style>
- <contents>
- <textItem>
- <dataSource>
- <dataItemLabel refDataItem="Revenue"/>
- </dataSource>
- </textItem>
- </contents>
- </listColumnTitle>
- <listColumnBody>
- <style>
- <defaultStyles>
- <defaultStyle refStyle="lm"/>
- </defaultStyles>
- </style>
- <contents>
- <textItem>
- <dataSource>
- <dataItemValue refDataItem="Revenue"/>
- </dataSource>
- </textItem>
- </contents>
- </listColumnBody>
- </listColumn>
- </listColumns>
- <sortList>
- <sortItem refDataItem="Country"/>
- <sortItem refDataItem="Province or state"/>
- <sortItem refDataItem="Last name"/>
- <sortItem refDataItem="First name"/>
- </sortList>
- </list>
- </contents>
- </block>
- <block>
- <contents>
- <textItem>
- <dataSource>
- <staticValue>East</staticValue>
- </dataSource>
- </textItem>
- </contents>
- <style>
- <CSS value="font-size:12pt;font-weight:bold;padding-top:2em"/>
- </style>
- </block>
- <block>
- <contents>
- <list horizontalPagination="true" refQuery="East" name="List1">
- <noDataHandler>
- <contents>
- <block>
- <contents>
- <textItem>
- <dataSource>
- <staticValue>No Data Available</staticValue>
- </dataSource>
- </textItem>
- </contents>
- <style>
- <CSS value="padding:16px;"/>
- </style>
- </block>
- </contents>
- </noDataHandler>
- <style>
- <CSS value="border-collapse:collapse"/>
- <defaultStyles>
- <defaultStyle refStyle="ls"/>
- </defaultStyles>
- </style>
- <listColumns>
- <listColumn>
- <listColumnTitle>
- <style>
- <defaultStyles>
- <defaultStyle refStyle="lt"/>
- </defaultStyles>
- </style>
- <contents>
- <textItem>
- <dataSource>
- <dataItemLabel refDataItem="Country"/>
- </dataSource>
- </textItem>
- </contents>
- </listColumnTitle>
- <listColumnBody>
- <style>
- <defaultStyles>
- <defaultStyle refStyle="lc"/>
- </defaultStyles>
- </style>
- <contents>
- <textItem>
- <dataSource>
- <dataItemValue refDataItem="Country"/>
- </dataSource>
- </textItem>
- </contents>
- </listColumnBody>
- </listColumn>
- <listColumn>
- <listColumnTitle>
- <style>
- <defaultStyles>
- <defaultStyle refStyle="lt"/>
- </defaultStyles>
- </style>
- <contents>
- <textItem>
- <dataSource>
- <dataItemLabel refDataItem="Province or state"/>
- </dataSource>
- </textItem>
- </contents>
- </listColumnTitle>
- <listColumnBody>
- <style>
- <defaultStyles>
- <defaultStyle refStyle="lc"/>
- </defaultStyles>
- </style>
- <contents>
- <textItem>
- <dataSource>
- <dataItemValue refDataItem="Province or state"/>
- </dataSource>
- </textItem>
- </contents>
- </listColumnBody>
- </listColumn>
- <listColumn>
- <listColumnTitle>
- <style>
- <defaultStyles>
- <defaultStyle refStyle="lt"/>
- </defaultStyles>
- </style>
- <contents>
- <textItem>
- <dataSource>
- <dataItemLabel refDataItem="Last name"/>
- </dataSource>
- </textItem>
- </contents>
- </listColumnTitle>
- <listColumnBody>
- <style>
- <defaultStyles>
- <defaultStyle refStyle="lc"/>
- </defaultStyles>
- </style>
- <contents>
- <textItem>
- <dataSource>
- <dataItemValue refDataItem="Last name"/>
- </dataSource>
- </textItem>
- </contents>
- </listColumnBody>
- </listColumn>
- <listColumn>
- <listColumnTitle>
- <style>
- <defaultStyles>
- <defaultStyle refStyle="lt"/>
- </defaultStyles>
- </style>
- <contents>
- <textItem>
- <dataSource>
- <dataItemLabel refDataItem="First name"/>
- </dataSource>
- </textItem>
- </contents>
- </listColumnTitle>
- <listColumnBody>
- <style>
- <defaultStyles>
- <defaultStyle refStyle="lc"/>
- </defaultStyles>
- </style>
- <contents>
- <textItem>
- <dataSource>
- <dataItemValue refDataItem="First name"/>
- </dataSource>
- </textItem>
- </contents>
- </listColumnBody>
- </listColumn>
- <listColumn>
- <listColumnTitle>
- <style>
- <defaultStyles>
- <defaultStyle refStyle="lt"/>
- </defaultStyles>
- </style>
- <contents>
- <textItem>
- <dataSource>
- <dataItemLabel refDataItem="Quantity"/>
- </dataSource>
- </textItem>
- </contents>
- </listColumnTitle>
- <listColumnBody>
- <style>
- <defaultStyles>
- <defaultStyle refStyle="lm"/>
- </defaultStyles>
- </style>
- <contents>
- <textItem>
- <dataSource>
- <dataItemValue refDataItem="Quantity"/>
- </dataSource>
- </textItem>
- </contents>
- </listColumnBody>
- </listColumn>
- <listColumn>
- <listColumnTitle>
- <style>
- <defaultStyles>
- <defaultStyle refStyle="lt"/>
- </defaultStyles>
- </style>
- <contents>
- <textItem>
- <dataSource>
- <dataItemLabel refDataItem="Revenue"/>
- </dataSource>
- </textItem>
- </contents>
- </listColumnTitle>
- <listColumnBody>
- <style>
- <defaultStyles>
- <defaultStyle refStyle="lm"/>
- </defaultStyles>
- </style>
- <contents>
- <textItem>
- <dataSource>
- <dataItemValue refDataItem="Revenue"/>
- </dataSource>
- </textItem>
- </contents>
- </listColumnBody>
- </listColumn>
- </listColumns>
- <sortList>
- <sortItem refDataItem="Country"/>
- <sortItem refDataItem="Province or state"/>
- <sortItem refDataItem="Last name"/>
- <sortItem refDataItem="First name"/>
- </sortList>
- </list>
- </contents>
- </block>
- </contents>
- </pageBody>
- <XMLAttributes>
- <XMLAttribute output="no" name="RS_legacyDrillDown" value="0"/>
- </XMLAttributes>
- </page>
- </reportPages>
- <pageSetup>
- <namedPaper name="/configuration/pageDefinition[@name='Letter']"/>
- </pageSetup>
- </layout>
- </layouts>
- <XMLAttributes>
- <XMLAttribute output="no" name="RS_CreateExtendedDataItems" value="true"/>
- <XMLAttribute output="no" name="listSeparator" value=","/>
- <XMLAttribute output="no" name="decimalSeparator" value="."/>
- <XMLAttribute output="no" name="RS_modelModificationTime" value="2015-11-25T21:38:24.820Z"/>
- </XMLAttributes>
- <queries>
- <query name="East">
- <source>
- <model/>
- </source>
- <selection>
- <dataItem aggregate="none" rollupAggregate="none" name="Country">
- <expression>[Sales (query)].[Branch].[Country]</expression>
- <XMLAttributes>
- <XMLAttribute output="no" name="RS_dataType" value="3"/>
- <XMLAttribute output="no" name="RS_dataUsage" value="0"/>
- </XMLAttributes>
- </dataItem>
- <dataItem aggregate="none" rollupAggregate="none" name="Province or state">
- <expression>[Sales (query)].[Branch].[Province or state]</expression>
- <XMLAttributes>
- <XMLAttribute output="no" name="RS_dataType" value="3"/>
- <XMLAttribute output="no" name="RS_dataUsage" value="0"/>
- </XMLAttributes>
- </dataItem>
- <dataItem aggregate="none" rollupAggregate="none" name="Last name">
- <expression>[Sales (query)].[Sales staff].[Last name]</expression>
- <XMLAttributes>
- <XMLAttribute output="no" name="RS_dataType" value="3"/>
- <XMLAttribute output="no" name="RS_dataUsage" value="0"/>
- </XMLAttributes>
- </dataItem>
- <dataItem aggregate="none" rollupAggregate="none" name="First name">
- <expression>[Sales (query)].[Sales staff].[First name]</expression>
- <XMLAttributes>
- <XMLAttribute output="no" name="RS_dataType" value="3"/>
- <XMLAttribute output="no" name="RS_dataUsage" value="0"/>
- </XMLAttributes>
- </dataItem>
- <dataItem aggregate="total" name="Quantity">
- <expression>[Sales (query)].[Sales].[Quantity]</expression>
- <XMLAttributes>
- <XMLAttribute output="no" name="RS_dataType" value="1"/>
- <XMLAttribute output="no" name="RS_dataUsage" value="2"/>
- </XMLAttributes>
- </dataItem>
- <dataItem aggregate="total" name="Revenue">
- <expression>[Sales (query)].[Sales].[Revenue]</expression>
- <XMLAttributes>
- <XMLAttribute output="no" name="RS_dataType" value="2"/>
- <XMLAttribute output="no" name="RS_dataUsage" value="2"/>
- </XMLAttributes>
- </dataItem>
- </selection>
- <detailFilters>
- <detailFilter>
- <filterExpression>[Sales (query)].[Branch].[Country] in ('Australia', 'Austria', 'Belgium', 'China', 'Denmark', 'Finland', 'France', 'Germany', 'Italy', 'Japan', 'Korea', 'Netherlands', 'Singapore', 'Spain', 'Sweden', 'Switzerland', 'United Kingdom')</filterExpression>
- </detailFilter>
- </detailFilters>
- </query>
- <query name="West">
- <source>
- <model/>
- </source>
- <selection>
- <dataItem aggregate="none" rollupAggregate="none" name="Country">
- <expression>[Sales (query)].[Branch].[Country]</expression>
- <XMLAttributes>
- <XMLAttribute output="no" name="RS_dataType" value="3"/>
- <XMLAttribute output="no" name="RS_dataUsage" value="0"/>
- </XMLAttributes>
- </dataItem>
- <dataItem aggregate="none" rollupAggregate="none" name="Province or state">
- <expression>[Sales (query)].[Branch].[Province or state]</expression>
- <XMLAttributes>
- <XMLAttribute output="no" name="RS_dataType" value="3"/>
- <XMLAttribute output="no" name="RS_dataUsage" value="0"/>
- </XMLAttributes>
- </dataItem>
- <dataItem aggregate="none" rollupAggregate="none" name="Last name">
- <expression>[Sales (query)].[Sales staff].[Last name]</expression>
- <XMLAttributes>
- <XMLAttribute output="no" name="RS_dataType" value="3"/>
- <XMLAttribute output="no" name="RS_dataUsage" value="0"/>
- </XMLAttributes>
- </dataItem>
- <dataItem aggregate="none" rollupAggregate="none" name="First name">
- <expression>[Sales (query)].[Sales staff].[First name]</expression>
- <XMLAttributes>
- <XMLAttribute output="no" name="RS_dataType" value="3"/>
- <XMLAttribute output="no" name="RS_dataUsage" value="0"/>
- </XMLAttributes>
- </dataItem>
- <dataItem aggregate="total" name="Quantity">
- <expression>[Sales (query)].[Sales].[Quantity]</expression>
- <XMLAttributes>
- <XMLAttribute output="no" name="RS_dataType" value="1"/>
- <XMLAttribute output="no" name="RS_dataUsage" value="2"/>
- </XMLAttributes>
- </dataItem>
- <dataItem aggregate="total" name="Revenue">
- <expression>[Sales (query)].[Sales].[Revenue]</expression>
- <XMLAttributes>
- <XMLAttribute output="no" name="RS_dataType" value="2"/>
- <XMLAttribute output="no" name="RS_dataUsage" value="2"/>
- </XMLAttributes>
- </dataItem>
- </selection>
- <detailFilters>
- <detailFilter>
- <filterExpression>[Sales (query)].[Branch].[Country] not in ('Australia', 'Austria', 'Belgium', 'China', 'Denmark', 'Finland', 'France', 'Germany', 'Italy', 'Japan', 'Korea', 'Netherlands', 'Singapore', 'Spain', 'Sweden', 'Switzerland', 'United Kingdom')</filterExpression>
- </detailFilter>
- </detailFilters>
- </query>
- </queries>
- <modelPath>/content/folder[@name='Samples']/folder[@name='Models']/package[@name='GO sales (query)']/model[@name='model']</modelPath>
- </report>
Advertisement
Add Comment
Please, Sign In to add comment