Issue with printing data horizontally. 1

[frankyberry]

I'm using CR v8.0.1.
I've been able to get data to display horizontally but not exactly to my liking.
When printing vertically, the data looks like this:

Set #1  Member(s):     Notes:
         Tim
         Mark
         Chris

Set #2  Member(s):     Notes:  2
         Sue
         Travis

The above leaves too much white space on the report and wastes a lot of pages as there can be anywhere from 50 to 100 sets.

What I am seeing:

Set #1  Member(s):  Notes:   Set #1  Member(s):     Notes:
         Tim                          Mark
         
                                       Chris

Set #2  Member(s):  Notes:  2 Set #2  Member(s):  Notes:  2 

         Sue                                  Travis

What I would like:

Set #1  Member(s):  Notes:    Set #2 Member(s): Notes: 2
         Tim                          Sue
         Mark                         Travis
         Chris                        

Set #3  Member(s):  Notes:    Set #4  Member(s):  Notes:  Novice
         Kerry                           Joel
         Scott                           Joe

Sorry about the crude demo above but I hope you get the idea.
What is the best way to achieve this?

 

[TheBlondOne]

not sure you will be able to achieve what your after without the use of subreports

Is it feasible to include sub-reports for your data? i mean this by how many Set # do you have? if you only have a few then you could use subreports, (1 subreport for each set and then just display the subreports in the report header or footers.

HTH

-Steve


"if at first you don't succeed, sky diving is not for you"!!! )

 

[frankyberry]

The number of Sets can vary...no rhyme or reason in the variance either...

 

[TheBlondOne]

Just another thought, might not be possible but can't try it at the mow. What if you set your report to be a label report (Right-click on the details section and go to section expert etc..), make the labels width equal in size (half the report canvas), insert a group on set # and then put the relevant fields in the details and group sections.

-Steve


"if at first you don't succeed, sky diving is not for you"!!! )

 

[frankyberry]

Thanks for the tip...I'll play around with it.
I'll post back shortly my results.

The one thing that I am trying to do as well is to create an array containing all members for each set and then group on sets....is that even possilbe?

 

[lbass]

Going back to your original approach, you should be using format sections with multiple columns->layout tab->down then across and also check "format groups with multiple columns". To get two groups per column, create a formula like:

whilereadingrecords;
numbervar cnt := cnt + 1;
numbervar cntx;

if remainder(cnt,2)-1 = 0 then
cntx := cntx + 1;
cntx

Add this formula to your group header for set# and then insert a group on it and make it your topmost group (you might have to go to database->check "select distinct records".

Then go to the section expert and highlight the group #1 (this formula) footer and check "print at bottom of page". This assumes you still have the report set up to format with multiple columns.

-LB

 

[frankyberry]

That's great...The only thing, and I am very thankful for your assistance but the report is printing the results vertically and then, if the total number of sets is great, prints the second column..

Something like this:

set 1                  set 4
...data..            ...data..
...data..            ...data..
...data..            ...data..

set 2               set 5
...data..           ...data..
...data..           ...data..
...data..           ...data..


set 3               set 6
...data..           ...data..
...data..           ...data..
...data..           ...data..

but again, its great that it does print a new column after about 11 sets, but is there a way to get Set 2 to print to the right of set 1?

 

[frankyberry]

Here is what I am doing right now....
I have a grouping on the formula, and the group options section is not choosen...

 

[lbass]

Sorry, I didn't notice that you wanted the names down but the groups across. Are you really ONLY displaying names in each set or are there multiple fields? You could collect the names in a variable to display in the group footer, and then suppress the detail section and format the multiple columns to go across then down.

-LB

 

[frankyberry]

Just an update on how this was achieved:

Created a subreport in the reports Details section. Formated this Details section with mulitple columns, set column width to 3.5.
In the subreport, I suppressed the Details section and placed this formula in the group footer to concatenate the members:

whilereadingrecords;
stringvar member;
stringvar memberDisplay;
numbervar memberLen;
global stringvar lensFailed;

If isnull({VW_CLUBHOUSE.MEMBERS}) Then
    member:= "N/A"
Else 
    member:= {VW_CLUBHOUSE.MEMBERS};

memberDisplay := member + ", " + memberDisplay;

memberLen := Length(memberDisplay);  //to remove trailing ','
Left (memberDisplay,(memberLen-2))

thanks to all! This looks great!