Method Community

I am having nightmares with these functions in the Report Designer.

Here is a simple formula that is not working and I cannot figure out why:

Iif(([CallReport.ComplaintCode] = 'CA' and [CallReport.DateReceived] >= AddDays(Today(),-30)),  1, 0)

Can someone help me out with this.  I have been designing reports for almost 15 years now and have never seen so many inconsistencies with a report designer.  Sometimes it works, and sometimes it doesn't.  And I cannot figure out why.

It could be me, but this is a very basic formula I have here!!

-Josh

Here is an example of what I am talking about (The values with the arrows pointing to them should be a 1 because both criteria are met)

@CDS_Josh

The fomula looks fine and I built a similiar conditional statement and it is working for me on a couple of test reports.

One thing I always recommend is when actually testing the reports design a simple screen that actually generates the report versus just looking at the results in report designer.

Are you actually generated it versus just previewing it? When previewing, it only displays the first few records of the date.

Please let me know if I can be of further assistance.

I only use the generate report function to test my reports.  I find the preview screen to be extremely buggy and will not show any results at times, even though a generate report with a wide open filter range will show hundreds.  I really wish Method would spend more time working with this report designer and work out all the kinks.  Its a great tool when it works.

I managed to get my desired results through Excel using an API call.

Thanks anyways!!