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!

All responses (5)

Answers (1)

Jay Dev 10 on at

Like (0)

Report

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

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.
MuthukumaranAX 2,901 on at

Like (1)

Report

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

Please restart SSRS services once and check.

thanks
Verified answer

atajjo 509 on at

Like (1)

Report

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

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.
Jay Dev 10 on at

Like (0)

Report

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

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!
atajjo 509 on at

Like (1)

Report

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

Are your table extension and report in the same model?