exporting a crystal report with a selection formula

[soskinny]

when i export my crystal report into a pdf format, the selection formula doesn't work. All records are returned. Does anyone know how to fix this?

Thanks...

[venerable bede]

I did something similar about 6 months ago but didnt' have the same problem.

The code I used actually generated the Crystal report first, then I think it saved the report then performed the pdf export on the saved file.

If you're interested I can see if I can dig the code out but it's at home so you'll have to wait till tomorrow.

Just let me know.

[soskinny]

Thanks VB.

I solved the problem. I was applying the selection formula to the viewer- which was how my documentation told me to apply it, but you can also apply it to the report object:

oRpt.datadefinition.recordselectformula=selectform

syntax is approximate.

If you want, though, post your code here. I searched the forums for my problem and I didn't see anything on it for these boards.

Thanks for the reply!