venerdì 23 aprile 2010

Running Reports with Oracle Report Server 10G using a web browser

Of course, it's possible to run Oracle reports with a simple http request.
This approach only requires Oracle Report Server installed on the machine/server and responding on its port 8889.

  • Verify that you have all license rights to install Oracle Report Server

  • Install a PDF reader (personally I love foxit reader)

  • Verify that these environment variables are set:
    REPORTS_PATH = C:\your_reports_folder;
    Important: Make sure your latest Dev
    Suite is on your PATH environment variable first, before any older versions!

  • Start OC4J

  • Start your web browser and run your report using this sintax:
    http://<reports server name>/reports/rwservlet?report=<report file name>&<other report parameters>


Common problems:
If your report calls other libraries, these must be in the same directory of the report, and must be compiled/recompiled with Oracle reports builder 10g.

To avoid errors like the following:
Not able to load oracle.reports.util.EnvironmentGlobal class
Using oracle.reports.util.Environment class

you must also generate/regenerate REP file using 10g Report Builder AND check whether the file/folder has enough privilege to the logged in user.
If you still have problems try to copy it to another folder: there might be problem with the acess right in your folder.

For reference:
Useful guide to Oracle Reports
Using the Oracle Reports Web Service
In the case that you can't use report server and you're forced to use something on the clients, thake a look at

mercoledì 21 aprile 2010

How to insert code (such as HTML, PHP, Javascript code) in your Blogger post?

The solution is simple.

1. Copy the code into your NOTEPAD
2. Use Edit->Replace (or Ctrl+H) and in find all the < and replace them with & l t ; (delete the spaces between the characters, without spaces you would just see another < here)
3. Use Edit->Replace (or Ctrl+H) and in find all the > and replace them with & g t ; (delete the spaces between the characters, without spaces you would just see another > here)
4. Copy the code from NOTEPAD into the Blogger post
5. And you are done

What have you done? The & l t ; is another way of telling the browser to shov a <.


giovedì 8 aprile 2010

.NET MVC and Jquery

To understand jquery a good place to start (how to show/hide divs, fade effects, and so on) is and

When you are planning to build a .NET MVC form which performs insert/edit/delete over a DB, it's very useful the jqgrid plugin. The only "problem" that I found with jqgrid is that it requires data in a json format and, IMHO, this is not very "comfortable".

If you make a google search, you'll find examples of MVC responses which make almost everything by their own.
It would be great if you keep all your javascript code in a proper contentplaceholder of your views:
<asp:ContentPlaceHolder ID="ScriptContent">
your code here

In the Master Page it must stay empty: ;-)
<asp:ContentPlaceHolder ID="ScriptContent" runat="server">

There is also the way to use Intellisense for jquery in Microsoft Visual Web Developer! to do this simply refer to the -vsdoc.js file in the head of your MasterPage:
<script src="../../Scripts/jquery-1.4.1-vsdoc.js" type="text/javascript"></script>