Home › Discussions › Questions & Answers › Using Hidden Parameters for Sheet Name Customization
Customer · · Questions & Answers · 5 replies
By default, the Excel sheet name is the report name. I need to dynamically change this based on a parameter, like the Operating Unit. Can I do this without showing the sheet name parameter to the user?
Yes, you can use the special anchor :sheet_name. You should set up a parameter that references this anchor, and hide it by assigning a negative display sequence number.
How would the default value for this hidden parameter be configured to rely on the Operating Unit?
You would use a default value SQL that references the Operating Unit parameter, for instance: : $flex$.operating_unit||’ suppliers’. This allows the sheet name to be dynamically set based on the run-time value of the dependency parameter.
So the :$flex$ syntax works in the default value field of a :sheet_name parameter?
It does. The :$flex$ syntax is used to define parameter dependencies in both LOV queries and default values.
Sign in with LinkedIn or Google to take part.
