I just realized that i previously said you should group by Id. Edit: Sorry, I had to go back to your original question. You should group by ID. The aka should be in the details section of the group and not another row in the group header.
Are you displaying the aka in the row which has the 3 horizontal lines in the row 'header' ?..on the left, where you can select the entire row. It sounds as if your aka is also in the grouping. If so the expression probably reads FIRST(Fields!Aka.value). It
should be in the details row, which is indicated by the 3 horizontal lines and the expression would then be =Fields!aka.value
why dont you create a group based on the concatenation of two fields name and Aka.
Ashutosh Pathak
Blog: http://catchcode.blogspot.com Please mark it as answer if it helps, as clicking on the button can save time of others :)
MCP,MCAD,MCSD,MCTS
Basquiat
Contributor
2387 Points
656 Posts
Re: Need help - Report
Mar 21, 2012 08:10 PM|LINK
Basquiat
Contributor
2387 Points
656 Posts
Re: Need help - Report
Mar 21, 2012 08:12 PM|LINK
erobinson
Member
86 Points
86 Posts
Re: Need help - Report
Mar 21, 2012 09:03 PM|LINK
I'm not sure what's 'details section of the group ', could you please explain more.
Basquiat
Contributor
2387 Points
656 Posts
Re: Need help - Report
Mar 21, 2012 09:19 PM|LINK
erobinson
Member
86 Points
86 Posts
Re: Need help - Report
Mar 21, 2012 09:34 PM|LINK
Thanks for the quick reply.
I have added AKA in detail row, and group by ID, Still getting wrong results
Name AKA Date
John Smith 1/1/2011
Benny Smith AKA Benny 1/1/2011
Missing AKA B.Smith , not sure what i'm missing here.
Any help is appreciated.
Basquiat
Contributor
2387 Points
656 Posts
Re: Need help - Report
Mar 21, 2012 09:42 PM|LINK
erobinson
Member
86 Points
86 Posts
Re: Need help - Report
Mar 21, 2012 09:47 PM|LINK
Nope, its Fields!AKA.Value
Basquiat
Contributor
2387 Points
656 Posts
Re: Need help - Report
Mar 21, 2012 09:50 PM|LINK
erobinson
Member
86 Points
86 Posts
Re: Need help - Report
Mar 22, 2012 04:39 PM|LINK
Thanks Basquiat.
Does anyone have some input?
Ashutosh Pat...
Contributor
5737 Points
1105 Posts
Re: Need help - Report
Mar 23, 2012 04:08 AM|LINK
why dont you create a group based on the concatenation of two fields name and Aka.
Blog: http://catchcode.blogspot.com
Please mark it as answer if it helps, as clicking on the button can save time of others :)
MCP,MCAD,MCSD,MCTS