Your videos were very helpful to fix all my Business Central development challenges! Millions of thanks! Keep posting new videos... (I subscribed your channel! ;) )
4 года назад+2
Hi Erik. Great tutorial. A sugestion as far as performance is concern, if you allow me. Instead of: if rec.findset(false,false) then begin repeat rec.calcfields(field1,field2....); until rec.next() = 0; end; Use this: rec.setautocalcfields(field1,field2....); if rec.findset(false,false) then begin repeat until rec.next() = 0; end; It's much more effective.
Great suggestion, have you tried doing an actual performance comparison on that?
4 года назад+1
@@Hougaard Yes, with the item record and a lot of records in it. It's not as awesome as the one you proved with TextBuilder, instead of Text concatenation, but it's ok. Ta Erick...... By the way....... I love your videos..... Keep doing them
I'm sure you guys already knows, but if anyone is reading this and wondering why setautocalcfields could be a lot faster, I believe it is because the calculation is done as part of the initial findset query on the sql server. The calcfields solution will do an extra query to the sql server per record for calculating the fields. In a huge table (many records) it will make a huge difference.... 1 sql query vs 1+n queries...
Thank you very much for this video. I got the implementation of Business Charts assigned as my qualification's final project and the lack of documentation really threw me off. After a little digging, I believe the bubble chart type is not even considered in the underlying .js file, so it's not like you had any chance except breaking it with that option. Did you ever figure out what the second parameter is used for?
Hi Erik, Thanks for sharing your know-how to us! Great tutorial - I wanted to enhance this by applying filters (e.g. Date Filter) but failed. I found the CurrPage.Chart.Refresh(), but in using it in validating the filter kills more or less the session. Do you have an advice?
@@Hougaard True, thanks for the hint. As I didn't manage to call the Buffer outside the usercontrol, I put the whole code in a local procedure which I'm now able to call whenever needed. Works great :-) Greetings from Austria, Stefan
Hi Erik Sir, Thank you very much for this video, Video is very helpful, And I Request Pls Create New Chart For Location Wise Sales Amount And Show Amount On Column Chart on Column..., Pls I Request...,
Hi Erik, thank you very much for the video, it helped me a lot to understand and work on charts in BC and I want to know how to filter the records based on Option or Enum field. For example i have 2 options In progress and Resolved with these status some records are there and against that some balance i need to show. I tired and able to get the chart but option names are not coming how to get them, can you please help me out to achieve that.
Hi Erik ,I'm Vivek from India. its so amazing to see your videos. Your Videos are very helpful for us. I just want to ask that I want to make a chart of customer and I want to see the details of his ship to address value in chart. can we do it with code.
@@Hougaard thanks for your time. I want to create a chart on customer card page and I want customer invoice details according to their ship to code location. I have seen how many invoices have been created from different ship to customer codes.
First of all, there are no silly questions, only silly answers (follow me on twitter @ehougaard for that) - By "generic" do you mean a function that takes a random recordref and produces a chart, that would be a fun idea for a video :)
@@Hougaard yes, I follow you on twitter ;-) - By generic chart I mean the old charts that were shown in the role center in NAV 2013...2018, it would be possible to use them in Business Central OnPrem?
Hi Erik, thank you very much for the video. Very helpful and detailed. And I especially like your approach to naming videos )
Your videos were very helpful to fix all my Business Central development challenges! Millions of thanks!
Keep posting new videos... (I subscribed your channel! ;) )
Hi Erik.
Great tutorial.
A sugestion as far as performance is concern, if you allow me.
Instead of:
if rec.findset(false,false) then begin
repeat
rec.calcfields(field1,field2....);
until rec.next() = 0;
end;
Use this:
rec.setautocalcfields(field1,field2....);
if rec.findset(false,false) then begin
repeat
until rec.next() = 0;
end;
It's much more effective.
Great suggestion, have you tried doing an actual performance comparison on that?
@@Hougaard Yes, with the item record and a lot of records in it.
It's not as awesome as the one you proved with TextBuilder, instead of Text concatenation, but it's ok.
Ta Erick......
By the way....... I love your videos..... Keep doing them
That for the feedback, I'll make sure to mention setautocalcfields in a later video :)
I'm sure you guys already knows, but if anyone is reading this and wondering why setautocalcfields could be a lot faster, I believe it is because the calculation is done as part of the initial findset query on the sql server. The calcfields solution will do an extra query to the sql server per record for calculating the fields. In a huge table (many records) it will make a huge difference.... 1 sql query vs 1+n queries...
Thank you very much for this video. I got the implementation of Business Charts assigned as my qualification's final project and the lack of documentation really threw me off.
After a little digging, I believe the bubble chart type is not even considered in the underlying .js file, so it's not like you had any chance except breaking it with that option.
Did you ever figure out what the second parameter is used for?
Nope
This dude is a bloody legend!
Erik your videos are incredibly helpful. Thank you.
Glad you think so!
Nice work! Reminds me of a special chart on a very special role center :)
Wow Erik. That is awesome.
I would love to see how you create dictionary behind the scene for the json data
Hi Erik, Thanks for sharing your know-how to us! Great tutorial - I wanted to enhance this by applying filters (e.g. Date Filter) but failed. I found the CurrPage.Chart.Refresh(), but in using it in validating the filter kills more or less the session. Do you have an advice?
I believe you can call buffer.update(CurrPage.Chart) multiple times.
@@Hougaard True, thanks for the hint. As I didn't manage to call the Buffer outside the usercontrol, I put the whole code in a local procedure which I'm now able to call whenever needed. Works great :-)
Greetings from Austria,
Stefan
Hi Erik. Nice Video. How to add a chart label name to that graph?
Hi Erik Sir, Thank you very much for this video, Video is very helpful, And I Request Pls Create New Chart For Location Wise Sales Amount And Show Amount On Column Chart on Column...,
Pls I Request...,
Sir When will you Provide the Video ?
Hey Erik, is there a way to create a 'Horizontal' Bar (Column) Chart? Cheers.
Not with that control. Check the video on the Google one...
Hi Erik, thank you very much for the video, it helped me a lot to understand and work on charts in BC and I want to know how to filter the records based on Option or Enum field. For example i have 2 options In progress and Resolved with these status some records are there and against that some balance i need to show. I tired and able to get the chart but option names are not coming how to get them, can you please help me out to achieve that.
There a several videos on the channel about setting filter with both SetFilter and SetRange, check them out :)
Hi Erik ,I'm Vivek from India. its so amazing to see your videos. Your Videos are very helpful for us. I just want to ask that I want to make a chart of customer and I want to see the details of his ship to address value in chart. can we do it with code.
nto sure I understand, what chart will show a ship to address, you mean a map?
@@Hougaard thanks for your time. I want to create a chart on customer card page and I want customer invoice details according to their ship to code location. I have seen how many invoices have been created from different ship to customer codes.
Loved it buy would like to see the version using power bi with on-prem server. Thanks
You mean, just using PowerBI to connect to your local BC?
I have that part figured out. Thanks. What I want is to show the Power BI inside BC
Then you need to use the on-premises data gateway docs.microsoft.com/en-us/azure/analysis-services/analysis-services-gateway
Erik Hougaard I have that!
So what happens when you click "Get started with PowerBI" from a rolecenter? (Are your users AAD connected)?
Hi Erik, is it possible to change the colors of the Chart?
I believe the colors are chosen by BC to stay within the great color scheme of BC.
Hi Erik
When i use colum there is no color, all are gray
depends on in the series, but all the colors are dull...
Hi Erik
Thanks for your response youare helpfull
Hi Erik, could you show a Generic Chart here? I'm sorry if it is a silly question
First of all, there are no silly questions, only silly answers (follow me on twitter @ehougaard for that) - By "generic" do you mean a function that takes a random recordref and produces a chart, that would be a fun idea for a video :)
@@Hougaard yes, I follow you on twitter ;-) - By generic chart I mean the old charts that were shown in the role center in NAV 2013...2018, it would be possible to use them in Business Central OnPrem?