Forum Discussion

DataVitalizer's avatar
DataVitalizer
Icon for Super User rankSuper User
4 years ago
Solved

Error message with paramaters Report Builder

Hi Community, I created a report using Report Builder, wthout using a parameter I can view the content of my report. The issue started when I added a parameter, after I select a value ffrom the dro...
Need Help
  • DataVitalizer's avatar
    DataVitalizer
    4 years ago

    Hi Community,

    In case you had the same error message as mine, make sure that the paramater and the fields you are visualizing in your report are not coming from the same dataset.

    Create another dataset (dsParameter) which will be used just in the @Parameter

    Edit the first dataset which you want to visualize, and filter your query by adding a condition where dsVisualize.Column = @Parameter


    Did it work ? 👌Mark it as a solution to help spreading knowledge 👉A kudos would be appreciated

DataVitalizer's avatar
DataVitalizer
Icon for Super User rankSuper User
4 years ago

Hi v-yalanwu-msft 

I created the parameter using the query designer by dragging a field from the same dataset into the paramatrer zone then I displayed it by ticking the checkbox.

Have I missed any step?

 

Thank you in advance

DataVitalizer's avatar
DataVitalizer
Icon for Super User rankSuper User
4 years ago

Hi Community,

In case you had the same error message as mine, make sure that the paramater and the fields you are visualizing in your report are not coming from the same dataset.

Create another dataset (dsParameter) which will be used just in the @Parameter

Edit the first dataset which you want to visualize, and filter your query by adding a condition where dsVisualize.Column = @Parameter


Did it work ? 👌Mark it as a solution to help spreading knowledge 👉A kudos would be appreciated