Step by step to create Bar Chart in Webclient UI
You can download the library and example from this link.
You can follow this document to create Bar Chart and embed it in your CRM system.
Although there are lots of js and css file in the downloaded library, in this sample only 8 of them are needed:
You can find all of them from attached file, just rename JChartLib.zip.txt as JChartLib.zip and unzip it.
Go to SE80 mime repository, follow the path “/bc/bsp/sap/crm_ui_frame” to find folder “CRM_UI_FRAME”. Create a folder “jchart” under it via context menu Create->Folder:
Repeat the operation ans ensure all the 8 files are created in mime repository correctly. ( The mime type for css file is “text/css”) Once done, it looks like below:
2. Create a new UI component and draw Bar Chart there
copy the source code of file main.html from attachment into the empty view you just created in UI component:
A brief explanation on the source code of main.html
- line18: create a new chart instance
- line19: position the chart into html element with ID = divChart1
- line20: set chart type as Bar
- line21: feed the chart with JSON data
- line22: enable 3D effect to make the chart look more fancy
- line23~25: set title
line28~line73: hard code the JSON data stream for chart
line81~line112: since I am not happy with the default color defined in css file, so I redefine them here.
So far, the development of webclient UI component is finished.
3. Create a new work center and put the UI component into it
Please find step by step about how to achieve it from this link.
Feel free to adapt the source code of this sample to meet with your own requirement.
Update on 2017-05-27
Great one! Any chance to see the code between lines 28 and 112? The screenshot contains only the code from 16 to 26.
The complete source code is in attachment of this document, file "main.html". 🙂
Great! Very useful!
Thanks for your work, Jerry!
Great document! It is clear and concise, showing the detailed steps needed to create charts that so many people are asking for.
Thanks for linking to the external content. This helps so much.
Awesome document Jerry,
Just few doubts. I downloaded the library from jChartFX. I did not see jquery-1.7.1.js file there. Is this file required? If so then from where can i have this?
Also did not get luck to see the attachment you appended in the doc. since it is ending up with some corrupted text file containing special chars only.
Can you please share the same since it seems main.htm has the main logic.
since it is not allowed to upload .zip file as attachment in SCN, so I did it via a workaround. In this document you could see the following attachment:
download it locally and unzip it, you will get a folder like below:
Open the folder and you will see a text file.
This text file is actually a zip file. Change it from "JChartLib.txt" to "JChartLib.zip", then unzip it and you will get all contents.
regarding the jQuery library usage, currently I use jQuery's document.ready function in maim.html:
If you use the event window.onload to call the initialize(), then I think jQuery is not necessary ( I haven't tried it yet ).
Thanks Jerry for sharing this. But it seems file got corrupted or something went wrong. I followed those steps but no luck. 🙁
I am missing that jquery and main.htm file. Anychance if you can zip these two files only?
it is strange. I just checked it from my side and it works quite well. I have reattached the main.html into attachment of this document. For the jQuery file, you can just download it from any website.
THanks Jerry for sharing this.
could you please check component FICACMP_ACC. I think the BAR chart coming in this component is not coming by this method.
Is there any other method to create these charts?
this component is attached in account balance->account balance overview,
Please guide me if there ia nay other way too.
Wow I never knew this component before! Could you please kindly tell me via which business role could I log on the web client UI so that I could see it there? Then I can investigate how it is built. Thanks a lot!
Jerry thanks for your reply....My problem is resolved...actually i was talking about some other type of BAR and PIE charts. I got the logic on how BAR graphs are getting created in this component...the code is written in a standard class CL_THTMLB)CELLERATOR.
I cant see the attachements, can you send me pls ?
Unfortunately the attachment is gone after the community is migrated. I will check in my system about the source code this evening after I return home.
please find the step to download source code from here.
Thank you Jerry.
Just wondering do we need to keep in mind the licensing cost of these graphs or are these freeware?