Editable text in paginated report for users in dashboard/reader view

discussed in call. Can you have esssentially blank text box that people can edit or add their own text on paginated report before exporting?

Hi @madnucks, here is my suggestion.
QuickSight released prompted report feature recently, in which you can add controls at the top of paginated report sheet so you can use that to filter the underlying data at hoc. We can use this feature to pass the user inputs from the control to a parameter, and the parameter inside a text box can be rendered when the report is exported. Below are the steps.

  1. Create parameter “userText”

  2. Create a control associated with the parameter


  3. Place a text box anywhere you want the user text to be displayed

  4. After publishing the dashboard, input some text to the control and try exporting it by hitting Run Now.

And, this is the exported PDF.

Although it’s a simple example, I hope it conveys the idea.

1 Like

Thank you!! This is helpful!! Is there any advice on utilizing this combo’ed with repeating sections? For example, I might want to cycle through multiple cases of same visuals, and have different text on each of the repeating. Is there a way for this?

@madnucks Glad to know it’s helpful :slight_smile:
In case your goal is to display the information about each of the repeating section instance, you can use the repeating dimension parameter in the text box, like the following example. (You might know this already)

But if you need to allow dashboard viewers to input different text for different instances of repeating sections, I don’t think this is possible today as the repeating sections are generated dynamically at the backend.

1 Like

Hi @madnucks, it’s been a while since I last heard from you. Let me know if you have any other questions related to the topic. Otherwise, please kindly mark my reply as solution✅. Thank you.

1 Like

Hi! Hope all is well. Started testing out adding repeating sections to some of my paginated reports. Question, I have a table that has filters on it that i am trying to have in the repeating section. The field im using for the repeated section has some selections that show “no data” on the table, which is correct, but it still prints those pages. Is there away to make it not print or “skip” over one of the sections if no data populates for the table based on the selection?

Hi @madnucks, apologies for the delay in response as I was away for a while.

If you change the scope of your filter from single visual to either single sheet or cross-sheet, repeating section will honor the filter setting and automatically skips the excluded instances.

2 Likes