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!

*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.

Jobs

PRINTING GROUP HEADER IN COLUMNS

PRINTING GROUP HEADER IN COLUMNS

(OP)
CRYSTAL REPORTS 2016
I have pulled all information into the details and have grouped based on their respective ID.
My problem is that the printout is way longer than the sheet & I wish to break printing into 2 columns on each page.
I realize that I can make columns in the details (now suppressed) but I need to make columns using the "Group Header #1".
Is there a way to print columns based on "Group Header #1"? I can find no way to make the group header print in columns.

RE: PRINTING GROUP HEADER IN COLUMNS

I would do this by using a command, you can then do grouping in SQL.
This then effectively makes your groups details and you can use the format multiple columns.

If you take SQL from your current report you can then modify to group as required and then paste this into a command object on a new report.

Ian

RE: PRINTING GROUP HEADER IN COLUMNS

2
You can do this by going into the section expert->details->check "Format with Multiple Columns" and then open the layout tab and also check "Format groups with multiple columns". You need to set the width of the columns and the gap to force the columns. Try setting the width to 3 in and the gap to 1 so you can see how it works.

You probably want to use the group expert->options to set the group header to repeat on each page.

-LB

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!

Resources

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