Solved

How to display large number of columns in CR?

Posted on 2006-06-12
6
711 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
  • 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
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 
LVL 1

Assisted Solution

by:wsinv
wsinv earned 30 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 45 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Query Builder on BOXIR2 7 48
Creating a New date by adding Todays Date by a number 6 46
Not Exists 3 53
display n/a in column 2 15
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. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

746 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

10 Experts available now in Live!

Get 1:1 Help Now