×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

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

Exporting reports to XLS

Exporting reports to XLS

Exporting reports to XLS

(OP)
CR2008.  I have several reports that the user wants to export to Excel and do some further manipulating and reporting.  Presently, when the reports are exported some of the cells are merged and cause problems when they are being referenced in another worksheet within the workbook.
How do I get a *clean* export from CR without cells getting merged?  Is this a formatting issue? I have tried Excel data-only many different ways and it is worse than exporting as regular Excel format.

For instance, the Sales Rep worksheet has a value I want to bring to the Summary worksheet --> 234020.31;
I see the following formula in the Summary worksheet cell: ='Sales Rep'!Y154:Z155 - resulting in a formula error.

Background: Reports have two groups and two subreports within them. The details are being suppressed. I am also using *underlay following section* for group footer #2a so that #2b prints in the same line.  Group footer #1 is where I am having my trouble with the merged cells, but I believe this is not causing my issue.  

Any ideas?

keith

 

RE: Exporting reports to XLS

It will be because you have different cell sizes in the subreport.

By trial and error you must get the Main report and Sub Rep cells to line up in columns.

Best way to do this is use guides and anchor all cells to them vertically.

Ian

RE: Exporting reports to XLS

My Grid User Function Libary lets you have total control of where values appear in an exported CSV file.  Works great across subreports as well

Download a trial version from my web site.

Editor and Publisher of Crystal Clear
www.chelseatech.co.nz/pubs.htm

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