AnsweredAssumed Answered

Indenting a field basted on the contents of another field

Question asked by BillPlunkett on Apr 17, 2013
Latest reply on Apr 18, 2013 by philmodjunk

Title

Indenting a field basted on the contents of another field

Post

     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:

     Operating Income

              Sales

                     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?

     thanks, bill

      

Outcomes