Good Afternoon Telerik,
Currently, I have 1 report where I am searching for all the machines in the database using a parameter querying Machine OS(with values in it like Android, IPhone, Windows 10, Windows 8, etc..). It is located in a table called Assets. Here is a sample query of what I am querying. When I run the table with the only sql datasource it returns my selection on the preview data. However, when I run it on the Telerik server the parameter field on the right hand side is completely blank with no values.
SELECT
at.machine name, at.machineos
FROM assets at
WHERE at.machineos IN (:MachineOS)
However, when I add a new SQLDataSource with the same information above and attach the datasource under the parameter to that. It displays the values and correctly queries the data. How can I get it to retrieve the values of the first datasource without making another datasource with the same exact query?
(I should also mention, the database is running on a oracle server)
1 Answer, 1 is accepted
Hello Austin,
If I understood correctly, you would like to have the Machine OS values listed under the Report Parameter AvailableValues.
If so, you need to have a SqlDataSource that doesn't perform filtering, so that it may extract all of the values. Then, in the Table DataSource, you would be able to filter by the selected values.
Generally, when there is no filtering by the ReportParameter, you may use the same SqlDataSource for both the Report Parameter and the Table. If you have filtering by the selected values in the Report Parameter though, you need to introduce an additional SqlDataSource for the parameter that is not filtered. The reason is that otherwise, there will be a circular dependency in the Report Parameter. On the one hand, the available values will depend on the selected parameter value, and on the other, the latter will depend on the available values.
Regards,
Todor
Progress Telerik