Dynamic Parameter

[skordis]

I started using CR 11 very recently and this is my first time using a Dynamic Parameter.

Aside from the fact that I need to edit the registry to display the list of all the products that I am trying to chose from; When I add the dynamic parameter and chose a couple of product names to test, it still returns all the products.

Does it make any difference if you are using a stored procedure or the 'Add Command'?

Thanks

 

[IdoMillet]

Did you use the parameter in the report's record selection formula?

- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[skordis]

I did use the parameter in the record selection formula but whenever I refreshed the data or chose another product, it took a while to display the results.

 

[IdoMillet]

Your description is vague. Did the report SHOW all records (including those that were supposed to be filtered) or was just too slow?

It would help if you let us see the record selection condition.

See the faq's for how to speed up reports by ensuring the filtering occurs at the DBMS.

- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[skordis]

I apologize for the vagueness. I am very new to CR. My understanding from the Help files was that if I include the Dynamic parameter it should work regardless of including the parameter in the record selection formula and that it will get passed to the query.


I suppose I was wrong in my assumption.

Thank you for your help. I will check the FAQ's.

 

[IdoMillet]

You are still not clear on what the problem is (speed or no filtering at all) and you still don't show the record selection formula. I'll stop bothering you.

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com