×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

cross tab formatting

cross tab formatting

cross tab formatting

(OP)
I have very simple cross tab as follows where I have:
supressed the Total header and lines
but want to show the 2nd summary row text and amount in red font

there will only ever be 2 rows of data as below example


Non - restricted 100,000,000
restricted 5,000,000 ---> put all this in red

Tried to normal method of font control but cant seem to get it working on this crosstab

RE: cross tab formatting

Please explain the crosstab setup. Identify the row field, the column field if any, and the summary fields. I am unsure whether the restricted/non-restricted are two instances of your row field or two separate summaries displayed horizontally and labeled.

-LB

RE: cross tab formatting

(OP)
Row field is "ShortName" - this will output either Restricted or Non-Restricted
No column field
Summary field is "Amount"

As say its a very simple crosstab

I want it to show this type of example:

Non-Restricted 10,0000,000.00
Restricted 5,000,000.00 -- with this amount and text in red

RE: cross tab formatting

(OP)
IBass

No worries I have found how to do this using Highlighting Expert button - something I have never used in 20 years of using Crystal, Ive always used field format and then used X-2 button to place restrictions. Always something new to learn hiden away even though its in full view!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close