Вернуться   AXForum > Microsoft Dynamics AX > DAX Blogs
Забыли пароль?
Зарегистрироваться Правила Справка Пользователи Сообщения за день Поиск Все разделы прочитаны

Опции темы Поиск в этой теме Опции просмотра
Старый 21.11.2012, 00:12   #1  
Blog bot is offline
Blog bot
25,510 / 847 (80) +++++++
Регистрация: 28.10.2006
emeadaxsupport: "Parameter is missing a value" error running a customized report in Microsoft Dynamics AX 2012

A Microsoft Dynamics AX 2012 report with a new parameter added to the contract may fail with the following error:

The 'ParameterName' parameter is missing a value

For example:

The 'SalesPackingSlipHeaderDS_FromDate' parameter is missing a value

This error is thrown because no value is provided for the parameter in the contract while it is required. To make the parameter optional the following properties of the parameter need to be set to True:

Allow Blank True

Nullable True

These properties are set to False by default when they are first created in Visual Studio. New parameters may be also created when a dataset of a standard report is refreshed. We have seen this with reports modified in Cumulative Update 3 where new parameters were added to some contracts. Since they are also created with the default settings they need to be modified manually to be treated as optional parameters.

In a few cases, however, we observed that modifications to these properties are not populated to the report server as expected. It may be related to some caching issue. One of the following methods may help to resolve it:

Method I.

Force the update of the properties by renaming the parameter

1. Open the report for editing in Visual Studio.

2. Expand the Parameters node and rename the affected parameter to ParameterName1.

3. Set Allow Blank and Nullable to True if not already set.

4. Deploy the report.

5. Rename the parameter back to ParameterName.

6. Deploy the report.

Method II.

Recreate the parameter in Visual Studio and set the properties as required before deploying the report

1. In AOT, expand the SSRS Reports node, expand the Reports node and locate the report.

2. Right click on the report and select Delete. This will remove all customizations to the report from the current model/layer so make sure you create a backup if you think you might want to return to them.

3. Right click on the report and select Deploy element. You should now be at the point where you did not receive this error.

4. Open the report for editing in Visual Studio and refresh the dataset. The parameter will be created under the Parameters node. Do not deploy the report at this point.

5. Set Allow Blank and Nullable to True.

6. Deploy the report.

Method III.

Modify the properties of the parameter editing the report in the Reporting Services Report Manager

1. Open the report for editing in Visual Studio.

2. Expand the Parameters node and locate the affected parameter.

3. Set Allow Blank and Nullable to True if not already set.

4. Deploy the report.

5. Open Reporting Services Report Manager, in the Parameters properties page of the report, verify that Has default and Null check boxes are selected for the affected parameter.

6. Press Apply to save any changes.

author: Jolanta Malkowska

editor: Jolanta Malkowska, Czesława Langowska Vliegen

Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.

Похожие темы
Тема Автор Раздел Ответов Посл. сообщение
crminthefield: Podcast and Overview: Microsoft Dynamics CRM 2011 Update Rollup 11 Blog bot Dynamics CRM: Blogs 0 06.10.2012 05:27
ax-erp: Creating SSRS-Reports in Dynamics AX 2012 – What’s no longer possible in AX-reports Blog bot DAX Blogs 0 18.07.2012 12:11
mfp: Microsoft Dynamics AX 2012 is here! Blog bot DAX Blogs 10 04.08.2011 17:11
dynamics-ax: Microsoft Dynamics AX 2012 Excel Add-in Blog bot DAX Blogs 0 08.06.2011 08:12
emeadaxsupport: Resolving some issues you may experience when creating an AX 2009 Role Center and Enterprise Portal Site using SharePoint Server/Foundation 2010 after installing Microsoft Dynamics AX 2009 SP1 hotfix 2278963 Blog bot DAX Blogs 1 24.09.2010 11:34
Опции темы Поиск в этой теме
Поиск в этой теме:

Расширенный поиск
Опции просмотра

Ваши права в разделе
Вы не можете создавать новые темы
Вы не можете отвечать в темах
Вы не можете прикреплять вложения
Вы не можете редактировать свои сообщения

BB коды Вкл.
Смайлы Вкл.
[IMG] код Вкл.
HTML код Выкл.
Быстрый переход

Часовой пояс GMT +3, время: 01:38.
Powered by vBulletin® v3.8.5. Перевод: zCarot
Контактная информация, Реклама.