Hiding A Row In List

[pucovsky]

Hi

I have a list container and I want to create a button on report page that will show/hide some rows from list.
As I understand, using HTML item and JavaScript is necessary.
Can somebody advise me how to do this?

Thx.

[Lynn]

or you could try a conditional style and have the report drill through to itself using a parameter for the show/hide.

[barrysaab]

Lynn,Could you please elaborate and give non java script solution.Thanks

[Lynn]

I belatedly realized the question was to hide a row (not a column)... Here is a similar concept but using a filter rather than conditional style.

Here is what I did:

• Drag a text box prompt on the page for a parameter (e.g., HideShow), pick a default value (e.g., Show) and set the prompt control to not visible. This allows the report to open initially without prompting.
• Set the query filter to exclude whatever rows should be hidden when value is 'Hide'.
• Create a query item called Toggle. The expression will set the value to the opposite of whatever the parameter value is: 
  if ( ?HideShow? = 'Show' )
  then ( 'Hide' )
  else ( 'Show' )
• Create a text item (or use an image) for the drill through
• Save the report first...then set drill through target as the same report
• Pass the Toggle data item to satisfy the parameter