Hi,
I have a simple reporting requirement that must have been solved many times but I'm not able to find any information from the forum postings. Any suggestions would be appreciated; requirement as follows:
1. A simple report with only detail section, e.g. member #, name, and dues paid:
1234 John Alan 2008 $100.00
1234 John Alan 2009 $100.00
1763 Peter Brown 2009 $80.00
2286 Jane Jones 2008 $100.00
2286 Jane Jones 2009 $100.00
2. What I would like to do is to suppress the member # and name values that are repeats from the previous rows:
1234 John Alan 2008 $100.00
2009 $100.00
1763 Peter Brown 2009 $80.00
2286 Jane Jones 2008 $100.00
2009 $100.00
I'm not able to figure out how to compare the values from the current row with values from the previous rows in code. Can anyone help?
Thanks,
Barry
I have a simple reporting requirement that must have been solved many times but I'm not able to find any information from the forum postings. Any suggestions would be appreciated; requirement as follows:
1. A simple report with only detail section, e.g. member #, name, and dues paid:
1234 John Alan 2008 $100.00
1234 John Alan 2009 $100.00
1763 Peter Brown 2009 $80.00
2286 Jane Jones 2008 $100.00
2286 Jane Jones 2009 $100.00
2. What I would like to do is to suppress the member # and name values that are repeats from the previous rows:
1234 John Alan 2008 $100.00
2009 $100.00
1763 Peter Brown 2009 $80.00
2286 Jane Jones 2008 $100.00
2009 $100.00
I'm not able to figure out how to compare the values from the current row with values from the previous rows in code. Can anyone help?
Thanks,
Barry