Hi I tried 1352000.1 but I have 3 sheets in my template and this is overwriting the other sheets. I want to count rows from each sheet and split each that way if over 65k rows

Sorry didnt realize they were on same platform

Thanks, thats the document I followed, Its confusing, it splits by department , I want to spilt by row count.

The users use the Export to Excel option (current page or entire dashboard) how to disable or add CSV option?

Thanks for the clarification, When the user exports the analysis, they may make changes, they may add a date or value in the blank columns, etc so would like to have consistent font style on entire document. I did go to Excel Options, General tab and change create new workbook to Arial but did not fix my issue, empty…

Thanks all, I used the front end, under advance tab, place sorting under Postfix Thanks!

Decided to change to a text box and allow user to paste comma separated values into it, works in 12c

Sorry thanks, will move to BI Publisher

It was helpful. I had already figured out a way to display link. I found the xdo file and created an action link image to show report as a hyperlink. Thanks, your way is another option I can use.

Hmmm, I think were using two different versions. (Oracle BI Publisher 12.2.1.0.0 ) I am not seeing those options under parameters or list of values Parameters: parameter type has 3 options (text, date, menu)

thanks choracy69, where can I find Enable user to Type Values?

thanks, this is what Im looking for but I don't have a pencil in the right hand corner. How do I enable it?

For example if a prompt has a list of over 100 values and user wants to select 50, instead of scrolling and selecting the ones they want, can they copy and paste from a text file?

yes, dashboard prompt for BI Publisher Enterprise

No, I don't believe in unicorns. After reading further I now know more about the function. I am looking for a simple sql statement that can pull server name into a variable at the report level. Thanks.

Thanks for the links, I don't want to go the way of changing the repository but looks like the function "valueof "maybe useful, just need to figure out how to use it.

Thanks I removed the NVL, it works now. org_id IN (:p_org_id)

Srini, Wondering if you can help me. I have the session variable. Im getting real close to my desired output. I could use some help modifying my data model and bursting query. I can get data to display if hardcode the KEY but only with a PDF output, CSV is invalid format but why? Anyway here is a snippet of my data model…

I used select :xdo_user_name from dual to retrieve username, how can I use this to send report via email to xdo_user_name? Bursting?

How and where should I write it in BIP report?