Clarity

  • Private Community
Back to discussions
Expand all | Collapse all

Under Advance Reporting/Ad Hoc views why is it not possible to add the OBS field data in the reports? Please see attachment.

  • 1.  Under Advance Reporting/Ad Hoc views why is it not possible to add the OBS field data in the reports? Please see attachment.

    Posted Jul 27, 2017 03:15 PM
      |   view attached

    Under Advance Reporting/Ad Hoc Views we are trying to create a report to show the actual data within the projects/OBS work category field on a report–

     

    Why can’t we just call the field and get the output of field on an adhoc report like the example below?

    Example:

     

    This is what we want – call Work Category under OBS and have the output of what is in the field to be output on the report.–

    We want to understand why we are unable to pull data out of the database for this report it should be just like every other field like Project ID?

    Attachment(s)

    docx
    OBS Issue.docx   49 KB 1 version


  • 2.  Re: Under Advance Reporting/Ad Hoc views why is it not possible to add the OBS field data in the reports? Please see attachment.

    Posted Jul 28, 2017 02:30 AM

    That is possible. You can select that information from OBS node in Domains. A screenshot below.



  • 3.  Re: Under Advance Reporting/Ad Hoc views why is it not possible to add the OBS field data in the reports? Please see attachment.

    Posted Jul 28, 2017 03:02 AM

    Hi michellenowicky81982758,

     

    You can select the work category and sponsor OBS which I believe can be selected through OBS Type. Then you can select The OBS Path for them. However, it might result in multiple rows for based on these two. I think you might need some further customization to get it in single row.