Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Column names based on Summarised fields in Crystal

Posted on 2009-07-09
5
Medium Priority
?
424 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 101

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 101

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 101

Accepted Solution

by:
mlmcc earned 1200 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

610 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