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)

Sort by

atajjo 509 on at

Like (1)

Report
Copy link

Link copied!

Are your table extension and report in the same model?

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

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

Please restart SSRS services once and check.

thanks

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

Like (0)

Report
Copy link

Link copied!

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