Open Forum

We created a custom SSRS report in AX 2012 some time ago.  I am looking to add a couple of new fields to the report.  No big deal, right?  I've done it 100 times on other reports.  :-)

I added the 3 new fields to the Tmp table in the AOT that the report uses.  Next I went in to the DataProvider class and set the logic to populate those fields with the correct values.

My next step would usually be to open the Visual Studio Project for the report, refresh the data set, and then drop the fields on the report where I want them.

Here is my problem.  This report is missing the Visual Studio project and I can't seem to locate it anywhere.  I decided I might be able to do what I needed anyway by navigating to the report through the SSRS Report Manager URL and opening the report up in Microsoft SQL Server Report Builder.

It looks promising but I cannot seem to figure out how to refresh the data set to pull in the new fields that I added.  The data source is AutoGen_ReportDataProvider and when I click refresh I just get an error with the following details.

"The selected data extension AXREPORTDATAPROVIDER is not installed or cannot be loaded. Verify that the selected data extension is installed on the client for local reports and on the report server for published reports."



------------------------------
Jim Czerniak
IT Manager - Applications
CMC Group
Bowling Green OH
------------------------------

------------------------------
Eduardo Sicouret
Ballast Point Brewing
San Diego CA
------------------------------

Original Message:
Sent: 10-18-2017 16:54
From: Jim Czerniak
Subject: AX 2012 SSRS Report - Missing Visual Studio Project

We created a custom SSRS report in AX 2012 some time ago.  I am looking to add a couple of new fields to the report.  No big deal, right?  I've done it 100 times on other reports.  :-)

I added the 3 new fields to the Tmp table in the AOT that the report uses.  Next I went in to the DataProvider class and set the logic to populate those fields with the correct values.

My next step would usually be to open the Visual Studio Project for the report, refresh the data set, and then drop the fields on the report where I want them.

Here is my problem.  This report is missing the Visual Studio project and I can't seem to locate it anywhere.  I decided I might be able to do what I needed anyway by navigating to the report through the SSRS Report Manager URL and opening the report up in Microsoft SQL Server Report Builder.

It looks promising but I cannot seem to figure out how to refresh the data set to pull in the new fields that I added.  The data source is AutoGen_ReportDataProvider and when I click refresh I just get an error with the following details.

"The selected data extension AXREPORTDATAPROVIDER is not installed or cannot be loaded. Verify that the selected data extension is installed on the client for local reports and on the report server for published reports."



------------------------------
Jim Czerniak
IT Manager - Applications
CMC Group
Bowling Green OH
------------------------------

Thanks!  Since i had the RDL file, I ended up just making a new Visual Studio project and adding it back to the AOT.  All is good.


------------------------------
Jim Czerniak
IT Manager - Applications
CMC Group
Bowling Green OH
------------------------------

Original Message:
Sent: 10-19-2017 11:33
From: Eduardo Sicouret
Subject: AX 2012 SSRS Report - Missing Visual Studio Project

If you have a database backup you can restore and a TEST company where to restore it to, then I would restore it and try to find the Visual Studio project in the AOT.

If that is not an option, I would download the RDL from SSRS and safe the file somewhere safe.  Then delete the SSRS report in the AOT.

Then I would create a new report model project and select the same data source, as you normally do with new reports.

Then I would open the RDL file you saved previously and have both projects side by side.  Then just set the report page size the same as the RDL file design and then select all the objects from the RDL report design and paste them in your new report.

Then publish the report as usual.

Hope this helps.
Cheers,
Eduardo Sicouret

------------------------------
Eduardo Sicouret
Ballast Point Brewing
San Diego CA

Original Message:
Sent: 10-18-2017 16:54
From: Jim Czerniak
Subject: AX 2012 SSRS Report - Missing Visual Studio Project

We created a custom SSRS report in AX 2012 some time ago.  I am looking to add a couple of new fields to the report.  No big deal, right?  I've done it 100 times on other reports.  :-)

I added the 3 new fields to the Tmp table in the AOT that the report uses.  Next I went in to the DataProvider class and set the logic to populate those fields with the correct values.

My next step would usually be to open the Visual Studio Project for the report, refresh the data set, and then drop the fields on the report where I want them.

Here is my problem.  This report is missing the Visual Studio project and I can't seem to locate it anywhere.  I decided I might be able to do what I needed anyway by navigating to the report through the SSRS Report Manager URL and opening the report up in Microsoft SQL Server Report Builder.

It looks promising but I cannot seem to figure out how to refresh the data set to pull in the new fields that I added.  The data source is AutoGen_ReportDataProvider and when I click refresh I just get an error with the following details.

"The selected data extension AXREPORTDATAPROVIDER is not installed or cannot be loaded. Verify that the selected data extension is installed on the client for local reports and on the report server for published reports."



------------------------------
Jim Czerniak
IT Manager - Applications
CMC Group
Bowling Green OH
------------------------------