In one of my requirement in the report I have 3 filters like plant, category and customer.
In the store procedure I have used split function to select multiple values for these 3 filters. when after executing the report , By Default report displays all the values but in the filters i have seen like for
Customer: BOA,Chase,US Bank. Instead of that i need to see ALL default option in all the filters:
like Customer:ALL,Category:ALL, Plant: ALL.
how Can I achieve this? i am using SQL Server 2008 R2
View Complete Post