[Add resources for role_user]

What happens if you give your users (or ROLE_USER) admin rights to that folder? Can they add resources that way?

[JasperServer-Scheduled Jobs-Saving to n/w drive]

Huh, that explains why JasperServer gets so slow and even starts breaking after a while, as saved reports start accumulating.

 

Too bad I haven't programmed on Java or I would be able to help.

[Exporting Reports in XML format]

I'm not sure then... I've never used Jasper Decisions. :( You might have to create your own exporter that manipulates the data in the way you want it. Just curious, why can't your users use CSV? What exactly are you trying to do with the XML file once you have it?

[How do I increase avialable RAM memory in v3?]

How do I increase the available RAM memory in JasperServer v3?  I have the latest version of Sun Java installed.

[Graphs question]

Can you try in-line graphs like Excel?  It's basically a fixed-size text field that adds a square character for every 10% or so, giving the impression of a horizontal graph.

http://beautifulpixels.blogspot.com/2008/04/inline-ascii-bar-chart-technique-for.html

Instead of using REPT() which probably doesn't exist in Java, maybe you can use a for loop or find a function similar to REPT() in java documentation sites.

[How to definde type of cells in Excel?]

Not sure, you but you can convert your field to a string in your report. To do this, edit the column you need and replace "$F{column_name}" for $F{column_name}.toString()

[Columnt Footer Only on Last Page]

I don't think that formula will work because PAGE_COUNT is increased every time the report generates a page -- but it doesn't know the total number of pages until all pages have been generated. Therefore, the current PAGE_NUMBER will always equal PAGE_COUNT, on every page, during report generation.

 

[Exporting Reports in XML format]

In Excel, just go to File -> Save As and change the File Type to XML.  It's that simple. :)  Pretty much every spreadsheet software nowadays can save to XML.

[JasperServer-Scheduled Jobs-Saving to n/w drive]

If it doesn't save to the file system, where does it save the reports to? A database table in mysql?

[Customize Jasper Server]

Did you restart JasperServer after making your changes?

[Add resources for role_user]

You just need to give Read/Write/Delete permissions.  At my company, we created a folder for each type of resource (data types, lists, reports, etc.)  If you do something similar, you can then click the folder you created, click the Assign Permissions icon, and change give Read/Write/Delete permissions to ROLE_USER.

If Read/Write/Delete doesn't do it, you can also give it Admin rights just to that folder.

 

[Publishing ireports in Jasperserver]

Hi Suma,

     It's good to know you're making progress.  Now, it is possible that your report didn't save the data source or it's using the wrong one.  In JasperServer, navigate to your report's folder, click the checkbox next to the report and click the Edit button on the toolbar.  This will take you to the report's properties.  Once you are there, click on Data Source, select the correct data source (database connection), click Save and then click Done.

     If that doesn't fix the problem, check our query to make sure it is written correctly.

Regards,

Gabriel Monge-Franco

Security+ Certified Professional

http://gabriel.mongefranco.com

 

[cannot start jasperserver 2.1]

Your mysql settings might be different on the test machine.  I setup my test environment by installing jasperserver on the test server, stopping mysql and jasperserver, and then copying my production files on top of the ones I just installed on test.  Not sure if that's the way to go, but it worked for me. :)

Can you post the whole error message here?

 

[LDAP for 2 weeks vs. $995 per incident]

Very cool.  There is also more information here for those who are looking for AD integration:

http://blog-gabriel.mongefranco.com/2008/06/active-directory-ad-authentication-for.html

 

[Display Grouped Data Side-BySide]

Could you group the data in your query and then just show summary fields in a single row of your report?

[external authentication using Open LDAP]

Thanks for the info.  I also found a few ways to do this (with AD though not Open LDAP) after lots of research:

http://blog-gabriel.mongefranco.com/2008/06/active-directory-ad-authentication-for.html

 

[Dynamic Columns--Suppress based on input params]

I'm not sure how to accomplish this, but perhaps you'd like a work around?  You can use setup 20 columns in your report and instead of hiding the field, hide the column that corresponds to that field.

Another work around -- you can also create a big, long field that fits your 3rd and 4th fields, and hides the 3rd one when you don't need it.  For example, ($P{yesnoparameter}.equals(true)?$F{field3}:'') + '  |  ' + ${field4}....  Not a pretty solution, but it's something. :)

[Exporting Reports in XML format]

Not sure how to do this, but you can always export to HTML or Excel, both of which can be easily converted to XML.

[Any Jasperserver db script for Oracle?]

Not sure... but check out this post:  http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=157

 

[downloads of excel files]

When you schedule the reports, you can tell JasperServer how to name the files.  Checking the sequential filenames checkbox will prefix the filenames with a date stamp (I think).

[Should I pay for JasperReports?]

Oh right -- I didn't see he was talking about JasperReports and not JasperServer. :)

[getting jasperserver started with windows services]

You could also have windows start the batch file launcher as a task.  You can tell it to run as a local or system account, and every morning it can re-start if it isn't already running.

[Add customized JSP in JS 3.0 when buiding from src]

Not sure, but I have edited the standard JSP pages before.  I imagine you could copy the headers, footers etc. and just edit the middle portion. ;)

[OutOfMemory and NullPointerException error]

Try increasing both the Java memory allocation and the mysql buffer memory (mysql.ini).

[Error: 1 - Access is denied - Message while using the]

Could you just create a generic account that everyone can use?  You can limit that account's access to only a "public" folder where you can put reports for anonymous users to access.  You could put the generic account user id and password in your login page.