# " The Excel buffer already exist identification field and value Row No =2 Column No = 1" error why and how solve **URL:** \ **Category:** Developers Forum\ **Created:** [June 2, 2013, 1:39pm UTC](https://www.dynamicsuser.net/t/the-excel-buffer-already-exist-identification-field-and-value-row-no-2-column-no-1-error-why-and-how-solve/46306 "2013-06-02T13:39:30Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![ahmedsa](https://avatars.discourse-cdn.com/v4/letter/a/7bcc69/32.png) [@ahmedsa](https://www.dynamicsuser.net/u/ahmedsa)\ **Post date:** [June 2, 2013, 1:39pm UTC](https://www.dynamicsuser.net/t/the-excel-buffer-already-exist-identification-field-and-value-row-no-2-column-no-1-error-why-and-how-solve/46306/1 "2013-06-02T13:39:30Z")
Hi guys i have problem i grouping report to item ledger entry table data item as following : item no quantity cost amount(actual) ax 5 3000 az 2 4000 grouping by item no until now is successfully. I try to print to excel sheet using excel buffer table so that i write following code : item ledger entry -on after get record trigger IF PrintToExcel THEN MakeExcelDataBody; CreateExcelBook() function ExcelBuf.CreateBook; ExcelBuf.CreateSheet(Text002,Text001,COMPANYNAME,USERID); ExcelBuf.GiveUserControl; ERROR(’’); MakeExcelInfo() function ExcelBuf.SetUseInfoSheed; ExcelBuf.AddInfoColumn(FORMAT(Text005),FALSE,’’,TRUE,FALSE,FALSE,’’); ExcelBuf.AddInfoColumn(COMPANYNAME,FALSE,’’,FALSE,FALSE,FALSE,’’); ExcelBuf.NewRow; ExcelBuf.AddInfoColumn(FORMAT(Text007),FALSE,’’,TRUE,FALSE,FALSE,’’); ExcelBuf.AddInfoColumn(FORMAT(Text001),FALSE,’’,FALSE,FALSE,FALSE,’’); ExcelBuf.NewRow; ExcelBuf.AddInfoColumn(FORMAT(Text006),FALSE,’’,TRUE,FALSE,FALSE,’’); ExcelBuf.AddInfoColumn(REPORT::“TotalQuantity-Cost”,FALSE,’’,FALSE,FALSE,FALSE,’’); ExcelBuf.NewRow; ExcelBuf.AddInfoColumn(FORMAT(Text008),FALSE,’’,TRUE,FALSE,FALSE,’’); ExcelBuf.AddInfoColumn(USERID,FALSE,’’,FALSE,FALSE,FALSE,’’); ExcelBuf.NewRow; ExcelBuf.AddInfoColumn(FORMAT(Text009),FALSE,’’,TRUE,FALSE,FALSE,’’); ExcelBuf.AddInfoColumn(TODAY,FALSE,’’,FALSE,FALSE,FALSE,’’); ExcelBuf.NewRow; ExcelBuf.AddInfoColumn(“Item Ledger Entry”.GETFILTER(“Item No.”),FALSE,’’,FALSE,FALSE,FALSE,’’); ExcelBuf.NewRow; ExcelBuf.ClearNewRow; MakeExcelDataHeader; MakeExcelDataHeader() function ExcelBuf.AddColumn(“Item Ledger Entry”.FIELDCAPTION(“Item No.”),FALSE,’’,TRUE,FALSE,TRUE,’’); ExcelBuf.AddColumn(“Item Ledger Entry”.FIELDCAPTION(Quantity),FALSE,’’,TRUE,FALSE,TRUE,’’); ExcelBuf.AddColumn(“Item Ledger Entry”.FIELDCAPTION(“Cost Amount (Actual)”),FALSE,’’,TRUE,FALSE,TRUE,’’); MakeExcelBody() ExcelBuf.NewRow; ExcelBuf.AddColumn(“Item Ledger Entry”.“Item No.”,FALSE,’’,FALSE,FALSE,FALSE,’@’); ExcelBuf.AddColumn(“Item Ledger Entry”.Quantity,FALSE,’’,FALSE,FALSE,FALSE,’’); ExcelBuf.AddColumn(“Item Ledger Entry”.“Cost Amount (Actual)”,FALSE,’’,FALSE,FALSE,FALSE,’’); Report - onprereport() itemFilter := “Item Ledger Entry”.GETFILTERS; PeriodText := “Item Ledger Entry”.GETFILTER(“Posting Date”); IF PrintToExcel THEN MakeExcelInfo; Report-onpostreport() IF PrintToExcel THEN CreateExcelbook; **Then when i run report i found error tell me as following :** **" The Excel buffer already exist identification field and value Row No =2 Column No = 1"** **How i solve this problem.** **thanks** ---
**Author:** ![mohana\_cse06](https://avatars.discourse-cdn.com/v4/letter/m/e480ec/32.png) [@mohana\_cse06](https://www.dynamicsuser.net/u/mohana_cse06)\ **Post date:** [June 2, 2013, 2:47pm UTC](https://www.dynamicsuser.net/t/the-excel-buffer-already-exist-identification-field-and-value-row-no-2-column-no-1-error-why-and-how-solve/46306/2 "2013-06-02T14:47:13Z")
You can search the forum with error. it means that row no. is not incrementing in your code… ---
**Author:** ![ahmedsa](https://avatars.discourse-cdn.com/v4/letter/a/7bcc69/32.png) [@ahmedsa](https://www.dynamicsuser.net/u/ahmedsa)\ **Post date:** [June 2, 2013, 6:22pm UTC](https://www.dynamicsuser.net/t/the-excel-buffer-already-exist-identification-field-and-value-row-no-2-column-no-1-error-why-and-how-solve/46306/3 "2013-06-02T18:22:27Z")
how i make this increment can you show me please ---
**Author:** ![amol\_salvi](https://avatars.discourse-cdn.com/v4/letter/a/ac91a4/32.png) [@amol\_salvi](https://www.dynamicsuser.net/u/amol_salvi)\ **Post date:** [June 3, 2013, 4:55am UTC](https://www.dynamicsuser.net/t/the-excel-buffer-already-exist-identification-field-and-value-row-no-2-column-no-1-error-why-and-how-solve/46306/4 "2013-06-03T04:55:54Z")
Hi Look at the folllowing posts [http://dynamicsuser.net/forums/t/54227.aspx](http://dynamicsuser.net/forums/t/54227.aspx) [http://dynamicsuser.net/forums/p/25998/140880.aspx](http://dynamicsuser.net/forums/p/25998/140880.aspx) You will get an idea how to write a code ---
**Author:** ![ahmedsa](https://avatars.discourse-cdn.com/v4/letter/a/7bcc69/32.png) [@ahmedsa](https://www.dynamicsuser.net/u/ahmedsa)\ **Post date:** [June 3, 2013, 8:34am UTC](https://www.dynamicsuser.net/t/the-excel-buffer-already-exist-identification-field-and-value-row-no-2-column-no-1-error-why-and-how-solve/46306/5 "2013-06-03T08:34:45Z")
Thanks i solved the problem by deleting all records from excel buffer table 370 Now i face another problem when i export data it show records but not show grouping as following : report show in normal way as item qty cost amount actual opc 5 2000 but in excel show details as following opc 1 400 opc 1 400 opc 2 800 opc 1 400 **how i solve this if possible** **what i need to show grouping in excel as report** **thanks** ---
**Author:** ![mohana\_cse06](https://avatars.discourse-cdn.com/v4/letter/m/e480ec/32.png) [@mohana\_cse06](https://www.dynamicsuser.net/u/mohana_cse06)\ **Post date:** [June 3, 2013, 9:40am UTC](https://www.dynamicsuser.net/t/the-excel-buffer-already-exist-identification-field-and-value-row-no-2-column-no-1-error-why-and-how-solve/46306/6 "2013-06-03T09:40:40Z")
Did you set Temporary property to yes for ExcelBuf record variable? ---
**Author:** ![ahmedsa](https://avatars.discourse-cdn.com/v4/letter/a/7bcc69/32.png) [@ahmedsa](https://www.dynamicsuser.net/u/ahmedsa)\ **Post date:** [June 3, 2013, 10:23am UTC](https://www.dynamicsuser.net/t/the-excel-buffer-already-exist-identification-field-and-value-row-no-2-column-no-1-error-why-and-how-solve/46306/7 "2013-06-03T10:23:36Z")
yes but not affect ---
**Author:** ![mohana\_cse06](https://avatars.discourse-cdn.com/v4/letter/m/e480ec/32.png) [@mohana\_cse06](https://www.dynamicsuser.net/u/mohana_cse06)\ **Post date:** [June 3, 2013, 10:57am UTC](https://www.dynamicsuser.net/t/the-excel-buffer-already-exist-identification-field-and-value-row-no-2-column-no-1-error-why-and-how-solve/46306/8 "2013-06-03T10:57:03Z")
This is not for grouping issue. this is for records inserting into table. You can write ExcelBuffer.DELETEALL; in the begining the code also. For grouping, you need to gropu your report as in normal reports and write code in Groupfooter/header sections… ---
**Author:** ![ahmedsa](https://avatars.discourse-cdn.com/v4/letter/a/7bcc69/32.png) [@ahmedsa](https://www.dynamicsuser.net/u/ahmedsa)\ **Post date:** [June 3, 2013, 12:33pm UTC](https://www.dynamicsuser.net/t/the-excel-buffer-already-exist-identification-field-and-value-row-no-2-column-no-1-error-why-and-how-solve/46306/9 "2013-06-03T12:33:22Z")
I using excel buffer .delete all; in pre data item first then no result and after get record triggers also not result . but no benefit i made as report number 6 in object designer and his name trial balance why this not give me result as in report. my report grouping data based on item no and successfully in that but Not successfully to group data in excel why ---
**Author:** ![amol\_salvi](https://avatars.discourse-cdn.com/v4/letter/a/ac91a4/32.png) [@amol\_salvi](https://www.dynamicsuser.net/u/amol_salvi)\ **Post date:** [June 3, 2013, 1:40pm UTC](https://www.dynamicsuser.net/t/the-excel-buffer-already-exist-identification-field-and-value-row-no-2-column-no-1-error-why-and-how-solve/46306/10 "2013-06-03T13:40:10Z")
Is data is grouping in Report ? Have you try to write code on Report Section ??? ---
**Author:** ![ahmedsa](https://avatars.discourse-cdn.com/v4/letter/a/7bcc69/32.png) [@ahmedsa](https://www.dynamicsuser.net/u/ahmedsa)\ **Post date:** [June 3, 2013, 1:51pm UTC](https://www.dynamicsuser.net/t/the-excel-buffer-already-exist-identification-field-and-value-row-no-2-column-no-1-error-why-and-how-solve/46306/11 "2013-06-03T13:51:46Z")
in report grouping already found and report work affectedly but in excel not work grouping **in which section i write and what i write to do that in excel** **if possible** thanks ---
**Author:** ![amol\_salvi](https://avatars.discourse-cdn.com/v4/letter/a/ac91a4/32.png) [@amol\_salvi](https://www.dynamicsuser.net/u/amol_salvi)\ **Post date:** [June 3, 2013, 2:12pm UTC](https://www.dynamicsuser.net/t/the-excel-buffer-already-exist-identification-field-and-value-row-no-2-column-no-1-error-why-and-how-solve/46306/12 "2013-06-03T14:12:17Z")
I think you need to add code on Report Section for the same. ---
**Author:** ![ahmedsa](https://avatars.discourse-cdn.com/v4/letter/a/7bcc69/32.png) [@ahmedsa](https://www.dynamicsuser.net/u/ahmedsa)\ **Post date:** [June 3, 2013, 2:20pm UTC](https://www.dynamicsuser.net/t/the-excel-buffer-already-exist-identification-field-and-value-row-no-2-column-no-1-error-why-and-how-solve/46306/13 "2013-06-03T14:20:54Z")
what this code i added to section ---
**Author:** ![ahmedsa](https://avatars.discourse-cdn.com/v4/letter/a/7bcc69/32.png) [@ahmedsa](https://www.dynamicsuser.net/u/ahmedsa)\ **Post date:** [June 6, 2013, 5:49am UTC](https://www.dynamicsuser.net/t/the-excel-buffer-already-exist-identification-field-and-value-row-no-2-column-no-1-error-why-and-how-solve/46306/14 "2013-06-06T05:49:55Z")
thank you very much it solved as you tell me by putting code in section of report thanks ---
**Author:** ![amol\_salvi](https://avatars.discourse-cdn.com/v4/letter/a/ac91a4/32.png) [@amol\_salvi](https://www.dynamicsuser.net/u/amol_salvi)\ **Post date:** [June 6, 2013, 7:50am UTC](https://www.dynamicsuser.net/t/the-excel-buffer-already-exist-identification-field-and-value-row-no-2-column-no-1-error-why-and-how-solve/46306/15 "2013-06-06T07:50:28Z")
Welcome… ---
**Author:** ![abuzar\_shaikh](https://avatars.discourse-cdn.com/v4/letter/a/a587f6/32.png) [@abuzar\_shaikh](https://www.dynamicsuser.net/u/abuzar_shaikh)\ **Post date:** [August 4, 2014, 8:32am UTC](https://www.dynamicsuser.net/t/the-excel-buffer-already-exist-identification-field-and-value-row-no-2-column-no-1-error-why-and-how-solve/46306/16 "2014-08-04T08:32:36Z")
what code u have added can u tell me as i’m getting the same issue