Custom columns in report queries

[ibmros]

Is it possible to select user defined custom columns when building a query structure? I see variables but not custom columns. Thanks.

Mark

[aner@we-can.co.]

Hey ibmros,

If i get you right, u wanna be able to build a report based on columns customized and names by you...

you can do it using varibles, by the `substring` function.

you should choose the field u want to be named differernt in "field", start index should be 0 and end index should be -1.

this will generate a new column.

in order to base the report with your brand new column, don`t forget to select and insert them in the "field" tab (in query editor) from the "varibles" tree.

hoped i was helpful.

Happy new year.

[ibmros]

Thanks for the info. I'm actually looking to add a custom column to a query. In the console window if you right click on one of the fields in the field set and go to edit custom columns you can define columns based on values from standard columns. It appears however that custom columns cannot be included in queries.