Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 463
  • Last Modified:

Text and number manupilation

I am trying display the following format as a Header in each group : # 1 (54) with the following formula :
---------------------------------------------------------------------------------------------------------------------------------
"# " & {#GroupCounter} & " (" & GroupName ({ContractParkerMovements.UserNo}) & " )"
---------------------------------------------------------------------------------------------------------------------------------
*(GroupCounter is running total that counts each time the group changes)

but keep getting the following result : # 1.00 (54)

How do I manipilate the GroupCounter (or for any number) not to show as a decimal but rather just as a 1
0
John-S Pretorius
Asked:
John-S Pretorius
1 Solution
 
mlmccCommented:
Try this

"# " & CStr({#GroupCounter},0,"") & " (" & GroupName ({ContractParkerMovements.UserNo}) & " )"


This should also work

"# " & ToText({#GroupCounter},0,"") & " (" & GroupName ({ContractParkerMovements.UserNo}) & " )"

mlmcc
0
 
Kyle AbrahamsSenior .Net DeveloperCommented:
0
 
John-S PretoriusTechnical Service Manager, Mid-AtlanticAuthor Commented:
Thank you, I used :
"# " & ToText({#GroupCounter},0,"") & " (" & GroupName ({ContractParkerMovements.UserNo}) & " )"

which worked perfect
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now