?
Solved

How to display large number of columns in CR?

Posted on 2006-06-12
6
Medium Priority
?
718 Views
Last Modified: 2009-12-16
Hello,

I was asked to grab data from 6 tables and and display most of the data in them, which total 65 data fields. How do I display so many fields?

One thing I'm thinking of doing, is to let the user SELECT the fields that they want to see at any specific time -- they don't need to see all of them at the same time, but some this time, some that time, and basically I need to make all 65 data fields available for them to select from. Is there a way to do that?

Thanks.

0
Comment
Question by:minjiezen
[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
  • 3
  • 2
6 Comments
 
LVL 26

Expert Comment

by:Kurt Reinhardt
ID: 16889956
Crystal Reports isn't really designed to do this (although you  might be able to do something programmatically) or display that many columns of data.  Generally speaking,   I would revisit the requirement with the user/customer and try to understand the reason why they are asking for this.  Should this be a 'hard' requirement, then I would suggest writing the report specifically for export to MS Excel, which is better for large numbers of columns.  Then, you don't necessarily have to figure out a way to allow the selection of certain columns - just return them all...

~Kurt
0
 

Author Comment

by:minjiezen
ID: 16894346
Hello Kurt, thanks for the reply! How do I write a report specifically for export to MS Excel? Or is there a link to an example? Thanks.
0
 

Author Comment

by:minjiezen
ID: 16894744
I could put at most 20 fields in the CR (cannot go further to the right). How do I fit all 65 fields in the "Detail" section in one line?
Thanks.
0
Want to be a Web Developer? Get Certified Today!

Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!

 
LVL 1

Assisted Solution

by:wsinv
wsinv earned 120 total points
ID: 16894954
You can make the details section as long as you want to. However, the fields do not show uo in design view, so you have to place the fields on the report in preview mode.

To extend the width of the report, follow the steps below;

open your report.

go to design view.

right click on the report and pick "Section Expert".

select the details section - check the "Format with Multiple Colums" box.

Now the Layout Tab should be viewable in the top right.

on the layout tab, enter a value for the width field.  i.e. 28. = 28"  

You can now control the width of your report to add as many rows as you like. (Really only good for exporting into Excel...)

Good Luck,

wsinv

 
0
 
LVL 26

Accepted Solution

by:
Kurt Reinhardt earned 180 total points
ID: 16895709
1)  You can change the paper size and orientation to fit all fields.  You can also create a custom paper size to accommodate any width as long as your printer will support it.  Check out the following:

http://support.businessobjects.com/library/kbase/articles/c2010175.asp

2)  If you want to design a report that is intended to be viewed as data-only in Excel (after export) then here are some tips:

a)  Suppress all sections except the page header and detail section
b)  Make all fields in the detail section the same width, which doesn't have to be as wide as the actual field allows
c)  Use guidelines between every field
d)  make sure there's no white space between fields - place them all flush with each other

The report will look ugly in Crystal, but will export very nicely into Excel

3)  This isn't really what 'Format with Multiple Columns' is used for, although I seems pretty creative.  The purpose of the multiple column formatting is to create a report with newspaper type columns where the each column is an extension of the previous column after it reaches the end of a page.  I can see how making an extremely wide column would allow one to  add  multiple fields, however.  Like I said, creative:).

~Kurt
0
 

Author Comment

by:minjiezen
ID: 16897767
Hi guys, thank you very much!
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

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…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

766 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