custom variables in report column descriptions?

[CNelsen]

Next report question:
Is there a way to use a custom variable in the description field in the layout of a report?
I know built in variables such as &osuser or &dbuser work but I can't seem to get it to work for custom variables.

I have a select column based on a variable from a list:

&<Name="Search On"
         List="i.Chain_Id, ""Chain Id"",
               i.Order_Key, ""Order Key"",
               i.Old_Order_Key, ""Old Order Key"""
         Description = "yes"
         Restricted = "yes"
         Required="yes"
         Default="Chain Id"> Search_Key,

And in the layout I have the Search_Key set with a Master/Detail Break.
But I would like the column header to reflect the actual value of the "Search On" variable.

Any ideas for a work around?

Thanks,
Christian

 

[Marco Kalter]

This does indeed not work for substitution variables. This is on the list of enhancement requests though.

 

[CNelsen]

Thanks,
I did find one work-around though it's a bit volatile. If I create 3 columns for each of the 3 possible descriptions I'm looking for, I can set each of them with the Master/Break.
Then if I remove the columns without updating the layout screen my variable column will use the layout style for which ever column matches.
Of course, if I refresh the columns in the layout tab these all disappear.

Christian