Thursday, February 19, 2015

How to fix "ssrs parameter does not exist in the parameters collection" in SSRS Report

i added a new parameter to my report and use it as the input parameter in dataset loading


but I got an error message "ssrs parameter does not exist in the parameters collection"



the solution is quick and easy use the up down arrows to change the order of the parameters in the report data window. in case. i moved the new parameter up





Wednesday, February 18, 2015

How to solve "fields cannot be used in report parameter expressions" in SSRS Report

when i try to use a field from the DataSet as one of report paramenter.

I got "fields cannot be used in report parameter expressions" error. the issue is caused by the dataset did not loaded when the report is render



we can solve this issue by selecting Get Values from a query stead of choosing Specify values
then we can select dataset contains that field. and specify the field in the value field drop down.



then the report will be render based on the field value of the specific dataset.