Hello Gomathi! What I really liked about this video is that you wrote the code line by line explaining each step. This makes the video duration longer but I get the feeling I learn better this way instead of copying&pasting the code from your GitHub. Thanks for your efforts!
Hi, I write a logic i. e. Using excel buffer my header column names will be repeated or iterated. Like below example; Quantity Value Quantity Value Quantity value. Can you please give me the idea
Hi, I haven't experienced this personally, but try the below steps To achieve the repeated or iterated header column names in your Excel report, you can follow these steps: 1. First, make sure you have set up your Excel buffer properly to handle data export. 2. Next, you'll need to design your report layout. In the report's dataset, you can define variables to hold the header column names (e.g., Quantity, Value, Quantity, Value, Quantity, Value). 3. In the report's data item, you can write a codeunit or function that populates these variables with the appropriate column names in the desired sequence. 4. When exporting data to the Excel buffer, ensure that you add these variables as part of the data output, so they appear in the first row of your Excel sheet.
Hi Mam, i have one query related to Merging of 2 or more columns(eg: A and B) cells in excel template into 1 single cell. I'm using excel buffer to export the data from Business central Saas 24.2 IN version. so i want to merge 2 or more cells in excel to show the captions. Is there any way to merge the column cells. please guide me.
@@gomstechtalks Thanks mam for your quick response, I just verified, that Merge cells field or procedure not available in BC SaaS 24.2 IN version Excel Buffer table. Any alternative for BC SaaS IN version.
Hi, I want write a condition on excel report using excel buffer. My report has amount column, & this column come from customer ledger entry table. If my amount is 0 then display no balance text in column. Can you give me idea, how to do this
Hi there! To display 'no balance' text in the amount column of your Excel report based on the customer ledger entry table, you can use an IF statement in Excel. Here's an idea on how to approach it: 1. Open your Excel report and locate the column where you want to display the 'no balance' text. 2. In the cell where you want the text to appear, enter the following formula: =IF(CustomerLedgerEntryTable!Amount = 0, "No balance", CustomerLedgerEntryTable!Amount) Note: Replace 'CustomerLedgerEntryTable' with the actual name of your table and 'Amount' with the corresponding column name. 3. This formula checks if the amount in the customer ledger entry table is equal to 0. If it is, it displays 'No balance'; otherwise, it shows the actual amount. 4. Drag the formula down to apply it to all the rows in the column, and the 'no balance' text will appear whenever the amount is 0. Remember to adjust the table and column names to match your specific scenario. I hope this helps! Regards, Dr. Gomathi S
Thank you for informative session.please make an video on json consumption in business central
Sure
Hello Gomathi! What I really liked about this video is that you wrote the code line by line explaining each step. This makes the video duration longer but I get the feeling I learn better this way instead of copying&pasting the code from your GitHub. Thanks for your efforts!
Thank you so much for your valuable feedback. I will follow this type of explaining the concepts from the upcoming videos. 🤗🤗🤗🎉🎉🙏🙏
Thank you so much .
Welcome.
Hello! Can I make an action that connects with a codeunit and it has all that code inside? Would it work too?
Yes. Possible.
Thank you Mam
Welcome.
Hi, I write a logic i. e. Using excel buffer my header column names will be repeated or iterated.
Like below example;
Quantity Value Quantity Value Quantity value.
Can you please give me the idea
Hi,
I haven't experienced this personally, but try the below steps
To achieve the repeated or iterated header column names in your Excel report, you can follow these steps:
1. First, make sure you have set up your Excel buffer properly to handle data export.
2. Next, you'll need to design your report layout. In the report's dataset, you can define variables to hold the header column names (e.g., Quantity, Value, Quantity, Value, Quantity, Value).
3. In the report's data item, you can write a codeunit or function that populates these variables with the appropriate column names in the desired sequence.
4. When exporting data to the Excel buffer, ensure that you add these variables as part of the data output, so they appear in the first row of your Excel sheet.
Hi Goms. Wanted to connect with you regarding BCE implementation. Let me know the best way to connect.
Hi Mam, i have one query related to Merging of 2 or more columns(eg: A and B) cells in excel template into 1 single cell. I'm using excel buffer to export the data from Business central Saas 24.2 IN version. so i want to merge 2 or more cells in excel to show the captions. Is there any way to merge the column cells. please guide me.
Please try this
ExcelBuffer.NewRow();
ExcelBuffer.AddColumn('Caption for Merged Cells', false, '', true, false, false, '', ExcelBuffer."Cell Type"::Text);
ExcelBuffer.AddColumn('', false, '', false, false, false, '', ExcelBuffer."Cell Type"::Text);
ExcelBuffer."Merge Cells" := 'A1:B1';
@@gomstechtalks Thanks mam for your quick response, I just verified, that Merge cells field or procedure not available in BC SaaS 24.2 IN version Excel Buffer table. Any alternative for BC SaaS IN version.
@user-hk6qr2un1m I am using a different version. Let me check for any other possibilities and update you.
@@gomstechtalks Thank you, Please.
Hi, I want write a condition on excel report using excel buffer. My report has amount column, & this column come from customer ledger entry table. If my amount is 0 then display no balance text in column. Can you give me idea, how to do this
Hi there!
To display 'no balance' text in the amount column of your Excel report based on the customer ledger entry table, you can use an IF statement in Excel. Here's an idea on how to approach it:
1. Open your Excel report and locate the column where you want to display the 'no balance' text.
2. In the cell where you want the text to appear, enter the following formula:
=IF(CustomerLedgerEntryTable!Amount = 0, "No balance", CustomerLedgerEntryTable!Amount)
Note: Replace 'CustomerLedgerEntryTable' with the actual name of your table and 'Amount' with the corresponding column name.
3. This formula checks if the amount in the customer ledger entry table is equal to 0. If it is, it displays 'No balance'; otherwise, it shows the actual amount.
4. Drag the formula down to apply it to all the rows in the column, and the 'no balance' text will appear whenever the amount is 0.
Remember to adjust the table and column names to match your specific scenario. I hope this helps!
Regards,
Dr. Gomathi S
Nice video Before I don't know This concept but but after i see this video this is very useful for me and can you explain the matrix page also
Sure. Thank you
How to bold and italic excel export file headers.
Usual formatting options. Once you created the report, you can do that.
i tried Task and it also completed thank you mam
Great to hear. Thank you.