Left, up, down, right ... GROUP!

The majority of reports I see are laid out as what is termed 'group above', the break groups appear above the detail data thus.

GrpAbove.gif:

Another not so common layout is to see break groups grouped to the left thus:


GrpLeft.gif:


You could even do group below


GrpBelow.gif:


or group right


GrpRight.gif:


OK, so maybe the last two are not so common or useful for that matter.
The template builder can help you with the first two options. For the group left its default output is not so nice:


GrpLeftRaw.gif:


We're working on resolving that but for now a little copy and paste and editing can resolve that and make the output much better.


To get the first two from the template builder it merely a matter of choosing group left or above in the table wizard or if you are using the Table/Form dialog then just set your parent nodes in the properties box to "Table" for group above you use "Free Form"


GrpDialog.gif:


and you're done, get a sample of everything here. The group left is mostly overlooked but it gives you a nice layout, once cleaned up and you can of course have multiple break levels.

Comments:

Tim Is it possible to add sub-totals at the group level? Cheers, Dave

Posted by David Barnes on June 28, 2007 at 03:12 AM MDT #

I have a question. In pick slip template, i want to create a group on pick slip number for table containing line no, quantity.. the problem is pick slip number is in Header_Custom_Section_S15 while line no and quantity are in Pick Slips Detail Lines S3. I am unable to collect lines n qty according to pick slip number. Please help me..

Posted by vibha on March 03, 2009 at 05:25 AM MST #

Nice, however I'd like to have a group print from left to right such that the tables each group creates are horizontal to one another instead of stacked. It's a requirement for most of our reports, unfortunetly I can't seem to get anything to display this way. Please HELP!

Posted by Sandy on June 11, 2009 at 03:53 AM MDT #

Hey Tim, Did you ever find a better way to format the left grouping? The table inside the table is making for some ugly outputs for me. I can't get the headers on the outer table to line up with the data cells on the inner table.

Posted by steve schmid on February 18, 2010 at 05:21 AM MST #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Follow bipublisher on Twitter Find Us on Facebook BI Publisher Youtube ChannelDiscussion Forum

Join our BI Publisher community to get the most and keep updated with the latest news, How-to, Solutions! Share your feedback and let us hear your voice @bipublisher on Twitter, on our official Facebook page, and Youtube!

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today