Forum Discussion
Retrieve data on table click
Hello - I have a datasource that by default connects to a SQL table and retrieves all data. Too much data to place into a report table. I'm trying to filter the data on click from another tabl...
Hi konlin22 ,
If you want to filter data before loading into data model, you can enter your requirements in SQL statement.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the replies. I would like to use the SQL statement option, but I can't figure out how to pass the parameter from the first table. For example, if I could create a data statement like:
SELECT * From OrderDetails WHERE ORDERID = '@orderID'
And then pass the orderID parameter from the selected row in my first data table. That would save me retrieving 100,000 + records and then filtering locally. And it would be quicker.
Any help would be appreciated. thanks