You’re offline. This is a read only version of the page.
375
Hello Every one,
I have the following ssrs report using data provider i need to select all warehouses when the warehouse filter is null how can i write this in select statment
*This post is locked for comments
Hi Nikolaos ,
thank you very much it working with me when i use the query
And of course you can add a standard query in your report. I see now that you haven't added any query to your data provider. Depending on your requirement, maybe you can handle the Warehouse field, and also others, with the standard query.
This should be your primary tool. You should add custom data provider dialog fields only if the report query isn't sufficient to resolve your requirement.
Hi Nikolaos,
I already do this but what can i do if i have multi parameters it's very defucult to use if statement
Hi Nikolaos,
I already do this but what can i do if i have multi parameters it's very defucult to use if statement
You need to have two versions of the select statement, one with the warehouse filter and one without. Then, depending if _warehouse is '' or has value, you run the corresponding select statement.
Instead of two different select statements, you can also use a Query object, and add a range for warehouse number only if _warehouse has value.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (