Skip to main content

The VertiGIS Community has been moved to the VertiGIS Support Center >>

Get Current records from related table in report

Ali VanSickle

This is probably very simple, yet I cannot figure it out. I am using my on prem version of Reporting (Version 5.15.2)

I have a Master-Detail layer report configured. I have the report set up as a table. The report will pull all features. I only want the details from the related table to appear if it was completed in the last year, but I still want the record to show up in the report even if there is no information from the related table.

The date is stored as an esriFieldTypeDate in my service. If I try to add this as a query in the Query Builder it fails: IsThisYear([Watermain Flushing Form.DATE_])

This is a sample of the datetime: 2021-04-16 12:00:25 PM

I also tried creating calculated fields using the GetYear() function as well. Not luck.

Any suggestions on how to achieve this? Basically I want to pull the record from the related table that was done this year. 

0

Comments

1 comment

Date Votes
  • Ali VanSickle

    I made a workaround by querying the data from the web service level and passing it into my report.

    YEAR(DATE_) = DATEPART(YEAR, GETDATE())

     

    1