Crosstab in subreport does not print data wider than one page 
Author Message
 Crosstab in subreport does not print data wider than one page


My crosstab report won't print properly. All data that is not one the
first page will not be printed.

This is the situation:
I have a list of farmers that all have cattle that is inventoried and
counted on various occasions. The counts are per type of animal (cows,
sheep, etc.). So de basic query looks like

farmer, date, animal type, count.

I want to present this data as follows:
farmer 1
address etc.
        5/4     7/19    12/6    
cows    40      50      45      
sheep   3       6       4      

farmer 2
address etc.
        5/4     7/19    12/6    
cows    100     100     103
sheep   35      36      40      

Since I wanted to put some info for each farmer above the crosstab, I
thought about making an group for the farmer and putting the crosstab
in de details section. This appears not to be allowed. So I decided to
use a subreport in which the crosstab is put.

there are now to queries: 1 with all farmers for the main report and
the previous one for the subreport. Both are linked on the farmer.

This works fine, except for one detail. If I have many dates for one
farmer, the crosstab is wider than one page and the remainder will not
be printed. I can be previewed though, by double clicking the
subreport area.

Has anyone experienced this problem and found a solution to it? Or is
there a better way to get the layout described above?

Any help will be appreciated.


Roel Schreurs

Wed, 25 May 2005 00:06:43 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Problems with printing a wide crosstab in a subreport

2. Could not print cross tab wider than one page

3. Subreport -too much data for one page

4. Subreport header not printing on second page

5. Crystal Reports 7 not refreshing data when printing and printing blank pages

6. Post data from one page to another (BOA page)

7. Printing multiple graphs to one printed page

8. CR7: Subreports -- How do I make them print on the same page

9. How to print a page header in a subreport

10. Printing Blank Pages in VB 6.0 App - Report has 9 linked subreports

11. Word not printing total number of pages in page footer correctly

12. Reports with Subreports are not printed


Powered by phpBB® Forum Software