Solved

Crystal Reports - Adding labels to Crosstab report

Posted on 2012-03-27
9
431 Views
Last Modified: 2012-06-21
Hi,

I have a report with a crosstab on it, as attached below;

Basically, the crosstab is giving the area name, and the number of litres and the number of records for the date specified.

It looks like this at the moment:

                             2012/01/01
AreaName             123
                               221

Now, what I want, is to make it look like this:

                                  2012/01/01
AreaName                 Litres                   123
                                  No of Records      221

Any ideas on how I can add those labels in there?
PikOPS-Fuel-capture-Count-by-sum.rpt
0
Comment
Question by:Jasmin01
[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
  • 4
  • 2
9 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 250 total points
ID: 37770840
In the crosstab expert click 'Show Labels' in the Customize Style tab.
0
 

Author Comment

by:Jasmin01
ID: 37770883
Thanks.  But the fields are calculations, so, it's giving me a label of @CountFuelID.  Can I customise this label to something else?
0
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 250 total points
ID: 37770908
Try this

Right click the label
Click FORMAT FIELD
Click the COMMON TAB
Click the FORMULA button to the right of DISPLAY STRING
Enter the text you want

mlmcc
0
On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

 

Author Comment

by:Jasmin01
ID: 37770988
But there is no option called "Display String" on the common tab.  When I right click on the field, the option is FORMAT TEXT, not Format Field.
0
 

Author Comment

by:Jasmin01
ID: 37771295
Ok, I seemed to get it working but right-clicking and selecting "Edit Text". Now, I need this to be exported to Excel, and look legible, but at the moment, it is creating rather large columns on Excel  See attached.  Can you help?
PikOPS-Fuel-capture-Count-by-sum.rpt
PikOPS-Fuel-capture-Count-by-sum.xls
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 37771658
WHat options did you choose when you exported?

Without saved data we really can't try ideas to see if they will work.

mlmcc
0
 

Author Comment

by:Jasmin01
ID: 37775261
I am exporting with :

Column width - Column width based on objects in the WHOLE REPORT
Show Gridlines

I have attached a report with data.
pikops-fuel-capture-count-by-sum.xls
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

Suggested Solutions

Title # Comments Views Activity
Dynamic Image won't display if no data is returned 11 72
Rounding duration within 20 min intervals 3 47
Crystal Reports 2013 25 58
Sum of multiple formulas 6 28
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
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…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

749 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