Solved

How to properly vertically align elements in Crystal Reports XI

Posted on 2010-09-20
9
882 Views
Last Modified: 2013-01-03
CrystalReportIssue.doc

I cannot get rid of unnecessary columns .. and have the report more readable in XLS.
0
Comment
Question by:djbeam
  • 5
  • 4
9 Comments
 
LVL 26

Expert Comment

by:Kurt Reinhardt
ID: 33718028
If you go into the cross-tab expert to the Customize Style Tab, you can uncheck the "Show Cell Margins" setting.  This provides a much cleaner export to Excel.  I just created a simple crosstab based on the Orders table in the Xtreme Sample Database.  With default settings, the 5 column crosstab (including rows and the total colum) occupied at least 9 columns in Excel.  After turning off cell margins, only 5 columns were exported, as desired.

The downside is that it doesn't look great in Crystal Reports.  So, do you need the report to look good in both?  If so, you might want to add a parameter to allow the user to select Crystal or Excel format at run-time and then conditionally suppress two different versions of the same crosstab, based upon the parameter selected by the end user.

~Kurt
0
 

Author Comment

by:djbeam
ID: 33718113
Thanks .. two issues

1 - I do not seem to be able to get the Customize Style tab active when I highlight the current Xtab .. where would I find this .. (sorry I do not use Crystal every day so I spend a lot of time search for things that are obvious to active users)

2 - why is the process to get "Total" to display nicely and a single column .. different for the individual columns.

tanx.. Don
0
 
LVL 26

Expert Comment

by:Kurt Reinhardt
ID: 33718536
1)  Right-click the crosstab and select crosstab expert
2)  Because it allows one to format the total columns separately (bolded text, shading, different colors, etc..)

~Kurt
0
 

Author Comment

by:djbeam
ID: 33718724
Thanks .. we are getting closer .. however .. not the brass ring ...

We now have some columns that are displaying and exporting okay .. but not all ...
Column "0" takes up 2 columns ..columns 1-5 take up 1.. 6 and 7 take up 2 . .but 8 to Total take up one.

???????

Don
CrystalReportIssue.1.jpg
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 

Author Comment

by:djbeam
ID: 33720647
anyone with any suggestions how to make all the numbers use only one column .. ?
0
 
LVL 26

Expert Comment

by:Kurt Reinhardt
ID: 33720764
The reason you're running into continued issues most likely has to do with the fact that you're exporting header information, too.  If you exported just the crosstab, with no cell margins, it would probably come out formatted properly.  Remember, Excel is very different than Crystal in terms of formatting.  The export wizard basically tries to export things as WYSIWYG as possible.

~Kurt
0
 

Author Comment

by:djbeam
ID: 33724438
I can appreciate that .. but what I find interesting is that the bulk of the export is aligned .. and where the header is as well .. .My 40+ years in IT look for things that are unique to cause issues .. this does not make sense .. but welcome to IT .. .

So other than exporting only the matrix .. you see no other solution .. is so thanks for the help .. .Don
0
 
LVL 26

Accepted Solution

by:
Kurt Reinhardt earned 500 total points
ID: 33725649
When I'm asked to build a new report, one of the first questions I ask during the requirements gathering process is "What are you going to do with it after it's done?"  If the intent is for the report to be exported to Excel, I think ask "Why?"  This helps me determine exactly how I'm going to design the report.  When exporting to Excel, which is trickier than .pdf or Word, due to the cells, there are limitations. You've run into some.

In your case, why does the data need to be in Excel?  Are they going to manipulate the results?  If so, how?  Why can't you give them the metrics they need in the first place so they don't need to manipulate the data?If they provide the business rules, you can most likely do what they need in Crystal. Remember, Crystal Reports are best presented in Crystal Reports format.  On top of that, the data isn't one step further removed from the source.  When you deliver a report and x number of people export it to Excel for their own purposes, x number of people can all show up at a meeting with different results...

~Kurt
0
 

Author Closing Comment

by:djbeam
ID: 33758389
I did not get an answer .. but it could be because there is not one.
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

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…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

762 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now