pentaho

Hi, Check the below Link to ByPass the login page............... http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=50689 Download the below Pdf ............... Jaspersoft-Rebranding-wp.pdf https://www.jaspersoft.com/downloadfile.php?itemname=wp-customizerebranding&newreg=1 Post Edited by pentaho pentaho at 02/18/09 12:23

Hi, Refer the below link....... Works Only in Windows XP not in Windows 2000 http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=51707#51746 Examples: Import the myDir catalog folder, prepending /importDir to all repository URIs: js-import --input-dir myDir --prepend-path /importDir Import the myExport.zip catalog archive file: js-import --input-zip myExport.zip Examples: · Export the /reports/samples/AllAccounts resource to a catalog folder: js-export --uris /reports/samples/AllAccounts --output-dir myExport · Export the /images and /fonts folders: js-export --uris /images,/fonts --output-dir myExport · Export all the resources with permissions to a zip catalog: js-export --uris / --repository-permissions --output-zip myExport.zip · Export all the resource and all the report jobs: js-export --uris / --report-jobs / --output-dir myExport · Export the report jobs of the /reports/samples/AllAccounts report unit js-export --report-jobs /reports/samples/AllAccounts --output-dir myExport · Export all the roles and users: js-export --roles --users --output-dir myExport · Export the ROLE_USER and ROLE_ADMINISTRATOR roles along with all users belonging to one of these roles: js-export --roles ROLE_USER, ROLE_ADMINISTRATOR --role-users --output- dir myExport · Export two users: js-export --users jasperadmin, joeuser--output-dir myExport Post Edited by pentaho pentaho at 02/18/09 09:25

Hi, How to display the fractional values in Pie chart........... <pie3DPlot labelFormat="{0} {2}" legendLabelFormat="{0} {1}"> <plot/> </pie3DPlot Using the above lines i can display only decimal values..... Like 20% 55%, 99%, 35% etc.......... I want to display output in pie chart like 12.25%, 55.30%, 0.05% etc........ How can implement this..............

Hi, How to display the fractional values in Pie chart........... <pie3DPlot labelFormat="{0} {2}" legendLabelFormat="{0} {1}"> <plot/> </pie3DPlot Using this i can display only decimal values..... Like 20% 55%.......... I want to display output in pie chart like 12.25%, 55.30%, 0.05%......... How can implement this.............. Post Edited by pentaho pentaho at 02/17/09 13:08

Hi, Got the Scheduling API........ http://kickjava.com/src/com.jaspersoft.jasperserver.api.engine.scheduling.index.htm

Hi, check this Post... http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=51564

Hi, List of API Names.... Using the Java APIs, you have full access to all JasperServer functionality, including: Repository Service API: Store, lookup, and retrieve content using the JasperSoft repository. (Also available with web services APIs.) Report Execution Engine Service API: Generate reports on-demand. (Also available with web services APIs.) Report Scheduling Service API: Execute, store, and distribute reports on a schedule. (Also available with web services APIs.) Ad Hoc Service API: Create ad hoc tables, charts, and crosstabs using a web browser. (JasperServer Professional only.) OLAP Service API: OLAP server and model runtime management. (JasperServer with JasperAnalysis only.) User Authority Service API: User and role management. Object Permission Service API: Search, retrieve, and modify repository object permissions. I need Report Scheduling Service API, Where can i get(Download) this API.

Hi, We are running Jasper Reports (it is integrated into another product CRM Tool). We have created 10 Jasper reports and we run them via the URL. We need to somehow automate these reports so they run on a scheduled basis with several report arguments (datestarted, dateend, etc). All these values(Daily, weekday, Month, Time etc...) are provided at CRM tool side....... I need java code or API to get all these values from CRM tool for a specific report and get an URL for the published report to run on these parametrs..................... Can somebody please tell us how to do this?

Hi, I have Integrated jasperserver with CRM Tool.............. We are using URL to access the published Report........... I have a Form that contains the report inforamtion & the scheduling information, Date, time, calendar events etc in my CRM application............. Is there an way can i use java code to run the scheduled report ....... Only the published reports from the jasperserver we are accessing(URL) & the scheduled data from CRM application......... Published reports are not scheduled at jasperserver, all the reports are scheduled in CRM application Please suggest me any java api's to run th report from jasper server & scheduled details are fetched from CRM application........ Scheduled data from the application side and the reports URL from jasperserver end........

