Thanks @Stu_SAS . I'll try this code and let you wat happens
Also,my another concern is it's not showing me the html format too because of that user can't see what are they getting in their excel file.
If you'd like to still show HTML, remove the "ods html close" line.
Hello, @Stu_SAS I sincerely appreciate your guidance and support, which have enabled me to complete this report.
I had a few inquiries about my work. I have to right-click the _webout.xlsx file in order to get the spreadsheet file. Why isn't it downloading instantly when I click on it?
Furthermore, I have another worry with the report title on my page, which displays the path of the stored process. Can I change it so the user understands it better? Als, by default (maybe), Viya opens the report in a separate tab. Can we do something to open in the report.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.