Flow report content across multiple page columns

I'm working on a simple report that has multiple groupings and such. The data shown for each detail section is pretty small, so I'm looking for a way to make better use of a page. What I'd like to do is flow the data from column to column across the page. The details section fits very nicely in about 3in. of space, so taking a standard 8.5x11 sheet of paper, i can fit 2 columns in portrait or 3 columns landscape. 
<pre class='_prettyXprint _lang-auto _linenums:0'>
Group A Header | Group B Header
Group B Header | Details
Details | Group B Header
Group B Header | Details
Details | ....
<goto nxt col> |

----page break

Group A Header
...and so on
</pre>
Is there a way to layout the report in this fashion?

Find more posts tagged with

Comments

jain

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="116914" data-time="1368823594" data-date="17 May 2013 - 01:46 PM">
I'll try again with the sample database stuff, but I had wanted you to give a sample with your own data that you know all of the end of lines are done properly. I'm not certain that the sample database doesn't have some oddities that are messing up the report we have with the sample database. That's why I'm trying to get a sample from you without the sample database. I hope this helps explain that better.

</blockquote>
Hi Michael, Please find the attached sample data, with this data the current logic is not working. Please let me know if the data provided is not giving much clarity. have tried in many ways its not working as expected 
 
Thanks, 
Jain

mwilliams

I'm not sure what you were wanting with this data, but without doing anything but moving it to a scripted dataSet and sizing the rows, the line breaks that were there were already present without me doing anything. To double them, all I had to do was for each "\n" to replace it with "\n\n" as I added a word to the row text. Hope this helps you out. I made a new example to use your data, much more simplified (single column, no grouping).

vijayshankar245

<blockquote class="ipsBlockquote" data-author="mwilliams" data-cid="106998" data-time="1341595056">
<div>
Ok. Here it is. This example has two different options. The first table is hidden because it's not a realistic option. It puts 7 words per line. The catch is that all the words are the same length "long text long text...". The second option figures which words go in each row based on the length of the words. You can see this script in the scripted dataSet. This example uses only one very long text, but multiple long texts shouldn't be much different. For the long text header, you should be able to split that into multiple rows and just include it in your scripted dataSet in proper order. You could then avoid having to use actual grouping, because you'd have handles all of that already, with your sort in your original dataSet. Hope this helps. Let me know if you have questions.
</div>
</blockquote>
Hi Mwilliams
 I have a similar requirement to show a text data in the same page with multiple columns. I have seen your example to show long texts into multiple columns, but you have used scripting in the dataset where as I have datamodel in my model since I have used .data design in my report. My requirement is to show a single text value e.g. "Address pincode" within the same page in multiple columns.
 
Will you be able to share a sample design if you have used scripting other than dataset.