SSRS Reports need to reuse rdl files from SSRS 2005 (VS 2005) in SSRS 2008 (VS 2008)

2
votes

I initially posted a thread here. Since I've received no answer, I'm posting here as well.

It's all about Dynamics AX 2009 and SSRS reports built and exported from VS 2005. I have rdl and rdl.data files from a Dynamics AX 2009 SQL Server 2005 ERP environment.

My problem is partially addressed in these threads (here, here and here).

A similar environment was set by the developers to study the client system with client data with following exceptions

  • Database: SQL Server 2008 R2 SP1 (not 2005)
  • Microsoft SQL Server Reporting Services Version 10.50.1600.1 (guess client has old due to sql Server 2005).
  • Visual Studio 2008 SP1

Now the only thing I want to do is to somehow get that rdl file (or rdlc file when renamed as directed in some threads) associated to some report project in Visual Studio 2008 / bids so that I can reuse the layout in rdlc file, associate it to some dataset/model (from AX, so I will need queries availability here) and get my report deployed in AX 2009 AOT.

I select the Dynamics AX Reporting project template in the VS 2008. The problem is, once I rename the rdl to rdlc and open it in VS 2008, it starts giving a very good layout as shown in the image as well.

enter image description here

But all this layout, these fields are useless since the dataset they are bound to is not available. And I find no other means to attach models that I can create in the new report(s)(.moxl file perhaps)

If I do not rename the rdl file, it opens its xml schema as follows:

enter image description here

I tried this since I found a conversion thread, I changed the schema and saved the file, reopened it and same xml which is useless for me I guess.

What's the role of SSDT, this is available only since VS 2010 I think, is that a must for rdl file conversion as I read here?

How can i reuse this 2005 rdl file or renamed rdlc file which is successfully rendering its layout / design in VS 2008, just need to bind it to AX datasource / query / temp table and I'm done.

Is it not possible at all? Or is it just not the way to do - I have tons of such rdl files and i want to reuse their layout.

1
ssrs-2008reporting-servicesdynamics-ax-2009rdl
try opening rdl files using MS SQL BIDS 2005 or newer. - user1578107
did so, but if u read carefully, i have got the layout, now what i need to do is to bind that rdlc file some how in the .moxl or the report model, how to do that ? Add some new datasource ? How can i bind it to the A queries which are available for any new report that i add from the IDE (VS 2008) ? - maqk

1 Answers

0
votes

Using the vanila Visual Studio Report Designer, it separates the Datasets from the Design surface. The Design surface doesnt care how you got the rows and columns in each Dataset. So your challenge is probably to create a new Data Source in the Report Designer and then edit the Dataset definitions so that the same columns are produced from your new Data Source.

I havent used SSRS against AX and havent heard of a model or .moxl file. This may complicate your scenario.