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......

Hi, Got the solution......... The Repository Export utility writes out all of the JasperServer Repository objects to a set of XML and binary format files. The output of the export operation is known as an export catalog. To create the export catalog, enter these commands: cd <js-install>/scripts js-export.bat --everything --output-dir js-backup-catalog OR Exporting Everything...... C:Program Filesjasperserver-3.1scripts> js-export.bat --everything --output-dir js-backup-catalog Export /Reports Folder Contents C:Program Filesjasperserver-3.1scripts>js-export --uris /Reports --output-dir js-backup-catalog The import utility reloads all of your repository data. As the data is being saved to the repository, To import your backup catalog to the repository, change directory to: cd <js-install>/scripts Enter these commands: js-import.bat --input-dir js-backup-catalog Copy & paste the exported folder(js-backup-catalog) into the following path(new system) C:Program Filesjasperserver-3.1scripts> Importing Files to jasper server......... C:Program Filesjasperserver-3.1scripts>js-import.bat --input-dir js-backup-catalog

Hi, Got the Solution.............. Sucessfully exported all reports........

Hi, Got the solution......... I was not able to export using Win 2000......... I tried in WIN Xp ................ Exporting Everything...... C:Program Filesjasperserver-3.1>js-export --everything --output-dir C:/sum Export /Reports Folder Contents C:Program Filesjasperserver-3.1>js-export --uris /Reports --output-dir C:/sum1 By using the above commands i have exported all the reports............. Post Edited by pentaho pentaho at 02/10/09 04:31

Hi, Thanks for the Info................

Hi Exporting Everything...... C:Program Filesjasperserver-3.1>js-export --everything --output-dir C:/sum Export /Reports Folder Contents C:Program Filesjasperserver-3.1>js-export --uris /Reports --output-dir C:/sum1 By using the above commands i have exported all the reports............. In one of the folder(Account_Management) I have a Specfic report Contact_List report......... How can i import this folder............... Suggest me the import command syntax............... I have attached my exported report folder........... I tried the below command, but it is not importing the report.......... Exporting Files to Folder........... C:Program Filesjasperserver-3.1>js-import --input-dir js-catalog --prepen-path C:/AM C:/AM Contains the reports.....

Hi. I have Installed the jasper server at D Drive.... the path is D:Program Filesjasperserver-3.1 If I run the js-export --help , i get the below error......... I'm running the above commands ( command prompt) at D:Program Filesjasperserver-3.1scripts paths ERROR: D:Program Filesjasperserver-3.1scripts> js-export --help The input line is too long. ".cpappend.bat" was unexpected at this time

Hi. I have Installed the jasper server at D Drive.... the path is D:Program Filesjasperserver-3.1 If I run the js-export --help , i get the below error......... I'm running the above commands ( command prompt) at D:Program Filesjasperserver-3.1scripts paths ERROR: D:Program Filesjasperserver-3.1scripts> js-export --help The input line is too long. ".cpappend.bat" was unexpected at this time

Hi, My js.quartz.properties file contains the following default values......... What values i need to Change here.......... # This file is now just a pass-through for stuff in the # file referenced by the Maven js.quartz.properties file. quartz.delegateClass=org.quartz.impl.jdbcjobstore.StdJDBCDelegate quartz.tablePrefix=QRTZ_ quartz.extraSettings= report.scheduler.mail.sender.host=mail.localhost.com report.scheduler.mail.sender.username=admin report.scheduler.mail.sender.password=password report.scheduler.mail.sender.from=admin@localhost.com report.scheduler.mail.sender.protocol=smtp report.scheduler.mail.sender.port=25 report.scheduler.web.deployment.uri=http://localhost:8080/jasperserver-pro

How to implement Report Scheduler in JASPER SERVER..... I have refered the Jasper Intellegence User's Guide for Report Scheduler info.... The published 5 Reports in jasper server, & used one Report scheduleded to work on specific date and time......... I have added folder to store pdf output files and enterd emailid to sent an attachment of the scheduled report output........ Report executed on specific time and pdf stored in the folder, but i'm not getting any email attachment report output........ To get an report email output attachment, any setting i need to make......... I'm not getting emails from the scheduleded reports......... How exactly email (scheduled reports outputs attachments) works in jasper server.....

Hi, I have designed Reports(iReports - 3.1.2) and Published the reports in Jasper server(3.1). Under /Reports folder I have created MyReports folder in jasper server(JS).......... I have published around 10 reports in JS........... Using iReports in the Repository Navigator i'm viewing the folders and published & sample reports....... I have installed jasper server in D:program Filesjasperserver 3.1 The created folders of JS are not visibile in my system(in the above path).... I can view the samples reports of JS and all published reports in the below paht.......... D:Program Filesjasperserver-3.1scriptsjs-catalogresourcesreportssamples why User created folders are not visible local file system............. My another Problem is that i'm not able to create a new folders through Repository Navigator of iReports... I can view published report of JS in iReports..... It takes name, label & Description if i try to save message windows displays a message Error: 1-Access is Denied. For all other operations(datasource creation, folder creation & publishing a report etc..) it displays same above error....... what settings do i need to make so that i can create folder, datasoucres etc in iReport..........