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.

Configure WCF Service wht HTTPS Binding

One of team mate told me that he was unable to use HTTPS  protocol to access the wcf service that hosts in the DMZ Server. even though he can browse the service with https in the browser.


the issue is caused by the wcf configuration in the web.config file and IIS configuration

the article in the MSDN will provide you the step by step guide to help you walk through the process

How to: Configure an IIS-hosted WCF service with SSL


the only thing i really want to mention is that we do not have to specific the web url in the address attribute when we configure the endpoint in the server web.config.

also we have to set the security mode to be Transport in the Binding configuration.

<services>
      <service name="MySecureWCFService.Service1">
        <endpoint address=""
                  binding="basicHttpBinding"
                  bindingConfiguration="secureHttpBinding"
                  contract="MySecureWCFService.IService1"/>

        <endpoint address="mex"
                  binding="mexHttpsBinding"
                  contract="IMetadataExchange" />
      </service>
    </services>

 <bindings>
      <basicHttpBinding>
        <binding name="secureHttpBinding">
          <security mode="Transport">
            <transport clientCredentialType="None"/>
          </security>
        </binding>
      </basicHttpBinding>
    </bindings>

script to activate the .Net 4.5 WCF in Windows Server 2012 Core

it is quick easy when we need to activate in the .Net WCF with GUI windows Server.

go to Control Panel and click on Programs and Features Icon, then click on Turn Windows Features on or Off on the left side windows.








Unfortunately. the Windows Server 2012 Core does not have the UI, we only can configure it via the CMD Windows. the following script will done the job for you

REM install Windows IIS features for WCF ran under .Net Framework

dism /Online /Enable-Feature /FeatureName:WAS-WindowsActivationService

dism /Online /Enable-Feature /FeatureName:WAS-ProcessModel

dism /Online /Enable-Feature /FeatureName:WAS-NetFxEnvironment

dism /Online /Enable-Feature /FeatureName:WAS-ConfigurationAPI

dism /Online /Enable-Feature /FeatureName:WCF-HTTP-Activation

dism /Online /Enable-Feature /FeatureName:WCF-HTTP-Activation45

REM Feature Install Complete

pause