+5I developed this report on Visual Studio 2017 with FSM extension.
The idea was to give to user some possibilities to generate the report.
It is working fine as the picture below.
After setting up the Report admin registry for this report.
I getting this error for the same filter:
The task_id field is setup like:
What should I do to fix this issue ?
Hi
I believe you need to change the operator from contains to equal. As an example the baseline task report you would use equal 245|264 to get both tasks.
Regards,
Morris
+5Same problem.
I don't think it is a SQL exception because Visual Studio was able to export a report. I don't get it.
+28I believe you need to set the taskid as numeric (int), and not varchar
Cheers!
+5The purpose of doing this is to apply a similar filtering as we can do through the web client. It allows the user to combine multiple task_ids into the report.
If filled with only one task_id, it works, but that's not the intention.
+28Thanks for the clarifications.
Do you have space characters in the parameters? Looks like from the screenshot.
Cheers!
+28I am out of ideas. The only thought is a product bug or compatibility issue.
What version of FSM do you run?
According to R&D VS 2019 is the preferred version for developing a report
Reports Support with FSM | IFS Community
Cheers!
rather than declaring it as a variable using ‘SET’
can you try to use it directly in the where query. Also use the ‘equal’ as the operator
Something like below
where task.task_id ##TaskID $$TaskId OR @TaskId is null
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.