Ideas on how to populate this report
Sample Report Looks like this..
__AC_No AC_Nm Bal__
123 www $40
__Desc Val ValDesc__
ww re nono
xx ps greg
vu hg rpts
AC_No,AC_Nm,Bal,Desc,Val,ValDesc are all my fields in the report which i have to make use of.
For that particular AC_Nm, I have to get the Desc,Val and ValDesc as shown above.
I am creating one more detail tab and and adding Desc,Val and ValDesc and when I am running the report my output is like this
__AC_No AC_Nm * Bal*__
123 www $40
__Desc Val ValDesc__
ww re nono
__AC_No AC_Nm * Bal*__
123 www $40
__Desc Val ValDesc__
xx ps greg
__AC_No AC_Nm * Bal*__
123 www $40
__Desc Val ValDesc__
vu hg rpts
Instead of as shown in the sample report.
Can some one help me to get on track and get the report as shown In the sample report above .