• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 536
  • Last Modified:

How to span columns across multiple pages?

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
killdurst
Asked:
killdurst
  • 3
  • 3
1 Solution
 
peter57rCommented:
I would have thought that this would be many times easier in Excel.
0
 
killdurstAuthor Commented:
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
 
peter57rCommented:
Are you saying it is always 100 records?
Do they have an id field which allows for selection into groups of 25?
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
killdurstAuthor Commented:
Nope, it is not always 100 records and we don't have an id field which allows for selection into groups of 25.
0
 
peter57rCommented:
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
 
mlmccCommented:
As stated by peter57r, there is no Crystal solution for your problem.

Accept - 22677039 - peter57r

mlmcc
0
 
killdurstAuthor Commented:
Thanks for participating.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now