John-S Pretorius
asked on
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
--------------------------
"# " & {#GroupCounter} & " (" & GroupName ({ContractParkerMovements.
--------------------------
*(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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you, I used :
"# " & ToText({#GroupCounter},0," ") & " (" & GroupName ({ContractParkerMovements. UserNo}) & " )"
which worked perfect
"# " & ToText({#GroupCounter},0,"
which worked perfect
http://crystaltricks.com/wordpress/?p=149