Hi,
I am using CRXI. I have 2 tables Item1 and Item2.
In Item1 i have column A_Owner and in Item2 i have B_Owner. Both field have multiple values per ID.
In my report i need all coumns where A_Owner and B_Owner are same. I add A_Owener = B_Owner in record selection formula. But now i need to add one separate column where it will show all B_Owner for that ID it doesn't matter if it is eqal or not. I added B_Owner in subreport and add the subreport as column in detail section. But it is showing all the B_Owner which are in column not for that ID no. in each row.
For eaxmple:
ID Address State Country A_Owner B_Owner
now i need to add "ALL B_OWNER" for that ID as a separate column.
I would really appreciate your help.
Thanks in advance
Aatman
I am using CRXI. I have 2 tables Item1 and Item2.
In Item1 i have column A_Owner and in Item2 i have B_Owner. Both field have multiple values per ID.
In my report i need all coumns where A_Owner and B_Owner are same. I add A_Owener = B_Owner in record selection formula. But now i need to add one separate column where it will show all B_Owner for that ID it doesn't matter if it is eqal or not. I added B_Owner in subreport and add the subreport as column in detail section. But it is showing all the B_Owner which are in column not for that ID no. in each row.
For eaxmple:
ID Address State Country A_Owner B_Owner
now i need to add "ALL B_OWNER" for that ID as a separate column.
I would really appreciate your help.
Thanks in advance
Aatman