I am passing a value to a formula from VB. The formula is used in the record selection formula. Crystal reports performs a query for all records (no criteria) then does the same query again with the record selection formula as criteria. Is there a way to eliminate the query that returns all records? My idea was to use a parameter, but we don't want the user to have to enter a value. Can I give the paramater a value using the passed variable? This did not work [?Parameter] := [@formula] or [?Parameter] = [@formula]
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.