Building a sql string for multiple selections..?

[Joffies]

Hi.

I have a listbox (checked style) that loades with codes.
I want to select certain codes to filter my crystal report with. How wil i build my querystring?

I code example would be helpfull!

Is there a specific syntax that crystal use? Is there an easy way to implement this. I currently use the ocx. in my application. This application is already in a production environment so to update or add componennts would be difficult at this moment.

Any advice would be appreciated.

Thanks

[john_murphy]

R U using SQL Server.

if so you could create a stored procedure that takes the query filters and appends them you could pass these to the crystal report from the vb code.

using the OCX you can submit the query but this could get very messy and security could be an issue.

[Joffies]

Hello again.

Well i have figured it out but....... I do work with sql server! I build a string according to the codes loaded in the Listbox and then pass this string to the parameter in the crystal report. The only problem is that crystal only accepts strings with no more then 256 characters through a parameter! Any idea how i can get around this as the string i build could easily ber more then 256. Maybe an array or something?

Thanks

[Joffies]

Version 9 of crystal reports accepts up to 64,000 characters. I am currently using version 8.5. Go figure.....