Welcome! Log In Create A New Profile

Advanced

Filtering in a report

Posted by AadG 
Filtering in a report
November 26, 2018 01:41PM
Hi all,

I'd like to know if it is possible to filter a report on a boolean/integer field. I'm using "if field = 1 then result True". This does not work.
Has filtering in a report any restrictions ??

Thanks for any help.


Best regards,

Aad
Re: Filtering in a report
November 26, 2018 03:49PM
Hi Aad,

Try with HFilter(....) in the Opening report section.

Regards

Vassilis
Re: Filtering in a report
November 26, 2018 04:46PM
Hi Vassilis,

Thanks for the.tip. Hfilter(File, "Field=0") works, but Field=1 doesn't.


Aad
Re: Filtering in a report
November 26, 2018 06:23PM
Hi Aad,

what type of Field is?
If it's boolean or numeric then should work.
If it's string then try this:
HFilter(File, StringBuild("Field = '%1'", Value)) // enclose the %1 in single quotes

Regards

Vassilis
Re: Filtering in a report
November 26, 2018 06:45PM
Hello Vassilis,

It's a boolean field, value 0 or 1. Filtering on 0 OK. Filtering on 1 not OK.
Strange product this ReportWriter. Setup such a filter in the Filter segment doesn't work at all.
I made a new report from scratch. Same result.

Aad
Re: Filtering in a report
November 26, 2018 06:52PM
Dear Aad,

Did you check the file ?. See if the coresponing field has the 1 value entered is some records.

Regards

Vassilis
Re: Filtering in a report
November 26, 2018 07:21PM
Yes I traced the report and the values are OK. Any suggestions ?? thumbs up
Re: Filtering in a report
November 26, 2018 07:27PM
Dear Aad,

in my opinion it's better to work with Query, as i do most of times.

Regards

Vassilis
Re: Filtering in a report
November 26, 2018 07:31PM
Yes that's the next step. Thanks very much for your help.

Aad
Re: Filtering in a report
November 27, 2018 02:41PM
Hi Aad,

Use a query; if my report doesn't report all the items of a file, then I always use a query to filter the report results.

Regards,
Darren.
Re: Filtering in a report
November 27, 2018 03:28PM
Hi Darren,

Thanks for your reaction. I'm working myself into queries know.. (newby to that)


Aad
Author:

Your Email:


Subject:


Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.
Message: