Complicated Data Export from Report

nverma
Member Posts: 396
Hey guyz,
I am in a bit of a pickle. Maybe some can shed some light and help me out.
Originally a report had one DateItem (Item) which was used to display the following information: No., Description, Quantity on Hand, Sales (Qty), Discontinued Item, etc. Upon users request, the report was slightly modified since the user wanted to see the Bin Content of each Item no. (i.e where is the item located (location code), how many are left in the warehouse (Quanity), etc).
Currently the report the report has two dataitems: Item and Bin Content (indented under the Item dataitem).
Now I have been asked to update the Print to Excel Option in the report to display the Bin Content Information aswell for every item no. I am not really sure how to do this: How do I create a new line in excel every time bin content is found.
Please find the enclosed attachment to get a visual aid.
Report Designer & Preview Report - http://www2.zshare.ma/mynlyp5e7ryc
Excel output - http://www2.zshare.ma/ulnefo8d7ja5
(I couldnt upload the pics here because the size of the image)
I have been able to get all the items information (from the item dataitem) to display (the black box...on the image). I am not sure how to display the bin content of each item in the excel report.
I am in a bit of a pickle. Maybe some can shed some light and help me out.
Originally a report had one DateItem (Item) which was used to display the following information: No., Description, Quantity on Hand, Sales (Qty), Discontinued Item, etc. Upon users request, the report was slightly modified since the user wanted to see the Bin Content of each Item no. (i.e where is the item located (location code), how many are left in the warehouse (Quanity), etc).
Currently the report the report has two dataitems: Item and Bin Content (indented under the Item dataitem).
Now I have been asked to update the Print to Excel Option in the report to display the Bin Content Information aswell for every item no. I am not really sure how to do this: How do I create a new line in excel every time bin content is found.
Please find the enclosed attachment to get a visual aid.
Report Designer & Preview Report - http://www2.zshare.ma/mynlyp5e7ryc
Excel output - http://www2.zshare.ma/ulnefo8d7ja5
(I couldnt upload the pics here because the size of the image)

I have been able to get all the items information (from the item dataitem) to display (the black box...on the image). I am not sure how to display the bin content of each item in the excel report.
0
Comments
-
If you want the Bin Contents in the rows below the Item row, just increase the row no. you send to create the cells in Excel. You may want to but the Bin Code in column B (description) so the bin information is indented.
If you are not sure how to do this, post the code within the Item Data item which is creating the Excel output now.Gerry Kistler
KCP Consultores0
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