[Field always on he top - despite a splitting another field]

Hi,

I have a report with a group G and 2 fields: AAA and BBB, and both are grouped by G. BBB sometimes is very long, so it splits over 2-3 pages. I need to print AAA on the top of every page where BBB splits. How shall I configure AAA to do so?

Thanks for the answers in advance.

[page_number slows down extremely the generation of report]

Well, i have the answer:

The images are quite big, and without a footer the report worked well. But, adding a footer with the pagenumbers made the report too big for a A4 page, and it started to spend too much time recalculating the sizes of the pictures.

[page_number slows down extremely the generation of report]

.

[page_number slows down extremely the generation of report]

The report consists up to 3 pages...
Every page is a subreport with a header and an image which fulfills nearly the whole page.
The page counters are on the footer of the parent report: 2 fields of PAGE_NUMBER (evaluation now or report).

[page_number slows down extremely the generation of report]

Hi,

my problem is the following: a report without pagenumber is generated in  a few seconds.

If i add a PAGE_NUMBER (evaluation now or report) it slows/freezes the generation of the report.

The report has several subreports in the Detail band which is grouped by the productID.

The pagenumber is on the page footer.

Any idea what can be the problem?

Thanks in advance.

Bianca

 

[stretch with overflow problem]

Hi,

There is a VARCHAR2 (2800 Byte) DB column. I show it on a report with the "stretch with overflow" option.

When i filter for a few lines, iReport generates perfectly the report.

But when i filter for several thousands of lines, iReport sometimes breaks some of this lines into 2:

- the first line contains all info of the line and the part of the problematic field.

- the second line contains only the cutted part of this field.

Do someone has some ideas what can cause the problem?

Thanks in advance.

Bianca

 

 

[report properties vs page properties]

Hi,

I have found that there are completely different values in the report properties and the page properties.

I supposed that the values of the menu Edit / Report Properties should be the same as the Properties panel. It seems that no.

What is the reason that my report can be landscape but the page portrait?

 

Besta regards:

Bianca

[Jasper returns to earlier version]

Hi,

I have changed a report last week: put some extra filters, but these new filters have disapperad today.

It seems that Jasper has returned to the earlier version of the report, alone.

It looks weird.

Do someone has some idea?

Thanks in advance.

Bianca

[Access denied: You do not have permission to take the requested action.]

Hi,

I had Jasper 3.5 working fine until yesterday.

I created a new report, gave permissions to the usergroups and when the users want to use it, it gives them the following error:

Access denied: You do not have permission to take the requested action.

I have compared the permissions with other reports. They are the same.

Do someone have some idea?

Thanks in advance.

Bianca

[strange oracle query received from iReport]

Thank you for your answer.

The problem was just simple: the column to be filtered can have 2 vaules: 0 and 1. But these values were stored (who knows why) as space+1 and space+0.

I have changed the multi-select-list-of-values to space+1 and space+0 and now the filter works fine.

 

Bianca

 

Post Edited by bbromonti at 04/26/2011 07:24

[strange oracle query received from iReport]

Hi,

i use jasper with iReport. I would like to test what queries sends iReport to the database (oracle)

In the v$sql i have found the following condition:

...

and ANOESTACION IN (:1) and 0 = 0 and CODEALPHA2 like :2

...

I thought that Oracle would receive the query with the chosen filters. But when does it assign the chosen values of the filters?

 

Bianca

 

[report usage info]

Hi,

Is there a way to get info about the which reports are used by which users?

Thanks in advance.

Bianca

[Parameter "DATABASE_TIMEZONE" does not exist.]

Hi,

i have  a report with 2 subreports.

If i execute it from iReport it functions well.

If i execute it from Jasper i get the following error:

Parameter "DATABASE_TIMEZONE" does not exist.

Do someone has an idea?

 

Bianca

 

Post Edited by bbromonti at 02/10/2011 13:41

[compile problem - Syntax error on token "4984632", delete this token]

Hi,

I've found the following problem:

everything had been working weel with iReport 3.0.0 until one day started to give the following compiltaion problem to a report which had been compilated dozens of times before:

Syntax error on token "4984632", delete this token public class 4984632PRODUCTION45SSP32Photo_1295349789235_527716 extends JREvaluator

Do soemone have some ideas?

Bianca

 

[page break]

Hi,

I've met a problem which looks very stupid but i cannot get rid of it:

I have a report which consist one subreport.

(The main report gets the list of IDs and the subreport creates a sub-report with each of these IDs)

I need to break a page after every subreport. I put a pagebreak on the main report after the subreport.

But it ignores it.

Do someone has any idea?

 

Bianca.

 

[blank space problem]

Only the first element has a fixed position (to the top) and the rest are float.

It is very necessary to make them float because the subreports can have varying height.

[blank space problem]

No, i don't have title band.

I have page header and page footer on tha main report but until now it didn' cause any problem.

When i start to take away subreports, than the extra blank space shrinks and at a point the empty second page disappears.

[blank space problem]

Hi,

I have a report which consists of 14 sub-reports. Some of these sub-reports are images and some of them texts.

The report is shorter than a page (15 cm), but when i create it, it adds some extra white space to the end, so the page breaks and i get an empty second page. The first page is perfect. But i need to get rid off the second page which is empty.

 

Do anybody has some idea?

Bianca

 

 

 

 

[multiple values in a crosstab]

Thank you for your answer.

There is a big table  made especially for for the reports.  No relations with the other tables, just to serve the reports.

Crosstab looked  like  an easy solution for this report, but it seems that not.

 

[multiple values in a crosstab]

Hi,

 

I have the following problem:

I would like to show multiple values in a crosstab but it creates multiple tables - containing simple values - instead of it.

The crosstab would be the following:

- row names: factories

- column names: date of arrival

- values: the code of the products which arrived X day from Y factory.

Do someone have any idea how to resolve it?

 

Thanks in advance:

Bianca

[database connection]

Thank you for your answer.

The configuration in iReport is perfect.

BUT i have discovered that on the web-browser-interface of Jasper the database connection was set to Locally Defined with the wrong IP and not to the From the Repository.

I have changed it to the "From the repository" and now really points to the correct BD.

[date format]

Thank you very much!!!!

It functions!!!!!

[date format]

I have tried to also to transform a string (dd/mm/yyyy) with

new SimpleDateFormat ("dd/mm/yyyy").parse($F{myDateAsString})

but it still gives the same dd/mm/yy h:min format.

How could i get free from the h:min at the end?

[database connection]

Hi,

I use iReport with Jasper and i have found 2 places to configure the database connection, but it still points to another machine.

It sounds crazy for me ??!?!?!?!?!?!??!?!?!?!?!

I set the connection details both in the database icon and the data sources folder.

Does anybody has an idea?

 

[date format]

Hi,

I have the following problem:

I get "pretty" and user-friendly dates from the database: "dd/mm/yyyy", but iReport transforms them into "dd/mm/yy h:mm" which is a bit disturbing, at least users will complain about it..

How could i maintain the original "dd/mm/yyyy" format?

(the column type in the database is date, iReport gets it as java.util.Date, the field on the report si also java.util.date

and Date has quite few not deprecated functions left...)