Скачать или смотреть Reporting: Filter Report Data on the Database Level Dynamically Using Parameterized Queries

Just like UI controls, reports render most efficiently if they use optimized data queries. If you allow users to customize aspects of a report using parameters, your queries can take advantage of the user-supplied values to retrieve only the set of data required for a report run. This approach is supported by different data source components and the following demo illustrates it for a JSON web service and a SQL Server database.

⏱ Timeline ⏱
0:00 Examine a report with a JSON web service data backend
1:13 A simple report parameter of type "number"
1:40 Add a query parameter for the web service URI
3:14 Save parameter definitions with the web service URI
4:20 Include a second query parameter with a complex JSON value
5:12 Construct the JSON parameter value dynamically
6:50 Switch to a report with a SQL Data Source
8:00 Set up a FilterString
10:00 Create a report and query parameter combination for filtering

⚡️⚡️⚡️ Overview ⚡️⚡️⚡️
https://www.devexpress.com/subscripti...

📒 Documentation 📒
https://docs.devexpress.com/XtraRepor...

🚀 Get Started Today – Free 30 Day Trial 🚀
http://dxpr.es/NUGET
http://dxpr.es/FREE-TRIAL

✅ Pricing and Online Demos ✅
http://dxpr.es/BUY
http://dxpr.es/DEMOS

🆘 We Are Here to Help 🆘
http://dxpr.es/SUPPORT

👍 Follow DevExpress on Social Media 👍
http://dxpr.es/FACEBOOK
http://dxpr.es/TWITTER
http://dxpr.es/BLOGS

🏁 Review Customer Testimonials 🏁
http://dxpr.es/TESTIMONIALS
http://dxpr.es/MARKETPLACE

#DevExpress, #devexpress_reports, #devexpress_desktop, #devexpress_winforms, #report_parameters, #query_parameters, #filter_report_data_dynamically,