Welcome! Log In Create A New Profile

Advanced

Filtering in a report

Posted by AadG 
Forum List Message List New Topic
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
Reply Quote
Vassilis
Re: Filtering in a report
November 26, 2018 03:49PM
Hi Aad,

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

Regards

Vassilis
Reply Quote
AadG
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
Reply Quote
Vassilis
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
Reply Quote
AadG
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
Reply Quote
Vassilis
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
Reply Quote
AadG
Re: Filtering in a report
November 26, 2018 07:21PM
Yes I traced the report and the values are OK. Any suggestions ?? thumbs up
Reply Quote
Vassilis
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
Reply Quote
AadG
Re: Filtering in a report
November 26, 2018 07:31PM
Yes that's the next step. Thanks very much for your help.

Aad
Reply Quote
DarrenF
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.
Reply Quote
AadG
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
Reply Quote
Newer Topic Older Topic
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: