Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CR11- format fields in drill down tree 1

Status
Not open for further replies.

azoe

Technical User
Feb 21, 2005
175
US
In my report I have formatted the fields in groups and detail sections but I would like to do the same in the drill down tree?

Thank you -
 
I am not sure what you are trying to format...are you trying to change the font color in the tree? I don't know if that is possible. You can format the way a tree selection appears as far as syntax by customizing a group name with a formula though.
 
Oh, sorry - no I have a number that I want to appear with no formatting and instead it has 2 decimal places and a comma in the thousands place.
Of couse I can format the field in the details section and I did it in the group header but they still have the decimals, etc over there in the tree and I don't know where to format it. But you are saying I can do it with a format in the group name? I'm not sure what the formula would be but I could try that.
 
If you change the Report-Options->Fonts default to have no separator and no decimals it will observe it (possibly only for future reports, but test).

Otherwise you'd have to convert the field to a string I think, which may cause sortation problems.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top