Agilent Community
Agilent Community
  • User
  • Site
  • Search the Community
  • User
  • Home
  • Technical Areas
    Technical Areas
    • AssayMap
    • Atomic Spectroscopy
    • Automated Electrophoresis
    • Cell Analysis
    • Consumables
    • CrossLab Connect
      CrossLab Connect
      • Service Management
      • Smart Alerts
    • Dissolution
    • GC
    • GC/MS
    • LC
    • LC/MS
    • Life Sciences Reagents
    • Molecular Spectroscopy
      Molecular Spectroscopy
      • Molecular Spectroscopy - UV-Vis & UV-Vis-NIR, FTIR, Raman & Fluorescence
      • 8700 LDIR User Group
      • Transmission Raman User Group
    • Real-Time PCR (qPCR)
    • Sample Preparation
    • Software
      Software
      • Chromatography Software
        OpenLab CDS, OpenLab ChemStation, OpenLab EZChrom
      • Data Management Software
        OpenLab ECM, OpenLab ECM XT, OpenLab Server
      • Mass Spectrometry Software
        Data Analysis, Data Acquisition, Productivity App, WalkUp Software
    • Vacuum
  • Applications Areas
    Applications Areas
    • Basic Research
    • Energy and Chemicals
    • Environmental
    • Food and Agriculture
  • Agilent Knowledge Portal
  • Links
    Links
    • Collection of Support Resources
    • Webinar Notifications
    • Contact Support
    • User Contributions
  • Getting Started
    Community Help and Resources
  • Browse
    Browse
    • People
    • Places
    • Your View
    • Your Community Inbox
Chromatography Software
  • Technical Areas
Chromatography Software
Wiki How to .. hide a table row based on a calculated value (OpenLAB CDS Intelligent Reporting)
  • Announcements
  • Forum
  • Articles
  • Videos
  • Wiki
  • More
  • Cancel
Actions
  • Share
  • More
  • Cancel
Table of Contents
  • +Software Collection of Resources
  • 7694B Headspace Sampler Software Support
  • Another calibration report for OpenLAB CDS ChemStation
  • Another calibration report for OpenLAB CDS EZChrom
  • Autostart macro failed error 999 in OpenLAB CDS ChemStation
  • Belarc Advisor for PC Profiling
  • Calculate date and time differences - Save date and time in IR
  • Calibration History Report (OpenLAB CDS)
  • Chemstation .CSV generation Decimal Places
  • Chemstation Chemmain Error During Startup
  • ChemStation Scheduler Commands
  • OpenLab CDS and Windows 7 Podcast
  • Computer Maintenance
  • Configuring OpenLAB CDS Chemstation for a 6890 with 3rd party detector
  • Connection to selected server failed Error 1068 - dependency service failed
  • DAMethod Register Export
  • Error Message "No Signals Available" appears when loading data
  • Error Message: Vial Range -1 to -1 - OpenLAB CDS Chemstation
  • Error: No Export File Selections Made Yet - OpenLAB CDS Chemstation
  • How to .. hide a table row based on a calculated value (OpenLAB CDS Intelligent Reporting)
  • How to ... add a percent sign to a PRSD number.
  • How to ... add LC diagnostic data to Intelligent Reports (OpenLAB CDS Intelligent Reporting)
  • How to ... add several comments to your report template without generating extra space on the report (OpenLAB CDS Intelligent Reporting)
  • How to ... align text boxes to the editor's grid (OpenLAB CDS Intelligent Reporting)
  • How to ... align uncalibrated peaks in 2 or more signals
  • How to ... auto-extract signals from a UV iso-absorbance plot
  • How to ... calculate summary statistics on computed numbers
  • How to ... calculate with a specific mutiplier or dilution factor generated by OpenLAB CDS EZChrom
  • How to ... filter for EZChrom run types QC Standard  (OpenLAB CDS Intelligent Reporting)
  • How to ... populate the template editor with your data
  • How to ... print ChemStation's live system values (OpenLAB CDS Intelligent Reporting)
  • How to ... report the number of repeated injections with OpenLAB CDS EZChrom
  • How to ... report the output of a category aggregator  (OpenLAB CDS Intelligent Reporting)
  • How to ... store a date stamp as a variable? (OpenLAB CDS Intelligent Reporting)
  • How to ... use external report parameters (OpenLAB CDS Intelligent Reporting)
  • How to ...  setup an array of compound specific parameters
  • How to configure Agilent GC headspace system within Waters Empower and ICF
  • How To Overlay Chromatograms in OpenLab ChemStation
  • How to... report sequence related customized parameters (OpenLab ChemStation Intelligent Reporting)
  • HowTo : Report the n Biggest Peaks of a sample analysis (OpenLab CDS Custom Calculator)
  • KB: Useful Free Third-Party Software Tools
  • Little script to print Text and Numbers as Results ( e.g. below detection limits ) (OpenLAB CDS Intelligent Reporting)
  • LookInMyPC - PC Profiling and Diagnostics
  • Make your own custom way of displaying the Date and Time in your reports
  • Migrating from OpenLAB CDS EZChrom Edition to OpenLab CDS Version 2.3 – Workstation to Workstation
  • MSD Error: HPMSAXQ0.DLL failed upon launching Openlab - OpenLAB CDS Chemstation
  • Notepad++
  • Openlab CDS C.01.07 and 6890 classic driver
  • Reprocessing data using a new calibration table
  • Sequence Aborted Due to File Access Error - OpenLAB CDS Chemstation
  • Sequence container/result set data will not load in navigation panel - OpenLAB CDS Chemstation
  • Video Series: OpenLab CDS for ChemStation Users
Still Need Help?

Post your question in our User Forum or Contact Support.

How to .. hide a table row based on a calculated value (OpenLAB CDS Intelligent Reporting)

Created by Agilent Agilent over 3 years ago | Last modified by kristen.sensabaugh kristen.sensabaugh over 2 years ago

In order to avoid circular references, the usage of calculation variables or aggregators in filter expressions is prohibited.

 

When using iif (...) statements in the table cell definitions it is possible to hide the values that do not fulfill the if condition - however, the empty result lines are not shrunk and appear on the report.

 

The visibility of individual table rows cannot be toggled with them means of the Report Template Editor, but using  Microsoft BI studio you could hide individual table rows based on a calculated expressions. The values are not erased like in a filter, but simply hidden.

 

If you do not have a BI studio development system at hand you could use the following procedure to make use of the feature:

 

Procedure:

  • Set up a helper table to calculate your aggregator: e.g. average area
  • Hide the entire helper table
  • Add a second table you would use for the result output
  • Use a dummy column where you would set up a filter condition like:

= iif(Peak_Area>Avg(area),Peak_Area,"")

  • Upon saving the template this syntax gets translated to the correct RDL syntax

=iif(Fields!PEAK_AREA.Value>Code.area.Avg(),……

  • Open the template in an XML editor and navigate to Body  > ReportItems > List > ReportItems > Table > Details >TableRows > TableRow
  • In the section

</TableCells>

      <Height>0.21in</Height>

         </TableRow>

Add a section like

</TableCells>

   <Height>0.21in</Height>

     <Visibility>

       <Hidden>=iif(Fields!PEAK_AREA.Value&gt;Code.area.Avg(),False,True)</Hidden>

     </Visibility>

   </TableRow>

 

The output of the filter must be …,False,True

 

(originally posted in OpenLAB Forum: https://zohodiscussions.com/openlabcdsforum#Topic/68030000000172001

2015 April 13 by betrich)

Attachments:
2015-0413_HideTableRows.rdl.zip
  • OpenLab CDS
  • OpenLab Intelligent Reporting
  • row
  • OpenLab
  • report table
  • Intelligent Reporting
  • filter
  • table
  • Share
  • History
  • More
  • Cancel
  • Sign in to reply
  • petur
    petur over 5 years ago

    Using C.01.07 SR4 version of OpenLAB Chemstation

    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • More
    • Cancel
  • petur
    petur over 5 years ago

    How would that code look if you used a fixed value instead of average and height instead of peak area?

     

    Regards, Pétur Ari

    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • More
    • Cancel
Was this helpful?
  • Yes
  • No
Thank you for your feedback!

Agilent Community Feedback

Agilent Community Feedback

×
We are glad this was helpful! We are sorry this was not helpful. If you still need assistance please create a community post or contact support. To help us improve, please provide any additional feedback. For full details of how we will treat your information, please view our privacy policy.
Submit Cancel
Submit Cancel
Related
Privacy Statement
Terms of Use
Contact Us
Site Help