Indenting a field basted on the contents of another field
I have a pretty standard budgeting app and I bet someone has a solution to this issue.
I have a table of budget line items with both detail records with budget amounts and a some records that are group dividers. Such as the following:
Widget items $50.00
I have a filed in the table to identify the indent level as H1 for the Operating Income line, H2 for the Sales line and DD for the detail line.
In a report, how can I casue the description field to indent based on the value of a different field. I thought maybe conditional formatting could be used but doesn't seem like it. Thought about 3 different description fields then how would you select which one to print.
Anyone have a soultion to this?