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.
or you could try a conditional style and have the report drill through to itself using a parameter for the show/hide.
Lynn,Could you please elaborate and give non java script solution.Thanks
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