kevin.de.wulf
-
Posts
7 -
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 kevin.de.wulf
-
use @var in mysql select query for dataset
kevin.de.wulf replied to kevin.de.wulf's topic in Products
I solved it, if I add an extra join join (select @total :=0 ) r[/code]it works -
Hi if I want to use this query below select b.naam, b.voornaam,if(bu.typeid='2',bu.bedrag,0) as 'inkomst', if(bu.typeid='1',bu.bedrag,0) as 'uitgave',bu.datum,@total:= @total + if(bu.typeid=2,bu.bedrag,0) -if(bu.typeid=1,bu.bedrag,0) as 'totaal'from bewoners_uitgaven bujoin bewoners b on b.id = bu.bewonerIDjoin kl_bewoners_uitgave_type kl on kl.id = bu.typeidwhere b.Id =150;[/code]I got null as a result for totaal, can I use @var in my mysqlstatement?
-
Hi I am trying to read a mysql datetime field with a query and when I run the report I get a "Unable to get value for result set field "date" of class java.sql.Date" error. I tryed changing to java.util.date and formatted the sql result to date(datum). Can someone help me?
-
Jaspersoft 6.3 compatible with jaserserver 6.0?
kevin.de.wulf replied to kevin.de.wulf's topic in Products
Hi, Nevermind the question, it turns out that Jaspersoft filled in the organization and it isn't filled in on ther server. I removed the organization and everything works :) -
Hi I installed Jaspersoft Studio 6.3 and I'am trying to connect it with Jasperserver 6.0 but I keep getting an unauthorized access error. I can login with the user and password in the webinterface. Is Jaspersoft 6.3 not backward compatible with Jasperserver 6.0 or do I need a special setting?
-
Thank you Ernestoo, that is a correct sollution
-
After I tried to make my reports anonymous accessible i receive this error when i try try to access them without authentication I followed this link http://community.jaspersoft.com/wiki/allow-anonymous-access-reports#Modify_Spring_Configuration_Files Can someone help me?
