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

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.

How to format the SSRS with Visual Studio 2013

there are two approach to format the layout of SSRS report, after we complete the design the report to make it look nicer

First Approach is to use the Placeholder Properties Windows

1. highlight the field that you want to format, then right click to select the Placeholder Properties option from the Popup Menu.


2. click on the Number tab to format the text field


3. click on the alignment tab to format the text alignment.


4. click on the font tab to change the text font properties.



Second approach is to use the TextBox Properties Windows to change the font and alignment properties.