Possible to hide a sub-report if NULL values?

  • Thread starter Thread starter Mikael Lindqvist
  • Start date Start date
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
 
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.
 
Back
Top