# IReport - Error in field names with capital letters

**URL:** <https://forum.servoy.com/t/ireport-error-in-field-names-with-capital-letters/13187>\
**Category:** Classic Servoy\
**Created:** [November 15, 2010, 10:42pm UTC](https://forum.servoy.com/t/ireport-error-in-field-names-with-capital-letters/13187 "2010-11-15T22:42:21Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![erikd](https://avatars.discourse-cdn.com/v4/letter/e/b782af/32.png) [@erikd](https://forum.servoy.com/u/erikd)\
**Post date:** [November 15, 2010, 10:42pm UTC](https://forum.servoy.com/t/ireport-error-in-field-names-with-capital-letters/13187/1 "2010-11-15T22:42:21Z")

</div>

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?

Thanks

---

<div class="post-metadata">

**Author:** ![stefbrt](https://avatars.discourse-cdn.com/v4/letter/s/858c86/32.png) [@stefbrt](https://forum.servoy.com/u/stefbrt)\
**Post date:** [November 16, 2010, 9:35am UTC](https://forum.servoy.com/t/ireport-error-in-field-names-with-capital-letters/13187/2 "2010-11-16T09:35:49Z")

</div>

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.

Regards

---

<div class="post-metadata">

**Author:** ![rgansevles](https://avatars.discourse-cdn.com/v4/letter/r/3d9bf3/32.png) [@rgansevles](https://forum.servoy.com/u/rgansevles)\
**Post date:** [November 17, 2010, 10:10am UTC](https://forum.servoy.com/t/ireport-error-in-field-names-with-capital-letters/13187/3 "2010-11-17T10:10:32Z")

</div>

Erik,

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 \_.

Rob

---

<div class="post-metadata">

**Author:** ![stefbrt](https://avatars.discourse-cdn.com/v4/letter/s/858c86/32.png) [@stefbrt](https://forum.servoy.com/u/stefbrt)\
**Post date:** [November 17, 2010, 11:12am UTC](https://forum.servoy.com/t/ireport-error-in-field-names-with-capital-letters/13187/4 "2010-11-17T11:12:27Z")

</div>

why they are replaced to lowercase? is it not possible to leave them uppercase?

---

<div class="post-metadata">

**Author:** ![pbakker](https://avatars.discourse-cdn.com/v4/letter/p/a4c791/32.png) [@pbakker](https://forum.servoy.com/u/pbakker)\
**Post date:** [November 17, 2010, 11:26am UTC](https://forum.servoy.com/t/ireport-error-in-field-names-with-capital-letters/13187/5 "2010-11-17T11:26:37Z")

</div>

Servoy is cross database and most databases support just support lower cases attribute names.

Paul