How To add an RDL file to SSRS Project in AX

(0) Share

Report

Posted on by Houda Chkoundali

147

Hi,

My main object is to use an RDL file as a design in My SSRS Report Project. How to add this existing item in my Visual Studio Project?

Thanks for help.

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

A.Prasanna 8,223 on at

Like (1)

Report

If you want to do modification on Existing SSRS report you have to modify relevent existing project and deploy. But if you want to create new SSRS report you must create project in AOT and then add SSRS report to Project .

as far as I know you cannot attach RDL file directly to the Project.

Thanks & Regards,

Amith Prasanna

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (1)

Report

Is that a standard SSRS RDL..? and not AX-SSRS RDL..? if so, you cannot use it directly except saving little time at designing. AX provides no way to import external RDL files in AOT

Was this reply helpful? Yes No
Houda Chkoundali 147 on at

Like (0)

Report

Thank you for the quick response Sohaib.

Actually it is the sales Confirm SSRS report wich was modified and deployed. I can see the design in my report server but unfortunately not in my AOT neither in my Visualstudio project. Also, by clicking in the menuitem the desired Design is displayed. I'm confused what is the problem! Help Please.

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

Houda Chkoundali

What you see in AOT if you have have a look at next object ..?

AOT\SSRS Reports\Reports\SalesConfirm

On which development layer were your changes that you did previously and what development layers are being shown now with this object as yo try to run compare tool..?

Was this reply helpful? Yes No
Douglas Noel 3,905 on at

Like (0)

Report

Hi,

did you connect your VS to the right client configuration?

If you don't see this report (design) from within application explorer of VS, you're maybe connected to the wrong environment?

regards Douglas

Was this reply helpful? Yes No
Houda Chkoundali 147 on at

Like (0)

Report

In AOT I see just the 3 standard Design of SalesConfirm SSRS Report. While when the project was deplyed it was in the USR Layer. the problem is that report is shown now in the( sys) layer. How display it from USR layer please?

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (1)

Report

There are no guarantees, after you have lost your USR layer.

If you don’t have a backup you can try following on any server. I don’t see any risk in trying it (after you have lost your customized layer object and it is already in SYS layer)

1)     Open VS WITH USR Layer and create a new AX reporting model project

2)    No try to import RDL file into VS project by selecting add existing item.

3)    Try to compile and deploy.

I am not sure if this can work or not, but you may give it a try.

Another option can be trying to copying paste xml from existing RDL file to SalesConfirm report, as you will open VS project from AOT.

Update:

See next post, once i played with XML to make different versions of the report work, if you can open XML of existing RDL, you can try to paste it in standard report on VS.

Worst case: redo your customization :) [I know everyone would hate this option, please start using version control]

Was this reply helpful? Yes No
Houda Chkoundali 147 on at

Like (0)

Report

Thank you Sohaib for all your response. Frankly I was in a hurry with a customer Delivery so my lead preferred to repeat the design. Thank you for all your suggestions. Certainly this is very helpfull .

Regards,

Houda Chkoundali

Was this reply helpful? Yes No