100 likes | 197 Views
The RIGHT Report Writer for Microsoft Dynamics NAV. Conference Dial-in Number: (641) 715-3200 Access Code: 640034#. Ron Summers, President Jon Oesch, VP Channel Dev Centerline Software www.centerlinesft.com . Ad-hoc Reports w/o Programming. Font Colors & Properties
E N D
The RIGHT Report Writer forMicrosoft Dynamics NAV Conference Dial-in Number: (641) 715-3200 Access Code: 640034# Ron Summers, President Jon Oesch, VP Channel Dev Centerline Software www.centerlinesft.com
Ad-hoc Reports w/o Programming • Font Colors & Properties • Headers & Footers • Charts • Data Indicators • Sort Report Columns • Calculated Fields • Flowfields & Option Fields • Green Bar Formatting • Collapse Subtotals • Page From n to m • Drill-down from Flowfields • Save to Excel and PDF
Financial Reports • “Out-of-the-box” • Uses Chart of Accounts • Uses Dimension Trees • Uses Account Schedules • Level by Indentation • Unlimited Dimensions • Comparison Columns • Dynamic Data Formatting • Pages • Columns • Rows • Drill Down into NAV • Save to Excel and PDF
Making the RIGHTDecisions • RIGHTCost • Developer Aids • Ad-hoc Reports • Financial Reports • SSRS Integration • Version 4.x plus • FREE Training • Visual Studio • RIGHTTechnology • Fast • Secure • Modern (RDL) • Leverage the Microsoft Stack • SSRS • SQL Server • RIGHTUser Experience • “Made Simple” • Classic • Role-tailored • Language • Currency
Testimonials "Pivotier is one of the easiest to use report building tools I have ever used.” “ I especially like the ease of creating joins and unions.” “Pivotier reports always look better than the NAV reports” “We are now creating meaningful and accurate reports quickly.” “Microsoft should be congratulating you for saving a NAV customer!” - from Pivotier customers “ … A great reason for my customers to upgrade to SQL Server and newer versions” “ I have NEVER had a customer call me and tell me they want a specific add-on product” - from NAV partners. “Together, the combination of Pivotier and NAV 7 will make the reporting story in NAV even that much better.” - from Microsoft . “…you are delivering the sizzle that we need”, “…no-brainer against competing products at less than half their price”, “…you are making complex things simple”, “…you leave money on the table at your low, all-inclusive pricing”. - from NAV customers.
Dynamics NAV Reporting Issues • Incompatible with SQL Server • SQL can’t “see” NAV data (e.g. Flowfields) • Security not respected by external SQL tools • Requires programming knowledge and cost • Expensive to add or modify reports • C/SIDE just gets harder and more technical over time • Technology is not Microsoft “standard” • Does not use Report Definition Language or SQL Reporting Services • Too many report writers • Slow, poor security • Force unwelcome learning of new applications • “the long and winding road” map • Not visually appealing, sometimes cumbersome • Limited color or font property management • No data visualization (charts or indicators) • Base NAV reports have poor content
What Pivotier Does for End Users • Easy “ad hoc” reports without programming knowledge • Reports against any C/SIDE (base or add-in) table/field • Data visualization with indicators and charts • Simplified views of complex data • Saved Report Configurations (filters and options) • Out-of-the-box financial reports • Dynamic pages, rows and columns from dimensions and G/L data • Account Schedules using new technology • Unlimited dimensions without cumbersome Analysis Views • Multiple Options for report production • Report Viewer, Email, Excel and PDF • Web-based reporting with SSRS w/o NAV user sessions • New, improved base NAV reports • Work against all versions from 4.x onwards • Drill-down to NAV from all reports • Eliminates the need for multiple report writers
Get it RIGHTNow! with theRIGHT • Technology • User Experience • Cost www.centerlinesft.com marketing@centerlinesft.com
Challenges for NAV Developers/IT Staff • SQL can’t see some NAV data properly • Flowfields • Option and Boolean fields • Language captions • NAV does not use newest Microsoft technology • Report Definition Language (RDL) • Microsoft Report Viewer • SQL Server Reporting Services (SSRS) • Visual Studio 2010 • If using RTC, still need to start in Classic version • Difficult to create Transact-SQL statements for: • Report Models • Data Sets • Too much time spent solving easy issues for end-users. • Difficult for end-users to understand a complex data model • 3rd-party tools violate security and performance controls