Creating reports and dashboards | Stimulsoft community forum

Hello,

I have two issues on the same report - if you need me to break them into two separate requests, please let me know.
I've attached the mrt I'm working with, and a pdf of the a sample report output, but I'm unable to send a sample database.

1. I have a text box in a group header with the following statement {Length(WorkOrders.woa_wo_rel.GIS_woa_Rel.InspectionArea) == 0 ? 'NA' : 'OK')}.
When my report renders, I was thinking the report would either display "NA" or "OK" depending on whether the expression evaluated to True or False.
However what actual renders is the following "{Stimulsoft.Report.Dictionary.StiFunctionsStrings.Length(WorkOrders.woa_wo_rel.GIS_woa_Rel.InspectionArea) == 0 ? 'NA' : 'OK')}".
I've also tried using the IIF function, but get the same results. Any idea what might cause this?

2. Whenever my report renders, there is a fairly large blank area on the first page between my report Title Band & the GroupHeader Band. I expect there
could be a few things that might cause this, but don't know exactly what they might be. Can you point me in the right direction in terms of properties I might be
able to set for the report, page or report bands?

I am using Stimulsoft Version: 2017.1.6 from June 3, 2017, ASP.NET, Flex

Thanks,
Carl

Hi,

I've managed to solve the blank space at the start of my report by setting the Page Unlimited Height property to True.
However, I'm still trying to solve the issue with my expression not rendering the way I think it should.

Thanks,
Carl

Hi,

I also just managed to find a solution to my expression problem - all I had to do was replace the
single quotes with double quotes. So simple... I should have tried that earlier

Thanks,
Carl

Hello, Carl.

Great.
We are glad that you have solved your issue.

Thank you.