Parameter for dynamic report

Question

Parameter for dynamic report

Santhoshini Indukuri 20

after setting the parameter, got a warning sign beside query when i did edit permission and run the native query its showing the below error Screenshot 2024-09-11 150510.png

This question is related to the following Learning Module

Answer accepted by question author

0 additional answers

Your answer

Answer 1

Syed Saleem Peera 13,100 Microsoft External Staff Volunteer Moderator

Hi Santhoshini Indukuri,

Thank you for reaching out to Microsoft Q&A forum.

The issue might be due to the incorrect use of &PID;, so please verify the exact ProductID being passed. Kindly refer to the highlighted screenshot below. User's image

If you are still facing any issue, please let us know in the comments and where you are encountering this error along with the screenshot for reference. We are glad to help you.

If the information is helpful, please Accept Answer so that it would be helpful to community members.

Thank you.

Santhoshini Indukuri 20 Reputation points

2024-09-12T19:51:27.8333333+00:00

I have followed the below steps from module, tried to apply the same by creating new parameter.
Syed Saleem Peera 13,100 Reputation points Microsoft External Staff Volunteer Moderator

2024-09-13T09:53:31.67+00:00

Hi Santhoshini Indukuri,

Could you please extract the distinct ProductID values and verify whether they are in the format PID, &PID, or another variation? Based on your findings, you can modify the query accordingly, as shown in the highlighted screenshot below.

If you are still facing any issue, please let us know in the comments and where you are encountering this error along with the screenshot for reference. We are glad to help you.

If the information is helpful, please Accept Answer so that it would be helpful to community members.

Thank you.
Syed Saleem Peera 13,100 Reputation points Microsoft External Staff Volunteer Moderator

2024-09-14T02:12:40.25+00:00

Hi Santhoshini Indukuri,

Just checking in to see if you had a chance to see the previous answer. Please let me know if it was helpful and don't hesitate to reach out to us if you face any issue.

If the information is helpful, please Accept Answer so that it would be helpful to community members.

Thank you
Syed Saleem Peera 13,100 Reputation points Microsoft External Staff Volunteer Moderator

2024-09-16T04:40:32.8933333+00:00

Hi Santhoshini Indukuri,

I wanted to check if you had the opportunity to review the information which was provided in our previous answer. Please feel free to contact us if you have any more quires. If you feel that your quires have been resolved, please accept the answer by clicking the "Upvote" and "Accept Answer" on the post.

Thank you.
Syed Saleem Peera 13,100 Reputation points Microsoft External Staff Volunteer Moderator

2024-09-19T04:28:45.9666667+00:00

Hi Santhoshini Indukuri,

Glad to hear that your issue got resolved. Please don't hesitate to reach out to us if you have any further queries.

Thank you.

Share via

Parameter for dynamic report

0 additional answers

Your answer