How to apply filters in crystal report through asp or pass parameter value to stored procedure?
Posted on 2004-03-31
I have crystal report 8.0, IE 6.0 and database sql server 2000.
I want to develop the following application.
A crystal report is comming from a table A. Through asp the user can select any column of table and then any values of this column, and these values will be applied to report as filter. Either it can be applied directly to report as filter or pass to stored procedure which can use these values into its where clause or any other easy solution. I need only end result, which is filter the reports data.
C1 C2 C3
1 alex 600
2 john 200
3 ami 700
4 frank 100
5 fred 500
user can select any column and then value for example he selects
C1(2,3) and C2(alex,john)
Now when user will click on report link and report will bring all data from table A
where c1 in (2,3) and C2(alex,john).
I need very urgent help.
Thanks in advance.