Guest Paul Alexander Posted May 14, 2018 Share Posted May 14, 2018 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? Link to comment Share on other sites More sharing options...
Steven Boardman Posted May 14, 2018 Share Posted May 14, 2018 @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 Link to comment Share on other sites More sharing options...
Guest Paul Alexander Posted May 15, 2018 Share Posted May 15, 2018 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 Link to comment Share on other sites More sharing options...
Victor Posted May 15, 2018 Share Posted May 15, 2018 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? Link to comment Share on other sites More sharing options...
Guest Paul Alexander Posted May 15, 2018 Share Posted May 15, 2018 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 Link to comment Share on other sites More sharing options...
Victor Posted May 15, 2018 Share Posted May 15, 2018 @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... Link to comment Share on other sites More sharing options...
Guest Paul Alexander Posted May 15, 2018 Share Posted May 15, 2018 @Victor it's all yours.............. Link to comment Share on other sites More sharing options...
Victor Posted May 15, 2018 Share Posted May 15, 2018 @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 Link to comment Share on other sites More sharing options...
Steven Boardman Posted May 15, 2018 Share Posted May 15, 2018 @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 Link to comment Share on other sites More sharing options...
Guest Paul Alexander Posted May 15, 2018 Share Posted May 15, 2018 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 Link to comment Share on other sites More sharing options...
Victor Posted May 15, 2018 Share Posted May 15, 2018 @Paul Alexander the alias option? Yes, always been there but rarely used... Link to comment Share on other sites More sharing options...
Guest Paul Alexander Posted May 15, 2018 Share Posted May 15, 2018 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! Link to comment Share on other sites More sharing options...
Victor Posted May 15, 2018 Share Posted May 15, 2018 @Paul Alexander nope, you definitely do not sound like anything you said ... you are right, it should be mentioned on the wiki... Link to comment Share on other sites More sharing options...
Steven Boardman Posted May 15, 2018 Share Posted May 15, 2018 @Paul Alexander we'll get the wiki updated Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now