on 09-02-2009 4:53 PM
Hello to all and good morning, I'm working on report that I need to duplicate a row if a field is true:
Invoice#.........Salesname1.......Salesname2
.......1.................Smith, R........... Barnes,
...... 2.................Saywer,t........ Paynee, T
...... 3................. Wayne,R.........Smith, R
Smith,R should have 2 rows because he was involve in 2 transactions , I'll group by salesName this what I'm looking for:
Smith,R
Invoice#.........Salesname1.......Salesname2
.......1.................Smith, R........... Barnes,
...... 3................. Wayne,R.........Smith, R
Thank you for any help.
Hi,
U may insert a detail section below the detail section using insert section below.
Then u may suppress that section using section expert when field=false.
I hope this will be helpful for u.
Regards,
Misra P.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Basically, you'll need to select the records twice. Using an SQL Command as the data source, it'd look something like (MS SQL):
select salesman1 as group_field, invoice_no, salesman1, salesman2 from invoices
union all
select salesman2 as group_field, invoice_no, salesman1, salesman2 from invoices
You can then group on group_field and get all of the records that you want to show. (Each invoice will show under both salesmen.)
HTH,
Carl
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorry, I did not undersand the message
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.