Solved

How to span columns across multiple pages?

Posted on 2008-10-08
7
519 Views
Last Modified: 2012-08-13
I have a table with 30 columns and 100 records. How can I display this table in Crystal Reports in tabular format across multiple pages? For example, if the first page can only show columns 1 to 10 and only records 1 to 25, then the second page should display columns 11 to 20 of records 1 to 25 and so on. Is this possible?
0
Comment
Question by:killdurst
[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
  • 3
7 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 22676182
I would have thought that this would be many times easier in Excel.
0
 
LVL 1

Author Comment

by:killdurst
ID: 22676258
Haha... yeah man... me too. Unfortunately, I don't have a choice. :( Have to try to do it in Crystal Reports first... Until a Crystal Reports expert can officially say that it can't be done.
0
 
LVL 77

Expert Comment

by:peter57r
ID: 22676474
Are you saying it is always 100 records?
Do they have an id field which allows for selection into groups of 25?
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 1

Author Comment

by:killdurst
ID: 22676556
Nope, it is not always 100 records and we don't have an id field which allows for selection into groups of 25.
0
 
LVL 77

Accepted Solution

by:
peter57r earned 500 total points
ID: 22677039
Then I think you have achieved your aim.

I don't think it is possible to do this in CR.

The only standard report in CR which allows for horizontal pages is a crosstab and it doesn't sound like your data qualifies for such a report. (or OLAP which also doesn't sound relevant)

The other solutions I can think of require at least an id field so that you can make sure that different pages have the same set of records in the same order.  If that were true then you could possibly devise a solution based around subreports, or the use of a sql command to create 3 copies of records which could be printed in different groups.  I also considered exporting to pdf and manipulating printing from there but I still can't see how you could do this.
You might want to leave this a bit longer though - in case someone has a suggested answer.
 
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 22854430
As stated by peter57r, there is no Crystal solution for your problem.

Accept - 22677039 - peter57r

mlmcc
0
 
LVL 1

Author Closing Comment

by:killdurst
ID: 31504559
Thanks for participating.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone 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

Suggested Solutions

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. …
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

710 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