pentaho

February 18, 2009

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

February 18, 2009

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

February 18, 2009

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

February 17, 2009

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

February 17, 2009

Hi,

Got the Scheduling API........

http://kickjava.com/src/com.jaspersoft.jasperserver.api.engine.scheduling.index.htm

February 16, 2009

Hi,

check this Post...

http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=51564

February 16, 2009

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.

February 13, 2009

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?

February 13, 2009

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

February 12, 2009

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

February 12, 2009

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

February 12, 2009

Thanks for the Info.....

Post Edited by pentaho pentaho at 02/12/09 05:47

February 11, 2009

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

February 11, 2009

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

February 11, 2009

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

February 10, 2009

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

February 10, 2009

Hi,

Got the Solution..............

Sucessfully exported all reports........

February 10, 2009

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

February 10, 2009

Hi,

Thanks for the Info................

February 9, 2009

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

February 9, 2009

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

February 9, 2009

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

February 5, 2009

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

February 4, 2009

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

February 4, 2009

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

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Downloads

Posts posted by pentaho

Products

Explore