several grouping in report in RTC in navision 2009 R2

Dear All,

I just made a report in classic to group several fields in the report, for that i use 2 properties data item table view and Group total fields properties and also write some code on the onpresection trigger then it give the correct output whati want. after that i using create layout suggestion to make a report in RTC. but it is not giving the proper result.for your clarification i just show you result in classic and in RTC below.

It is showing in classic like below which i want in RTC,

Item No. Entry Type Location Cod Posting Da Quantity Cost Amount (A
1001
Sale
BLUE
01/27/11 10 -3,505.94
-3,505.94
YELLOW
01/27/11 10 -3,505.94
-3,505.94
-7,011.88
-7,011.88
1100
Sale
BLUE
01/27/11 1 -129.67
-129.67
-129.67
Positive Adj
06/01/10 200 25,934.20
25,934.20
25,934.20

But it in the RTC

Item No. Entry Type Location Code Posting Date Quantity Cost Amount (Actual)
1001
Sale
BLUE
1/27/2011 10. -3,505.94
-3,505.94
1001
Sale
YELLOW
1/27/2011 10. -3,505.94
-3,505.94
1100
Sale
BLUE
1/27/2011 1. -129.67
-129.67
1100
Positive Adjmt.
6/1/2010 200. 25,934.20




















25,934.20











Create Layout Suggestion will not give you the 100% correct result.

You need to adjust the rdlc after creating that…

Thank you Mohana,

But can u advice me how can i adjust that rdlc or you suggest me any site for this

You can learn from here

http://msdn.microsoft.com/en-us/library/dd338686.aspx

Thanks Mohana