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

Report Wrap

Report Wrap

(OP)
I am working up a report that a customer would take from a spreadsheet and copy and paste into a word document for presentation. The report in Excel yielded 8 rows, but 17 columns. In order to present the report, they copied the first 8 columns and pasted them in the report, then copied and pasted the remaining 9 columns right below. Essentially like a word wrap, but on the whole table.

I am trying to re-create this in CR, but not sure if my solution is reliable. I am planning to use a report with two sub reports, each sub report holding 8 and 9 columns of data, then placing the sub reports in the main reaport that will simply contain the header/footer information.

Any other solutions?

Thanks all

JJ

RE: Report Wrap

In the report's details, put cols 1-8,
then right click in details
"Insert section below"
D is now Da
and you have Db
In Db, put columns 9-17

line columns up,resize etc,note loss of column headings for fields 9-17
You can prefix the fields in Db with text boxes if required.
Save

export as Excel data only, maintain relative position
col 9 is now below column 1,
one record appears on 2 excel rows.
Beauty of this is, no subreports required.smile
If you export same without checking the maintain relative position, al1 17 cols appear on one line

You could create the word doc for them if you page break after the Db and exported to Word RTF

I do this all the time but can't post examples due to security restrictions by my employer.

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