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)

Suggested answer

Ajit 8,755 on at

Like (0)

Report

Check if your used EDT has a table relation?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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 (0)

Report

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 (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Ajit 8,755 on at

Like (0)

Report

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 (0)

Report

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 (0)

Report

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 (0)

Report

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 (0)

Report

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 (0)

Report

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