Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 267 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Loop by TextBox in RDLC report header
Lyuchin
Member Posts: 23
Hi all,
I need to make a loop by header of the RDLC report. The header contains static data (e.g. company information), which will be repeated on every report sequence page and changeable data from the report's dataitem, which should be iterated in the header throughout the report (actualy the data, which would have to be in a body, but in the design it should be in the header area). One option is to put a rectangle into table's header (and set RepeatOnNewPage property in true) and place inside of this rectangle the fields which should be included into loop. Is there any other option how to implement this? Once more, I mean something like a table or a list, but with header related information (that is the fields which normally would be placed into report's header, but because there are some fields with iterated content, all this set of fields should be somehow refactored in the RDLC design).
Any help appreciated. Thanks.
I need to make a loop by header of the RDLC report. The header contains static data (e.g. company information), which will be repeated on every report sequence page and changeable data from the report's dataitem, which should be iterated in the header throughout the report (actualy the data, which would have to be in a body, but in the design it should be in the header area). One option is to put a rectangle into table's header (and set RepeatOnNewPage property in true) and place inside of this rectangle the fields which should be included into loop. Is there any other option how to implement this? Once more, I mean something like a table or a list, but with header related information (that is the fields which normally would be placed into report's header, but because there are some fields with iterated content, all this set of fields should be somehow refactored in the RDLC design).
Any help appreciated. Thanks.
0
Comments
You could write a VB script function that stores passed values (your values that change according to the body) into variables.
Then in Report Header you could call another VB script function that gives-back variables' values.
If it's not clear I'll explain better.
It works as expected... More or Less...
Hi, thanks for reply. Do you mean SetData, GetData functions like in standard sales reports? If no, can you please explain in more details.
Yes the idea is the same of SetData and Getdata.
It works as expected... More or Less...
It works as expected... More or Less...
I need something like table or list (that is iterated data) but in !report header!, not body. Like if you run some sales report (for example ID 205) you can see company information in the header. And now imagine that in the left side of this report header I need some data (for example Location name/address) which are not static for each report page, but changing (iterating) according to report dataitem.
So, something like this.
Page1 of report.
Location Blue, Address1 Company Info
Page2.
Location Red, Address2 Company Info
Page3.
Location Green, Address3 Company Info
So, I need the same number of pages in the report as a number of locations. And mention please, that all this information placed in header.
Maybe I'm stupid but in my opinion (if I understood well) the following should be the solution to your needs:
1. create a group based on locations.
2. Set the flag "Page Break at the End" on this group (in this way there will be a page break at then end of each location)
3. Pass values with SetData as I suggest you before (I would do the call to the function in the body of your table)
4. GetData in header and you'll get what SetData wrote
In my opinion should work.
It works as expected... More or Less...
i Face the Same Problem. I found out the Solution .
1.In Body Section all Control with in a Single ListBox.
2.In ListBox you have Create a Grouping (for example "Document No."). :thumbsup:
Note:
Kindly Ref to Report 206 (UK Database).