Export account schedule layout to excel

franklin1232
Member Posts: 35
I have a dimension called department. Each of our stores is a department. When we print the account schedule we pick a range of department numbers. Each department account schedule report needs to print and staple. Our current solution is to use one report to open a second report for each department in the range. This is a slow process since each of the department report is open, printed, closed, and repopen. We have 87 stores. I was thinking of using Jet reports or Crystal reports to export the data, but I was hoping someone already has this feature since the other options will take time to program that I don't have.
0
Comments
-
Jet Reports would be a good option for this. You would be surprised how quickly you can put together a Jet report to pull this data. Depending on your data it may take a little bit to run of course.Thad Ryker
I traded my sanity for a railgun0 -
Crystal works great for us - you can group by your department dimension very easily0
-
We use Jet Reports frequently for reports with dimensions. Easy to use, and fast to develop. It has special advanced dimension filters, which allow you to create functions as if all dimensions are global dimensions - and not just the ones you setup in GL setup.Kind regards,
Hans Fousert
Microsoft Certified Trainer and Jet Reports Certified Trainer0
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
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions