Forum Discussion
No Option to Select Parameters when Applying a Filter to Datasets
Hello Maggie,
Thanks for your reply. I finally got to the bottom of the problem.
It seems like the parameter format/type has to match the column format exactly. So, in my case, I imported a table from SQL Server using a stored procedure and hence date column came through in datetime format i.e. yyyy-mm-dd hh:mm:ss. However, parameter type was set to date. When I changed the parameter type to date/time everything started to work.
Hopefully, this will help others as well if they come across with a similar issue.
Community SupportHi Anonymous
When i test with a simple dataset, i can apply parameter correctly.
dataset:
parameter1
parameter2
Apply parameter
Could you show some screenshots of your columns and parameters?
Best Regards
Maggie
Hello Maggie,
Thanks for your reply. I finally got to the bottom of the problem.
It seems like the parameter format/type has to match the column format exactly. So, in my case, I imported a table from SQL Server using a stored procedure and hence date column came through in datetime format i.e. yyyy-mm-dd hh:mm:ss. However, parameter type was set to date. When I changed the parameter type to date/time everything started to work.
Hopefully, this will help others as well if they come across with a similar issue.