6 Replies Latest reply: Dec 27, 2011 3:31 AM by Martin Olsen RSS

    How can I combine data from one dataset to another in the front-end

      Hello all,

       

      I am working on a report which compares the values from one parameter to another whith a common variable "Batch".

      As you can see in the attachment I have one dataset with 3 columns (batch, parameter, value). I want to make a selection of 2 of those parameters and use the first selected parameter (linked value) as dimension and the other parameter (linked value) for the expression. Because the dataset holds very much parameters I would rather not generate a column for each parameter. In stead I want to form a dataset when the selection is made.


      Hopefully my description (in combination with the attachement) is clear. I am open for alternatives if I'm not on the wright track.
      Thanks in advance for the reply.


      Best regards Tom