Method:Classic General Q&A

Re: Conditionally Hide Detail1 row in Report Designer - Invoice(Product)

sbradley — Thu, 11 Jul 2013 17:51:57 GMT

Perfect! Thanks for your help. Part of it was the = vs ==, part of it was I was not referencing the InvoiceLine child object of Invoice, just the global InvoiceLine object which was messing up my references.

Re: Conditionally Hide Detail1 row in Report Designer - Invoice(Product)

Method_Samuel — Thu, 11 Jul 2013 13:42:04 GMT

Hey sbradley,

I've tested this with rows and it does work, but there are a few things to consider:

1) Ensure you are using "==" and not "=" to compare. i.e. IsNullOrEmpty([Item])==True

2) Also once you are finished editing the formatting rule it must be added to the Formatting Rule Editor List (picture below)

3) Lastly, if this is a Detail Report (a sub report for each Detail) then you must set the Data Member for the formatting rule.

I've attach some pictures to hopefully make it a bit clearer.

Sam

Conditionally Hide Detail1 row in Report Designer - Invoice(Product)

sbradley — Tue, 09 Jul 2013 19:41:22 GMT

Hi there,

I'm trying to conditionally hide Detail1 rows where the InvoiceLine.Invoice.Desc field is empty or is null, but it doesn't seem to be working as expected. I've set the condition to IsNullOrEmpty([Item])=True in the Formatting Rule, with the result being Visible = False. The control I've applied this to is the Detail1 control itself, to hide the entire row. When I preview the invoice in Report Designer, or even Print Preview one from within Method, the effect does not appear to have been applied. Any ideas?

Thanks,

-S