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;
  PATH=C:/DevSuite10_home;C:/OLD_DevSuite9_home;etc...
  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>

Example:
http://localhost:8889/reports/rwservlet?report=rep_007.rep&userid=username/password@192.168.19.58:1
521/ORCL&desformat=pdf&destype=cache&YOUR_REPORT_PARAMETER1=image.bmp&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 http://www.rittmanmead.com/files/quick_start_guide_oracle_reports.html
Using the Oracle Reports Web Service http://download.oracle.com/docs/cd/B10464_05/bi.904/b13673/pbr_webservice.htm
In the case that you can't use report server and you're forced to use something on the clients, thake a look at
http://www.orafaq.com/forum/t/37321/2/

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 <.

Simple!

.NET MVC and Jquery

To understand jquery a good place to start (how to show/hide divs, fade effects, and so on) is http://docs.jquery.com/Tutorials:Getting_Started_with_jQuery and http://visualjquery.com/

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
</asp:ContentPlaceHolder>

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

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>