Microsoft Dynamics AX (Archived)

Lookup field in SSRS Parameter using x++

(0) Share

Report

Posted on by Community Member

Hi Everyone,

I have recently started SSRS report development using x++ after suggestion from some senior AX community members.

I need a lookup parameter which shows the list of Assetid from Assettable so that the report can be filtered.

Below is my contract class code :

1. [DataContractAttribute]
class EA_AssestableContract_UI

{
AssetId assetId;
}

2. [DataMemberAttribute("AssetId")]
public AssetId parmAssetId(AssetId _assetId=assetId)
{
assetid=_assetid;
return assetid ;
}

currently it is showing input assetid number to filter the report :

thank you.

*This post is locked for comments

I have the same question (0)

All responses (19)

Answers (1)

Sort by

Suggested answer

Ajit 8,788 on at

Like
a
(0)

Report
Copy link

Link copied!

Check if your used EDT has a table relation?

Was this reply helpful? Yes No
Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

Yes it is related to other tables to bring worker department

Was this reply helpful? Yes No
Suggested answer

Rohin 4,624 on at

Like
a
(0)

Report
Copy link

Link copied!

I believe "AssetId" uses the relation with Asset table. Might be problem with cache?

have you clear the Report Caches(AOT Development : Tools > Caches) ?

have you run CIL ?

Was this reply helpful? Yes No
Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

I havnt run CIL but does it relates to ssrs parameter lookup ?

Was this reply helpful? Yes No
Suggested answer

Ajit 8,788 on at

Like
a
(0)

Report
Copy link

Link copied!

It should have relation with Asset table. Try to redploy your report and also restart SSRS service once.

Was this reply helpful? Yes No
Verified answer

Rohin 4,624 on at

Like
a
(0)

Report
Copy link

Link copied!

Please try what Ajit suggested to you once , if it works then well and good otherwise try what i told to you( clear Report Caches and run Compile +CIL).

Was this reply helpful? Yes No
Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

You haven't understand my query well sorry for that.

Actually i need a class query which should show the drop down menu of assetid as a parameter in the SSRS user interface.

thank you

Was this reply helpful? Yes No
Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

Instead of above Fixed Asset Number parameter i need a drop drop list of Fixed Asset Number.

How to get it : D.

Was this reply helpful? Yes No
Rohin 4,624 on at

Like
a
(0)

Report
Copy link

Link copied!

We are suggesting you the solutions for same Maqbool. You want Lookup for Fixed Asset Number (which is AssetId EDT). right??

Was this reply helpful? Yes No
Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

Yes i want lookup in the report i have not written any query for that in the contract class how it will display ? should i share the enter class codes ?

Was this reply helpful? Yes No