Lookup or Filter multiple datasets in an Expression? RRS feed

  • Question

  • Hi 

    I am new to Visual Studio and am trying to find my feet.

    I have a totals form which I can use an Expression to select all the data from multiple datasets fine, but I am wanting to filter the results to just show a single user at a time on my form. (Dataset shows Users and Grand Totals)

    Is it possible to use an Expression to say (Select ["Grand Totals" from Dataset1] where ["User" from Dataset1] = "Julie Smith") ?

    Thank you 


    • Moved by Amanda Zhu Monday, December 15, 2014 6:59 AM
    Saturday, December 13, 2014 1:26 PM