Dynamic colum titles

Applications Grid / Reports
#1

Hello Everyone. I’m developing my first ScriptCase app, really, really happy with the product.

This is my question:
I have some columns in my database that have a standard name, say “Student”.

But due to my app requirements, this column could be titled “Student” in some particular instance of the application, and “Member” o “Individual” in other instance (another client using my app, with their own database).

I have a configuration table where the user can enter the title string he wants for this column.

But… how can I show this string in Grids or Reports? I know it’s not possible using the Data Dictionary because the strings there are static, and my titles are read at runtime from the Database, ergo, they are dynamic.

Any ideas or directions will be appreciated.

Thanks.

#2

Use a global variable as label for the column (i.e. [col_title]).
Read your database and set the variable in the onApplicationInit event.

jsb

#3

[SOLVED] Dynamic column titles

Thank you very much, jsbinca, I’m trying it and let you know! So simple…

[QUOTE=jsbinca;36943]Use a global variable as label for the column (i.e. [col_title]).
Read your database and set the variable in the onApplicationInit event.

jsb[/QUOTE]

#4

You can also change the column label using the SC macro sc_label({My_Field}) in Grids and Forms.