Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Can we embed an excel worksheet into the RQM dashboard?

I have a report that is created in excel, which contains charts. I would like to display this on the RQM dashboard. Is there a way we can do this.

I have tried using html widget and savingthe excel chart as an image . However this does not work.

Please advise.

0 votes

Comments

What happens when you try to include the image in the HTML widget?



One answer

Permanent link
Hi Seema,
You will need to put your image of the chart on a server that can be reached by a URL that is accessible from the RQM server machine (It will not go through  any firewalls you might have in place!).

The steps are:
On the dashboard use the "External Content" widget.
In the settings of that widget you can specify the external URL for your image graph:
For example:
http://www.ibm.com/images/portal/X793998X98785J28/08152011_Redbooks.png

In case this is blocked by your infrastructure you can also try to use the Tomcat server of your CLM installation
Create the folder C:\Program Files\IBM\JazzTeamServer\server\tomcat\webapps\ROOT\static
(or where you have installed your server) and put your images in there.
For example C:\Program Files\IBM\JazzTeamServer\server\tomcat\webapps\ROOT\static\mychart.jpg
The URL to use  inside the widget is then something like https://clm-server:9443/static/mychart.jpg

Hope this helps,
Gerd Schiering
TechSupport
IBM Rational

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,014

Question asked: Mar 21 '13, 9:07 a.m.

Question was seen: 5,339 times

Last updated: Mar 25 '13, 7:06 a.m.

Confirmation Cancel Confirm