0

Else in a conditional replication

Jet Reports Historic Posts

January 09, 2017 16:45

None

Follow

I found this Jet knowledgebase article on how to do a conditional row replication: https://jetsupport.jetreports.com/hc/en-us/articles/219402997-Conditional-Replication.
This is great, but I need to build an Else into my conditional replication. Does anyone know how to build an Else into a conditional replication?

• Facebook
• Twitter
• LinkedIn

4 comments

• 
  Jet Reports Historic Posts January 09, 2017 22:13 Official comment

  It certainly is.
  
  Let's look at a rudimentary example mixing my original example and your settings.
  
  If F5 set to "Corp/Mgt" or "Farmworker", I want to draw information from my Customer table. Otherwise, I don't.
  
  Further, if F5 is "Corp/Mgt", I want customers from with a county code of AR. If F5 is "Farmworker", I want customers with a county code of FL.
  
  So…
  
  
  It would get a bit more complicated with additional possibilities in cell F5, but the concept would stay the same.
• 0
  
  Jet Reports Historic Posts January 09, 2017 20:51

  Hello -
  
  The concept behind Conditional Replication is that - if a condition is met, perform the replication… else, don't.
  
  The same technique can be used in different circumstances.
  
  For example, you can use the technique to draw data from two separate tables:
  
  [this example uses both conditional replication and also the embedding of NL(First) functions within an Excel IF() function ]
  
  What is it that you are trying to accomplish?
• 0
  
  Jet Reports Historic Posts January 09, 2017 21:12

  Thanks for your reply. Let's take your example in cell C5 a little further to explain what I'm trying to do. Say if B3 = 1, then return all rows where product type = X. But if B3 = 2, then return all rows where product type Y. Is it possible to do that?
  
  Here is the formula I'm working with. It works great. But, if F5 = "Farmworker", then I want to return rows where Class Code = "FARM".
  =NL("rows",IF($F$5="Corp/Mgt","Employee",{""}),"No.","+No.","*","Class Code","SALARY|HOURLY","Status","<>Terminated","link=","Employee Other Auth. Info","Employee No.","=No.","Filing Status Code","@@"&$D15)
  
  Thanks for the help!

• 0
  
  Jet Reports Historic Posts January 09, 2017 22:40

  HPDeskJet,
  
  You are a life saver! Thank you so much; it's working now.
  
  My final formula is:
  =NL("rows",IF(OR($F$5="Corp/Mgt",$F$5="Farmworker"),"Employee",{""}),"No.","+No.","*","Class Code",IF($F$5="Corp/Mgt","SALARY|HOURLY","FARM"),"Status","<>Terminated","link=","Employee Other Auth. Info","Employee No.","=No.","Filing Status Code","@@"&$D15)