Change title of columns in Reporting

[Guest Paul Alexander]

Hello

Didn't there used to be a 'rename' option when selecting columns in reports? I'm sure it used to be there, but I can't see it any more...and ideas please?

[Steven Boardman]

@Paul Alexander it seems to be working for me

Any other context you can add, type of report (Entity, SQL Designer etc)?  Which browser are you using?

If you navigate to another tab and come back do you still not see it?

Steve

[Guest Paul Alexander]

Hi Steve

it looks like it's only reports where the data source is 'controlled Sql' where we can't change the column names. Any report using an Entity as the data source DOES have the option.

We're using Chrome as the browser, but I've tried it on IE11 and it's still the same. 

 

Hopefully that might help shed some light on it!

 

thanks

 

Paul

 

 

[Victor]

1 hour ago, Paul Alexander said:

it looks like it's only reports where the data source is 'controlled Sql' where we can't change the column names.

Controlled SQL? ... Do you mean report using "SQL Schema Designer"? In any case, you should be able to amend column names for any type of report...

Can you please download and PM me the report definition file?

[Guest Paul Alexander]

I was referring to the Data Source in the list of reports:

 

These do seem to have 'SQL Scheme Designer' set as the 'report using' value:

 

They all seem to be the same, so would you still like me to download a definition file and send it to you?

 

thanks

 

 

[Victor]

@Paul Alexander well I learn something new every day ... had no idea is called like that in the list...

I could have a look in your instance if that's ok with you...

[Guest Paul Alexander]

@Victor it's all yours..............

[Victor]

@Paul Alexander ok, it seems you only get the option to rename the column if the report pulls data from multiple tables... if you only query one table, using "SQL Schema Designer" (instead of "Entity") the option is not there. Can't say if it is by design or not... I'll ask internally

[Steven Boardman]

@Paul Alexander if you are using the SQL Schemer Designer and only using one table, if you give the table an Alias (by double clicking on the table name in the Select Tables tab, then you should see the option to add custom titles to that tables columns in the select column tab, as below.

Let me know if this works for you

Steve

[Guest Paul Alexander]

Cheers @Steven Boardman that works a treat.

Has that option always been there?! I'm sure I've never seen it or heard of it before.......

thanks

[Victor]

@Paul Alexander the alias option? Yes, always been there but rarely used...

[Guest Paul Alexander]

At the risk of sounding like a smart-ar5e I reckon people WOULD use it if they knew it was there! I can't see any mention of it in the Wiki anywhere......jus saying!

[Victor]

@Paul Alexander nope, you definitely do not sound like anything you said ... you are right, it should be mentioned on the wiki...

[Steven Boardman]

@Paul Alexander we'll get the wiki updated