Solved

Column names based on Summarised fields in Crystal

Posted on 2009-07-09
5
416 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Excel Graph of User occurance 9 27
Delete all words in cell more than 5 words 7 47
Remove row and column 3 45
Help with Adding text from a form to a worksheet 5 35
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

943 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now