This is a migrated thread and some comments may be shown as answers.

Empty value in multi-valued parameter

1 Answer 597 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
khandokar
Top achievements
Rank 1
khandokar asked on 29 Sep 2017, 08:55 AM

Hi,

One of my report parameter has a single column data source and empty value in the first row. Both AllowBlank and AllowNull are true on this parameter. But the empty value is not showing after run. Using firebug, i found that empty listviewitem exists there but not showing(Report1.png). When i wrote something in listviewitem by editing html element in firebug, it appears(Reprt2.png). I need to filter using empty value because the report data source contain empty values in some rows. Now only way i have to filter using empty value is, first, click the 'Select all' on the parameter and then deselect other values one by one so that empty value keep selected and Click 'Run Report'. But it is not the right approach to do. As AllowBlank is true, empty/blank should visible & should be selectable/deselectable? 

Please give a solution on this.

sabbir

1 Answer, 1 is accepted

Sort by
0
Katia
Telerik team
answered on 02 Oct 2017, 02:54 PM
Hi Sabbir,

Report parameter that has available values will be displayed in HTML5 Report Viewer by Kendo UI listview widget and null values retrieved from parameter's AvailableValues.DataSource will be ignored.

If you need to filter the report's data using an empty value you can specify it in the filter expression, for example:
= Fields.MyField Is Null Or Fields.MyField = ""

Hope this information will help.


Regards,
Katia
Progress Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
General Discussions
Asked by
khandokar
Top achievements
Rank 1
Answers by
Katia
Telerik team
Share this question
or