Can Crystal Parameters be passed to a Foxpro View First

[cinbh]

We are using dbf's from Visual Foxpro 7.0 and since I'm limited by the amount of links when I execute in Crystal,

ACTUAL ERROR MESSAGE IS:
ODBC error[Microsfoft][ODBC Visual Fox Pro Driver] SQL: Too Many Subqueries

so I've had to set up a couple of local views which is fine, BUT my crystal report really only needs a subset of the information that is generated by these views. Rather than grind the system to a halt (and we are NOT planning on allowing endusers into the view areas) I would like to have the user's Crystal parameters be passed FIRST to the view which would limit the data while allowing me to print the user prompts on the report. Let me know if this is possible and if so what sort of programming might accomplish it.
Thank you.
Cindy

 

[synapsevampire]

Can you add the criteria into the record selection criteria, as in:

{MyView.MyField1} = {?Parm1}
and
{MyView.MyField2} = {parm2}

This should pass the values along, I haven't done it with views, but it works with a .dbf, so I'd think it does.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[cinbh]

I gave it a shot, but I get a program error crw32.exe which says it's writing to error log but nothing shows in it for me.

 

[cinbh]

I went ahead and reset another test using your feedback saved the report first and gave it another run, seems to be working now. Have to check my data but THANK YOU for the quick response K!
Cindy