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
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.
yes it is set to required. Not sure why the separate page opens.
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.
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?
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
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?
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.
I have the xml file but i am unable to upload. I am getting an avatar error message. Any help would be appreciated.
USe the Insert Code button '#'. Paste betweeen the tags in the actual body of the message.
when I select the xml button on the tool page it displays xml but I am unable to copy and paste.
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.
<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
The clipboard has way to many characters i would have to split code at least 10 times.