AX for finance and operations -> SSRS report data provider new fields

(0) Share

Report

Posted on by Jay Dev

Hi Guys,

recently experienced weird behavior in visual Studio on adding new fields into ssrs report data provider temp table.

    [SRSReportDataSetAttribute(tableStr(RetailLabelTmp))]
    public RetailLabelTmp getRetailLabelTmp()
    {
        select * from tmpTable;
        return tmpTable;
    }

I have added new fields in RetailLabelTmp table extension but can't manage to see them in SSRS report

It is existing report. Compilation, DB sync completed. DataSet in a report has been Restored. But no luck.

Any ideas would be much appreciated.

Thanks!

I have the same question (0)

All responses (5)

Answers (1)

atajjo 509 on at

Like (1)

Report

Are your table extension and report in the same model?

Was this reply helpful? Yes No
Jay Dev 10 on at

Like (0)

Report

Hi,

no, in different models.

Is it the possible reason?

I will try to move fields into the same model.

Many thanks for the hint!

Was this reply helpful? Yes No
Verified answer

atajjo 509 on at

Like (1)

Report

They can be different models, but if you want your report to see a table extension in another model, you need to add a reference to that model so the report could see it.

Was this reply helpful? Yes No
MuthukumaranAX 2,903 on at

Like (1)

Report

Please restart SSRS services once and check.

thanks

Was this reply helpful? Yes No
Jay Dev 10 on at

Like (0)

Report

Thank you very much!

yes, the reason is exactly as you wrote.

Report design is in a legacy model with no reference to a new one.

I have moved design to a new model and all new fields are visible now.

Was this reply helpful? Yes No

Join the conversation

Community site session details

AX for finance and operations -> SSRS report data provider new fields

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

AX for finance and operations -> SSRS report data provider new fields

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates