Report Start expression: List of businesses


I’m trying to pull in 3 data sets from “Business” table by <Start:Business><<[Business name]>><< End>> from an “Application” table. I have the below set up.

The below are the business names I want to pull in but with no success. There’s no error that appears as well so I couldn’t troubleshoot what’s happening.
Screen Shot 2020-07-08 at 10.57.18 AM

Any suggestions?


1 Like

Hi @LeventK thank you for this. I had to restructure my data to be able to pull things from tables. And I have actually learned some limitation of the < < Start > > like the formula is only working horizontally. My question though is why does it erase data from the table where I pull in data from when I delete the key, which is my entry, in “Application” table. Here’s how the structure looks like.

The above is my application table where I choose “Client Id” and serves as the key as well.

The above is the table where I pull data from.

The data in the “Business” table gets erased when I delete an an entry in my “Application” table.

This workflow works like the below:

  1. Choose Client Id from the list in “Application” table
  2. Data is fetched from “Business” table
  3. Send email to appmaker

Any help will be appreciated. Thanks.

Please check and verify if your ref column is set with isPartof property set to ON. If so, when you delete a parent record, related child records are erased as well.

1 Like

@LeventK Thank you for your help. Working perfectly now!


You’re welcome. Glad to hear that you have solved the issue.