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
50%
Handover everything to System Integrator from drawing BP till implementation of ERP
0%
Hire more inhouse skilled & capable IT Resource to work directly with SI
50%
Rely on SI Architects/Consultants
0%
Total votes: 4

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 18th June 2020, 08:54
pegaga1979 pegaga1979 is offline
Senior Member
 
Join Date: Oct 2008
Posts: 192
pegaga1979 is on a distinguished road
Baan: Baan V - DB: SQL - OS: WINDOWS 2003
Add text and formula at report field
Baan: Infor ERP 10.7
C/S: None/Unknown

Hi,

I have my formula on number of days.
therefore, in my report layout, i would like to put number of days and text days.
i tried in
print expression: no.of.days & "days"
domain: tcstr.12

but having error.
Anyone can help me on this?
Thank you in advance for the expertise.
Reply With Quote
  #2  
Old 18th June 2020, 09:50
bdittmar's Avatar
bdittmar bdittmar is offline
Guru
 
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,848
bdittmar will become famous soon enough
Baan: 2.2/3.1/4c4/LN6.1 FP6/FP9/HiDox Tools 10.7 - DB: tbase, ms-sql7, oracle10gV1, 11g - OS: HP-UX, W2K3, SLES
Long and string

Hello,

if no.of.days ist type long you have to convert to string.

Try:
Code:
str$()
Syntax:
function string str$  (void input.value)

Description

The function str$ converts the supplied input value from its original type to type string.

Typical usage of this function includes (but is not restricted to) the conversion of an integer or floating point value to its decimal string representation. 


Arguments
void input.value  
 
Return values
Implicit conversion of the input value from its original type to type string is performed. The resulting string value is returned.
regards
__________________
//Bernd
Reply With Quote
  #3  
Old 19th June 2020, 03:00
pegaga1979 pegaga1979 is offline
Senior Member
 
Join Date: Oct 2008
Posts: 192
pegaga1979 is on a distinguished road
Baan: Baan V - DB: SQL - OS: WINDOWS 2003
may i know how to convert?
do i need to add in script?
Reply With Quote
Sponsored Links
  #4  
Old 19th June 2020, 03:52
tmannais's Avatar
tmannais tmannais is offline
Senior Member
 
Join Date: Jul 2017
Location: Bangkok, Thailand
Posts: 281
tmannais is on a distinguished road
Baan: LN 10.5, 10.6, 10.7 - DB: MSSQL - OS: Windows
Can we see the error?
Reply With Quote
  #5  
Old 19th June 2020, 07:18
DDPatel's Avatar
DDPatel DDPatel is offline
Member
 
Join Date: Dec 2018
Location: India,Gujarat,Umbergaon 396150
Posts: 33
DDPatel is on a distinguished road
Baan: LN10.3 - DB: SQL SERVER 2008 R2 - OS: WINDOW SERVER 2008 R2
As solution given by @bdittmar

You can change the expression and domain for O/P in Report Layout.
Code:

HTML Code:
Print Expression : str$(r.days)&" Days"
Domain : tcmcs.str15
O/P Example.
15 Days


Best Regards,
DDPatel
Reply With Quote
  #6  
Old 19th June 2020, 10:56
pegaga1979 pegaga1979 is offline
Senior Member
 
Join Date: Oct 2008
Posts: 192
pegaga1979 is on a distinguished road
Baan: Baan V - DB: SQL - OS: WINDOWS 2003
It is working.
Thank you very very much
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
Understanding "Labels" report Medtun Tools Development 4 18th December 2015 15:11
Execute Formula in text erp.analyst Tools Development 1 27th October 2015 11:29
how to do formula calculation in SQL query by text manager dhaniah Tools Development 4 15th March 2013 17:56


All times are GMT +2. The time now is 17:16.


©2001-2018 - Baanboard.com - Baanforums.com