Hi Erik, thank you very much for the video. Very helpful and detailed. And I especially like your approach to naming videos )

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.

@Hougaard

3 жыл бұрын

Great suggestion, have you tried doing an actual performance comparison on that?

3 жыл бұрын

@@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

@Hougaard

3 жыл бұрын

That for the feedback, I'll make sure to mention setautocalcfields in a later video :)

@gertlynge

3 жыл бұрын

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...

Your videos were very helpful to fix all my Business Central development challenges! Millions of thanks! Keep posting new videos... (I subscribed your channel! ;) )

Nice work! Reminds me of a special chart on a very special role center :)

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

3 жыл бұрын

I believe you can call buffer.update(CurrPage.Chart) multiple times.

@kitcat3653

3 жыл бұрын

@@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

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?

@Hougaard

24 күн бұрын

Nope

Erik your videos are incredibly helpful. Thank you.

@Hougaard

2 жыл бұрын

Glad you think so!

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.

@Hougaard

8 ай бұрын

There a several videos on the channel about setting filter with both SetFilter and SetRange, check them out :)

Wow Erik. That is awesome.

Hi Erik. Nice Video. How to add a chart label name to that graph?

Hey Erik, is there a way to create a 'Horizontal' Bar (Column) Chart? Cheers.

@Hougaard

10 ай бұрын

Not with that control. Check the video on the Google one...

I would love to see how you create dictionary behind the scene for the json data

Hi Erik, is it possible to change the colors of the Chart?

@Hougaard

3 жыл бұрын

I believe the colors are chosen by BC to stay within the great color scheme of BC.

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...,

@rinku9528

2 ай бұрын

Sir When will you Provide the Video ?

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

4 ай бұрын

nto sure I understand, what chart will show a ship to address, you mean a map?

@viveksharma-zw5zk

4 ай бұрын

@@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

@Hougaard

3 жыл бұрын

You mean, just using PowerBI to connect to your local BC?

@YannSaintLaurent

3 жыл бұрын

I have that part figured out. Thanks. What I want is to show the Power BI inside BC

@Hougaard

3 жыл бұрын

Then you need to use the on-premises data gateway docs.microsoft.com/en-us/azure/analysis-services/analysis-services-gateway

@YannSaintLaurent

3 жыл бұрын

Erik Hougaard I have that!

@Hougaard

3 жыл бұрын

So what happens when you click "Get started with PowerBI" from a rolecenter? (Are your users AAD connected)?

Hi Erik When i use colum there is no color, all are gray

@Hougaard

9 ай бұрын

depends on in the series, but all the colors are dull...

@jaouahdouhosni6934

9 ай бұрын

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

@Hougaard

3 жыл бұрын

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 :)

@testdagustin7077

3 жыл бұрын

@@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?