2 Replies Latest reply: Aug 15, 2011 2:49 PM by Jonathan Dienst RSS

    Expressions in a table

      I'm trying to set up a few reports (lists) where the report should be described in an external source (in this example as inline)


      LOAD * INLINE [
          Report, Line, Text, Expression
          1, 1, "Line 1 - A1", "sum(  { <Account='A1'> } Amount)"
          1, 2, "Line 2 - A2", "sum(  { <Account='A2'> } Amount)"
          1, 3, "Line 3 - A3", "sum(  { <Account='A3'> } Amount)"
          2, 1, "Line 1 - B1", "sum(  { <Account='B1'> } Amount)"
          2, 2, "Line 2 - B2", "sum(  { <Account='B2'> } Amount)"
          2, 3, "Line 3 - B3", "sum(  { <Account='B3'> } Amount)"
          2, 4, "Line 4 - B4", "sum(  { <Account='B4'> } Amount)"    



      So, by selecting either report 1 or 2, It would use different expressions (set analysis) for the report.

      Is that possible in any way?


      Best regards


        • Expressions in a table
          Goran Korsgren

          Hi Steen


          Yes I think it is possible, but you may have to add a variable (vExpression for instance), and add triggers on the field so this variable is set when you select one of the Expression values.


          Then you can use $(vExpression) as the expression for the report.



            • Re: Expressions in a table
              Jonathan Dienst



              This is simple if you have one line per report, but not so simple with two dimensions (report and line). You might get a simpler solution if your table was something like:


              Report, Text1, Expression1, Text2, Expression2, ... Textn, Expressionn


              Then, if you select a report, you can get the expression for each line using (say 3 for example)




              Tip: best if your report selection list box is set to "one and only one" selection.


              You may be able to use your structure by selecting both report and line (either from list boxes or through set analysis) and using




              Hope that helps