I have a solution for you.  In my example, I'm using the sashelp.cars table.  The data item used is MAKE.   1. Create a calculated data item to represent your default value.  In my example, the default value is "Honda Motor Sports".   The Make Parameter would be the drop down list that you would clear.   2. Create a hidden page.  On the hidden page, add another drop down list and assign the role to be the calculated item in #1.   Create a parameter for that drop down.  In my case, I called it Hidden Parameter.     3.   Back on Page 1, I have some descriptive text that only references the parameter from page 2.   4.  Results.   a.  You select a car make on page 1. b. You clear the filter.     ... View more

1. from the code, it is unknow where your Excel file is located so in order for me to get it to work, I needed to point to an Excel file in metadata.  I went to SAS Drive and looked for an existing spreadsheet.  Then looked at the properties to get the uri.   filename excelout filesrvc '/files/files/5bb9d9bd-1b4f-4d04-8fb2-4e0992d1aaf7' parenturi="&SYS_JES_JOB_URI" name='_webout.xlsx' contenttype='application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' contentdisp='attachment; filename="my_excel_file.xlsx"'; ; ods excel file=excelout style=htmlblue options(sheet_name="Receipt Data" embedded_titles='yes');   2. I created a Job in ..../SASJobExecution app.  When I run the job, I get: 3. When you click on _webout.xlsx, you are prompted to download the file  I suspect the _webout.html is in reference to the parenturi option specified.  I suspect if you were linking to this code from another web page then that would be similar to a back button.   In regards to a definition of everything in the code, I reached out to ChatGPT for a decent definition: FROM CHATGPT:     The provided SAS ODS (Output Delivery System) code is used to generate an Excel file with the name "my_excel_file.xlsx" and a sheet named "Receipt Data." Let's break down the code: filename excelout : Specifies the filename and file location for the Excel output. filesrvc : Specifies that the file is to be stored on the server. parenturi="&SYS_JES_JOB_URI" : Specifies the parent URI for the file. &SYS_JES_JOB_URI is a system macro variable that provides the URI of the job. name='_webout.xlsx' : Specifies the name of the Excel file to be created, which is '_webout.xlsx'. contenttype='application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' : Specifies the content type for the HTTP response header. In this case, it indicates that the content is an Excel file in the Office Open XML format. contentdisp='attachment; filename="my_excel_file.xlsx"'; : Specifies the content disposition for the HTTP response header. It sets the disposition type to 'attachment', indicating that the content should be treated as an attachment. The filename parameter is set to "my_excel_file.xlsx." ods excel file=excelout : Opens the ODS Excel destination and directs the output to the file defined by the excelout filename statement. style=htmlblue : Specifies the style for the Excel output. In this case, it uses the 'htmlblue' style. options(sheet_name="Receipt Data" embedded_titles='yes'); : Specifies additional options for the Excel output. It sets the sheet name to "Receipt Data" and enables embedded titles in the Excel sheet. In summary, this SAS code generates an Excel file named "my_excel_file.xlsx" with a sheet named "Receipt Data." The Excel file is stored on the server, and the HTTP response header indicates that it should be treated as an attachment with the specified filename. The style 'htmlblue' is applied to the Excel output, and embedded titles are enabled in the sheet.       ... View more

Below is an example where I used 3 object:  Precision Container, Key Value, Image.  It takes some trial and error.  You basically add the image and the key value to the precision container.  Set the height and width on key value and image to be 100%.   Adjust the size of the precision containte to your desired size.   Lighten the background image by changing the background percent on the Key Value. Original Image Color:   In regards to finding images, if you search the web you will find some that are free and some with a fee.         ... View more

Typically with a dashboard, you want to convey at least one metric that is important to the domain.  Thus, the end user gets a quick overview.  If you don't have a metric, then a background image that links to another report looks flashy.  Below is just a quick example of delivering a metric on each domain that can be clicked on to see more in depth reporting.  You want to incorporate colors that are the theme of the customer.     ... View more

You only need a Text Entry for parameters that would have multiple selection.  If most of your other parameters are single selection then you can add them as parameters to the external url assigned to the list table. Example: We have a cars report with text entry and 3 single selection list boxes.  The List table is filtered.  The stored process is triggered by clicking on the row in the list table.     1.  The External URL for the list table would look like the following: 2. When a user clicks on a row of the list table, the following URL is generated. https://www.google.com/?Color=Green+Blue+Red&Make=Acura&Model=+3.5+RL+4dr&Origin=Asia   Note:  Within your stored process, you can reference Make, Model, and Origin directly.  For Color, you would need to parse that out and separate in your SAS code.     ... View more

There is not a way to parse the contents of a multi select parameter.  Your idea of a text entry is definitely feasible.  Here is an example below: 1. Create a new report.  Add a Text Entry object.  Add a parameter to that.  (This will represent what you are adding to the URL) 2. Add a list table to the report. 3. Create a calculated item to represent the URL that you want to call.    concatenate the url with the parameter values. 4. Add that data item to your list table. 5. Set an action on the list table for external URL.   Here is the trick, do not enter a URL.  ONLY add the new item you created in step #3.   Test Report: A. In my example, I type in "superbowl hotels" in the text box and select enter. B. I then see that the MyString data item on the list table updates. C.  Double click on the MyString value and the link will open.  (Note, the syntax for google is incorrect, but you could easily modify that)   ... View more

If deleting and re-adding the pie chart fixes the issue then I suspect something with the report XML got messed up.  If you would like for Tech Support to analyze your report XML, please open a Case with SAS Technical Support. ... View more

I suspect there is something else going on with the report. 1. Is the pie within a container? 2. Have you tried changing the location of the legend to see if that makes a difference. 3. Does the issue happen in both view mode and edit mode? 4. Can you replicate this on a new report with just the pie chart.   If none of that helps, make a copy of the report and start removing things in the report until you notice a change in the pie legend.  Then you will know what is causing it. ... View more

Can you provide a screen capture of this issue? ... View more

I think Hunter mentioned this.  You need to add another data source to your report. 1. open Excel. Type ------ Year Quarter Month 2. Import in that small table and use it as the source for your prompt (which as parameter). 3. In the measure, you would use: If MyParameter = "Year"   return (FiscalCalculationData Item) Else if MyParameter = "Quarter"    return (FiscalQuarterData Item) Else return (MonthlyData Item)   Note:  I'm assuming you already have the calculations representing the different Fiscal year, qtr, month. ... View more

What do your calculations currently look like for Fiscal Year, Fiscal Qtr, and Fiscal Month? ... View more

Below is a very simple job. From the previous example, I'm passing in make. You reference make using &make in your SAS code. Put it in double quotes to evaluate. * Write the custom HTML to _webout; %global make; data _null_; file _webout; put '<html>'; put '<head><title>Hello World!</title></head>'; put '<body>'; put "<h1>The selected car is: &make</h1>"; put '</body>'; put '</html>'; run; ... View more