Forum Discussion

MEFOX's avatar
MEFOX
Helper III
3 years ago
Solved

Paginated report - Protect a parameter field from data entry

I have an Account Id field that I would like to only contain values from the drop down. I want to prevent the user from entering anything into this field. Can someone tell me how I can accomplish this. This is a paginated report.

Thanks

 

 

  • Hi, MEFOX 

    Please refer to the following tutorial.

    12 Days of Paginated Reports - Day 4 - Add a Parameter 

    You need design a query to get the distinct values of Account Id field.

    Then edit the Report Parameter Properties and select the value from the specified query for this parameter.

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

1 Reply

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support

    Hi, MEFOX 

    Please refer to the following tutorial.

    12 Days of Paginated Reports - Day 4 - Add a Parameter 

    You need design a query to get the distinct values of Account Id field.

    Then edit the Report Parameter Properties and select the value from the specified query for this parameter.

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.