CiviCRM Community Forums (archive)

We've got CiviReport up and running, but our BIRT install does a few things oddly.

If I query for two columns of the same name (eg civicrm_membership_status.name and civicrm_membership_type.name), BIRT will always export the first as "name" and the second as "name_3". The number "3" is derived from the number of columns - if x.name is preceded by another column of the same name, and it is the third column, it will appear as name_3.

I've attempted to prevent BIRT doing this by both using SQL's "AS" alias, and by using the "Alias" and "Display Name" settings in BIRT's "Edit Data Set => Output Columns". Neither of these approaches works. BIRT does the same thing both installed via Tomcat as a web viewer, and in Eclipse on my desktop.

This is frustrating, because it's so easy to alias the column names in SQL, but the results just don't come out of BIRT! I've verified that the column names are correctly displayed if I copy the query from BIRT's query editor and paste it into MySQL CLI.

Looking forward to sharing tips and advice with other users who are newly familiar with BIRT!

I did, yes. The response was,

I haven't found your issue in 2.2.1.r221_v20070924 build. The column name is as the alias which defined in SQL but not a name with automatically suffix. If the column name are same with out define alias in SQL, it will add a number suffix and the number is will be the index of the columns' sequence. So would you like to try another build to reproduce it?

Thanks

Tianli

I'm using the same version and see this issue on both our OSX desktop, and Linux server.

Am I missing something w.r.t SQL's "AS"? Is that what Tianli would mean by "with out define alias in SQL", or is there some other syntax for alias definitions that I'm not aware of?