Microsoft Dynamics NAV (Archived)

Is there any way I can add the SSRS reports in Navision 2013.

(0) Share

Report

Posted on by manish.yadav

1,835

Dear All,

Is there any way I can add the SSRS reports in Navision 2013.

manish

*This post is locked for comments

All responses (13)

Answers (4)

manish.yadav 1,835 on at

Like (0)

Report

RE: Is there any way I can add the SSRS reports in Navision 2013.

very thanx binesh sir.

manish
Verified answer

Rajasekhar@MS 5,567 on at

Like (0)

Report

RE: Is there any way I can add the SSRS reports in Navision 2013.

Hi

To develop reports you need to install Visual Studio for NAV 2013 Version, from 2013 R2 and later versions only you can use SQL Server Report Builder.
manish.yadav 1,835 on at

Like (0)

Report

RE: Is there any way I can add the SSRS reports in Navision 2013.

When I try it..the only part is showing there. I am using the Navision 2013 version.

manish
Verified answer

Binesh 7,885 on at

Like (0)

Report

RE: Is there any way I can add the SSRS reports in Navision 2013.

Hi Manish,

Open Development Environment, and then Go Tools then Options then Use Report Builder = Yes

See the bellow image.

For Hyperlink: see bellow image
manish.yadav 1,835 on at

Like (0)

Report

RE: Is there any way I can add the SSRS reports in Navision 2013.

Dear Sir,

How to define the Parameter in SRS report for making an hyperlink.

manish
manish.yadav 1,835 on at

Like (0)

Report

RE: Is there any way I can add the SSRS reports in Navision 2013.

but I am unable to find the path

From MENU Goto TOOL/USE REPORT BUILDER -> YES.

manish
Verified answer

Rabin 2,976 on at

Like (0)

Report

RE: Is there any way I can add the SSRS reports in Navision 2013.

Hi Manish,

There is nothing to get confused about here...

-> Create a New report in NAV -> say TEST_Report...

-> From MENU Goto TOOL/USE REPORT BUILDER -> YES.

-> Now Design and open layout of "Test_Report" report

it will open layout into "SQL SERVER REPORT BUILDER"

For detailed step follow this link

forum.mibuso.com/.../how-to-create-ssrs-reports-in-navision
Verified answer

Ashwini Tripathi 4,624 on at

Like (0)

Report

RE: Is there any way I can add the SSRS reports in Navision 2013.

SSRS report runs in browser hosted on Report Server. Create your report and publish on Report Server.

You can call the url including any parameters required to call. Copy the URL of the report

Create a hyperlink from Navision for the URL : http://server name/full path of report/name of report?Parameter=parametervalue

When you click on URL Link the report will open in browser as you usually run your ssrs report.
Suggested answer

Roberto Stefanetti 12,998 on at

Like (0)

Report

RE: Is there any way I can add the SSRS reports in Navision 2013.

hi,

look at this post on mibuso:

forum.mibuso.com/.../how-to-create-ssrs-reports-in-navision

SQL Server Report Service (SSRS) reports exist entirely outside of the Navision environment, but are accessible to Navision via their URL.

The steps are as follows:

-Create a T-SQL query that produces the data set you need

-Construct the SSRS report layout in the IDE

-Publish your report to the ReportServer

-Set all configurations and security in the SSRS Report Manager

-Construct a call to the SSRS report URL including the report name and all parameters

-Call the report via the URL from within C/AL

.........

and look here:

22 Free Reporting Services Reports for Dynamics NAV available

blogs.msdn.com/.../567113.aspx
manish.yadav 1,835 on at

Like (0)

Report

RE: Is there any way I can add the SSRS reports in Navision 2013.

Dear Amol Ji,

I am sorry for the little bit confusion. I have manually prepared the View in Sql server 2012. Now wants to use the existing query in sql report designer Part. Here I can link my sql view to sql report designer part plz see the screenshot.

I hope you can understand my actual concern.

very thanx.

manish