Random Thoughts

Views on life

Building Live Dashboards using Live Office

Posted by Hemanta Banerjee on February 3, 2011


In my previous post Creating Live Dashboards using QWAAS I had shown how you can use QWAAS (query as a webservice) to build live dashboards. While QWAAS is very powerful it has 2 drawbacks

  1. It is only available as part of BusinessObjects Edge/Enterprise (BOE). Crystal reports server (CRS) users do not have access to it.
  2. Can be confusing for the end user

Live Office is a great utility that comes as part of CRS and BOE and allows embedding reports or report parts within Microsoft Office documents. It is compatible with excel, word and PPT and allows creating live refreshable documents directly within MS Office.

Click here to download video

Using Live office to create refreshable office documents

 

As shown in the video above the process of creating a live document is quite straightforward. Now we know that XCelsius works with excel documents and using live office we can create a live excel documents. So putting these together we can now create a live dashboard which uses an existing crystal reports to fetch data from the database.

Click here to download video

Using Live Office and Excel to create connected dashboards

 

Using this technique it becomes quite easy for end users to pickup existing reports that already contain the data needed by the dashboard and quickly create live dashboards.

To download HD videos of this post please vi

Advertisements

6 Responses to “Building Live Dashboards using Live Office”

  1. […] This post was mentioned on Twitter by The Xcelsius Gurus, ASUG. ASUG said: RT @XcelsiusGurus: New Post: Building Live Dashboards using Live Office: http://bit.ly/gN5fSB #Xcelsius #BOBJ #LiveOffice […]

  2. Runtime-Error-429 said

    Works Great ! Just what I needed.

  3. […] Building Live Dashboards using Live Office […]

  4. Excellent article. I was checking constantly this blog and I am impressed! Very helpful information specially the last part. I care for such info much. I was seeking this particular information for a very long time. Thank you and good luck.

  5. Nice post. I was checking constantly this blog and I am quite impressed! Very useful info particularly the first part. I care for such info a lot. I was looking for this certain info for a long time. Thank you and good luck.

  6. […] this with the live office functionality discussed in the last post should allow you to build really powerful and interactive dashboards. You can download a more […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: