I am creating a monstrous all in one report in OpenLAB CDS 2.5 that can calculate USP <905> Content Uniformity Acceptance Values, Assay Values, Impurity Values calculated multiple different ways, and Retention Time ID. I would like to try and keep this all in 1 report for ease of maintaining, and for analyst convenience however not all sections would apply all of the time. Is there a way to set up the report to ideally exclude sections that don't have any data? I am using the Injection_SampleLabel field to flag the data so it can be grouped into the correct sections. My ideal outcome would be when the report is generated, if there are no samples for a given result section, that whole section would be skipped/omitted from the final report. Is this possible, and if so, how?
If my ideal option is not possible, how can I go about setting the report up so that when there is no data for a given result section the report gives a text field stating that "No data for <section> present in this result sequence. This section is not applicable and therefor blank." in place of the section? What formatting options are there to make the text box eye catching and easy to spot?
