Single Select to Multiple Select in Parameter window

(0) Share

Report

Posted on by Community Member

Hi,

In a report , i am having a field named order status which is a single select.Now i have to do multi select for all the status.Please refer the image below

the value comes from prodstatus of prodtable.Should i create a new form to achieve the requirement

Waiting for someone to guide me!

Thanks

Anna

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

André Arnaud de Cal... 301,210 Super User 2025 Season 2 on at

Like (1)

Report

Hi Anna,

You can read the next blog to know how to include a multi select on a dialog: daxtechies.blogspot.nl/.../dialog-in-ax-2012-multiselect-control.html

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for the Response Andre,

In my scenario i have to show all the 7 fields in the multi select,and then i have to filter based on those selected fields.So all the 7 fields must be displayed for select.

Is it possible to achieve with the above scenario?

Regards,

Anna

Was this reply helpful? Yes No
Basheer17 2,720 on at

Like (0)

Report

Hi Anna,

Yes It is possible. Using a query object and SysLookupMultiSelectCtrl::constructWithQuery method. By looking at the screenshot i'm not sure but i can tell order status is coming from Enum. So you have to write some code to get multi select lookup work.

Was this reply helpful? Yes No
Martin Dráb 237,990 Most Valuable Professional on at

Like (0)

Report

Have you considered using a query instead of simulating the same capabilities with a plenty of custom code?

Users would be able to add ranges for any field, with multiple values, exclusions etc. and you would simply take the query and execute it.

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (1)

Report

It is possible to do a multi-select in the dropdown. See also the comments section in the linked article, with the Custom UI Builder class for your SSRS report dialog.

Alternatively you could add all enum values as separate checkbox field controls, and filter your records based on those dialog return values.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report

Hi All,

I achieved a solution for above issue through the following code in contract class

    DataMemberAttribute('prodstatus'),

    AifCollectionTypeAttribute('prodstatus',Types::Enum , enumStr(ProdStatus)),

    AifCollectionTypeAttribute('return',Types::Enum , enumStr(ProdStatus)),

    SysOperationGroupMemberAttribute('Order'),

    SysOperationDisplayOrderAttribute('12')

]

public List parmprodstatuslist(List _prodstatuslist = prodstatuslist)

{

    prodstatuslist = _prodstatuslist;

    return prodstatuslist;

}

List enables me to do multi select!

Thanks

Anna

Was this reply helpful? Yes No