If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Cascading value prompt opens an unwanted promt page

Started by fullyii, 22 Sep 2010 11:53:28 AM

Previous topic - Next topic

fullyii

I have 2 value prompt lists Session and Course where course cascades off of session. When I run the report with auto-Submit set to no and run report manually for each prompt selection all works fine. I then set session property to auto-submit to yes and all of a sudden when I select a value in the session prompt a unwanted prompt page appears with the course prompt list.

Is there a setting somewhere to turn off prompt page?

Thank you,
Fullyii

cschnu

Is the course parameter list set to required on your prompt page? If it is not the auto-submit from the session parameter will close out your first parameter page because it has captured all required parameters for the page. The report will then bring up a second page to ask you for the required detail clause in your query which is the course parameter.

fullyii

yes it is set to  required. Not sure why the separate page opens.

technomorph

Make sure you have your value prompts configured correctly. Check that the Cascade Source property of the Course value prompt is set to the parameter of the Session value prompt.



fullyii

When i turn the auto-submit off property the prompt page doesn't appear and the list cascades properly. Does that mean it is configured properly?

technomorph

#5
Hi,

You need to have Auto-Submit turned on for cascading to work, so I'm not sure how it's working if you have it turned off. The following are the properties that you need to set:

Session Value Prompt
Query > Prompt Query1
Use Value > Data Item 1
Parameter > P_Session
Auto-Submit > Yes

Course Value Prompt
Query > Prompt Query2
Use Value > Data Item 1
Cascade Source > P_Session
Auto-Submit > No

I don't think I've missed anything out, however it's always difficult to know exactly what's going on without seeing the report in the flesh. If the above still doesn't work, perhaps post the report XML so that we can have a look.

Cheers




fullyii

Thanks for your input. I set all of my filters to optional and now the prompt page does not come up and the cascade does work. The issue I have is that the whole report has to run for each prompt. Is there a way to only update the prompts and not all the query's. In otherwords have the user select criteria in each prompt with cascade feature and then rely on the user to select run report to get the filtered report?

technomorph

If I follow correctly, I think you ultimately just want the prompts to be mandatory and cascading, right?

This sounds like a filter issue. However, I think it will be quicker to resolve this issue if you publish the XML here so we can take a look.


fullyii

I have the xml file but i am unable to upload. I am getting an avatar error message. Any help would be appreciated.

technomorph

USe the Insert Code button '#'. Paste betweeen the tags in the actual body of the message.


fullyii

when I select the xml button on the tool page it displays xml but I am unable to copy and paste.

technomorph

Within Report Studio go to Tools > Copy Report To Clipboard

Then paste the code into the body of your new message using the Insert Code button. Make sure you paste between the code tags.

fullyii



<report xmlns="http://developer.cognos.com/schemas/report/5.0/" expressionLocale="en-us">
<modelPath>/content/package[@name='L1SAT']/model[@name='model']</modelPath>
<drillBehavior modelBasedDrillThru="true"/>
<layouts>
<layout>
<reportPages>
<page name="Page1">
<style>
<defaultStyles>
<defaultStyle refStyle="pg"/>
</defaultStyles>
</style>
<pageBody>
<style>
<defaultStyles>
<defaultStyle refStyle="pb"/>
</defaultStyles>
</style>
<contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell colSpan="2"><contents><selectValue parameter="QMIdParam" refQuery="qrySession" multiSelect="false" range="false" required="true" autoSubmit="true"><useItem refDataItem="SessionId"><displayItem refDataItem="StandardLevel1_x00"/></useItem><defaultSelections><defaultSimpleSelection>ILT - Short</defaultSimpleSelection></defaultSelections><propertyList><propertyItem refDataItem="SessionId"/><propertyItem refDataItem="StandardLevel1_x00"/></propertyList></selectValue><selectValue parameter="pCourseCode" refQuery="Query1" cascadeOn="QMIdParam" multiSelect="false" range="false" required="true" autoSubmit="true"><defaultSelections><defaultSimpleSelection>CourseCode</defaultSimpleSelection></defaultSelections><useItem refDataItem="CourseCode"/></selectValue><selectValue parameter="OfferingId" refQuery="Query3" cascadeOn="pCourseCode" multiSelect="false" range="false" required="false"><useItem refDataItem="OfferingId"/></selectValue><textItem><dataSource><staticValue>   Start Date </staticValue></dataSource></textItem><selectDate parameter="pDateFrom" multiSelect="false" required="false" selectDateUI="editBox"/><textItem><dataSource><staticValue>      End Date  </staticValue></dataSource></textItem><selectDate parameter="pToDate" multiSelect="false" required="false" selectDateUI="editBox"/><hyperlink>
<dataSource>
<staticValue/>
</dataSource>
<contents>
<textItem>
<dataSource>
<staticValue>Open-Ended Comments</staticValue>
</dataSource>
</textItem>
</contents>
<style>
<defaultStyles>
<defaultStyle refStyle="hy"/>
</defaultStyles>
</style>
</hyperlink></contents><style><CSS value="width:100%;border:1pt solid



fullyii

The clipboard has way to many characters i would have to split code at least 10 times.