Missing Pages when report is run.

[valkyrie69]

I have developed some reports for our sales database and I have set up an access database with crystal report controls to call the report. Problem is that the viewer and printer refuse to print or view much more than the 1st five or six pages. some of the reports go to 300 pages or more.
Can anyone suggest what may be the problem. The main data source for the report is a sql database which is being called via odbc.

It is better to ask for for directions rather than wander blindly... Where am I and why did I ever get into I.T.

 

[synapsevampire]

How does your viewer and printer demonstrate that it's refusing? Do you get an error?

What viewer are you using, and what version of CR?

Here's the sample VBA application whitepaper:

http://support.crystaldecisions.com/communityCS/FilesAndUpdates/rdc_vba.exe.asp

-k

 

[valkyrie69]

Hi Thanks for responding. The viewer will allow you to flick through the first 4 or five pages then will just refuse to select the next pages.
Sometimes if you click to go through to the last page you are taken to it and then from that page you can vavigate back 5 or 6 pages.
Printer only ever seems to have the first 4 or 5 pages sent to it and prints those perfectly but there are no error messages. the viewer does not lock-up and no error message is generated. Crystal reports 8.5 professional is the version i have at the minute along with windows 2000 on a compaq p4 pc

It is better to ask for for directions rather than wander blindly... Where am I and why did I ever get into I.T.