How to activate a hidden sheet by URL?

[erichuang]

All,

I try to use a url string to open one sheet(ex. sheet id is SH_201) of a document, and the tabrow is set to hidden in document properities. My url string is as..http://khbisqlikview/QvAJAXZfc/opendoc.htm?document=qvw%5Ctestreport.qvw&sheet=SH_201, but it didn't work. Is there any way to resolve this problem?

PS. If tabrow is set to display, the url string is o.k.!

[marcus_sommer]

If you changed the visibility-condition for the sheet to something like:

= match(osuser(), 'YourUser', 'FurtherUser', ...)

it should work.

- Marcus

[erichuang]

Hi Marcus,

Thanks for your reply! Could you give me more examples about your suggestions? Because I don't know where to insert the codes you said.

For avoiding gaps, I post my steps as the followings:

Step1. For my project, I must hide the tabrow.

Step2. I used ASP.net to make a url string(http://......&sheet=SH_201) to open a sheet in a document.As the below picture, the report should be opened in [Analysis] section, but it didn’t work.

Step3. If I uncheck [Hide Tabrow], and reopen the report with the same url string.

The url string worked and the document was opened in sheet 201(SH_201).

[marcus_sommer · Accepted solution]

The visibility conditions for the sheets will be handled within the sheet-properties in tab general:

- Marcus