12-23-2022, 06:58 AM
Suppose we are creating data set in that we want to show the data based on selected row in a column:-
1)select name,gender,sum(amount) as total from restaurant_data where gender =@gender@
so when we run this query in data set it gives gender column data=Male and female ,based on select it shows data accordingly..
All filter
2) select name,app,gender,sum(amount) as total from restaurant_data where (app=@app@ or "All"=@app@)
* it means if we select ALL in filter ,it shows data for all Apps,,
1)select name,gender,sum(amount) as total from restaurant_data where gender =@gender@
so when we run this query in data set it gives gender column data=Male and female ,based on select it shows data accordingly..
All filter
2) select name,app,gender,sum(amount) as total from restaurant_data where (app=@app@ or "All"=@app@)
* it means if we select ALL in filter ,it shows data for all Apps,,