How to inject javascript into a Webi report

Well it's quite easy! Let's say we want to display a message to the user every time he opens the report.

Step 1
The javascript is easy


Step 2
We open the document and add a blank cell somewhere in the report

Step 3
With the blank cell selected we go to Properties --> Display --> Read cell content as... and select HTML. By doing this we tell BO to treat whatever we write inside the blank cell as HTML. By default it treats it as it was simple text.

Step 2 and 3
Step 4
We select the blank cell and write to the Formula Editor:
<script type="text/javascript">alert("Hello injection!!!");</script>
Step 5
Then we press the validate button and save the report.

Step 4 and 5

Step 6
Open the report (view) and the message we wrote in javascript appears!



Aesthetic Tip
Select the blank cell and remove the borders in order to make it "invisible" to the user's eye.

Comments

  1. bbains9 Jul 2013, 18:47:00

    Great technique! Is there any way to delay the script execution until after user prompts have been selected?

    ReplyDelete
    Replies
    1. Antonis Tsalapakis10 Jul 2013, 11:22:00

      I haven't tried that but I can't think an easy way to do that...

      Delete

Post a Comment

Popular posts from this blog

Freeze panes in BO Webi report like Excel

Image
Since the design of my first BO report a need kept coming up. The need for freeze panes. When there is a table that doesn't fit in the screen and you start scrolling, the moment the headers disappear you lose track of your data and start scrolling up and down, left and right again and again to see those headers. Well here it is what you need to do to add freeze pane capabilities to your report. For this example we have the crosstab table of the screenshots below: Headers disappeared The logic is quite simple. With the help of javascript we are going to move headers accordingly to the user's scrolling so as the user thinks the headers are pinned to the screen while the body of the table is moving. The problem is that if we see the structure of the crosstab it is actually an html table which means that we can not move header cells independently from body cells. HTML structure of the crosstab So we have to break the crosstab down to three independent...
Read more

IIS "Access to the path 'C:\inetpub\wwwroot...' is denied."

Image
When a website in IIS gives you the following yellow screen of death with "Access to the path 'C:\inetpub\wwwroot...' is denied." this means that it is a permission thing. The account running your application pool doesn’t have permission to access this path. This will usually happen when you run your website under a different application pool other than the DefaultAppPool. When a new application pool is created, a new virtual account is created in Windows and it is this account that doesn’t have permission. To solve this issue: In Windows Explorer, right click on the folder you have your website files; in my case C:\inetpub\wwwroot\dnndev8.me\, and select Properties Go to tab “Security” Click “Edit” Click the “Add” button In the “Select Users or Group” window click “Locations” and select your local computer Then in the “Enter the object names to select” textbox write “IIS AppPool\dnndev8.me” without the double quotes. My app pool name was dnndev8.me...
Read more

Convert Outlook EntryID to EwsID Exchange Web Services

I found myself trying to find an email in Exchange the other day, based on the EntryID I could retrieve from the email in Outlook (Exchange account). I was using Exchange Web Services EWS to access the mailbox the email was stored in. In EWS you can retrieve an item by providing its ID Dim item As Item = item.Bind(service, New ItemId(entryid))   Well quickly I found out that the EntryID of the email in Outlook was not what I wanted. After some reading I discovered the ConvertId function that converts ids from one format to another. The available formats are  EntryId EwsId EwsLegacyId HexEntryId OwaId StoreId   So I went on to do the obvious, convert my ID from EntryId to EwsId. I wish! Microsoft.Exchange.WebServices.Data.ServiceResponseException "The specified object was not found in the store." was what I got to my surprise! What actually was wrong was that the EntryID was not in EntryId format but i n HexEntryId format . The code that gets th...
Read more