Hi all,

I have generated a bunch of reports for my clients and creted a form
in VB for them to input SelectionFormula and SortField at run-time.
The rports came out the way I want them to be.  I also want to print
the Selection and Sort information on the top of the report but not
able to figure a way.

I tried to look for any methods in Crystal OCX to allow me to do this
and couldn't find anything.  I guess I have to create some sort of
string and pass them back to crystal.  Can anyone give me a hint on
how to accomplich this?  Or is there a better way?

Thanks!

Fan

PassSelect as ''
and print it where you what it.

in vb set formulas(0) = "PassSelect='" & recordselctionformula & "'"
-------------------------------------------------------------

 http://home.rica.net/wmingee      

What I do is:

When I build the SelectionFormula, I also build the User Fiendly Criteria
String and them pass it back to the Crystal Report as a formula.

That the only way I know!

Then, set the Formulas property in the VBX/OCX to redefine these
formulas.  Then they will print out the info you want.

i.e.
Report1.Formulas(0) = "SelectionFormula = " & Report1.SelectionFormula

you can do the same for the SortFields...

Jeremy Markman