Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Poll
As a Customer What would do to keep your ERP Implementation intact
Proactively define Business Process-- Take the Project Ownership
45%
Handover everything to System Integrator from drawing BP till implementation of ERP
18%
Hire more inhouse skilled & capable IT Resource to work directly with SI
36%
Rely on SI Architects/Consultants
0%
Total votes: 11

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 17th February 2021, 17:07
LordMrT LordMrT is offline
Junior Member
 
Join Date: Nov 2020
Posts: 12
LordMrT is on a distinguished road
Baan: 10.7 - DB: Oracle - OS: InforLN 10.7
Report Designer - hide field if empty
Baan: Infor ERP 10.7
C/S: Client

Hello all,

I am currently working with the Report Designer in Infor LN 10.7. I would like to hide fields and their headline if the content of the data field is empty. How can I implement this?

Thank you very much.
Reply With Quote
  #2  
Old 18th February 2021, 14:32
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,562
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Well I don't think I ever hid a report field on its own. In 4c4 I did have sessions where based off the data(or user selections) I would sent it to different reports with different formats. Now if I want to clear a heading (Normally I would change it) I would use the print expresssion on the field. So I would make the heading lets say a string field. I would then use a print expression - like if hours.weekly>0 ? "Weekly hrs" : "Daily Hours". This would allow me to change the column heading and I could do the same for the data column in the report. I don't recall setting a column to like "", but the same could be done here.

Of course I just noticed it is LN so wait - LN might have a much better solution.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #3  
Old 19th February 2021, 13:55
GeekGirlAkshara's Avatar
GeekGirlAkshara GeekGirlAkshara is offline
Junior Member
 
Join Date: Jul 2020
Location: India
Posts: 24
GeekGirlAkshara is on a distinguished road
Baan: 10.4 / 10.7 (Infor LN) - DB: MySQL, Oracle - OS: Windows
Quote:
Originally Posted by LordMrT View Post
Hello all,

I am currently working with the Report Designer in Infor LN 10.7. I would like to hide fields and their headline if the content of the data field is empty. How can I implement this?
Hi,
If you are talking about the Report Personalization, find a screenshot I've attached.
Select the field you want, set the print condition as per your requirement.

Note that, this personalization is on user level.Attachment 6875
Attached Images
File Type: png report designer.png (63.0 KB, 14 views)
__________________
Always ready to learn new things!
Reply With Quote
Sponsored Links
  #4  
Old 19th February 2021, 14:20
LordMrT LordMrT is offline
Junior Member
 
Join Date: Nov 2020
Posts: 12
LordMrT is on a distinguished road
Baan: 10.7 - DB: Oracle - OS: InforLN 10.7
Hi GeekGirlAkshara,

thank you very much. This works great. Have a nice weekend.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
LN UI report designer - centering heading okneb1 Tools Development 5 22nd July 2019 17:00
Footer in Report designer Premahari Tools Development 2 6th August 2018 08:01
String Field in Report Issue beluver_2k Tools Development 3 25th July 2008 15:16
Customized report problem with special field. wricks Tools Development 3 3rd November 2005 17:30
solving recursion problems rmarles Tools Development 2 25th January 2005 22:23


All times are GMT +2. The time now is 08:46.


©2001-2021 - Baanboard.com - Baanforums.com