Report Filter Option In Web

[JaC74]

Here is the issue, any help will be appreciated. I have a report with a secondary prompt. Once the report is returned, I go to menu option View / Report Filter. The Report Filter options does not display what was selected in the secondary prompt. Is there a way to expose this through a setting or customization?

More details on the report execution and prompts
Steps:

1. Prompt on location (This prompt uses location hierarchy)
2. Prompt on product (This prompt uses product hierarchy)
3. Prompt on Promotion Start Date (User enters a single previous date here)

Secondary prompt
4. Based on the date entered in #3, this prompt brings back completed weeks between #3 date and current date.

After the execution, the Report Filter only displays #1, and #2.

John

 

[spod]

You need to do this through customization of FilterDisplayCuLib.asp.

Get the report XML, find the value for the prompt and display that. Be aware that the prompt answer is NOT in the XML after a drill!

some messy code now follows:

'get report xml
	strReportXML = aReportInfo(O_REPORTXML_REPORT).xml
	set objReportList = Server.CreateObject("Microsoft.XMLDOM")
	objReportList.LoadXML(strReportXML)


Set objRptDefOi01 = objReportList.selectSingleNode(".//mi/rit/rsl/mi/in/oi[@n='Name of prompt']/mi/pif/pa")
			strValue01 = objRptDefOi01.text
			response.cookies("promptanswer01") = strValue01