Hi I have created report now in report i have multiple dropdown where data is coming from database but ALL option also i have added. Report Type --Select-- Summary Report Moved Object Report Maintenance Report Analysis Report Warranty Report Barcode Report Missing Report Object Type ALL Movable Immovable Location ALL trichy Chennai bangalore From Vendor Name ALL Lenovo PHILIPS Hcl Object ALL Washing1 Oven Refridgerator test object Department ALL Electronicsaa Automobile test department To Now how to give condition if i want to search report data based on location or department or vendor name ... so on with two conditions if selected value is ALL then all details should come or selected value is value then based on that data should come from database. if i ll put if else condition then it ll be many conditions i have to put that i don't want. I am not getting how to do that.I want help. If question will not clear please let me know.

Answer

select multiple dropdown in VB.Net

rachayita jaiswal

11y

1.1k

Hi, I have created report, now in report i have multiple dropdown where data is coming from database but "ALL" option also i have added.

Report Type	Object Type	Location	From

Vendor Name	Object	Department	To

Now how to give condition if i want to search report data based on "location" or "department" or "vendor name" ... so on with two conditions if selected value is "ALL" then all details should come or selected value is "value" then based on that data should come from database.

if i ll put if else condition then it ll be many conditions i have to put that i don't want.

I am not getting how to do that.I want help.

If question will not clear please let me know.