Hi, Got the solution............... Single JRXML query can be filter based on WhereClause Values........ For the below query........... select monitor_name, customer_name, server_name, monitor_type from Monitor where $P!{WhereClause} order by customer_name, server_name URL is http://localhost:8080/jasperserver/flow.html?_flowId=viewReportFlow&reportUnit=/reports/Test/i ncd&standAlone=true&ParentFolderUri=/reports/Test&WhereClause=customer_name='abc' and server_name='Ser1' The JRXML file i have added only one parameter WhereClause and the default value is 1=1........ If you are publishing the jrxml file, add input control(parameter name) as WhereClause, Type as single value and locally defined & data type name as WhereClause, Type as Text/number/date/datetime. Finally in URL you can pass any parameters............. Filter the data by passing dynamic fields to WherClause Type 1: customer_name, & server_name WhereClause=customer_name='abc' and server_name='Ser1' http://localhost:8080/jasperserver/flow.html?_flowId=viewReportFlow&reportUnit=/reports/Test/i ncd&standAlone=true&ParentFolderUri=/reports/Test&WhereClause=customer_name='abc' and server_name='Ser1' Type 2: monitor_name and monitor_type WhereClause=monitor_name='mn1' and monitor_type='mt' http://localhost:8080/jasperserver/flow.html?_flowId=viewReportFlow&reportUnit=/reports/Test/i ncd&standAlone=true&ParentFolderUri=/reports/Test&WhereClause=monitor_name='mn1' and monitor_type='mt' Type 3: monitor_id and monitor_place WhereClause=monitor_id='mid1' and monitor_place='mp' http://localhost:8080/jasperserver/flow.html?_flowId=viewReportFlow&reportUnit=/reports/Test/i ncd&standAlone=true&ParentFolderUri=/reports/Test&WhereClause=monitor_id='mid1' and monitor_place='mp' Filter the Records Just add the & WhereClause=monitor_id='mid1' and monitor_place='mp' at the end of your URL.......... Donot Filter(All Records) If you want to display all values without filtering the data, default vaue expression for WhereClause is 1=1 Your URL will be without WhereClause http://localhost:8080/jasperserver/flow.html?_flowId=viewReportFlow&reportUnit=/reports/Test/i ncd&standAlone=true&ParentFolderUri=/reports/Test

Hi, Got the solution............... Single JRXML query can be filter based on WhereClause Values........ For the below query........... select monitor_name, customer_name, server_name, monitor_type from Monitor where $P!{WhereClause} order by customer_name, server_name http://localhost:8080/jasperserver/flow.html?_flowId=viewReportFlow&reportUnit=/reports/Test/i ncd&standAlone=true&ParentFolderUri=/reports/Test&WhereClause=customer_name='abc' and server_name='Ser1' The JRXML file i have added only one parameter WhereClause and the default value is 1=1........ If you are publishing the jrxml file, add input control(parameter name) as WhereClause, Type as single value and locally defined & data type name as WhereClause, Type as Text/number/date/datetime. Finally in URL you can pass any parameters............. Filter the data by passing dynamic fields to WherClause Type 1: customer_name, & server_name WhereClause=customer_name='abc' and server_name='Ser1' http://localhost:8080/jasperserver/flow.html?_flowId=viewReportFlow&reportUnit=/reports/Test/i ncd&standAlone=true&ParentFolderUri=/reports/Test&WhereClause=customer_name='abc' and server_name='Ser1' Type 2: monitor_name and monitor_type WhereClause=monitor_name='mn1' and monitor_type='mt' http://localhost:8080/jasperserver/flow.html?_flowId=viewReportFlow&reportUnit=/reports/Test/i ncd&standAlone=true&ParentFolderUri=/reports/Test&WhereClause=monitor_name='mn1' and monitor_type='mt' Type 3: monitor_id and monitor_place WhereClause=monitor_id='mid1' and monitor_place='mp' http://localhost:8080/jasperserver/flow.html?_flowId=viewReportFlow&reportUnit=/reports/Test/i ncd&standAlone=true&ParentFolderUri=/reports/Test&WhereClause=monitor_id='mid1' and monitor_place='mp' Filter the Records Just add the & WhereClause=monitor_id='mid1' and monitor_place='mp' at the end of your URL.......... Donot Filter(All Records) If you want to display all values without filtering the data, default vaue expression for WhereClause is 1=1 Your URL will be without WhereClause http://localhost:8080/jasperserver/flow.html?_flowId=viewReportFlow&reportUnit=/reports/Test/i ncd&standAlone=true&ParentFolderUri=/reports/Test Post Edited by pentaho pentaho at 02/12/09 07:58

Thanks for the Info..... Post Edited by pentaho pentaho at 02/12/09 05:47

Hi, select * from customer where $P!{WhereClause} order by customer, city This is my query with parameter name WhereClause. How do i filter the report on customer & city ....... customer & city are optional parameters, i have added only WhereClause parameter in iReport........ If i publish the report in Jasperserver, how can i add customer & city parameters..... WhereClause default value is 1=1, Query is : select * from customer where 1=1 order by customer, city I want the query like: (Optional values) select * from customer where customer='aa' and city='X' order by customer, city

Hi, select monitor_name, customer_name, server_name, monitor_type from Monitor where $P!{WhereClause} order by customer_name, server_name parameter $P!{WhereClause} Default Value Expression is "1=1" The above query at run time is given below select monitor_name, customer_name, server_name, monitor_type from Monitor where 1=1 order by customer_name, server_name The above query will display all the records........ I want to filter the data based on customer_name and server_name but these two parameters are optional values. How can i add these two parameters in jasper server to filter the data.................. The final query if i select the customer_name and server_name select monitor_name, customer_name, server_name, monitor_type from Monitor where customer_name='xyz' and server_name='server1' order by customer_name, server_name How to implement the above things in jasper server.............. The parameters are optional, they are passed dynamically to the sql $P!{WhereClause} parameter........

Hi, I have designed one simple report with dynamic PARAMETERS in query....... select monitor_name, customer_name, server_name, monitor_type from Monitor where $P!{WhereClause} order by customer_name, server_name If I want to publish this report in Jasper server, I have Two Optional Parameters............. HOW TO ADD THESE TWO PARAMETERS(optional) IN JASPERSERVER....... 1. Customer Name 2. Server Name How exaclty the $P!{WhereClause} works................. The above two parametrs are optional and these two parameters are not added in iReport JRXML file.................... I have attached my jrxml file........... I would appreciate any help......