Prompts In Reportnet 1

[mdr]

Does Anyone Know how to set a value prompt to 'ALL'?
I have a report that has a type of either 'reactive' or 'proactive' and users need to filter by either. however, occasionally they will need to see data by both reactive and proactive types, and i would like to see a drop down that either has the all option showing, or allows me to rename the {unknown} selection.

Any ideas?

 

[Waspy]

2 options
1/ Make it optional and not choosing anything?

2/
Add a drop down prompt to the report
Add “All” as a static choice
In the filter type ((?prompt? = ‘All’) Or (column = ?prompt?))

Report based on GO sample package -

<report xml:lang="en-us" xmlns="

http://developer.cognos.com/schemas/report/1/"><!--RS:1.1-->

<modelConnection name="/content/package[@name='GO Sales and Retailers']/model[@name='2004-11-15T15:47:51.301Z']"/>
<querySet xml:lang="en-us">
<BIQuery name="Query1">
<cube><factList><item refItem="Product line" aggregate="none"/></factList></cube>
<tabularModel><dataItem name="Product line" aggregate="none"><expression>[gosales_goretailers].[Products].[Product line]</expression></dataItem><filter><condition>((?Product line? = 'All') or ([gosales_goretailers].[Products].[Product line] = ?Product line?))</condition></filter></tabularModel></BIQuery>
<BIQuery name="Product line"><cube><factList><item refItem="Product line" isHeader="true"/></factList></cube><tabularModel><dataItem name="Product line" aggregate="none"><expression>[gosales_goretailers].[Products].[Product line]</expression></dataItem></tabularModel></BIQuery></querySet>
<layoutList>
<layout>

<pageSet>

<page name="Page1">
<pageBody>
<list refQuery="Query1">
<listColumnTitles><listColumnTitle><textItem><queryItemRef refItem="Product line" content="label"/></textItem></listColumnTitle></listColumnTitles>
<listColumns><listColumn><textItem><queryItemRef refItem="Product line"/></textItem></listColumn></listColumns>
<style>
<CSS value="border-collapse:collapse"/>
</style>
</list>
</pageBody>
<pageHeader>
<block class="reportTitle">
<textItem class="reportTitleText">
<text/>
</textItem>
</block>
<style>
<CSS value="padding-bottom:10px"/>
</style>
</pageHeader>
<pageFooter>
<table>
<tableRow>
<tableCell>
<textItem>
<expression>AsOfDate()</expression>
</textItem>
<style>
<CSS value="vertical-align:top;text-align:left;width:25%"/>
</style>
</tableCell>
<tableCell>
<textItem>
<text>- </text>
</textItem>
<textItem>
<expression>PageNumber()</expression>
</textItem>
<textItem>
<text> -</text>
</textItem>
<style>
<CSS value="vertical-align:top;text-align:center;width:50%"/>
</style>
</tableCell>
<tableCell>
<textItem>
<expression>AsOfTime()</expression>
</textItem>
<style>
<CSS value="vertical-align:top;text-align:right;width:25%"/>
</style>
</tableCell>
</tableRow>
<style>
<CSS value="border-collapse:collapse;width:100%"/>
</style>
</table>
<style>
<CSS value="padding-top:10px"/>
</style>
</pageFooter>
</page></pageSet><promptPageList><page name="Prompt Page1">
<pageHeader>
<block class="reportTitle">
<textItem class="reportTitleText">
<text/>
</textItem>
</block>
<style>
<CSS value="padding-bottom:10px"/>
</style>
</pageHeader>
<pageBody>
<style>
<CSS value="padding:12px"/>
</style>
<block><textItem><text>Product line</text></textItem></block><block><style><CSS value="margin-bottom:12px"/></style><selectValue refQuery="Product line" parameter="Product line" multiSelect="false"><useItem refItem="Product line"/><selectOptions><selectOption useValue="All"><displayValue value="All"/></selectOption></selectOptions><defaultSelections><defaultSelection>All</defaultSelection></defaultSelections></selectValue></block></pageBody>
<pageFooter>
<style>
<CSS value="padding:12px;border-top:1pt solid #999999"/>
</style>
<promptButton type="cancel">
<style>
<CSS value="margin-right:7px"/>
</style>
</promptButton>
<promptButton type="back">
<style>
<CSS value="margin-right:7px"/>
</style>
</promptButton>
<promptButton type="next">
<style>
<CSS value="margin-right:7px"/>
</style>
</promptButton>
<promptButton type="finish"/>
</pageFooter>
</page>
</promptPageList></layout>
</layoutList>
</report>