How Add Field to AX SSRS Data Set

(0) Share

Report

Posted on by Mark Greg

Hi all,

I am using AX 2012 and am trying to customize an SSRS report. The reports data is coming from an AX temp table that is being populated by and AX Class. I have added a field to the temp table and can see it is storing the data I am passing it by writing it to a txt file. But I don't know how to add a field to the report itself. I am editing the report using visual studio 2010. And the data set is an AutoGen_ReportDataProvider. I have tried refreshing it after adding the field to the temp table, compiling the table and running incremental CIL. But I still don't see the new field on the report. Is there something else I need to do to get a new field on the report? Also if I right click on the dataset and select view properties, the source is just named coa_details, and the Available datasets dropdown is just "Fields", with no actual field names. Any help would be greatly appreciated.

*This post is locked for comments

I have the same question (0)

All responses (20)

Answers (1)

Suggested answer

Chaitanya Golla 17,225 on at

Like (0)

Report

Hi,

After your changes to report, please deploy your report to to the report server and compile report classes, run incremental CIL and try to generate the report again.

Was this reply helpful? Yes No
Mark Greg on at

Like (0)

Report

Hi Chaitanya,

I can make changes to the report, I can also change values in the class and they show up when I deploy the report. The issue I'm having is I want to add a new field to the dataset to display on the report. I thought it would be as simple as adding a field to the tmp table. right click -> add field. But for the life of me I can't figure out how to add a new field to the dataset.

Was this reply helpful? Yes No
Suggested answer

Chaitanya Golla 17,225 on at

Like (0)

Report

Hi,

After adding field You need to refresh fields on your query in the report data pane to get new fields. Refer below link for specific details:

(Add, Edit, Refresh Fields in the Report Data Pane (Report Builder and SSRS))

docs.microsoft.com/.../add-edit-refresh-fields-in-the-report-data-pane-report-builder-and-ssrs

Was this reply helpful? Yes No
Mark Greg on at

Like (0)

Report

Thank you, but I have refreshed it. It doesn't appear to me to be a query field. There is a class in AX that builds a temp table and the report must grab from that temp table. I have added the field to the temp table, and can see it gets populated, but that field doesn't show up in the data set of the report. I have compiled the class and table and ran the incremental cil and then refreshed the data set, but the field does not come in......

Was this reply helpful? Yes No
Suggested answer

Chaitanya Golla 17,225 on at

Like (0)

Report

Hi,

Please restart report server once.Can you provide details like which report are you working is it a custom or standard one?

Was this reply helpful? Yes No
Mark Greg on at

Like (0)

Report

Hi Chaitanya,

I believe it is a custom report. I am new to the company and new to AX. It is a Certificate of Analysis report. I don't understand how the AutoGen_ReportDataProvider works. What kind of confuses me is that the temp table is named different than the DataSet, but I'm sure it's the correct one because I changed the values in the temp table and they are displayed on the report. Right now I recompiled the Class and the temp table and am running a full CIL. When you say restart the report server, do you mean the SSRS Service? and after I restart, then should I refresh the dataset, or should it be there after the restart?

Was this reply helpful? Yes No
Mark Greg on at

Like (0)

Report

Thanks Sakrut, But I don't think this is a query dataset Please see screen grab.

Was this reply helpful? Yes No
Mark Greg on at

Like (0)

Report

Hi Chaitanya, I ran a full CIL, and restarted the report server and still no luck seeing the new field....I attached a screen grab of what I am seeing in reply to Sukrut, if you can take a look at that, maybe it will give you more insight....

Was this reply helpful? Yes No
Mark Greg on at

Like (0)

Report

Also, I just noticed I get this error when I open in VS, not sure if it is related??:

Error 1 An exception occurred in the query metadata execution. The exception is Cannot process COA - no valid parmMiscText specified:

(S)\Classes\xInfo\add

(S)\Classes\Info\add - line 94

(S)\Classes\Global\error - line 3

(S)\Classes\CopyOfGCC_COA2_DP1\processReport - line 138

(S)\Classes\SrsReportProviderQueryBuilder\initialize - line 57

(S)\Jobs\

. CopyOfGCC_COA_universal1.Report [Preview] 0 0

Was this reply helpful? Yes No