Solved

Column names based on Summarised fields in Crystal

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

809 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