Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 304 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Reporting in Excel?
ifonly
Member Posts: 34
Hello, i am struggling with trying to produce some reports in Excel to share with other users in the organisation. I can make an Excel report on my pc that uses MS Query & all is fine, if i save this on the network & then try to run this from a different pc i get a select error on the table's.
From investigation i believe it is because i have the SQL Role sysadmin, but the other Nav users just have the SQL Role Public - does this sound correct?
I have tried with a simple based on Opportunity & Opportunity Entry tables to look at Open Opportunities as i was hoping to create a pivot chart/Dashboard report for the senior management.
I know about Jet Express, but was not looking at putting this on users systems, i just wanted to create a couple of simple reports, what do other companies do? Do they use MS Query?
From investigation i believe it is because i have the SQL Role sysadmin, but the other Nav users just have the SQL Role Public - does this sound correct?
I have tried with a simple based on Opportunity & Opportunity Entry tables to look at Open Opportunities as i was hoping to create a pivot chart/Dashboard report for the senior management.
I know about Jet Express, but was not looking at putting this on users systems, i just wanted to create a couple of simple reports, what do other companies do? Do they use MS Query?
0
Comments
http://jetexpress.jetreports.com/
/Claus Lundstrøm
I'm blogging here:http://mibuso.com/blogs/clausl and used to blog here: http://blogs.msdn.com/nav
I'm also offering RDLC Report Training, ping me if you are interested. Thanks to the 700 NAV developers that have now already been at my training. You know you can always call if you have any RDLC report issues :-)