Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Horizontal Results List -- Is this possible?

Status
Not open for further replies.

nidifice

Programmer
Oct 9, 2003
47
0
0
US
I'm grouping my results, and each group has about 3 detail lines. I'm wanting to list these 3 things horizantally after my group name. Is this possible?

Group is obviously my grouping, and the resultxx is what is being returned into my details view.

ex:
Group 1 - result01 / result02 / result03
Group 2 - result01 / result03
Group 3 - result02

currently:
Group 1
result01
result02
result03
Group 2
result01
result03
Group3
result02
 
You can do this, the solution being version dependent, which you didn't share, nor did you share if you're outputting strings or values.

Try posting real technical information when requesting technical help, such as:

Crystal version
Database and connectivity used
real example data
real expected output

A generic means is to create formulas to house the individual results:

Group Header formula:
whileprintingrecords;
numbervar Counter:=1;
stringvar String1:="";
stringvar String2:="";
stringvar String3:="";
stringvar String4:="";
stringvar String5:="";

Details formula:
whileprintingrecords;
numbervar Counter;
if counter=1 then
String1 := {table.field}
else if counter=2 then
String2 := {table.field}
(etc...)
;
counter:=counter+1

Group Footer formulas:

whileprintingrecords;
stringvar String1

whileprintingrecords;
stringvar String2

etc...

-k
 
Put crosstab into the group header with "results" in columns, group generating field in rows (will be 1 row) and anything (count) in the crosstab body. Now you need only column headers, the rest... hide, suppress, white out... whatever.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top