Skip to Content
avatar image
Former Member

Dynamic prompt

Hello All,

I working on Red Amber Green report based on the number in two different phase i.e., Conduct and closeout. So for these 2 phases different object variables are used. Is that anway to execute the report based on the prompt value. For example if the user responded as "Conduct" then the Conduct report should run it in WEBI if Closeout then the closeout report should run. Kindly let me know anyway to do this.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jun 26, 2017 at 07:40 PM

    Hi Arunraj,

    How complex are those Conduct/Close Out reports? Can you create just one report for both of them (with multiple queries, bringing all the required data? You can hide the blocks for Close Out when Close Out is selected in Prompt, and vice-versa, using the "Hide when the following condition is true feature" in the Format Table/Chart/(block) options.

    Example: In the table for Conduct data, the formula in Format Table -> Hide when... the formula would be =Userresponse () = "Close Out". And for Close Out, the formula would be =Userresponse () = "Conduct".

    Thanks,
    Mahboob Mohammed

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 11, 2017 at 08:57 AM

    Thank you Mahboob Mohammed for your suggestion I will implement and let you know any further suggestion requires.

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 05 at 05:52 AM

    Yes,

    If i am not wrong, then you can go with the optional prompts at report level rather then using the prompts universe level as per the scenario you have mentioned.

    As per performance based, optional prompt is not good as compared to Universe level prompt.

    Regards...

    Add comment
    10|10000 characters needed characters exceeded