sjongenelen
-
Posts
88 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Everything posted by sjongenelen
-
no this is not possible try to use roles on domains and reports... perhaps it can using SQL, but you're on the wrong forum for that - try mssql/mysql/oracle forums :)
-
Ive been told from support that IWA-like single sign on never has been done... i might be hiring JasperSoft for it (they seem to be able to create it for you) could you please post your progres riteshkumar_c?
-
ireport 3.6.1 arial font and jasper server 3.5
sjongenelen replied to huwtrimet.org's topic in Products
i just try to retype the fonts.. for example: sansserif does not exist.. SansSerif does (uppercase ;)) -
try domains :)
-
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
-
same.. gonna make a support call for it :/
-
did you update your mysql jdbc driver to the latest version (5.1 i believe)
-
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
-
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!{}
-
its called hyperlinking with reportexecution and parameters. There are a lot of post on it on this forum :)
-
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
sjongenelen replied to sjongenelen's topic in Products
*bump* -
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
-
yes, everything. Try to run the querys of the reports directly into the MSSQL server. simultaniously ofcourse
-
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
-
check the sticky on cascading input controls
-
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
-
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
-
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
-
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
sjongenelen replied to sjongenelen's topic in Products
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 -
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
sjongenelen replied to sjongenelen's topic in Products
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
sjongenelen replied to sjongenelen's topic in Products
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! -
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
