Skip to Content
0
Jun 25, 2009 at 07:33 AM

Crystal Report and Invoices printing

82 Views

I created a invoice layout from a COMMAND in SQL.

I created a SELECT command to extract ALL documents in OINV table.

I created 3 parameter fields to filter invoices at runtime: SERIES, STARTNUMBER and FINISHNUMBER.

This parameter fields are dynamic, so my purpose is that to show in the list the Series number and description that are present in the database.

Our customer has in the database all invoices from 2001 to 2009, about 500.000 documents in total.

Problem is that: In the list to choose the Series number I cannot see all the Series present in the database. It appears like the system show only the Series present in a limited set od record (in example, only the first 10.000) so I cannot choose the series for 2009 invoices.

The only temporary solution I found is that to insert manually a list od Series to filter the database. Problem is that, next year I need to manually update this list...

How can I allow the user to choose the correct Series number from a list that will be dynamically updated from the existents data in the DB?

Thanks in advance,

Jonny Cortonicchi