Wednesday, March 21, 2012

Dataset and Filters

Hi !

I have a quick question. If i have a report that show invoice by suppliers. Sometime i would like the report to diplayed all suppliers and sometimes for only one suppliers. Can i do this using the filters property of the dateset? Or did i have to create 2 reports. One for the case All suppliers and the other for the case Only one suppliers?

Thank and sorry about my bad English ^_^
Just play with the parameters
2 ways I can think of
1. Add a "ALL" parameter above all suppliers
(need to play with your DataSet query with UNION)

2. Use the multi-value option provided in report parameter
(it'll end up passing into dynamic sql as .... WHERE supplier IN (@.parameter)|||Thanks for your answer. I"ve tried what you told me and it works !

Thanks again !