Reports: multiple problems: printing, querying, trigger
Posted on 2004-08-11
I am making my first baby stept with Oracle Reports Services and have a few things I can't figure out. (This is more or less a 'help me get started please' :-)
a) I installed Oracle (9.0.4) on both Win2k and WinXP. Both are on the same network and both have the same printer installed as default (and only) printer. Both Oracle Reports servers have the same configurations (Except for their hostname and IP dependent config switches ofcourse). Running a report on the WinXP system goes just fine: I enter the correct URL in a webbrowser and it rolls out of the printer. But whenever I try to run a report on the Win2k server it gives me the error "REP-3002: Error initializing printer. Please make sure a printer is installed." Which is rediculous because it is installed perfectly fine. I tried this with multiple printers. Also on the XP box no matter what the printer settings are in the windows printer dialog, it always wants to print from the multi-purpose paper feeder (tray 0) and no other one. Which is rather anoying. I suppose there must be some way to tell Reports Services to use another one. Any hints/tips/suggestions?
b) In my report I defined a user parameter KP_ID which I use in my query as '... where id = :KP_ID'. The report is printed without any text though. Just the background image appears. I suppose this is because I fail to understand how to create the proper key in cgicmd.dat. Currently it looks like this:
brief: userid="user/pass@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=testserver)(PORT=1521))(CONNECT_DATA=(SID=MYSID)))" report=D:\projects\reports\brief.rdf destype=printer
What to add? I fail to understand the bit of documentation in the cgicmd.dat file I guess.
c) I installed the event-based reporting API in the Oracle 9i DB server (9.2) but now am searching for explanation on how to create a trigger that will call this report whenever an insert occurs on a specific table, but the documentation CD is not of any help, or I am just to stupid to find the correct page in that jungle of documents. Heh.
A lot of questions. I know. Assigned all points I currently own. Hmm... think I should become a paying member here. Will fix that soon.