SSRS Report Error "Parameter is missing a value"

-




I was start getting error "Parameter is missing a value" when i left blank parameter of report. To make report parameter optional you have to follow these steps.

1. Open report in Visual Studio.

2. Go to Parameters and open the properties of your parameter.


 

3. Set Allow Blank to true.

4 Set Nullable to true.

5. Build and deploy the report.

6. In AOT, goto SSRS report and right click on your report and select Deploy Element.

7. Run your report.

Comments

Post a Comment

Popular posts from this blog

Dynamics AX 365 : The name does not denote a class, a table or an extended data type

-
Image
I was getting following error during customization of Dynamics AX. After some debugging i found that it is due to model. Error can be resolved by updating model. In this blog i am working with smmActivities but it can applied for any table. Goto your table in AOT you will see model name in square brackets in light color grey. You have to add this model to resolve issue. In my case model name is "Case Management". In toolbar go to Dynamics 365 →Model Management → Update model parameters. Select your model in which you are doing your customization, in my case it is "testModel" and click on next, scroll down and select "Case Management" and select next and then click on finish. Build your solution error should be gone now.
Read more

Timesheet periods have not been created for Employee

-
Recently i was trying to create timesheet record but was getting error "Timesheet periods have not been created for Employee". I have resolve this by performing following steps. 1. Goto Project Management and Accounting -> Setup -> Timesheets -> Timesheet period types. Select your Period Type and click on Generate Periods. Fill out the form and press OK. 2. Goto Human Resources -> Workers -> select your worker. 3. Goto Project Management tab and select Project Setup. Fill out the form select Period Type for which you just have generated periods. 4. Now you good to create timesheet record.  
Read more

Dynamics 365 Error : Unable to resolve dependency dynamicsax-dimensionsformadaptor

-
We were removing over layering from our code and while creating deployment package we got this error "Unable to resolve dependency dynamicsax-dimensionsformadaptor". This error comes because we were not including some models. So what you have to do is to check model dependency hierarchy and see on which models have dependency. Just include those models in your deployment or remove reference of model from your model. To check model dependency hierarchy in AOT model view right click on model and  View Package Dependencies > View Incoming References. To remove model reference  go to Dynamics 365 > Model Management > Update Model Parameters select your model and uncheck model which you want to exclude.
Read more