[Solved] Templates for Reporter?

[Anon Anon]

Were do I go to find more templetes for reporter?  Or for that matter, how do I create new templetes so that I can report on other things.

One of the main things I need to report on are updates/changes/additions to any uproc/task/session/unijob, etc.

[Anon Anon]

Hello,

It's technically possible to create and plug new reports for Reporter, but for now there is no documentation that explains how to create custom reports.

So I think the only "official" way to  get new report is to ask to ORSYP Professional Services.

Regards,

Didier.

[Anon Anon]

Thanks I'll open a case on getting new reports created.

[Anon Anon]

I was informed that there are no new templates for reporter.  What I'm trying to do is accessable with Publisher.  We didn't purchase that part of the ORSYP product line.

[Anon Anon]

Hello John,

Reporter runs reports on the operations (basically job status) when Publisher documents the job settings (Uprocs, Sessions, Tasks et al).

You also have the audit trail which is included in Dollar Universe, which tracks the objects changes.

Hope this clarifies things,

Michel

[Anon Anon]

Auidt trail does not help with unijob changes.  I also tried looking for the audit trail in dollar universe.  I can't seem to find it.  I've been through every window, every option.

[Anon Anon]

UniJob audit-trail can be displayed from the Audit tab in the associated information box in the UniViewer Console. The audit trail itself will be extracted by Reporter or displayed with a command (see unilst AUDIT). The Audit Trail is activated from the UVMS Node Settings, in the Logging section.

Dollar Universe audit trail is activated by default in recent releases (as of v5.2). As far as I know, it has not been integrated in UniViewer yet, but the data is present in file uxiotrns.log in the log directory of the Area concerned.

Michel

[Anon Anon]

I was given access to Ireport, the free utility for creating jasper reports that Reporter uses.

I get this error when opening up one of the existing reports:

Error loading the report template:
net.sf.jasperreports.engine.JRRuntimeException: No query executer factory registered for the 'ORSYP_SQL' language.

What does this mean?

[Anon Anon]

[quote name='John Ling' post='9215' date='August 12 2011, 09:28 PM']Error loading the report template:
net.sf.jasperreports.engine.JRRuntimeException: No query executer factory registered for the 'ORSYP_SQL' language.

What does this mean?[/quote]

Hi John

ORSYP uses a custom query for shortening the SQL in the reports.

So I presume you're using iReport v4.0.2 ?

From the menu TOOLS > OPTIONS> QUERY EXECUTERS

ADD

Language: ORSYP_SQL
FactoryClass: com.orsyp.reports.filters.OrsypJdbcQueryExecuterFactory

Then from TOOLS > OPTIONS> CLASSPATH

Add the jars:
<REPORTER_DIR>/exec/RepServerJava.jar and
<REPORTER_DIR>/exec/RepPubServer.jar


I suppose you're trying to open the .jasper files (compiled Jasper reports) in <REPORTER_DIR>/data/reports/templates/system/<dbtype>?

This proposes to convert the Jasper report to a .jrxml template file.

Then you should be able to customze the report...let me know how you get on.

Regards

Gary

[Anon Anon]

Thanks Gary.  This worked like a charm&#33;   The report came up nicely.  I have one question though.  It seems to want to save the file as the jrxml file.  Where do I go to compile the report?

[Anon Anon]

[quote name='John Ling' post='9237' date='August 17 2011, 04&#58;05 PM']Where do I go to compile the report?[/quote]

The compile button is in the report document toolbar to the right of the zoom out. It looks like a hammer and a sheet of paper.

Regards

Gary

[Anon Anon]

Hi,

have you been able to create you custom reports? For me this does not work. No problem in opening a jasper-file in Ireports and it does compile, but reporter does not seem to be able to handle these jasper-files. Which seems logical since according to what I've read jasper is not forward compatible at all and Ireport can create a backward compatible jrxml but it wil still create a jasper file in the ireport version.
I'm using ireport 4.1.1 and report 3.0.0 which contains jasperreports-3.1.3.jar. So I have been trying to use Ireport 3.1.3 but here I cannot find a compile button neither can I find where to specify the query executer ORSYP_SQL.
I've also tried using the 3.1.3.jar in 4.1.1 but then I can't compile.

[Anon Anon]

[quote name='Recordbank IT Operations' post='9320' date='August 26 2011, 03&#58;39 PM']jasper is not forward compatible[/quote]

This would appear to be true.
Consequently, you should be using a version of iReport which corresponds to the version of the JasperReports x.x.x.jar.

[color="#1F497D"][color="#000000"]What we use for editing and  fixing reporter maintenance bugs is iReport 3.0.0 and it can be found here : [/color][url="http://sourceforge.net/projects/ireport/files/iReport%20%28classic%29/iReport-3.0.0/"]http://sourceforge.net/projects/ireport/fi.../iReport-3.0.0/[/url]  .

[/color]     [color="#000000"]To define Query Executors:[/color]


[b][color="#000000"]Menu Bar > Options > Query Executors
[/color][/b]

To compile:

[b][color="#000000"]Menu Bar >Build > Compile[/color][/b]

[color="#000000"]Even in iReport V4.0.0 you can set compatibility to JAsperReports 3.1.3:[/color]

[color="#1F497D"][color="#000000"][b]iReport > General > Compatibility[/b]
[/color][/color]

    [color="#1F497D"]
[/color]

    [color="#1F497D"] [/color]

    [font="Arial"][color="#000000"]I Hope this [attachment=413:ireport.PNG]answers all your questions?[/color][/font]

[font="Arial"][color="#000000"]
[/color][/font]

[font="Arial"][color="#000000"]Regards[/color][/font]

[font="Arial"][color="#000000"]
[/color][/font]

[font="Arial"][color="#000000"][color="#1F497D"]Gary
[/color][/color][/font]

[font="Arial"][color="#000000"]    [/color][/font]

[Anon Anon]

I was using iReport-nb-3.1.3 which seems to be a port of ireport to netbeans which is really incomplete. I can't find anywhere to set the query executer anyway. I hadn't seen the ireport classic before which I have used now thx to Gary and which seems to be working perfectly. I do get a query executer problem when I open a jasper file but when compiling ireport clearly states Setting com.orsyp.reports.filters.OrsypJdbcQueryExecuterFactory as Query Execute
r Factory for language: ORSYP_SQL. It seems ireport does not really realize the query executer is correctly defined when opening a jasper-file and claims incorrectly there is a problem.

Concerning the compatibilty in 4.0.0 (or later I've been trying 4.1.1) as far as I read the info about this correctly I've understood that when opening a jasper-file in compatibilty (eg 3.1.3) it will create a 3.1.3-compatible jrxml but when compiling it still uses the 4.x.x engine and in so creating a non-compatible 4.x.x jasper-file. IMHO iReport classic 3.0.0 is the only out of the box usable gui to edit reporter-templates.

One last question. Would it be possible to upgrade reporter to be using a new version of jasperreports (by replacing som jars or changing some parameters) so to be able to use all latest jasperreports functionality and the latest iReport-version? Not that it is that likely we will want to fiddle with that but it's just nice to know.

Floris

[Anon Anon]

that would be nice to know too since I just started working with ireport and have the 4.0.2 version.

[Anon Anon]

Reporter V3 was generated using iReport V3.1.3
    The documentation specifies: 

[quote]The user is at liberty to create custom reports  from scratch with the [b]iReport v3.0[/b] utility.


The .jasper files should be deposited in:

    <ReporterServer>&#092;data&#092;reports&#092;templates&#092;custom&#092;<db_type>[/quote]

Reporter v4 was generated with JasperReports v4.0.1  so no need for a Product Enhancement Request.

What seems to be clear is the necessity to use the version of iReport corresponding to the JasperReport.JAr version.

Regards

Gary

[Anon Anon]

Cool.  Now the bigger question is how do I get connected to the database?

I have the creditials to my oracle database.  iReport doesn't come with the drivers for oracle (they are "red").  I have them installed for another product I use (quest's TOAD) that connects to the database.  it's an Oracle 9 database.   I tried using the "mysql" driver, but all it did was hang the program.  Any suggestions?

[Anon Anon]

John

You should be able to download them from www.oracle.com

As for driver versions you should check with iReport documentation.

Good luck

Gary

[Anon Anon]

I got this up and running.  However, I get this error when trying to preview the report.  I have made no changes to one I pulled in that comes with reporter:

[quote] Compiling to file... C:&#092;AmLL&#092;TUJ-1-2 Job Status with List of Anomalies.jasper
 Compiling subreports....
 Subreport C:&#092;AmLL&#092;TUJ-x Data Validity Subreport.jrxml already compiled.
 Subreport C:&#092;AmLL&#092;TUJ-1-2 Job Status with List of Anomalies Subreport 2.jrxml already compiled.
 Subreport C:&#092;AmLL&#092;TUJ-1-2 Job Status with List of Anomalies Subreport 1.jrxml already compiled.
Compilation running time: 14,719&#33;
 Filling report...
 Locale: English (United States)
 Time zone: Default
Error filling print... null
java.lang.NullPointerException      at com.orsyp.reppub.server.context.ServerContext.getInstanceOf(ServerContext
.java:15)      at com.orsyp.reports.filters.OrsypJdbcQueryExecuter.registerFunctions(OrsypJ
dbcQueryExecuter.java:35)      at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.<init>(JRJdbcQueryExecuter.java:113)      at com.orsyp.reports.filters.OrsypJdbcQueryExecuter.<init>(OrsypJdbcQueryExecuter.java:28)      at com.orsyp.reports.filters.OrsypJdbcQueryExecuterFactory.createQueryExecut
er(OrsypJdbcQueryExecuterFactory.java:22)      at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFi
llDataset.java:681)      at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDatas
et.java:605)      at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.
java:1281)      at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:901)
      at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:845)
      at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:58)      at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManage
r.java:417)      at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManage
r.java:247)      at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompi
ler.java:878)      at org.openide.util.RequestProcessor&#036;Task.run(RequestProcessor.java:572)      at org.openide.util.RequestProcessor&#036;Processor.run(RequestProcessor.java:997) 
Print not filled. Try to use an EmptyDataSource...[/quote]


What could be missing here?  I don't know how to read this.

[Anon Anon]

John


It looks like you are trying to  compile and fill the report with iReport.

This will not work  as the parameters sent by Reporter are formated in Univiewer or directly in  Reporter.


If you want to test the  reports created in the same style as the reports that are already  available in the Reporter Server you will have to fill them in Reporter/Univiewer.


Hope that helps?

[color="#1F497D"]Gary
[/color]   

[color="#1F497D"] [/color]

[Anon Anon]

[quote name='John Ling' post='9392' date='September 8 2011, 03&#58;20 PM']What could be missing here?  I don't know how to read this.[/quote]

Hello,

I don't really know how to read it, so I'm not sure neither... but I would first check the if the connection to the database is correctly configured: when you setup the Database connection, there is a button in IReport to verify the connection. Is the verification successful?

Regards,

Didier.

[Anon Anon]

yes, the connection is verified and working properly.

[Anon Anon]

John

Did you see my post - the one before Didier's?

Was that clear?

Gary

[Anon Anon]

I think so.  All I did was import an already existing report, then tried to preview it.  that was all.  I didn't hcange anything in the report.

If I understand correctly, I should create the report, compile it, push it to the reporter server, test it.

[Anon Anon]

[quote name='John Ling' post='9442' date='September 12 2011, 03&#58;48 PM']If I understand correctly, I should create the report, compile it, push it to the reporter server, test it.[/quote]

I reckon so...I was serving as middleman for the message in question and haven't got down to the nuts and bolts of Reporter yet. I will probably knuckle down next week when I'm finished with generic supervision.

regards

Gary

[Anon Anon]

Please note that the tutorial on how to customize a standard report template is now available:

http://www.orsypforum.com/index.php?showtopic=3093


Gary

[Anon Anon]

Hi Gary,

So there is really no way to have an execution of a report in ireport itself using ORSYP_SQL??
I do mention using ORSYP_SQL since at the moment as a workaround I change ORSYP_SQL into SQL and change all lines with &#036;X{REPORTER_DB_FILTER into standard SQL eg I change &#036;X{REPORTER_DB_FILTER, rl.SESSION_NAME, SESS} =>  rl.SESSION_NAME = SESS (I do know this is not the same) . Off course this does not give me the full functionality of the ORSYP_SQL but it's more than sufficient to be able to test a report. After I've tested my report I change back to ORSYP_SQL and put in REPORTER_DB_FILTER where applicable.
It would surprise me if that is the way professional services works as well
FYI using ORSYP_SQL always retrurns the error as mentioned in #19

Regards,

Floris

[Anon Anon]

Floris

R&D informed me that Reports could not be tested directly in iReport (because of the ORSYP_SQL).
You seem to have found a solution that allows you to get round this barrier, but all the chnages you need to make to do this seem quite heavy in comparison to pushing the report to Reporter and testing it there.

May I ask why it's so important for you to test in iReport?

Regards

Gary

[Anon Anon]

Hi Gary,

      first of all those changes are not that heavy. It takes me ca 2 minutes to make the change from orsyp_sql to sql and 1 minute to change them back (just need to copy paste the original REPORTER_DB_FILTER's back). Second of all it's really much easier to instantly see the result of my modifications in stead of having to upload them to the reporter server and creating a report (I think I gain 2 minutes with every test I want to do, normally it takes me at least 20 tests before I'm satisfied with the report I created). I could start scripting some automation for this which would give me less overhead instead of the manual ftp and report generation but switching to sql is still the fasted solution IMHO. Using sql in stead of orsyp_sql also gives the advantage of being able to use the query designer and having immediate access to the fields of the used tables.
      so if I understand you correctly professional services also changes reports, compiles them and then uploads this to their reporter server. I find this a bit hard to believe since we received reports from professional services where the LOGO_FILE_PATH was changed to a local folder as initial value. If they test the reports with reporter and not through ireport this does not make any sense since reporter will overwrite this parameter value.

kind regards,

Floris

[Anon Anon]

OK Floris, now I understand the problem a little better, I'll try and find out what Professional Services do to get round this.

This will remain however a workaround, since R&D says you should test your reports in Reporter.

It looks like this may need a Product Enhancement Request to get improvement but no guarantees on priority.

Regards

Gary

[Anon Anon]

Floris

I hope this extract from a internal document may be of help:

[quote]
[b]     Add the Query Executer classes to the class path[/b]

To be able to compile and execute Reporter v3.0 type of reports you need to give iReport access to the new enhanced filter classes added in this version.
In consequence you need to take the following jars from Reporter’s exec folder:[list]
[*]RepPubCommon.jar
[*]RepPubServer.jar
[*]RepServerJava.jar
[/list]
And put them in either the iReport class path:

Or copy them in iReport’s lib folder: [i]“C:\Program Files\JasperSoft\iReport-3.0.0\lib”[/i]

[b]     Register New Query Executer[/b]

The user must register a new [b]query executer[/b] inside iReport. This is done, by accessing the [b][i]Options/Query executers[/i][/b] menu option.

The new executer that has to be added has the following information:[list]
[*]Language: [b]ORSYP_SQL[/b]
[*]Factory Class: [b]com.orsyp.reports.filters.OrsypJdbcQueryExecuterFactory[/b]
[*]Fields Provider class: [b]com.jaspersoft.ireport.designer.data.fieldsproviders.SQLFieldsProvider[/b]
[/list]
[/quote]


Gary


PS I got feedback from the PS guy who said he set up a batch to copy the compiled templates to Reporter for testing.

[Anon Anon]

Hi Gary,

this is in fact the information which is already on this forum. which gives
[quote]Error filling print... null
[font="Courier New"][size="3"]java.lang.NullPointerException [/size][/font]
    at com.orsyp.reppub.server.context.ServerContext.getInstanceOf(ServerContext.java:15)
          .......
[/quote]
when run in ireport. So it seems changing to SQL or creating a batch to pick-up the new template and create a report out of it is the only available solution at this time.

regards,

Floris