Rename Drill Through columns

Giulio Vialetto

Dear all,

 

I would kindly ask you if it is possible to rename columns name in Drill Through. As the picture attached below you could see that some columns have Column1, Column2..., these are the fields corresponding to the entities meanwhile Conto Contabile, QtaEvadibile... are data fields. BOARD allows me to add "AS" on data field when I define Drill Through to change their name but it does not allow me to use "AS" for the fields related to the entities. If I try to do it when I use drill through on a screen BOARD show me a generic error message. This environment uses BOARD 10.3. 

 

 

Thank you for all of the suggestion.

Domenico Panetta

Hi Giulio,

try this solution:

• use the manual datareader
• map all Board fields normally as usual (you can also repeat the same field because we are in manual)
• create your query
• assign aliases using "as" if you prefer (field 1 as "Cliente", field 2 as "Anno", etc)
• close your query into a new select statement (this to avoid the error you are talking about):
  • select one, two from (your query) as table

 

At this point modify your SQL Field by writing headers name manually as shown:

 

Let me know if everything is clear and if it works.

 

Regards

Domenico

Giulio Vialetto

Dear Domenico,

 

thank you for the reply. I tried as suggested but it didn't work. SQL database is SQL Server. As you see I tried as suggested and using browse it works

 

 

but here there is the error.

 

I checked and there are not error into SQL Log.

Pablo Luis Rodriguez Longhi

Hi Giulio,

I use too much the drill through (Board 10.6). May be is better if you create a view in sql and use this view in the definition, also the use of alias work fine .

I have this drill (work fine in Desktop version too):

and the definition is this one: