?
Solved

How to properly vertically align elements in Crystal Reports XI

Posted on 2010-09-20
9
Medium Priority
?
1,005 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
[X]
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
  • 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
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

 

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
 

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 1000 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

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

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. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses

801 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