Can a cross tab print down then across

[sk8er1]

I have a cross tab which has dates along the columns and typical data across the rows. Is there a way to print down the columns...what is happening, is there are large areas of whitespace...

1/17 1/18 1/19
xxx1
xxx2
xxx3
xxx5
xxxx6

I would like to see the value xxx3 as the first item in the 1/18 column....is this do-able in Crystal. I am using the version embedded within VS.NET...
Thanks

 

[lbass]

Already provided the solution to this in thread767-977668. Your row field needs to be removed, and multiple summaries entered, using Nthmostfrequent, incrementing N by 1 with each ned summary field entered.

If you tried this, please explain why you weren't happy with this solution.

-LB

 

[sk8er1]

OK i'll give it a try....

 

[sk8er1]

Hi

Are you telling me to put a summarized field (Nth Most frequent incrementing N by 1) into the row value...

I dont think I can do that. Crystal is putting the row value in that spot ...

 

[sk8er1]

Forgive me ...I am trying to understand your response.

for column i have @ActDate, for the row I have @Vehicle
and for summarized rows I have (Nth most freq)N=1 of @Vehicle....and count of vehicles....

OK...What do I do....

Thanks so much

 

[lbass]

In your original thread (or maybe it was a different thread) you seemed to want to list the vehicles by truckID, but with no count. Please show a sample of the display you want using row fields, column fields, and summaries. For example, if you were to use a row field by location and a date field as your column field, you could insert a count of {truck.IDs} and then multiple instances of {truck.ID}, using NthMostFrequent and incrementing N each time. The crosstab would look like:

1/17 1/18 1/19
Boston 3 2 4 //count
B C X //N = 1
D G Y //N = 2
A B //N = 3
G //N = 4
New York 2 3 1
C H M
J I
K

Please show a similar example, explaining exactly what question you are trying to answer with this crosstab.

-LB

 

[sk8er1]

Thanks for getting back to me....
The user is looking to see just the truckID's ....I don't need it grouped by City (ie Boston, or NY)....
Simply the date like you have in the column heading, and the values B C X for each of the days...and DGY...

I know the user will want to see the values without all the whitespace i have now. That is because on days with alot of transactions, they will be scrolling down quite far...

1/17 1/18 1/19
B C X //N = 1
D G Y //N = 2
A B //N = 3
G //N = 4

This is how I would like to see it.

 

[lbass]

What is the maximum number of trucks per day, and is your version the equivalent of CR 9.0 or higher? Specifically, I'm wondering whether you have the 254-character limitation.

-LB

 

[sk8er1]

The maximum is something like 20 or so per day....
I am using the version that is embedded in VS.NET

 

[lbass]

Try the following. Instead of a crosstab, insert a group on {table.date}. Drag the group name to the group footer. Then insert a second group footer (GF#1_b). Create three formulas:

//{@reset} to be placed in the group header:
whileprintingrecords;
stringvar x := "";

//{@accum} to be placed in the detail section:
whileprintingrecords;
stringvar x;

if instr(x,{table.truckID}) = 0 then
x := x + {table.truckID} + chr(13);

//{@display} to be placed in GH#1_b:
whileprintingrecords;
stringvar x;

Right click on {@display}->format field->common->check "Can Grow".

Suppress all sections except GF#1_a and _b.

Then go to the section expert->details->format with multiple columns->layout tab->choose width and gap to force the number of columns you desire per page->across then down->check "Format groups with multiple columns".

You can insert an additional GF#1_c if you want a little more room between recurring sections.

The advantage of this method is that each recurring section will only be as tall as the longest list within that section.

-LB