Pages

October 03, 2023

[Solved] Parameter issue with SSRS report

If you are reading this post, my humbly empathy with you, you are one of the victims of the SSRS report. :)

I am not diving on exact error messgae you may getting while build/deploying report. 

Lets understand the root casue of this first, 
..
.
.
.
.
.
.
.
.
.
.
.
.
.

There is no root cause. Its just SSRS, 


Well, if you open SSRS report in XML editor (by right click on report and Open with), you will total two place where parameters are defined. (In case there is one datasource in report, there be more place if there are more than one datasource)
Take a close look on all three and makre sure all of them having same number of paramters , plus same name of each paramater.

1. Under node: Report dataset parameter









2.  Under node : ReportParametersLayout, 




well, this one is reall yintesting as you also needs to make sure of changing the ColumnIndex or RowIndex.

-Harry Follow us on Facebook to keep in rhythm with us. https:fb.com/theaxapta

No comments:

Post a Comment

Thanks