Long string parameters sending to Crystal Reports 8 coming from VFP6

[INFORMAT]

We make client/server applications in Visual Foxpro 6.0 and use Crystal Reports 8.0 as report designer. Microsoft SQL-server is the databaseserver.

In a list we want to use the multiselect principle: the user can select more than one line, then press right-mouse button and print a report. To send the selected lines to the reports, we create a parameter like:

thisform.OleControl1.ParameterFields(0) = "parPointers;'100','101','102';1"

This maens that we want to print something of the selected lines with pointers 100,101,102. OleControl1 is the crystal reports ActiveX-object on our form.

We have the following problem: if the "array" ('100','101','102') becomes to long (that is when the user selects to much lines at a time), we get an error from crystal reports like "invalid parameter field". The reason for this is that the parameter-string becomes to long (longer than the maximum string length)...

What can be the solution for this problem, or do we have to use another principle?

Thanks a lot,
BOLLE MARNICK,
Informat.

 

[dcm]

INFORMAT: This is a known problem - you will hit an upper limit to parameter string length. Only thing I can think of is to have more than 1 parameter but others here may have a workaround David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Seagate Enterprise Partner