SetData GetData issue

jordi79
Member Posts: 280
Hi,
I have attached 2 screenshots. 1 is the layout of the report, and the other is the result of report.
In the picture "Report Layout", the red box is the SetData part of the report. I tried to put SetData on the header, but it did not work, so I moved it to lines.
In the picture "Report Printout", all the results are correct as long as the printout is within 1 page. But if there is a spillover to 2nd page, then the header data is not correct.
There seems to be a weird behaviour where by the SetData on the line does not update the Header.
I have also checked the dataset exported to the report, and the data set is also correct.
Jordi
I have attached 2 screenshots. 1 is the layout of the report, and the other is the result of report.
In the picture "Report Layout", the red box is the SetData part of the report. I tried to put SetData on the header, but it did not work, so I moved it to lines.
In the picture "Report Printout", all the results are correct as long as the printout is within 1 page. But if there is a spillover to 2nd page, then the header data is not correct.
There seems to be a weird behaviour where by the SetData on the line does not update the Header.
I have also checked the dataset exported to the report, and the data set is also correct.
Jordi
0
Comments
-
setdata works with the data on the specific page. Getdata retrieves it.
For your vendor value are you using the field selection or the dataset selection for the first value of the field for the report?David Machanick
http://mibuso.com/blogs/davidmachanick/0 -
Hi DavMAc,
I am not sure what you mean by field selection or the dataset selection?
In the screenshot of the report layout, the field in RED is the field where I put the SetData. And I put SetData in the Visibility Expression of the field.
Jordan0 -
Hi Jordan,
I could advise you to place a list moving through all your vendors, put all the body inside that list and your red textbox should be one outside the table and placed on the top left corner of the list, you can put the table above that textbox.
This will make you sure that if you have multiple pages in the same invoice for the same vendor it will keep the correct information.
This can also be done with the table as is but you would need to correct the group or move the set data to other place.
Hope this can help you.0
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