Solved

Column names based on Summarised fields in Crystal

Posted on 2009-07-09
5
417 Views
Last Modified: 2015-01-05
Hi,

I'm new to Crystal Reports and am trying to convert previous pivot tables compiled in Excel into Crystal to automate reporting processes.  However, I have come across an issue that is proving a bit of a "show stopper"!

One Excel pivot I produce shows how student's fees and subsequent invoiced amounts are totalled by cost centre and fee type, it looks like this::

                                    Column
                                    Exams                                                 Tuition
Row                            Sum of Fees    Sum of Invoiced          Sum of Fees       Sum of Invoiced
COST CENTRE            £x.xx                £x.xx                          £x.xx                   £x.xx

I have created a crosstab in Crystal (Report Footer section) and placed all data into the Design section.  The nearest equivalent crosstab I can compile in Crystal looks like this:

                                     Column
Row                              Exam                 Tuition
COST CENTRE              £x.xx                 £x.xx
                                      £x.xx                 £x.xx

It does not state which figure is "Fees" and which one is "Invoiced" and doesn't make figures go across the page as I wish them to.  I have exhausted efforts in trying to change this using crosstab formatting options in Crystal hence this post.  Is it at all possible to replicate the Excel layout above in Crystal?

Many thanks.
0
Comment
Question by:MidlandR
  • 3
  • 2
5 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 24814442
So the second row you want shown as the "second" column?

That is controlled through the CROSSTAB expert.
Right click the cross tab in the upper left corner
Clcik CROSS TAB EXPERT
Click the CUSTOMIZE STYLE Tab
Click the SUMMARIZED FIELDS - Horizontal

mlmcc
0
 
LVL 1

Author Comment

by:MidlandR
ID: 24814682
Hi, thanks for help but I can't find where I select "SUMMARIZED FIELDS - Horizontal", I attach a bitmap of the options available.

It shows more rows selected as the report is more complex as originally made out, I didn't think I needed to go into more detail about the rows in my scenario.
Crystal-Customise-Style.bmp
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 24815077
What version of Crystal?

In CR XI it is in the blank space under the COLUMNS list block

mlmcc
0
 
LVL 1

Author Comment

by:MidlandR
ID: 24815090
v8
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 300 total points
ID: 24815193
I wonder if that was a feature added in later versions.

I don't have CR8 installed anywhere but my CR7 install is totally different for a cross tab.
I know the cross tab has had some major upgrades with CR9 maybe even other versions.

mlmcc
0

Featured Post

ScreenConnect 6.0 Free Trial

At ScreenConnect, partner feedback doesn't fall on deaf ears. We collected partner suggestions off of their virtual wish list and transformed them into one game-changing release: ScreenConnect 6.0. Explore all of the extras and enhancements for yourself!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question