[Jasper Report]

Hi Babs,

     JasperSoft offers a complete suite of applications.  Among the open source editions you will find iReport (a report designer, similar to Crystal Reports), JasperServer (reporting server), and others.  You can use iReport to design and run reports locally.  However, if you want to give other uses access to your reports via a web browser, you will need to install JasperServer, which is a web server that hosts reports.  You would still design your reports in iReport, and then upload them to the server.

 

[Error logging in to JasperServer 3.0 using postgre]

I haven't used JasperServer with a Postgres database, but if mysql has some tables that postrges doesn't, then perhaps you should add them?

[cannot start jasperserver 2.1]

I don't think you can do that, because the database and much of the code have changed. There are some scripts included to upgrade from 2.1 to 3.1, and you could run them in a test server so you don't mess with your production data.

[downloads of excel files]

Are these scheduled reports outputs in PDF/XLS, or just filex eported by clicking the PDF/XLS icons?

[How to use anchor for HTML]

I"m not quite sure what you're trying to do....   Do you want to click on a hyperlink and have it open another report, passing doc_number as a parameter?

[how to send data to jasperserver using WS]

I think JasperServer is designed mostly just to run reports (read-only), not to enter data like a web form.

[Should I pay for JasperReports?]

There are two versions available, one that's commercial and one that's open source.  The open source one doesn't have all the features of the commercial edition, but it's VERY usable and it's free, even for commercial use.

 

To use the commercial version, you need to pay for a license.  You'll need to get a quote from jaspersoft.com.

[Mutiple Input Controls]

I don't think you can unless create custom JSP pages. Do a search in this forum for "cascading" input controls.

[Single select querry]

I usually do a UNION in my query... something like this:

SELECT '%' AS Value, '  All  ' AS Label

UNION ALL

SELECT MachineName AS Value, MachineName AS Label FROM NC_Workstation

 

Then, in your report query, you would use LIKE:

SELECT *

FROM NC_Workstation

WHERE MachineName LIKE $P{InputMachineName}

 

This blog post has some examples:   http://blog-gabriel.mongefranco.com/2008/07/csv-and-wildcard-searches-in.html

 

[Problem with the user security and permissions]

Make sure your data sources are readable by ROLE_USER.

[Input Control Parameter with SQL value]

I'm not sure if this helps, but just in case....

http://blog-gabriel.mongefranco.com/2008/07/csv-and-wildcard-searches-in.html

 

[Flash reports]

Add this at the end of your URL:  &decorate=no&output=swf

Also see:   http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=44405

 

[JasperServer report URL with output paramater]

Add this to your URL:  decorate=no

Also see: http://blog-gabriel.mongefranco.com/2008/08/creating-dashboard-in-sharepoint-using.html?showComment=1219387020000

 

[How to customize Pie Chart color]

Right-click your pie chart and got to chart properties. One of the tabs lets you set a collection of colors to use in each slice.

[HELP!!! How to create referece to catalog?]

For security reasons, I would recommend making a separate report for each partner, each in its own folder, and each folder with its own permissions.

[Avoiding input controls dialog for direct URL]

See http://blog-gabriel.mongefranco.com/2008/08/creating-dashboard-in-sharepoint-using.html.

Basically, you'll want to pass these parameters in the URL:  decorate=no&output=html

[Publishing ireports in Jasperserver]

Make sure you have the JasperServer plugin installed.  Then, configure your repository browser to connec to JasperServer.

 

Open the report you created.  Expand the repository browser, right-click the folder where you want your report, and select Add Report Unit.  When it asks you for the source JRXML, click Get Current and it will copy the report you have open. 

[Parameter DATABASE_TIMEZONE does not exist- urgent]

In iReport, go to View -> Paremeters and make sure your parameters are defined.  If they aren't, add them.

[How to Call Jasper report from ASP?]

Check out the API and developer docs in the JasperServer section.  I did this just using the HTTP interface and frames, because in the API, you need to parse the reports yourself. :(

[Passing a list of results to another report (or sub-report)]

Hi all,

     I need to run a report from databae A where a PONumber field appears in database B.  Since the databases resided on different servers and are not linked together, I thought maybe I could do this with a sub-report?  Any idea how?

My first query would retrieve a whole bunch of order numbers:

SELECT DISTINCT TicketNumber

FROM A

WHERE A.TicketStatus = 'Open';

 

My second query, and the one for the report I actually need, would look like this:

SELECT PONumber, PODate, POStatus

FROM B

WHERE B.TicketNumber IN (... results from the previous query... );

 

Any idea how I accomplis this?

Thanks!

[Incorrect HTML report generation]

I figured it out... DefaultJasperViewer.jsp can be used to hide the toolbar. :)  I wrote a short tutorial here if anyone is interested:

http://blog-gabriel.mongefranco.com/2008/08/creating-dashboard-in-sharepoint-using.html

 

[Incorrect HTML report generation]

Now I'm wondering -- is there something I can change in an XML or JSP file to prevent the menus from showing up?

[set default for the controls (jasperserver)]

Actually, I was talking about iReport -- but Sherman's way works too if you want to setup defaults from within JasperServer directly. :)

 

[Incorrect HTML report generation]

Thanks!  At least with "decorate=no" I can generate a flash report... That should do the trick for a dry dashboard on SharePoint. :)

Are there any other paremeters beside "decorate" that are not documented, or that were added in v3.0?

[Incorrect HTML report generation]

Hi everyone,

     I am trying to access a report from within SharePoint.  I am passing all the required parameters through the URL (flow.html, report name, etc.) but there is one parameter that doesn't seem to work: output=html.

     When I use the parameter output=html, JasperServer gives me the whole page including the toolbar, menus, etc.  I was expecting to receive the report only (in HTML), which would make sense since output=swf and output=pdf both return the report only.  How can I make JasperServer return the report only (in HTML) instead of the whole web interface?