GMSC Discussions

GeoMedia Smart Client community discussion board is where you can create, contribute and share information and knowledge in regards to configuring as well as working with GeoMedia Smart Client. Find your answers, share your knowledge and help build a strong GeoMedia Smart Client community.
Showing results for 
Search instead for 
Do you mean 
Reply
Highlighted
Contributor
Posts: 26
Registered: ‎11-21-2015

Problem Displaying Filter Field in Report

[ Edited ]

Hi,

We are upgrading a customer from 2015, to 2018. Found problems with some of the reports in v 2018, which works fine in 2015.

 

In v2018, The error (pls see attachment) comes up whenever a telrik textbox refers to a Filter field in the form.

for eg: =Fields.FILTER_BETWEEN_L_REQ_DATE

 

We use this in the report header to show the user specified query. For eg: generate a transaction report for requests between date1 and date2.

 

Whats' the issue. ?

 

 

<FormReport name="DPS_REPORTING_LP_TRANSREP" label="Transaction Report" format="PDF,XLS" type="overview"/>
    <FormTab name="Report_Tab" label="General">
          <FormGroup name="DetailGroup" label="Details">
                <FormField name="ID" type="textfield" datatype="guidstring" visible="hidden"></FormField>
                <FormField name="CPR_NO" label="Request Number:" type="textfield" datatype="string" required="false" maxlength="40" visible="list"/>
                 <FormField name="REQ_DATE" label="Requested Date:" type="datepicker" datatype="date" required="false" maxlength="15" visible="list,filter" filter="ISBETWEEN" />

 

...

 

 

Thanks.

Highlighted
Technical Evangelist
Posts: 707
Registered: ‎11-12-2015

Re: Problem Displaying Filter Field in Report

Hi mshameem,

 

Where is your definition for 'textbox24' or 'textbox25' in the report?

Maybe I am missing something here but I dont see where Fields.FILTER_BETWEEN_L_REQ_DATE is defined.

The report/workflow wasn't altered from 2015 to 2018 versions?

Highlighted
Contributor
Posts: 26
Registered: ‎11-21-2015

Re: Problem Displaying Filter Field in Report

Hi sclow,

 

  • The report / workflow hasn't been altered from 2015 to 2018.
  • definition of textbox - pls see the attachement for the telrik design view.
  • The field is defined in the form report as below

<FormField name="REQ_DATE" label="Requested Date:" type="datepicker" datatype="date" required="false" maxlength="15" visible="list,filter" filter="ISBETWEEN" />

..

 

It has visible "list,filter" so, it appears as one of the filter fields of the List view

The telrik report, can refer to the value in a filter field by = Fields.FILTER_{FilterFieldId}

Documentation reference > https://hexagongeospatial.fluidtopics.net/reader/rMZAmliqhWp7LKakCy9Pig/uisw96ejixCZSYcyf1h6SA

 

FieldId is REQ_DATE, Since it's a 'isbetween' filter, it would display 2 fields, and the lower side of the 'between' is referred to as =Fields.FILTER_BETWEEN_L_REQ_DATE , which works perfectly fine in v2015. But not, on 2018.