Report grouping problem

petevans
Member Posts: 78
Hi.
I am making a Sales - Shipment report, and am having trouble with the grouping.
Here is the body design:

Without choosing grouping the report looks like this:

And that is as expected, all is well. But what happens when I choose Edit Group-> Page break at start/end is not as expected.
This is with Page break on end:

And this is with Page Break at start:

Page break on end makes one page per group, which is good, but only shows the first record per group, which is bad.
Page Break at start is the same, but sometimes prints several groups per page.... which is even worse, not to mention strange.
My grouping is Group on:
=Fields!Sales_Shipment_Header_No_.Value
=Fields!Sales_Shipment_Line__No__.Value
And sorting:
=Fields!Sales_Shipment_Line__No__.Value
Can anyone tell me what I am doing wrong?
I am making a Sales - Shipment report, and am having trouble with the grouping.
Here is the body design:

Without choosing grouping the report looks like this:

And that is as expected, all is well. But what happens when I choose Edit Group-> Page break at start/end is not as expected.
This is with Page break on end:

And this is with Page Break at start:

Page break on end makes one page per group, which is good, but only shows the first record per group, which is bad.
Page Break at start is the same, but sometimes prints several groups per page.... which is even worse, not to mention strange.
My grouping is Group on:
=Fields!Sales_Shipment_Header_No_.Value
=Fields!Sales_Shipment_Line__No__.Value
And sorting:
=Fields!Sales_Shipment_Line__No__.Value
Can anyone tell me what I am doing wrong?
NAVN00b
0
Comments
-
Let me know if there is anything I can explain in order to clarify the scenario. Seems like this should be a pretty standard problem in RDLC design.NAVN00b0
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
- 322 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