Topic: Adding an extra field to the query results in a broken report

Hello friends,


I am having a weird problem. My report is working fine, but, as soon as i try to add an extra field from the table to be used as data in the report (in MVD > button > add data > open report in designer) the report breaks and i get an error ".... is not a valid integer" (an error on a field that worked before, and has nothing to do with the field that is added.


Any ideas?


Anyway i am trying to get the value of an id from a table in the report, could i use an SQLExecute in Fast Report?

Something like this in a Label: SQLExecute('SELECT field FROM table WHERE id = ...');

What would be the correct syntax?



Thanks in advance!

Re: Adding an extra field to the query results in a broken report

Hi Kristof,
If you can attach the project and indicate the newly added field, I can have a look and see if I can spot anything.
Derek.

Re: Adding an extra field to the query results in a broken report

Hello derek!

Thank you for the help (again)! I had a quick look again and i found the issue myself, i had a report value (StrToInt..., i removed this and now the error is gone and the report shows the value of the newly added field.