Community
Showing results for 
Search instead for 
Do you mean 
Reply

Doesnt show results that dont have a Note

New Member
Posts: 2
Country: Australia

Doesnt show results that dont have a Note

I am an outsourced IT guy.

My client uses ACT.

She runs a query where "Notes" is a sub table/query.

She wants to show everyone, but the result only shows people who actually have a Note.

If they dont have a Note listed, they do not get printed.

I am guessing at a Join or something in the query, but I cannot find the sql syntax part in ACT.

 

Some guidance would be helpful.

Cheers.

Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: Doesnt show results that dont have a Note

You would need to edit the report template and set the Hide on Empty Subreports property to No.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
New Member
Posts: 2
Country: Australia

Re: Doesnt show results that dont have a Note

Sounds like a plan Roy.

So, can you please tell me click by click?

 

I can open the template and find the notes section.

If I double click Notes, it takes me to the sub report template. Correct?

 

What do I do now?

Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: Doesnt show results that dont have a Note

In the main body of the template, view the properties for the detail section and set the Hide on Empty Subreports property to No.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129