Jump to content
Changes to the Jaspersoft community edition download ×

Table Columns containing spaces


Recommended Posts

By: Mark Smith - ubbogus

Table Columns containing spaces

2003-06-12 17:14

Trying to use simple query report and I'm having problems when my database's table's column name contains whitespace.

If my table's column name contains whitespace is it possible to specify a valid "field" element which will map to the column in my ResultSet?

I believe this may be a bug but I wanted to know if anyone else has encountered/overcame this issue.

 

Any help would be greatly appreciated.

 

Thanks

Mark

 

 

 

 

By: Teodor Danciu - teodord

RE: Table Columns containing spaces

2003-06-15 13:29

 

Hi,

 

This is not a bug.

Is just that report fields, parameters, groups and variables cannot

have spaces or dots in their name.

 

To overcome this you can use aliases for the columns

returned by your SQL query:

 

SELECT MyTableColumn AS MyReportFieldName FROM MyTable

 

I hope this helps.

Teodor

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...