Grouping withot field no.

guptavarunmca

Hello
i want to group my data in report instead of posting date only with the month of that posting date .Is this possible in navision.

vijay_g

Earlier has discussed on this topic....you can search
solutions is you have to add a field Name Month in table and calculate month for each posting date then you can.

guptavarunmca

Please let me know the process how to group if i have month field.

Shonatina

guptavarunmca wrote:

Please let me know the process how to group if i have month field.

do it the same way you would have done with the posting date, now instead of posting date, use Month.

guptavarunmca

I used the same but not working. i use month in totalcausedby but nothing grouped

alok_dida

vijay_g wrote:

Earlier has discussed on this topic....you can search
solutions is you have to add a field Name Month in table and calculate month for each posting date then you can.

Without adding month field we can also do it.
In group use Expression instead of direct field value.

Suppose in your table field name is "Posting Date" and you want to group your data based on month in Posting Date.
You can use following expression for it.

=MonthName(Month(Fields!Cust__Ledger_Entry__Posting_Date_.Value))

instead of =Fields!Cust__Ledger_Entry__Posting_Date_.Value this.

I have did this thing for RTC.

guptavarunmca

I used following code in group header section

CurrReport.Showoutput:=CurrReport.TOTALCAUSEDBY = MonthName(Month(Rec."Posting Date"));

Month is calculated field for month from posting date.



But its giving error monthname not a function.

](*,) ](*,) ](*,) ](*,)