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!

*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

Lining Up Text with Cross Tab Report

Lining Up Text with Cross Tab Report

Lining Up Text with Cross Tab Report

I have multi Cross Tabs for Financial Statements for multiple Companies.  I am not using any data in the rows or columns sections, only in the Summarized Fields section, so I have to Insert text for each line item.  

Is there a simple method in lining up a text object horizontaly with the field it describes.  I usually can do it for a few, but there are so many and I do not have time.

Can anyone give advice or a tip.

CR 11 - Jason

ie.   Text Object           {ME0709Financials.Depr}  

RE: Lining Up Text with Cross Tab Report

I can't think of a reason you would use a crosstab without rows or columns. Why not just enter text fields and the result without the crosstab?


RE: Lining Up Text with Cross Tab Report

It is only because I am doing Financials, so a lot of the final results depencd on Formulas.  If I use the Cross Tab, it becomes misconstrued.

I am using the Summary portion for the Data to get my results, but I still need explanation from the Insert Text function for the Numbers to have relevance.

Is there a way for lining up the Text function with the field in which it is in corelation?


CR 11 - Jason

RE: Lining Up Text with Cross Tab Report

I think you missed my point. I don't think you should be using a crosstab at all. You can instead place your formulas directly in the detail section and insert summaries on them.

In the main report you can align text with fields by attaching them both to the same horizontal guidelines. You can also right click on the gray area to the left of the report->select all section objects->format objects->make same size:  height->align: bottoms.


RE: Lining Up Text with Cross Tab Report

You were right.  Thanks for the tip!

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