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
Jasmin01Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

peter57rCommented:
In the crosstab expert click 'Show Labels' in the Customize Style tab.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
OWASP Proactive Controls

Learn the most important control and control categories that every architect and developer should include in their projects.

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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.