Query Secondary datasource - InfoPath Dev
in

InfoPath Dev

Query Secondary datasource

Last post 04-07-2013 08:14 PM by Hilary Stoupa. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 04-04-2013 01:59 PM

    Query Secondary datasource

    I am trying to display the monthly totalsavings value of the rows from a secondary data connection based on the dropdown selections on my form. My problem is the total depends on 2 fields.check if use_adjustedvalues field is no then sum savings field else sum adjustment field.Is it possible to query each row and take that value from either field to total?  Any help would be appreciated.

     

    Thanks!

  • 04-07-2013 08:14 PM In reply to

    Re: Query Secondary datasource

     I'd use calculated values (expression boxes) - one with the value of each field - and hide the one you don't need based on conditional formatting using your checkbox. Does that make sense?

    Hilary Stoupa

Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.