• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 453
  • Last Modified:

Crystal Reports - Adding labels to Crosstab report

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
Jasmin01
Asked:
Jasmin01
  • 4
  • 2
2 Solutions
 
peter57rCommented:
In the crosstab expert click 'Show Labels' in the Customize Style tab.
0
 
Jasmin01Author Commented:
Thanks.  But the fields are calculations, so, it's giving me a label of @CountFuelID.  Can I customise this label to something else?
0
 
mlmccCommented:
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
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
Jasmin01Author Commented:
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
 
Jasmin01Author Commented:
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
 
mlmccCommented:
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
 
Jasmin01Author Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now