I have a report that shows provider information and client information, when the user selects what client status to see on the report I don't want this to effect how the rest of the report runs. If the user selects Active then I want Active clients to print on the report, if the user selects All I want all clients to print regardless of client status, but if the user selects None this means do not print any clients on the report (but I still want the provider information to print). I am not sure 1) if I need to pass parameter to the report query, 2)if I do how write the sql to not use the expression when the client status is none, 3)if I don't and use the print when expression how to I define the parameter so it knows what All means?
The Best possible way to achieve what you are looking for is to create a parameter driven SQL to run your report. For detailed explanation, check my blog http://www.rajeshsirsikar.com/?p=286