ReportNet - Displaying Selected Prompt Value 1

[sapatriot24]

Quick question and could have a simple solution but I've been blind, I guess. I have a select a value prompt that has several values to choose from. If I choose only 2 of the values, only those two info should appear right. For some odd reason, only two of the chosen appear with info but all other values from the prompt appear as the section headers with no info. But, I dont want them to appear. Please help me if you can

 

[ChillAPAC]

How are you filtering the selected prompt values?
table.column_name in (?promptvalue?)?
What is the query source for your section headers?
If the section headers are from the same query you are applying your prompt values they should not appear.

Are you using any sort of Master-Detail relationship?
I've used them to force the creation of pages even when there was no data. It was a bursted report and the user wanted an email so they knew the report ran even if there was no data for a particular set of users.

 

[sapatriot24]

thanks! all done.

 

[rccacn]

Make sure are you using #promptmany(xxxxx)# and not #prompt(xxxxx)#.

 

[raghuveeer]

Hello! I am creating a sectional report in report studio by selecting a column from the list and sectioning it. I am also using the section header and one other column from the list report as prompts. Following ChillAPAC's suggestion I was able to hide the section headers based on the prompt value, but how do I hide the list column titles aslo based on the prompt value.