on 01-13-2015 11:47 AM
Hi,
I have searched this forum and various others but I am unable to find the solution I need for my issue.
I have a report that consist of just one report field 'USERID', which is placed within the details section.
This field contains records that are not necessarily duplicated but are related to the previous record. For instance...
USERID
AADMIN
AADUMMY
AAPPLE
AAPPLE1
AAPPLE2
AAPPLE3
AATKIN
AAUSTIN
....
....
....
In this particular scenario I would like like to suppress 'AAPPLE1', 'AAPPLE2', & 'AAPPLE3'.
I would appreciate any assistance with this.
Kind regards
Gary
Hi Gary,
If two or more rows are related to each other, would the second (or subsequent rows) be suffixed with an incrementing number?
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
OK. Try this please:
1) Create a formula with this code"
stringvar s := {UserID};
Replace(s, totext(val(StrReverse(s)),0,""),"");
2) Go to the Group Expert > Move the formula field from Step 1 to the Pane on the right so that a Group is inserted on this formula field
3) Instead of placing the fields on the Details Section, move them to the Group Header section
-Abhilash
Another way to do this is to go to the Section Expert > highlight the details section > Click the formula button beside 'Suppress' and use this code:
stringvar s := {UserID};
Replace(s, totext(val(StrReverse(s)),0,""),"") = Replace(Previous({UserID}), totext(val(StrReverse(Previous({UserID}))),0,""),"")
-Abhilash
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.