mibuso.com

Microsoft Business Solutions online community
It is currently Thu May 23, 2013 5:41 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 9 posts ] 
Author Message
 Post subject: SSRS Reporting
PostPosted: Wed Nov 30, 2011 6:36 am 
Offline

Joined: Wed Nov 30, 2011 6:30 am
Posts: 6
Country: Sri Lanka (lk)
I need to do my NAV reports through the SSRS(SQL Server Reporting Services). Anyone can help me to do this ??
:)


Top
 Profile E-mail  
 
 Post subject: Re: SSRS Reporting
PostPosted: Wed Nov 30, 2011 7:37 am 
Offline

Joined: Wed Sep 29, 2010 3:18 am
Posts: 764
Country: Australia (au)
you create first the report from classic
after that... tools - view layout
you can design in RS reporting


Top
 Profile E-mail  
 
 Post subject: Re: SSRS Reporting
PostPosted: Wed Nov 30, 2011 8:36 am 
Offline

Joined: Wed Nov 30, 2011 6:30 am
Posts: 6
Country: Sri Lanka (lk)
there is no function like tool - view layout in NAV 2009.


Top
 Profile E-mail  
 
 Post subject: Re: SSRS Reporting
PostPosted: Wed Nov 30, 2011 11:57 am 
Offline

Joined: Tue Dec 08, 2009 11:40 am
Posts: 43
Country: Netherlands (nl)
Yes indeed, that makes me wonder, it only has the options Tools > "Create Layout Suggestion" and Tools > "Delete Layout".

If you choose "Create Layout Suggestion" you get the confirmation dialog:

---------------------------
Microsoft Dynamics NAV Classic
---------------------------
This report already has a layout. Creating a layout suggestion will import a new layout which will overwrite the existing one. Do you want to continue?
---------------------------
Yes No
---------------------------

How do we modify the existing layout instead of starting from scratch.


Top
 Profile E-mail WWW  
 
 Post subject: Re: SSRS Reporting
PostPosted: Wed Nov 30, 2011 12:59 pm 
Offline

Joined: Tue May 10, 2011 8:20 am
Posts: 90
Location: Trondheim
Country: Norway (no)
You click Show -> Layout (The menu right to the left of tools) when you are in the design of the report


Top
 Profile E-mail WWW  
 
 Post subject: Re: SSRS Reporting
PostPosted: Wed Nov 30, 2011 6:14 pm 
Offline

Joined: Fri Aug 06, 2004 9:30 pm
Posts: 899
Location: Richardson
Country: United States (us)
If you are on partnersource or customersource then download the free training materials.
Also consider buying "Dynamics NAV 2009: Professional Reporting" from either Packt publishing - they have the book and ebook bundle or from Amazon.
Plus look at the technical documents on MSDN.

These will guide you through the basics: how to get started, simple reports on to complex reports.

_________________
David Machanick
http://mibuso.com/blogs/davidmachanick/


Top
 Profile  
 
 Post subject: Re: SSRS Reporting
PostPosted: Thu Dec 01, 2011 11:38 am 
Offline

Joined: Wed Nov 30, 2011 6:30 am
Posts: 6
Country: Sri Lanka (lk)
How i can do SSRS reporting for NAV 2009..??

Is there any possible way to do my work.. ?? This matter is very urgent.. !!


Top
 Profile E-mail  
 
 Post subject: Re: SSRS Reporting
PostPosted: Thu Dec 01, 2011 11:57 am 
Offline

Joined: Mon Sep 08, 2008 10:25 am
Posts: 485
Location: Switzerland
Country: Switzerland (ch)
If you read the answers given carefully you find out how you can get to the development environment to "do the work".

If you still (after reading the training materials as suggested) not know how to create / modify a RDLC Report, then ask a professional to do it.
Nobody here will do the work for you, and putting "urgent" in your post will not help you either.

_________________
My Blog


Top
 Profile  
 
 Post subject: Re: SSRS Reporting
PostPosted: Fri Jan 27, 2012 7:49 pm 
Offline

Joined: Fri Jan 27, 2012 7:28 pm
Posts: 4
Country: United States (us)
Pivotier allows NAV users and developers to design and run reports from both Classic and RTC. Reports are created using true RDL (not RDLC like base).

One of the output options is Publish to SSRS which makes reports editable in SSRS Report Builder and also available in a browser for detached users.

NAV tables can be interpreted to generate TRANSACT SQL as well as SSRS Report Models. C/SIDE table properties are automatically interpreted so that flowfields, option and boolean fields as well as language captions are evaluated in creating datasets. For eample:

Code: Select all
// auto aliasing of fields names to handle spaces, periods, etc.
SELECT Customer.[No_] AS CustomerNo_, Customer.[Name] AS CustomerName,

// handling an Option field
(CASE Customer.[Blocked] WHEN 0 THEN ' ' WHEN 1 THEN 'Ship' WHEN 2 THEN 'Invoice' WHEN 3 THEN 'All' ELSE '' END)  AS CustomerBlocked,

//handling a boolean field
(CASE Customer.[Tax Liable] WHEN 0 THEN 'No' WHEN 1 THEN 'Yes' ELSE '' END)  AS CustomerTaxLiable, Salesperson_Purchaser.[Name] AS Salesperson_PurchaserName,

// translating a flowfields into a nested SELECT
(SELECT Sum([Amount (LCY)]) FROM [CRONUS EXT USA, Inc_$Detailed Cust_ Ledg_ Entry] WHERE ([Customer No_] = [Customer].[No_])) AS CustomerNetChangeLCY

// handling company names
FROM [CRONUS EXT USA, Inc_$Customer] AS Customer

// joining a table
LEFT OUTER JOIN [CRONUS EXT USA, Inc_$Salesperson_Purchaser] AS Salesperson_Purchaser ON Salesperson_Purchaser.[Code]  =  Customer.[Salesperson Code]


Reports are also going to be at least 10 times faster than base NAV and much more colorful by using the latest data visualization which is possible with Microsoft (Redmond) capabilities.


Attachments:
File comment: NAV report published to SSRS using Pivotier.
ssrs.jpg
ssrs.jpg [ 34.67 KiB | Viewed 410 times ]
Top
 Profile E-mail  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 9 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: