我正在研究CR。我有一个前缀数据字段,名字数据字段和姓氏数据字段。在报告中他们看起来像这样: Dr.MarkFun 我想把它拿到看起来像这样: Mark Fun博士 我用这个公式来修剪它:
I have a CR that I am working on. I have a Prefix data field, First Name data field and Last Name data field. On the report they look like this: Dr.MarkFun I am trying to get it to look like this: Dr. Mark Fun I am using this Formula to trim it:
Trim({TableCEO.Prefix})&trim({TableCEO.FirstName})&trim({TableCEO.LastName})哪个工作正常,但我明白了: Dr.MarkFun 我试图用这个:
Which works fine but I get this: Dr.MarkFun I tried to use this:
Trim({TableCEO.Prefix})&trim({TableCEO.FirstName}+space(30-length)&trim({TableCEO.LastName}))错误出现说:没有足够的论据已经获得了这个功能。 如何获得报告所需的结果?在我的代码中我做错了什么?
The error comes up saying: "Not enough arguments have been given to this function." How can I get the result I need for the report? What did I do wrong in my code?
推荐答案我得到了修复!!这是我的公式: 修剪({TableCEO.Prefix})&&trim({TableCEO.FirstName})&&trim({TableCEO.LastName} ) 那给了我 Mark Fun先生 I got it fix!! Here is my formula: Trim({TableCEO.Prefix})&" "&trim({TableCEO.FirstName})&" "&trim({TableCEO.LastName}) That gave me Mr. Mark Fun
更多推荐
Crystal Report在字段之间添加空格
发布评论