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:24 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/subscriptions/reporting/
📒 Documentation 📒
https://docs.devexpress.com/XtraReports/17387/detailed-guide-to-devexpress-reporting/bind-reports-to-data/sql-database/specify-query-parameters
🚀 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, #parameters, #parameterized,