Finance | Project Operations, Human Resources, ...

Multi select lookup on SSRS report issue

(0) Share

Report

Posted on by Awaxx

229

Hi guys,

I'm trying to create multi select lookup for my ssrs report but values are not given as i expected and dont figure why ?

i used this query

        Query query = new query();

        qbds = query.addDatasource(tablenum(OmOperatingUnit));
        qbds1 = qbds.addDatasource(tablenum(OmHierarchyRelationship));
        qbds1.addLink(fieldnum(OmOperatingUnit,RecId),fieldnum(OmHierarchyRelationship, ChildOrganization));
        qbds1.relations(false);
        qbds1.addRange(fieldnum(OmHierarchyRelationship, ParentOrganization)).value(queryvalue(omIo.RecId));

        TableId multiSelectTableNum = tableNum(OMOperatingUnit);
        container selectedFields = [multiSelectTableNum, fieldName2id(multiSelectTableNum, fieldStr(OMOperatingUnit, OMOperatingUnitNumber))];

        SysLookupMultiSelectGrid::lookup(query,_control,_control,_control,selectedFields);

Here is the result of my query

And what i want to reach is to have only OMOperatingUnitNumber

Could someone help please ?

Regards

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Awaxx 229 on at

Like
a
(0)

Report
Copy link

Link copied!

I have to add that when i tried my query in a job i got the good result but i dont know why its not working on my lookup.

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,573 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, Can you try adding qbds.addLookupField and remove EDT on Campus field or set EdTRelation table field property to No.

Was this reply helpful? Yes No
Suggested answer

GirishS 27,843 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi awaxx,

I think you are asking how to show lookup with only operating unit number. Is that correct?

If yes you can create an query and use it in code. In that query you can set dynamic property of the datasource and add only your required fields.
Refer to the below thread.

Thanks,

Girish S.

Was this reply helpful? Yes No
Awaxx 229 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi GirishS Mohit Rampal

I m close to reach my goal

I added those 3 lines on my query

qbds.fields().dynamic(true);
qbds.fields().addField(fieldNum(OmOperatingUnit, OMOperatingUnitNumber));
qbds.fields().addField(fieldNum(OmOperatingUnit,Name ));

Now i ve got this lookup

How could i delete the next columns after name ?

Regards

Was this reply helpful? Yes No
GirishS 27,843 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

As I said earlier, I think it won't hide unnecessary columns until you create a query with Dynamic fields property set to No and add only required fields. Use that query in the lookup code. Please see the thread which I have posted.

Thanks,

Girish S.

Was this reply helpful? Yes No