Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Export to Excel Alignment problem

Posted on 2004-09-02
6
304 Views
Last Modified: 2008-03-04
Hi Experts,

I have a report composed of 5 columns namely:
AcctID
AcctDesc
Balance1
Balance2
Total

AcctID and AcctDesc are declared inside a formula while the Balance1 and 2 are fields from the table. Total is a formula which is equal to Balance1 + Balance 2.
I can't combine AcctID and AcctDesc into one formula because AcctID will be displayed on a different color (blue) while the rest of the objects will be in black. Another thing is we have a function that once you double-click on AcctID (during preview), a report will be called which acts as something like a details info about the AcctID.

On the report interface (a VB6 form) we provided to let user select possible options, we have an option (checkbox) that will allow user to mark if he/she wants to display AcctID.
What I am doing was to overlap AcctID and AcctDesc (AcctDesc on top of AcctID). So that if checkbox is unmarked, AcctDesc will be alligned to the leftmost side of the paper. If checkbox is marked, AcctID will be on the leftmost and followed by the AcctDesc (I have some coding on the AcctDesc formula to somehow add few spaces so that it will look like they are not overlapping when you preview the report).
The report looks good when I preview and print it but if I export it to excel, Balance1, 2 and Total columns are not align with the column heading.

It seems that when you export a report with overlapping fields/formulas, crystal will try to allocate spaces for each overlapped objects. This will cause the total fields to be moved a column or 2 away.

I'm using cr10, VB6 and MSSQL 2000

Please Help,

zerobro
0
Comment
Question by:zerobro
  • 2
6 Comments
 
LVL 42

Accepted Solution

by:
frodoman earned 75 total points
ID: 11962251
>>> It seems that when you export a report with overlapping fields/formulas, crystal will try to allocate spaces for each overlapped objects.

This is correct and unfortunately there's nothing you can do about it except change your fields so that they don't overlap.  Here's the Crystal 10 document on the topic if you want more information: http://support.businessobjects.com/communityCS/TechnicalPapers/cr10_export_excel.pdf.asp

frodoman
0
 

Author Comment

by:zerobro
ID: 11969347
Hi frodoman,

I've tried overlay sections (the AcctID on the 1st and AcctDesc on the 2nd) but it seems overlay doesn't work also.
Any idea as to why overlay/overlap sections didn't work?

zerobro
0
 
LVL 42

Expert Comment

by:frodoman
ID: 12151171
TheLearnedOne,

I believe my response was accurate - meaning that the behavior described is correct and can't be changed.  The askers followup posting was about a specific thing he tried that didn't work but it was redundant after I'd already indicated that nothing can be done to change the export behavior.

Thanks (as always) for consideration,

frodoman
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question