Book a Demo

Author Topic: Supressing SQL Alias Names in RTF Reports  (Read 2666 times)

Grahame

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Supressing SQL Alias Names in RTF Reports
« on: September 03, 2013, 07:08:20 pm »
I've got a set of RTF reports that use custom SQL queries to get their data. In the query I've got an alias name for each value I want to use, and in the RTF template I'm displaying them in a table. This all works fine, but if it comes across a record where the field was empty instead of leaving a blank in the document it fills the space with the alias name used in the SQL query.

Is there a way to stop it doing this?

e.g.
SQL> Select id as objID, nameas objName from t_object
RTF Fragment> Insert a custom fields {objID} {objName }
Document>
123  Component 1
124  Component 2 Name
125  objName

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8110
  • Karma: +119/-20
    • View Profile
Re: Supressing SQL Alias Names in RTF Reports
« Reply #1 on: September 04, 2013, 09:01:49 am »
Sounds like you should be sending in a bug report. The behavior is at the very least inconsistent with behavior of other fields in rtf reports when empty.