[multi-page report in iReports]

Look attached report. 

[ERROR TypeError: v.AdHocView is not a function]

I think problem can be in cache. Can you try clear browser caches

[Visualize.js and IE version?]

We support same versions as in JasperReport Server.

It should be IE 9 + 

[Why is my blank report so many pages?]

Ok, when you put in your detail band fields you will not have empty pages, you will have pages with your data

Note detail band height should be not very big (usual it same as field height), in other case you will have empty spaice after every rows.

 

[Why is my blank report so many pages?]

Hello,

As i see you have big details band, this band  will repeat for every record in your dataset.

For resolve this issue you need change detail band height to 0, or remove it.

 

<detail>        <band height="0" splitType="Stretch"/> </detail>[/code]

 

[Change Datasource]

Hi Oscar,

You can try use parameter $P{REPORT_CONNECTION} for change datasource dynamically.

[How do I set a parameter that is a date?]

Hi,

I can create report using query:

select count(orderid) as o_count, shippeddate from orderswhere shippeddate >=  $P{From_Date}  and shippeddate <= $P{To_Date} group by shippeddate[/code]

As example you can use my attached jrxml file. It's used sample sugarcrm database

[How do I set a parameter that is a date?]

Default value for Date paramented should be specify as:

new java.util.Date(97, 5, 1)[/code]

 

[Can I pass a query that contains a CASE expression?]

Hello, I think problem in "group by field2" part. 

Can you please run you sql in any sql client, I think you will have error.

[multi-page report in iReports]

Hello, 

You need create 2 Detail bands.

In Detail 1 you need add fields and after it "Brake" component.

In Detail 2 you can put same fields or other fields and "Brake" component.

 

 

[Upgrade from 3.7 to 5.5]

Yes, you can do it.

Please look  section "Upgrading from 3.7 - 5.2 to 5.5101CHAPTER11 UPGRADING FROM 3.7 - 5.2 TO 5.5" from install guide

http://community.jaspersoft.com/documentation/jasperreports-server-install-guide-commercial-edition-1 (page 101)

 

[First Step to publish a report]

When you add subreport to report you able choose other datasource as in main report. So for subreport you able specify other datasource.

About report parameters: you need create input control with same name as your parameter in Controls & Resources page.

 

 

[First Step to publish a report]

Hello You can do it in two way:

1. Add JRXML to report from Ireport

2. From jasperreport server

• create report and upload main jrxml
• open tab "Controls & Resources"
• Click "Add Resource…" link 

My proposition: you can use Jaspersoft Studio, from this report designer you can publish your report with all subreports in one click

 

[2 different Database in one report]

Hello, 

Jasperreport server support Virtual Data Source. It's datasource that can have information drom different databases.

For Create report you need create Virtual Data Source, create domain from this datasource.

After It you will able create domain base report.

Other way, you can create subreport - that can use other datasource as main report. In this case data between databases will not joined

Let me know if you need help with it.

[Can I get the list of reports running on the background ?]

Hello

You can see it in Diagnostic Report

Look attached screen

 

[Maps Pro widget is working only for "USA" Map]

Hello, 

you need change "Map name Expression", by default it's "USA". 

It's can me any country or region. 

It's can be value from parameter or value from column

[multiple column with same name]

Hello, query should be like this

select  t1.Col_id as t1_col_id, t1.Col_OrderedByName, t1.Col_Name_ProductName,  t2.Col_id as t2_col_id, t2.Col_ProductName from Table1 t1 left join Table2 t2 on t1.col_Name_ProductName = t2.Col_id

[Page break when date changes.]

Hello 

You need create grouping for you timestamp column. Add to report groupFooter and add "Break" to this groupFooter 

[How to get new page]

Hello 

 

Look my report with 1 subreport in  attached file.

 

For run it use sample sugarcrm database

 

I propose for you put in summary "Break" component.

 

 

Let me know if you have question

 

[Help! String before the Date]

Hello,

 

If you men use it in jasperreport you can use date pattern.

Look attched screen.

 

In report you can have label with text "Von :" and after this label you can put your field with correct date pattern.

 

Or you can use pattern like this "'Von : ' MM.dd.yyyy"

 

[ireport Compatibility with Java8]

Hello 

We don't support Java 8 right now. Support will be added in next versions.

I recommend use Jaspersoft Studio for design reports.

Thank you

[Add charts to JasperServer 5.5]

Hello,

It's not supported. You can use only charts that available from jasperserver or Jaspersoft studio.

[How to get new page]

Hello, 

You can use page break or subreports.

Expect it you can create few Detail bands

 

[I have question about XML Datasource and XML Remote DataSource]

For use Remote XML Datasource you need just put in fileName url adress like this:

<fileName>http://community.jaspersoft.com/sites/default/files/answers/test_0.xml</fileName>

 

[I have question about XML Datasource and XML Remote DataSource]

Hello,

You need create data adapter in jasperserver repository.

You can found example in folder: /organizations/organization_1/reports/interactive

Customers Report used Customers Data Adapter.

in Report JRXML we need add property:

<property name="net.sf.jasperreports.data.adapter" value="repo:/reports/interactive/CustomersDataAdapter"/>[/code]

CustomersDataAdapter it's xml file with next content: 

<?xml version="1.0" encoding="UTF-8"?><remoteXmlDataAdapter class="net.sf.jasperreports.data.xml.RemoteXmlDataAdapterImpl"> <name>northwind</name> <fileName>repo:/reports/interactive/CustomersData</fileName> <useConnection>true</useConnection> <datePattern>yyyy-MM-dd</datePattern> <numberPattern>#,##0.##</numberPattern> <locale xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="java:java.lang.String">en</locale></remoteXmlDataAdapter>[/code]

<fileName>repo:/reports/interactive/CustomersData</fileName> - it's path to XML file in jasperserver repository, can be remoute XML file

/reports/interactive/CustomersData - it's XML file taht can be uploaded to Jasperserver repository