[ireport 3.6.1 arial font and jasper server 3.5]

i just try to retype the fonts.. for example: sansserif does not exist.. SansSerif does (uppercase ;))

[Roles and permission]

try domains :)

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

i think not as this is not the idea behind web based reporting.. you might want to try to schedule e-mails containing the reports, and auto planting them in a UNC folder

[Single Sign On]

same.. gonna make a support call for it :/

[Error using accents char inside a formula field]

did you update your mysql jdbc driver to the latest version (5.1 i believe)

[Memory leak in IE8 with JS 3.5 & domain editor]

you should post this bug in the bug post section... ive had some issues like that as well, although it mainly occured when using large databases and condions/querys on it

[Using java.util.List type parameter in Query]

afaik, you can accomplish this by using a 'multiple select query' as input control from the JasperServer. Im uncertain this can be done in iReport itself. You should try to get the values from the 'MSQ' in the correct SQL String, which i suppose should look like: "countryA", "CountryB"

perhaps you should use $P!{}

[connecting Jasper reports]

its called hyperlinking with reportexecution and parameters. There are a lot of post on it on this forum :)

[How many concurrent users can use in JasperServer]

if you checked the MSSQL server its safe to say its the jasperserver. Go check/monitor resources on the machine

[Using local Report Unit resource for hyperlinking]

*bump*

[Default value expression for input control]

i dont think its possible, only with parameters.

next question could you please format it decently and give examples? this way your questions can be answered better and/or workarounds can be given

[How many concurrent users can use in JasperServer]

yes, everything. Try to run the querys of the reports directly into the MSSQL server. simultaniously ofcourse

[Use of many instructions inside a variable]

yes, as long as make it in one line :)
make it easier on yourself to get the date from your DB as Date (field)
(new java.util.GregorianCalendar().setTime($F{date}).get(java.util.Calendar.YEAR)

perhaps you can make multiple variables to make it easier OR

try to use the SQL functions of your db... for example, i use the WEEK() function of MySQL:
select WEEK(customer.dob) as weeknumber_dob from customer

Post Edited by sjongenelen at 11/17/2009 15:29

[Urgent Help:Search button]

check the sticky on cascading input controls

[Urgent Help:Search button]

erhm? in jasper server? use input controls? you can search using data from this input control input which you use as parameter.

 

example:

select * from customers where name LIKE '%$P{kkii}%'

 

also, i think you should read the documentation

[Using local Report Unit resource for hyperlinking]

Hi,

What if i want to hyperlink to an JRXML resource on the current Report Unit? so, a local resource

ive set up parameters for ReportExecution for use on blank target.
what should be the _report string?

I've tried "repo:filename.jrxml" and absolute reference: "/testdashboard/voorstellingindex_files/WeekOverzicht_voorstellingindex/WeekOverzicht_voorstellingindex.jrxml"
and this obviously didnt work :)

i dont want to use the JRXML as subreport, but as a 'new' report as a popup

what is the way to go here?

/uploads/projects/jasperserver/jsprsrvr_repo_question(1).jpg

 

[How many concurrent users can use in JasperServer]

as ive read in this forum, this presumably has to do with you JDBC/ODBC connection to the database.

 

edit: i checked the forum couldnt find it that fast :P but i know it because Sherman said it :p  it has something to do with the max of 5 concurrent connections :) gl

Post Edited by sjongenelen at 11/17/2009 09:40

[Porcedures in Adhoc Report]

I dont think Jasper supports the use of Stored Procedures. At least, i didnt get it working with Pervasive engine..

 

You should try to make a domain in which you call the Stored Procedure. You can then make a ad-hoc report on this domain.

again, i didnt get this to work but perhaps you can :) let me know

[Drill down to another report unit gives wrong URL]

I've corrected the issue - the way i did was the correct way :)

 -edited: making a new post for this issue-

Post Edited by sjongenelen at 11/17/2009 10:07

[Column Header SORTING ?]

let them open it in excel or something? perhaps you make a hyperlink on it that refreshes the whole report and re querys with another SORT?

[report export error after update JasperReports]

i would like to use it too ofcourse. Is this a bug? any ideas?

 

edit: workaround found (not real nice, but still)

change the page height (pageHeight="842" in the XML) to something like 100000 :)

Post Edited by sjongenelen at 11/13/2009 12:31

[report export error after update JasperReports]

you sir, are my hero for today!

 

i edited %program files%\jasperserver-pro-3.5.1\apache-tomcat\webapps\jasperserver-pro\WEB-INF\applicationContext.xml

 

and changed

<property name="onePagePerSheet" value="TRUE"/>

 

thank you!

 

 

[report export error after update JasperReports]

I've recently upgraded JasperReports on my JasperServer (pro) from 3.5.0 to 3.6.1 (from iReport).

this worked suprisingly well :D

I have updated the following Jar's:
jasperreports-chart-themes-3.5.3.jar
jasperreports-3.6.1.jar
jasperreports-extensions-3.5.3.jar
jasperreports-fonts-3.6.1.jar

I placed them into
"C:\Program Files\jasperserver-pro-3.5.1\apache-tomcat\webapps\jasperserver-pro\WEB-INF\lib"

I have removed the following Jar's:
jasperreports-3.5.0-Mondrian-3.1.1.jar
jasperreports-chart-themes-3.5.0.jar
jasperreports-ofc-component-0.0.2.2.jar

Since this update, all my reports are no long exportable to MS Excel! All other exports work, but Excel gives the following error:

Error Trace:

java.lang.NullPointerException

 

 

[export in the same window]

you should look throught the report templates and change a line like "target=_blank" into "target=_self"

 

dont know where though :)

[Drill down to another report unit gives wrong URL]

please could someone give me a few pointers? i've checked the demo data, which is similar to mine! =/