Possible to hide a sub-report if NULL values?

M

Mikael Lindqvist

Hi,

I have created a report (column) that list open invoices and I have also
attached a sub-report (different table) that displayes comments.

Problem: sub-report is showing for all invoices, but I would like it to show
ONLY for invoices that has a comment.

That is, invoices that has no comments only list their usual values, and
invoices with comments I have a sub-report displaying the comment.

Is that possible? (otherwise my invoice-list with contain a lot of
unecessary space - used by the sub-report).

Kindly,
Mikael
 
M

Marshall Barton

Mikael said:
I have created a report (column) that list open invoices and I have also
attached a sub-report (different table) that displayes comments.

Problem: sub-report is showing for all invoices, but I would like it to show
ONLY for invoices that has a comment.

That is, invoices that has no comments only list their usual values, and
invoices with comments I have a sub-report displaying the comment.

Is that possible? (otherwise my invoice-list with contain a lot of
unecessary space - used by the sub-report).


Have you set the CanShrink property for both the subreport
control and for its section?

Make sure the subreport control's Link Master/Child Fields
properties are set appropriately.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top