Post reply

Condition with 2 datasets.

  • April 20, 2015 at 3:49 am

    #316867

    Hi, is it possible to put condition into expression when two values from two datasets are equal?

    For example. To set background color when values from one dataset are equal to another

    Max from Dataset2, the rest from Dataset1.

  • April 20, 2015 at 4:47 am

    #1791970

    Hi, Imho you can use the Lookup() or Lookupset() functions to retrieve data from two datasets based on lookup keys.

    Br.

    Mike

  • April 21, 2015 at 1:37 am

    #1792295

    Some more tips?

    With Lookup i got the error: not declared. - it only works for version above 2008

  • April 21, 2015 at 1:58 am

    #1792300

    Hi

    Yes, it works since 2008 R2, Let me check how I did it on SQL 2005 version, I had to dig out some

    older projects.

    Br.

    Mike

  • April 21, 2015 at 5:11 am

    #1792343

    any hints? 🙂

  • April 21, 2015 at 5:57 am

    #1792360

    Hi

    I checked a few of my projects and I usually combined different sources into single data set (stored procedure, query level), please just try out in this way.

    Br.

    Mike

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply