Is there an option within IFS Business Reporter to display design rows/ columns even when there are null values when the report is run? For example, our current BR reports will not display rows/ columns where the GL Balance amount is zero. The report only will shows those columns and rows where GL Balance data is not null. Any help would be appreciated. Thanks.
IFS Business Reporter missing rows and columns
Userlevel 2
+4
Userlevel 1
+3
Hi,
Why don't you add another column/row which has a not NULL value and then hide that dummy column/row.
Best regards,
Ravi
Userlevel 1
+3
Or else, you have to extend the information source with a custom field which retun 0 instead of NULL. And then use the custom field in your BR instead of the standard field.
Hi,
There is an option under report options in BR client to treat null as zero. It will replace all the null values with zeros. May be you can use that functionality.
Best Regards,
Nisansala
+1
Hi,
On the Repeater tab within the design row/column options a column called ‘All’ exist. Tick this and all row/columns are returned.
Kind regards,
Chris.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.