Grazy Mos

As mentioned before the jaspersoft team still works at a decent sql query builder for ireport. We want ireports to be customer friendly, and we really cant force them to use sql My question is when could we expect this feature to be implemented? Im asking because the lack of such feature plays a big role in the decision we are making to choose for the jaspersoft solution or a other solution. thanks in advance, Niels,

I was talking about the combobox options in the Content Repository behind the folder label Content Repository *folder [COMBOBOX WHERE YOU CAN SELECT THE FOLDER] The combobox automaticly gives all the folders where the user has (read)acces to. Since i only want those folders to be read only shouldnt it be logic they wouldnt be in the write-to-folder-combobox? thanks in advance, Niels Post edited by: Grazy Mos, at: 2006/11/16 12:14

I see how its impossible to save it to a local users pc when the user isnt logged on. So that wouldnt be an option in this case. I just want to prevent my server to be full of executed reports. Is it possible to make a temp folder where the reports could be stored for a day then get deleted? And is it possible to remove all directory's in the Content Repository except this temp folder? ps. the Run in Background functionality also has this 'problem'. Thanks in advance, Niels

Is it possible to store the result files you get from the scheduler on a local pc instead of a directory on the server? I dont want to have the exucuted reports saved in jasperIntelligence. But I dont want to remove the complete scheduler. The users should have the option to schedule the reports and get the results in their mailbox :) Is there a way to remove the Content Repository option in the scheduler or to modify it so it could store the executed reports on a local pc. Thanks in advance, Niels

The only way to create reports from a jdbc database is with using sql. In other report solutions designer tools there is a drag/click system where you can select the tables and give relations. Then it automaticly makes a sql statement from the information. Is there something in iReports what has the same functionality? or is it always neccesary to use sql? Thanks in advance, Niels

I have created a custom datasource bean I want to execute some query's in the datasource wich use the username of the one calling the datasource. I dont want this to happen in the jrxml file! but in the datasource. Is there a "user" bean wich i can add to the factory when the datasource is called, or could I solve this in a other way? thanks in advance, Niels

Thanks! It worked great when I putted the method createConsourceimp in jasperintelligence :) Cheers, Niels

A quick question :) i am making my own datasource and when i looked at you're sample code i noticed the procedure: public Object createMondrianDataSourceService() throws IOException { Here all the magic works rite? But in your applicationContext you do not call the procedure or link it to anything, seems to me you only sets the parameters. Does he automaticly call the create procedure or does it happends somewhere else? thanks in advance, Niels

Then why it gives me the following error when i try to run a report in jasper intelligence: org.springframework.webflow.ActionExecutionException: Exception thrown executing [AnnotatedAction@1262f7c targetAction = com.jaspersoft.jasperserver.war.action.ViewReportAction@1f784d7, attributes = map[[empty]]] in state 'verifyData' of flow 'viewReportFlow'; nested exception is com.jaspersoft.jasperserver.api.JSException: Bean with name: conSource does not have method: org.springframework.webflow.ActionExecutionException: Exception thrown executing [AnnotatedAction@1262f7c targetAction = com.jaspersoft.jasperserver.war.action.ViewReportAction@1f784d7, attributes = map[[empty]]] in state 'verifyData' of flow 'viewReportFlow'; nested exception is com.jaspersoft.jasperserver.api.JSException: Bean with name: conSource does not have method: com.jaspersoft.jasperserver.api.JSException: Bean with name: conSource does not have method: etc.. applicationContext-myDatasource.xml: <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd"> <beans> <bean id="conSource" class="consource.ConSourceImp"> <property name="dataSource"> <ref bean="dataSource2"/> </property> </bean> <bean id="dataSource2" class="org.apache.commons.dbcp.BasicDataSource" singleton="false"> <property name="driverClassName"> <value>oracle.jdbc.driver.OracleDriver</value> </property> <property name="url"> <value>jdbc:oracle:thin:@localhost:1521:devdb</value> </property> <property name="username"> <value>user</value> </property> <property name="password"> <value>password</value> </property> </bean> </beans>consourceImp: import com.jaspersoft.jasperserver.api.JSExceptionWrapper; import java.sql.Connection; import java.sql.SQLException; import java.util.Map; import javax.sql.DataSource; import net.sf.jasperreports.engine.JRParameter; public class ConSourceImp implements ReportDataSourceService{ Connection c; public DataSource datSourc; public void setDataSource(DataSource datSourc) { this.datSourc = datSourc; } public void closeConnection(){ try{ c.close(); } catch(Exception e){ e.printStackTrace(); } } public void use(){ try{ c = datSourc.getConnection(); //do something with the connection } catch(Exception e) { e.printStackTrace(); } } public void setReportParameterValues(Map parameterValues) { use(); try { c.setTransactionIsolation(Connection.TRANSACTION_READ_UNCOMMITTED); } catch (SQLException e) { e.printStackTrace(); throw new JSExceptionWrapper(e); } parameterValues.put(JRParameter.REPORT_CONNECTION, c); } } ReportDataSourceService interface: import java.util.Map; public interface ReportDataSourceService { void setReportParameterValues(Map parameterValues); void closeConnection(); } How could i fix this? thanks in advance, niels

Thanks, im still confused how to call the bean from jasper intelligence. Should I call the DAO bean or create a transactionmanager bean and call that? And how is the bean method used? Do i have to create a bean method and use it? or can I leave it blank. Thanks in advance, Niels

if you want to distribute JasperIntelligence as part of your own application If you plan on distributing (i.e. people accessing the application are not part of your organization) a software application containing JasperIntelligence... Does this means I need a commerial license if I want to deploy jasperIntelligence.war and config it how I want, and use a link in my own application to go to the report service? Or is it possible to do this under the gpl license without giving my application source free? We are planning to use jasperIntelligence and distribute it to our clients but without modifing the source code or using parts of the source code.

At the start of executing a report in jasperintelligence 1.1.0 I want to send a static query to the database. The connection that sends this query should also be used to execute the report! My idea was to put the query in a bean(code) that links to the datasource: public class ConSourceImp implements ConSource{ Connection c; public DataSource datSourc; public void setDataSource(DataSource datSourc) { this.datSourc = datSourc; // use(); } public void use(){ try{ c = datSourc.getConnection(); //do something with the connection } catch(Exception e) { e.printStackTrace(); } } } applicationContext.xml: <bean id="dataSource2" class="org.apache.commons.dbcp.BasicDataSource"> <property name="driverClassName"> <value>oracle.jdbc.driver.OracleDriver</value> </property> <property name="url"> <value>jdbc:oracle:thin:@serverdb:1521:devdb</value> </property> <property name="username"> <value>username</value> </property> <property name="password"> <value>password</value> </property> </bean> <bean id="conSource" class="consource.ConSourceImp"> <property name="dataSource"> <ref bean="dataSource2"/> </property> </bean> I am not sure if the bean conSource can work as a datasource and this idea is possible to astablish with jasper intelligence without adjusting the source code. When i try executing the bean in jasperIntelligence it gives no method exceptions. How can i get this working? Any help would be greatly appriciated thanks in advance, Niels

Hello, I am pretty new to the security scene I would like to set the securtiy of JapserIntelligence so that the users have full read acces but only could save the created reports to a specific file. So they could read: root, root-reports, root-reports-samples but only could save it to: root-reports-samples. Any ideas how to do this or where I could find the solution are welcome. thanks, Niels Post edited by: Grazy Mos, at: 2006/10/03 10:44