Skip to Content
avatar image
Former Member

I want to create a prompt at report level and link it to the variable created .

capture1png.png

I want to create a prompt at report level and link it to the variable created . So that according to the report type selected (yearly , monthly , quarterly) the report opens.

capture1png.png (32.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 23, 2017 at 01:52 PM

    if i understood correctly based on the prompt value selection like Yearly you want o display yearly data table? if yes then follow these steps.

    Capture the prompt text with user response function.

    Show/Hide=useresponse("prompt text")

    Right click on the Table->Format table->tick on "Hide when following formula is true"

    and place the formula. [Show/Hide]<>"Yearly"

    similarly for other tables

    Add comment
    10|10000 characters needed characters exceeded