Easier way to change a reports source?

[Aycex]

I am using Crystal reports to make post cards with variable data. The problem is when i hit 6 thousand cards it starts messing up the data so I am limited to 6k at a time. Now I am pulling this data off of a ACCESS quesry and that is fine. What I need to know is if all the field names are the same is there any way to change the query they are coming from. I write my queries to pull 6k at a time so the first would be 1-6000, then 6001 - 12000 and so on. The field names are all the same just the data it pulls and its name is different is there a way to do this?

 

[synapsevampire]

You might try adding a numeric range parameter and in the Report->Selection Formula->Record place:

recordnumber in {?MyRange}

This should limit the rows to the records you specify at runtime, or you can hardcode in values if it's scheduled for the ranges required.

Although I'm curious why you can't just run them all, obviously sharing your software version and describing what "messing up" means would be useful.

-k

 

[Aycex]

I am sorry I am using Crystal Reports 8.5. When I say messing up when I export it to PDF if i try and do 6k or more it starts dropping fonts and changing margins and just not exporting correctly. If i go over about 10k it will error out the export, and when you are talking about having 300k records or more it would certainly die horribly before finishing the report. I could run them all in Crystal reports easily enough it is just exporting them from crystal reports to PDF that has problems. Also I am limiting the records as per the query in access, I am not sure how to do this at run time but if you could explain in a bit more detail and if it can be changed it would be much more efficient.

 

[synapsevampire]

Don't limit the rows returned by the query from within Access, instead do so as I've described above.

Not sure what sort of clarification to that you seek.

I think that I looked into your concern a while back, and of course creating 300K PDFs isn't what was intended by the product, nor by Crystal, it's indicative of a bad requirement in that they're unable to focus their business intelligence to answering questions, rather becoming reliant upon humans downstream to process results from a large document.

-k

 

[Aycex]

The clarification neede is where i put the record number in range, as i am new to crystal reports and I have never used it to limit I have only limited it on the access side...

 

[synapsevampire]

Not sure what " is where i put the record number in range" means.

I stated how to traverse the Crystal menu to get you where you need to be, and what to place in the record selection to limit the rows, perhaps you don't know how to create a parameter?

Right click the parameters and select new, and make sure that it's a numeric type and that range is selected.

I suggest that you try what I suggested prior to saying that you don't know how to do it, I spelled it out pretty clearly there.

-k