Group Values to appear horizontal

[CromwellF]

I have a collection of data which encompasses a date field. I have group together the records on the data vaules and of course they appear within the group footer down the page.

However I was wondering if there is a way I can still group these records via the date vaule by displaying the date vaules across the report horizontally?

 

[kskid]

Without specifics, have you tried crosstabs?

Crystal Version
Database and connectivity
Sample data
Expected output

 

[CromwellF]

I cannot use Crosstabs due to the data manipulations

 

[lbass]

If you provide more information about your report and your calculations, we can probably show you a way to use a manual crosstab, if an inserted crosstab doesn't work (although it still might).

-LB

 

[CromwellF]

I have a data set that returns four names, a points score and an interaction date.

I have successfully returned the data i need which displays Hierarchy of the four names, then a average points score of the for each level and a difference between each average all displayed against the interaction date

Current Example
14/01/05
Group1 10
Group1b 10
Group1C 5
Group1C 6 +1
Group1C 7 +1
Group2 9 -1
Group2a
15/01/05
group1 etc(repeat)

I require
14/01/05 15/01/05
Group1 10 10
Group1b 10 9
Group1C 5 3
Group1C 6 +1 2 -1
Group1C 7 +1
Group2 9 -1
Group2a

 

[lbass]

Please provide the group fields and also explain why you are using different sections within each group--you seem to have different calculations in each. It would also help to see samples of the content of the formulas you are using for calculations. You are not using subreports, are you?

-LB

 

[CromwellF]

Firstly I am not using sub reports.

The data is a selection of scores given to individuals (Group1c). The other groups displays the team and department that the individual resides within. An individual can have multiple scores for each date range. The data each value is an average. Therefore

Agent1 may have 6 scores that return and average of x.
Team1 has agents1/2/3/4 within it and therefore returns and average of the agents averages
Department 1 has teams 1/2/3 within it and returns and average of each team.

In addition to that there is a difference field that display the difference between the averages displays on date 1 to those displayed on date2.

Example of the formulas.
Agent Avg= Average ({REPORT_TEAM_POINTS;1.p_points}, {REPORT_TEAM_POINTS;1.I_Created}, "daily")

Difference1 = whileprintingrecords;
numbervar sumamt := 0;
numbervar prevave := 0;
numbervar counter := 0;
whileprintingrecords;
whileprintingrecords;
numbervar sumamt := {@AvgPoints4} ;
numbervar counter := counter + 1;


If counter = 1 then
prevave:= 0
else
numbervar prevave;
prevave := sumamt/counter

Difference 2 = whileprintingrecords;
numbervar sumamt := 0;
numbervar prevave := 0;
numbervar counter := 0;
whileprintingrecords;
whileprintingrecords;
numbervar sumamt := {@AvgPoints4} ;
numbervar counter := counter + 1;


If counter = 1 then
prevave:= 0
else
numbervar prevave;
prevave := sumamt/counter

 

[CromwellF]

Sorry my mistake Difference 2 =
whileprintingrecords;
numbervar prevave;
If prevave = 0 then
prevave:= 0
else
{@AvgPoints3} - prevave

 

[Madawc]

It sounds like you need a 'Mock Crosstab' - something that looks like a Crosstab, but in fact you define each column yourself, normally as a running total. Crystal should have included an example along with the Crosstabs.

Madawc Williams (East Anglia, UK)

 

[lbass]

You haven't explained where these formulas are located or told us what your group fields are, but you might test whether using multiple column formatting would create the display you want. You would go the section expert->details->format with multiple columns-> layout tab->choose a width and gap that would allow the correct number of columns->check "Format groups with multiple columns". Try using "Across then down" and see if this gives you the display you want.

If instead you want to try a manual crosstab, you would have to make your formulas specific to a date, but I'm not sure how well that would work when you are using variables to compare between dates.

-LB

 

[CromwellF]

Thanks for this input

I am trying to locate: section expert->details->format with multiple columns-> layout tab->choose a width and gap that would allow the correct number of columns->check "Format groups with multiple columns"

Is this a list of menu options? If it select "section expert" I am present with dialog box that i can write a formula for the group/data selected?

 

[CromwellF]

Forget the last post I have found the options and investgating now.
Thanks