Whenever I create a report file using IReport with field names in capital letters, Servoy can’t run it because the foundset automatically converts all fields to small letters, which makes it inconsistent with the db field name copy.
For example, if the exact db field name is “titleText”, using Database JDBC connection, IReport will extract the same file name, “titleText”, and insert it in the JRXML file as textfield. In Servoy, it has extracted the same field name as “titletext”, so when I use the foundset as parameter to the report file, “titleText” has no data and causes and error.
Does this mean, all field names that will be used in IReport should be in small letters? Is there a workaround on this?
I never got this error because we do not use camelCase for DB-attributes. But this seems to be an bug. You should create an issue in the Support system.
With reports on foundsets you can use Servoy dataproviders in your report, not sql columns.
Servoy dataprovider names are not the same as sql column names, when they are based on db columns their names are made lowercase and spaces are replaces with _.