Get Current records from related table in report

Ali VanSickle

24 Maj 2022 19:08

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

• 

  Ali VanSickle

  25 Maj 2022 19:46

  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

Du måste logga in om du vill lämna en kommentar.