How can i filter d repot fields at runtime...

nikks9 · June 9th, 2006, 05:14 AM

i am using CR9 with vb.net....

c i want to filter some data fields, at the runtime from crystal report ,is it possible.....?
if yes, how can i do it...?

Nikhil

Raghavendra_Mudugal · June 9th, 2006, 05:41 AM

Hello Nikhil

This is i follow...
Create a SP with the in params what you want to pass. Make sure after passing
the params, the SP is giving the proper output at DB level only, then refer
this SP in report.

use parameter method of the ReportDocument object and pass the value to it
at the run time. So this will effect to the SP, there you have the data
as needed to your inputs from the GUI.

Actually I follow this way. Hope you may find better way than this.

Hope this helps.

With Regards,
Raghavendra Mudugal