iReport QA

0

Hi,

I am Marina Ryzhikova, the Jaspersoft QA Manager. I am responsible for QA for all open source and professional edition releases.

We are looking for community members to help us:
 * Understand your usage and report development needs
 * Improve the iReport user experience by exploring iReport 3.1.4 and logging tracker tickets for any usability issues you note.
 * Improve the overall quality iReport by logging tracker tickets for any quality issues you note.

 If you are interested in helping with this testing, log in to the JasperForge, and log your bugs here: Bug Tracker for iReport Designer

 

marianol's picture
4337
Joined: Sep 13 2011 - 8:04am
Last seen: 8 months 2 weeks ago

63 Answers:

0
Hi I am new In Ireport want to learn the how to create chart in ireport and also I fired the query using ireport after that I want to do some calculation in the result set using that reslt I want to do with ireport have to do. anandhzedo@gmail.com send mail this address
anandhk's picture
Joined: Feb 21 2009 - 12:33am
Last seen: 10 years 3 months ago
0

Hi,

     How to caculate a percentage of the pie chart's?

Thanks,

Li

lixiaokui11's picture
Joined: Feb 19 2009 - 6:17am
Last seen: 5 years 3 weeks ago
0

Only part of the Axis Label Expression is displaying.  The attachment shows the value the Axis Label Expression set to and how only part of the expression appears on the graph. 

petruch's picture
Joined: Feb 18 2009 - 2:09pm
Last seen: 10 years 4 months ago
0
Forgive me I should have looked at what was in the database before I posted this. problem solved.
petruch's picture
Joined: Feb 18 2009 - 2:09pm
Last seen: 10 years 4 months ago
1

I've been using iReport for over 7 years to layout jasper reports and am very profient with the classic version.  I am extremely disappointed with what I've seen in the nb version so far.  There are so many subtle changes that dramatically decrease productivity, that it is a major step backwards.  I've attempted to report several issues as bugs, with most of them closed mentioning a an obscure but less efficient workaround.  The problems I'm having are so severe, I'm beginning to wonder whether or not I can continue to use iReport at all.

Among the problems I have with the new version:

1)  No support at all for barcodes.  This was extremely important in several of the postal and shipping reports I've created over the years.

2)  The new way of selecting multiple elements has several problems.  Previously you could hold down shift and quickly click around the screen to select multiple items.  If you accidently selected something you didn't want, you could simply click on it while holding shift again to de-select it.  If you tried to shift click on something and missed (eg clicked in an empty section), it wasn't a problem.  Now you have to double-click to de-select an item which is awkward.  Even worse, holding Ctrl and clicking an an empty area (easy to do with a complicated design, or when trying to click on a graphic line) clears out everything you've selected, forcing you to start over.

3)  copying and pasting is almost unusable now.  In the old version, you could select one or more elements then press ctrl C and Ctrl V to copy all of those elements.  The best thing about this under the classic designer was that as part of the paste, all of the copied elements were offset horizontally and vertically by 10 pixes and all of them were automatically selected.  This made it very easy to use the arrow keys + Shift to re-align an entire section to where it needed to be copied to.  Since many reports have similar graphic/text sections it reduced report design time. 

With the new product you can still select and copy multiple elements.  However, they are copied into the exact same x/y coordinates as the source and even worse they are not selected, which makes it really hard to reselect just the copies and move them to where they belong.  Instead of being able to copy 5 or 10 elements at the same time into correct position, it forces you copy each element one at a time, which really slows down the layout.

There also seems to be a limit on how many elements may be pasted at once.  I tried to select 62 elements from one report and copy them into the page of a different report.  For some reason only 7 elements were copied onto the other report.

4)  Under the classic version it was possible to manipulate the Z coordinate of graphic elements.  This was important when attempting to have text items in front of background image or background color filled graphic elements.  This was down by simply clicking on an element and choosing "send to back" or "bring to front".  That functionality seems to be lost in the nb version which makes it difficult to correctly layout reports with overlaid elements.

5)  Under the classic version it was possible to see whether or not a valid variable, field or parameter was being used in the popup properties editor by the color of text in the Text Field Expression section.  This was it was really easy to have the popup window open and click around the elements to check the variables being used.  Under the nb version the property sheet does not feature the same color highlighting for variable names.  To see it, you have to click on the elipse to open up the text field expression dialog.  This dialog has to be closed before choosing another element which again subtly slows down the editing process.

6)  having to confirm that I really want to delete something every time I press delete is annoying.  There should be a way to turn this confirmation/warning off for advanced users.

 

 

ddavis539's picture
Joined: Dec 6 2006 - 3:59pm
Last seen: 9 months 4 weeks ago
0

 

Hi Davis,

this is a very good feedback, it is really appreciated. There are many little details that still have to be adjusted in iReport nb, there is lack for many things that after years people just were used to (even if many of them are back with the 3.5.0 verision), but before go forward, let me spend a couple of words about why we decided to rewrite iReport and which are the benefits of using iReport NB. The old version (or classic if you prefer) works, and it works pretty well. During the years the JasperReports library is not grown very much, letting me the time to focus on many design shortcuts and usability improvements. But in the last year JasperReports is grown a lot, adding a lot of new advanced features. The internal architecture of iReport was limiting us from continuing to extending the application, and especially was limiting us to support the new features of JasperReports, many of which are still almost unknown just because people never moved to the iReport nb. Things like chart themes to change the chart look and feel, fonts extensions, multi-scriptlets, generic elements and custom components to create and support advanced content,  have  never been possible in the old version of iReport. We spent a lot of effort in creating the base on the ireport future, we did not waste time in giving iReport just a new buggy look and feel (even if unfortunately this is what may feel an expert iR 3.0 user on a fist glance). Today JasperReports and iReport are much more integrated then before, iReport uses the native JasperReports model and no more a custom model (source of many problems for years before reaching the stability that iR 3.0 offers and lacking of many JR tags support). The main benefit of using the JR model is that iR is no longer responsable to load and save the jrxml, problems checking is faster and what you see is exactly what you'll get (this is not true in the old version). You have now realtime chart preview in design mode, you can copy and paste a chart and a crosstab, if a new tag is not visually supported, it will not removed or corrupted by iReport because it is still managed by the JasperReports object model.
Soon a new manual of iReport will be available, it will help people to start working with iReport NB without facing the documentation obstacle, and one of my primary objectives in the next months will be to provide a lot of freely available documentation.

Now, let's walk trough your concern.

1)  No support at all for barcodes.  This was extremely important in several of the postal and shipping reports I've created over the years.

Barcodes will be soon reimplemented as a Custom component (this was supposed to be ready some time ago, it will be ready soon togheter with a new component to display bullet lists).

2)  The new way of selecting multiple elements has several problems.  Previously you could hold down shift and quickly click around the screen to select multiple items.  If you accidently selected something you didn't want, you could simply click on it while holding shift again to de-select it.  If you tried to shift click on something and missed (eg clicked in an empty section), it wasn't a problem.  Now you have to double-click to de-select an item which is awkward.  Even worse, holding Ctrl and clicking an an empty area (easy to do with a complicated design, or when trying to click on a graphic line) clears out everything you've selected, forcing you to start over

I hate the new way elements are selected, I'm rewriting the selection logic to make it similar to the old one.

3)  copying and pasting is almost unusable now.  In the old version, you could select one or more elements then press ctrl C and Ctrl V to copy all of those elements.  The best thing about this under the classic designer was that as part of the paste, all of the copied elements were offset horizontally and vertically by 10 pixes and all of them were automatically selected.  This made it very easy to use the arrow keys + Shift to re-align an entire section to where it needed to be copied to.  Since many reports have similar graphic/text sections it reduced report design time. With the new product you can still select and copy multiple elements.  However, they are copied into the exact same x/y coordinates as the source and even worse they are not selected, which makes it really hard to reselect just the copies and move them to where they belong.  Instead of being able to copy 5 or 10 elements at the same time into correct position, it forces you copy each element one at a time, which really slows down the layout.There also seems to be a limit on how many elements may be pasted at once.  I tried to select 62 elements from one report and copy them into the page of a different report.  For some reason only 7 elements were copied onto the other report.

Little details like paste in a slightly different location the elements and select them make the difference. We will replicate the same behaviour in the next version. I'll check the problem of copying many elements.

4)  Under the classic version it was possible to manipulate the Z coordinate of graphic elements.  This was important when attempting to have text items in front of background image or background color filled graphic elements.  This was down by simply clicking on an element and choosing "send to back" or "bring to front".  That functionality seems to be lost in the nb version which makes it difficult to correctly layout reports with overlaid elements.

Z-order is now manageable in the outline view just dragging elements in the right position. For an user used to the old version of iReport this kind of interactivity of the outline view (aka Report Inspector) is something of totally new. You can now drag an element from a band to another just using the outline view, change the parameters order, the z-order and so on.
Anyway I'll revert the two menu items you are talking about, togheter with other commonly used context-menu items like:
- Edit textfield expression
- Format tools
- Copy/paste style
- Transform in other element
and other shortcuts.

 5)  Under the classic version it was possible to see whether or not a valid variable, field or parameter was being used in the popup properties editor by the color of text in the Text Field Expression section.  This was it was really easy to have the popup window open and click around the elements to check the variables being used.  Under the nb version the property sheet does not feature the same color highlighting for variable names.  To see it, you have to click on the elipse to open up the text field expression dialog.  This dialog has to be closed before choosing another element which again subtly slows down the editing process

The editor is going to be improved a lot, and the feature you are talking about is just one of the many we are thinking about (including auto-completion and real syntax checking). But the kind of checking you are talking about are performed by iReport, see the Report Problems window.

6)  having to confirm that I really want to delete something every time I press delete is annoying.  There should be a way to turn this confirmation/warning off for advanced users.

Agree ;-)

Said that, did you see what you get in iReport NB that you have not in iReport 3.0.0?

- Ability to set reloadable paths in the classpath (i.e. to test a datasource you are creating, or a scriplet stored in a jar that you are deploying from an external IDE)
- Comprehensive support for export options (big lack in iR 3.0)
- Ability to really design at any zoom level (iReport 3.0 is not precise at all designing at zoom levels different than 100%), especially when using a grid and snap to grid.
- Integrated preview window and XML editor
- Undo/redo for all the properties (not for just some operations)
- Style editor
- Chart theme editor
- A faster and more precise report problem reporter engine (based on JasperReports)
- All the element properties on the property sheet (not just some of them)
- Many other little features present only it iReport nb (did you try to drag a field in a band different than the detail? Or add a label format to a pie chart? Or the pdf 508 assistant? Or the new page format dialog?

We need power users like you to go forward, to understand how to improve iReport in the right direction from an user prospective, to list all the features missing and to think about new usability improvements. All the stuff you mentioned will be implemented in the next version. Stay tuned.

Giulio

 

giulio's picture
21446
Joined: Jan 2 2007 - 4:15pm
Last seen: 4 months 1 week ago
0
It is posible to return to properties popup? I think the properties are visually more accesible from this
jvmolto's picture
11
Joined: Sep 13 2006 - 7:26pm
Last seen: 3 days 16 hours ago
0

We have been using iReport and JasperReports in our product for about 5 years now (since version 0.7).

 

We produce mainly shiping reports with barcodes for our clients and JasperReports is still doing this perfectly.

 

Recently we wanted to use Jasper as a report server for our application and wanted to generate reports either on a GUI request or on a batch request.  We studied JasperServer to do this but it was not the right solution since it is essentially a Web GUI solution. Maybe this need is fairly wide spread in the industry and it could be a good market for you since you have almost every thing to offer this kind of tool, I do not know...

 

Anyway, in the process I switched to iReport 3.1.4.  At first I was glad with the general look and fell of this new version but then, I was quiet desappointed (afraid ?) not to find any kind of barcode support. After a few hours, I found a workaround for this on the net but this point is extremely important for us and I am now reassured barcode will not be abandonned. I think barbecue was the barcode library formerly used, am I right ?  This project has been inactive since May 6, 2007. Could it be possible to use Barcode4J ( http://barcode4j.sourceforge.net/index.html ) instead or any other libray with more activity ?  EAN128 or event DataMatrix barcode support would be very nice features... 

 

For now here are the remarks I can submit to you from our experience. When I have the time to work a little longer with iReport 3.5.0, I will add new remarks and suggestions if I have any.  



Post Edited by B F at 03/31/09 12:47



Post Edited by B F at 03/31/09 12:48
frab42's picture
7
Joined: Mar 6 2009 - 2:45am
Last seen: 5 years 7 months ago
0

I would like to second (or n-th by this time) the comments by ddavis. I have only been using iR for about  a year. If I had not started on the classic, I would have simply thought the nb version was simply a lacking IDE for report generation. Having seen the potential in classic, I think it is important to add these features in the very near future. While there are several new and very useful features in nb (and 3.5.0 is an improvement), the lack of certain basic operations makes it very difficult to develop any sort of complex reports. I am glad that ddavis was able to take the time to carefully articulate the areas that are missing, many of which are what is keeping me from using the nb version to develop reports. One thing I would add to the object selection process is the ability to rubber band (click-hold) more than one area. In classic, you could rubber band while holding the shift key to select several discontiguous areas. This allows the user to select these areas and apply a common change (height, width, etc.). The nb version resets the previous selection once the mouse is clicked off an object (regardless of the key chords pressed).

Thanks,

Ed.

ejhellerattc's picture
Joined: May 20 2008 - 6:30am
Last seen: 2 months 17 hours ago
0

Hi,

I humbly ask for your assistance.

I\\'ve been trying to generate a report on ZuckerReport with iReport 3.0.0 on SugarCRM 5.2.0. So far all hsve be successiful till a point.

I\\'m running Fedora core 8 O/S with Java 1.5.0 and am unable to launch iReport 3.0.0. I have been following a tutorial on the ZuckerReport-iReport, I Configured the iReport, I started a new Report, entered a report query, Designed a report and each time I click on Build to complile the report, I get a still or something like an hanged popup bringing out a BLANK REPORT. I thought by it time to load will solve the problem but I gave it enough time to load. I have no clue to it.

I have no errors when running the application and have no leads on this issue.

Please help.

Thank you very much.

 

ope73


 

ope73's picture
2
Joined: Apr 20 2009 - 2:15am
Last seen: 10 years 2 months ago
0

To help you understanding what we are doing:

We use iReport with a JasperReport custom server, filled by xml datasource.

We integrate iReport within a Python / Qt application.

Templates (jrxml) are stored / versioned in a database, and used directly by the server.

Our templates heavily rely on subreports, which are dynamically choosen from user data.

 

Now, some things I hate in ireport-nb:

 1) Property window, really hard to get for end users. Please give it back as in iReport-classic (left button on an element), it was fantastic :-)

 2) As said just before by someone: colors are a cool thing! Users are now use to thoses colors! (Green OK)

 3) Alignments are really cool things, Isn't it possible to get it like in the other version in the menubar ? (I've tried to create a new toolbar, no success)

 4) iReport-nb launcher do not understand files other than ".jrxml" files... So bad! Isn't it possible to add an extra argument in the command line to get thoses files opened as jrxml reports ? (Our users of iReport don't care of netbeans)

 5) Please give us the possibilty NOT to load previous opened files!!!! (Example: open a ".xml" file, Open a report, close iReport, launch iReport, the xml file is loaded!)

 6) Why drag & droping fields in the "display" between bands do not switch which band contains the element?

 7) Zoom / Page width was REALLY an amazing feature!

 8) Styles (Bold, italic, ...) in the designer view are hidden if the screen is not large enough, isn't it possible to get it back in the toolbar like "open, save, ..." ? (Like in office, openoffice, ...)

 

Things I love in iReport-nb:

 1) Customization, really amazing (but buggy :))

 2) It's fast, really! Good job!

 3) JR 3.5 full support

 4) Properties window can modify ALL things ! Really cool if it could be accessed with left button ;-))

 

 

Hope it'll help you improve this beautifull product.

Many thanks for that really good piece of code,

Best regards,

 

Laurent

clarisys's picture
Joined: Dec 28 2006 - 10:36pm
Last seen: 12 years 5 months ago
0

I created an align elemets toolbar with no problem in 3.5.0.

And I like the property window. once I shuffled a few other windows out of the way and got it to take up the whole right hand side.

baggypants's picture
Joined: Apr 7 2009 - 12:43am
Last seen: 10 years 2 months ago
0

I just wanted to come back and thank the development team for the many improvements included in the nb 3.5.1 release.  I dowloaded it the day it came out and am very pleased with the improved usability.  I created a multi-page report from scratch within one day with the new version, making heavy use of the new copy/paste functionality.  The quick turnaround has created some fans in our management team as well.

ddavis539's picture
Joined: Dec 6 2006 - 3:59pm
Last seen: 9 months 4 weeks ago
0
I agree, 100% good features ! Many thanks iReport / JasperReports team!
clarisys's picture
Joined: Dec 28 2006 - 10:36pm
Last seen: 12 years 5 months ago
0

[6/1/09 10:09:24:821 SGT] 0000002e Digester E TRAS0014I: The following exception was logged org.xml.sax.SAXParseException: Element type "topPen" must be declared.

 

How can I solve this? I am using iReport verson. 3.5.0 Thnx.

 

makweatan's picture
Joined: May 27 2009 - 5:53pm
Last seen: 10 years 3 weeks ago
0

What i did was deleting all the 'toppen, leftPen,rightPen, bottomPen"...along with the <box>      </box>....

The new version cannot read the .jrxml of the older version.

makweatan's picture
Joined: May 27 2009 - 5:53pm
Last seen: 10 years 3 weeks ago
0

 Hi,

          I have installed iReport 3.0.1 in netbeans 6.5.How to start using iReport for Visual Web Pack components.

There isn't any documents available.Please suggest me ,how to proceed.

 

Thanks

Amarshi

 

amarshi's picture
Joined: Jun 4 2009 - 2:10am
Last seen: 10 years 2 weeks ago
0

hi all ,

i have the following requirements

 1)User to be able to modify a report's output format after that report has been generated like edit format or hide column,

is it possible to do in any report solutions?

thanks in advance

gandeepan

 

gandeepan's picture
Joined: Jun 9 2009 - 11:18pm
Last seen: 10 years 1 week ago
0

Hi everybody,

 

I just began making reports in Ireport. Everything works just fine. However there are a couple of things that are not so easy (if you don't have any Java knowledge that is).

I am trying to make a hyperlink reference in a column. So far so good. But how do set up the link so that it references to another report that i have made.

 

hope someone can help me

 

Many  thanx in advance

a_madani's picture
Joined: Jun 19 2009 - 2:10am
Last seen: 10 years 1 day ago
0

Hi,

My name is Kalin Rashev and I'm using JasperReports and iReport since 2008.

I really like the products and they work really great! It is really easy and a lot of fun creating reports with Jasper products!

However, my reports are using custom JRDataSource implementation, which requires some java code to be executed before the iReport is started. I have integrated this perfectly with the classic iReport 3.0. I made a starter application which initializes my data source provider and then simply invokes it.businesslogic.ireport.gui.MainFrame.main(args); to start iReport.

The problem is that the new iReport 3.5.x is a NB plugin and I can not find a way to start the iReport from my application. There is simply no main method anymore, because it is no longer standalone application, but NB plugin! Starting iReport from another application is critical for me. As I read the posts in this topic, I made a conclusion that the classic iReport will not be upgraded anymore. So it is a matter of time to become incompatible with the new JasperReports features.

I believe the new iReport will soon have more cool features than the classic one and I can see it is being actively updated. I really want to switch to it, but that is not possible until I find a way to start iReport from another applciation.

Can somebody please tell me how to start the iReport NB from another Java application?

Thanks in advance,

Kalin Rashev

kalinr's picture
6
Joined: Jun 19 2009 - 4:11am
Last seen: 10 years 22 hours ago
0

I noticed that grouping is missing in netbeans:

1. in classic, you can select items that you want to group,  right click and then select 'Group selected element(s)'

2. if you add elementGroup tags in the code and then go to Report Inspector, the label 'Element group' is missing next to document structure item

 

richardc's picture
Joined: Mar 7 2007 - 9:18am
Last seen: 12 years 3 months ago
0

amarshi: About iReport you can find some tutorials in the wiki in order to get started.

a_madani: you need a backend application (like JasperServer). JasperReports does not include a drill down feature per se.

kalinr: you have to look at the netbeans platform. You can run it from your application, it's just a bit more complicated. Ask on
the NetBeans development forum to ask how to do it, or take a look at the start scripts to see what classes are executed.

richard: this has been fixed in 3.5.2.

Thanks

Giulio

giulio's picture
21446
Joined: Jan 2 2007 - 4:15pm
Last seen: 4 months 1 week ago
0

Hi

 

I have a question about the input controls. I want to have three drop down boxes on my report. The first one should be a simple single select query. The second box should only show values dependent on the value given in box 1. same goes for box 3.

Is there anyway to do this?

a_madani's picture
Joined: Jun 19 2009 - 2:10am
Last seen: 10 years 1 day ago
0

The answer of my question

#58705

is posted here: http://stackoverflow.com/questions/852320/how-to-run-ireport-nb-3-x-x-fr...



Post Edited by kalinr at 07/03/2009 11:57
kalinr's picture
6
Joined: Jun 19 2009 - 4:11am
Last seen: 10 years 22 hours ago
0

Hi,

I create a main report with a subreport, but the subreport didn't compiled when I execute the main report, how can I set ireport can make them compiled together?

Thx & Best Regards!

gannidie's picture
Joined: Jul 13 2009 - 7:19pm
Last seen: 9 years 11 months ago
0

Hi this is Vikas.

I hav e a question about adding Subreports to a main Report. I made a report wherin i had to add sub reports which comprises of recurrsive datas. That is a table whose rows are not fixed and depands only on the amount of data comin from the bean. Now i have a text box just under this report which actually sum the table contents of the subreport (the text box is on the main report). when i compile and run the report it works very fine only with one problem. that is the recurssive table of subreport overrides the text box. The view is all meshed. What would u suggest to solve this problem.??

vastmind's picture
Joined: Jul 14 2009 - 2:02am
Last seen: 9 years 11 months ago
0

Hi,

i am a ireport developer from Hong Kong, i would like to create an order sheet report.
Just simple show the order list with different sub total,
but i found that there is a problem on the sub total, please see the sample
user A have an order list

Lot No.    Colour      Size     Length           Qty
0001          B               S           32                100
0001          B               S           33                100
0001          B               M           34                100
0002          B               M           32                100
0002          B               M           33                100
0002          R               M           34                100

now the requirement want to group by Size, Colour, Lot No.
I expected the result will like this

Lot No.    Colour      Size     Length           Qty
0001          B               S           32                100
0001          B               S           33                100
------------------------------------------------------------
Size:                                                          200

0001          B               M           34                100
 ------------------------------------------------------------
Colour :                                                    300

0002          B               M           32                100
0002          B               M           33                100
 ------------------------------------------------------------
Lot No.:                                                     500

0002          R               M           34                100
 ------------------------------------------------------------
Size                                                          600
Colour                                                      600
Lot No.:                                                    600


But now the report become

Lot No.    Colour      Size     Length           Qty
0001          B               S           32                100
0001          B               S           33                100
------------------------------------------------------------
Lot No.:                                                    200
Colour                                                      200
Size                                                           200

0001          B               M           34                100
 ------------------------------------------------------------
Lot No.:                                                    300
Colour                                                      300
Size                                                           300

0002          B               M           32                100
0002          B               M           33                100
 ------------------------------------------------------------
Lot No.:                                                    500
Colour                                                      500
Size                                                           500

0002          R               M           34                100
 ------------------------------------------------------------
Lot No.:                                                    600
Colour                                                      600
Size                                                          600


 Seems the group have problem, either one value changed, all groups will be print out.
What do you think? i am using 3.6.0 (most updated version, same problem found)

,Choi
 



Post Edited by colachoi at 10/12/2009 10:14
colachoi's picture
Joined: Oct 12 2009 - 2:13am
Last seen: 9 years 8 months ago
0

Hello,

 A strange problem in iReport. When I generate a pdf, all my charts
have this red gradient on them. I'm using iReport 3.6.0. 
How can I fix this?
 
Thanks
james001's picture
Joined: Oct 12 2009 - 8:54pm
Last seen: 9 years 8 months ago
0

Hi,

i'm new to iReport.

 

i wonder if i need JasperReport if i already has the iReport? i've downloaded iReport for the NetBean plugin, i can design and compile the report

now what must i do to load the report in Java application? how to install JasperReport in Windows? 

 

Thank you!

thesti's picture
1
Joined: Oct 13 2009 - 1:32am
Last seen: 9 years 8 months ago
0

 Hi,

I am a jasperReports Professional customer and now we want to upgrade jasperReports Professional from 2.1.1 to 3.6. But I have a question, I know jasperReports Professional 3.6 integrate the iReport 3.6. In my project, I need to start the iReport from Web page. In previous build, the iReport provide a startup.bat, so I can start it from web page. But in iReport 3.6, it only provide a exe file to start it. So, I want to know if the JasperReports Professional 3.6 provide the startup.bat or something else, or if it can be started from webstart? Because I need to start it from web page.

 

Thanks

Ken

 

dzhxie's picture
3
Joined: Oct 8 2009 - 10:09pm
Last seen: 1 month 3 weeks ago
0
Hi Guilio. A very good day.
I have your book "The defenitive guide for ireport". I'm following the steps exactly as you mentioned in the book. Initially I got Exception Description: The entity class[Varia] was not found using class loader[oracle.toplink.essentials.internal.ejb.cmp3.javasecmpinitializer$TempEntityLoader@162bd90]. Internal Exception:java.lang.ClassNotFoundException:Varia

Later after checking through the forum i understood it is some problem with the hibernate jar. So i added the latest jars into class path. And now when I click on Test button i donot get any error or success message. Please help me out
javapedant's picture
Joined: Oct 16 2009 - 6:28am
Last seen: 9 years 8 months ago
0

Hi Guilio

 

When I go into the log file of ireport I got the following error. Please help me in sorting this out

 

 <B>

java.lang.NoClassDefFoundError: org/hibernate/id/factory/IdentifierGeneratorFactory at org.hibernate.ejb.Ejb3Configuration.(Ejb3Configuration.java:107) at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:124) at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:52) at com.jaspersoft.ireport.designer.connection.EJBQLConnection.getEntityManager(EJBQLConnection.java:129) at com.jaspersoft.ireport.designer.connection.EJBQLConnection$1.run(EJBQLConnection.java:179) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209) at java.awt.EventQueue.dispatchEvent(EventQueue.java:461)

 

Please let me know the mistake i'm committing

 

thanks in advance

javapedant's picture
Joined: Oct 16 2009 - 6:28am
Last seen: 9 years 8 months ago
0

Please disregard this message.



Post Edited by aenache36 at 11/03/2009 13:50
aenache36's picture
Joined: Nov 3 2009 - 5:05am
Last seen: 9 years 7 months ago
0

i'm just change from iReport 3.0 to 3.6.2 version.

can anyone help me with the new interface, it's a little bit difficult for me.

How to change report query?

How to edit parameters and variable? right click on it but there's no option to edit...

and the toolbar  (bold, italic, etc..) can't fit at the window, the window seem to small for all  the icon..

thanks...

bluecool_2003's picture
Joined: Jul 2 2009 - 6:32pm
Last seen: 9 years 11 months ago
0
I use ireport 3.7.0, when i add [ language="java"]
 to the jrxml file in xml view 
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports <a href="http://jasperreports.sourceforge.net/xsd/jasperreport.xsd"" target="_blank">http://jasperreports.sourceforge.net/xsd/jasperreport.xsd"</a> name="examSchedulesCSV" pageWidth="612" pageHeight="792" columnWidth="552" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20" language="java">
 
when i swith to the design view do some edit and save, 
the jrxml file will elase the  [ language="java"] automatically
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports <a href="http://jasperreports.sourceforge.net/xsd/jasperreport.xsd"" target="_blank">http://jasperreports.sourceforge.net/xsd/jasperreport.xsd"</a> name="examSchedulesCSV" pageWidth="612" pageHeight="792" columnWidth="552" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20">
 
xuyijun008's picture
Joined: Dec 28 2009 - 10:07pm
Last seen: 9 years 5 months ago
0

Hi,

I'm in charge of the integration project of Jasper reports to our PLM/MPM software. I'm currently trying to improve the integration of iReport with our infrastructure in a way that customers will be able to create and edit their own reports. RIght now, we have to send consultant on site for that work. Edition is too complex. We think that training customesr to work with your report "IDE" will simplify edition and reduce maintenance cost.

Our reports gets their information by direct call to our API (java of course). Is it possible to have path completion when editing report with iReport (same way than Eclipse does) ? Is it possible to generate preview of the design with data obtain from our API?

I attach a code example to show you how we have embedded our api inside your reports.

 

The second attachment show a screen shot where you can see in the iReport Problems window that java class importation error are detected... Is it normal? How can I fix that?

 

 

 

Thanks!

 

 

Bruno Dufour

Director

www.notixia.com

bdr@notixia.com's picture
Joined: Mar 6 2007 - 6:31am
Last seen: 5 years 6 months ago
0

Hi,

Whilst I am new to iReports, I have been working with reporting tools for many years and I have issues with Jasper iReports V3.7 handling of Input Parameters and Patterns...

My problem is that I want to choose 2 dates each formatted as "yyyy-MM-dd HH:mm:ss.SSS" being 4 digit year, 2digit month, 2 digit day, 2 digit Hour, 2 digit minute, 2 digit seconds and 3 digit micro-seconds.  This is a mandatory requirement for our Systems Engineering guys to get this sort of fine grained reporting from our Database.

I have not had any success in getting this to work.  The xml snippets below is from one of our reports...

    <parameter name="StartDate" class="java.util.Date" isForPrompting="false" />
    <parameter name="EndDate" class="java.util.Date" isForPrompting="false" />
    <queryString>
        <![CDATA[SELECT
 FROM_UNIXTIME(WF_Timestamp) Req_Date_Time,
 SUBSTR(Request_URL,1,LOCATE("?",Request_URL)-1) Search_URL,
 REPLACE( SUBSTR( SUBSTR( Request_URL, LOCATE( "?",Request_URL ) +1 ),1),"+"," ") Search_Terms,
 User_Name,
 Source_IP_Address Client_IP
FROM REPORTING.WEBFILTER_REPORTING
WHERE (LOCATE('google',lower(Request_URL))>0 OR LOCATE('yahoo',lower(Request_URL))>0)
AND LOCATE('http://localhost/cgi-bin/utils/proxy/',Request_URL)=0
AND Flags < 64
AND (FROM_UNIXTIME(WF_Timestamp) BETWEEN $P{StartDate} AND  $P{EndDate})]]>
    </queryString>

Note: The WF_Timestamp above is a UNIX TIMESTAMP including Time to nano-seconds.

and

    <pageFooter>
        <band height="27">
            <textField>
                <reportElement mode="Opaque" x="0" y="4" width="734" height="13" backcolor="#E6E6E6"/>
                <textElement textAlignment="Right"/>
                <textFieldExpression class="java.lang.String"><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression>
            </textField>
            <textField evaluationTime="Report">
                <reportElement mode="Opaque" x="734" y="4" width="52" height="13" backcolor="#E6E6E6"/>
                <textElement/>
                <textFieldExpression class="java.lang.String"><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>
            </textField>
            <textField pattern="yyyy-MM-dd HH:mm:ss">
                <reportElement x="0" y="4" width="120" height="13"/>
                <textElement/>
                <textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="130" y="4" width="118" height="13"/>
                <textElement/>
                <textFieldExpression class="java.lang.String"><![CDATA["Date range between: "]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="248" y="4" width="135" height="13"/>
                <textElement/>
                <textFieldExpression class="java.lang.String"><![CDATA[new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSS").format($P{StartDate})]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="386" y="4" width="35" height="13"/>
                <textElement/>
                <textFieldExpression class="java.lang.String"><![CDATA[" and "]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="424" y="4" width="139" height="13"/>
                <textElement/>
                <textFieldExpression class="java.lang.String"><![CDATA[new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSS").format($P{EndDate})]]></textFieldExpression>
            </textField>
        </band>
    </pageFooter>
 

Please advise how I can set up an Input Control which will present itself as a Date, Time , Microtime formatted as "yyyy-MM-dd HH:mm:ss.SSS"

I am not a Java Programmer, but can understand the use of the various classes ie: java.sql.Timestamp, java.util.Date and the methods they provide etc...

Please avoid the US Convention of "MM-dd-yyyy" as this is just plain confusing for our European and Australasian Clients.

Code:
<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports <a href="http://jasperreports.sourceforge.net/xsd/jasperreport.xsd"" target="_blank">http://jasperreports.sourceforge.net/xsd/jasperreport.xsd"</a> name="SearchEngineRequests" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="786" leftMargin="28" rightMargin="28" topMargin="28" bottomMargin="28">
	<parameter name="StartDate" class="java.util.Date" isForPrompting="false" />
	<parameter name="EndDate" class="java.util.Date" isForPrompting="false" />
	<queryString>
		<![CDATA[SELECT
 FROM_UNIXTIME(WF_Timestamp) Req_Date_Time,
 SUBSTR(Request_URL,1,LOCATE("?",Request_URL)-1) Search_URL,
 REPLACE( SUBSTR( SUBSTR( Request_URL, LOCATE( "?",Request_URL ) +1 ),1),"+"," ") Search_Terms,
 User_Name,
 Source_IP_Address Client_IP
FROM REPORTING.WEBFILTER_REPORTING
WHERE (LOCATE('google',lower(Request_URL))>0 OR LOCATE('yahoo',lower(Request_URL))>0)
AND LOCATE('http://localhost/cgi-bin/utils/proxy/',Request_URL)=0
AND Flags < 64
AND (FROM_UNIXTIME(WF_Timestamp) BETWEEN $P{StartDate} AND  $P{EndDate})]]>
	</queryString>
	<field name="Req_Date_Time" class="java.sql.Timestamp">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="Search_URL" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="Search_Terms" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="User_Name" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="Client_IP" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<background>
		<band/>
	</background>
	<pageHeader>
		<band height="103">
			<line>
				<reportElement x="0" y="102" width="786" height="1" forecolor="#000000"/>
			</line>
			<staticText>
				<reportElement x="383" y="34" width="403" height="35" forecolor="#0099CC"/>
				<textElement textAlignment="Right">
					<font size="24" isBold="true"/>
				</textElement>
				<text><![CDATA[Search Engine Keywords Report]]></text>
			</staticText>
			<image>
				<reportElement x="0" y="0" width="277" height="91"/>
				<imageExpression class="java.lang.String"><![CDATA["repo:EditureWebLogo.gif"]]></imageExpression>
			</image>
		</band>
	</pageHeader>
	<columnHeader>
		<band height="28">
			<line>
				<reportElement x="0" y="26" width="786" height="1" forecolor="#666666"/>
			</line>
			<staticText>
				<reportElement x="0" y="5" width="97" height="20"/>
				<textElement markup="none">
					<font fontName="SansSerif" size="10" isBold="true"/>
				</textElement>
				<text><![CDATA[Request Date]]></text>
			</staticText>
			<staticText>
				<reportElement x="370" y="5" width="239" height="20"/>
				<textElement markup="none">
					<font fontName="SansSerif" size="10" isBold="true"/>
				</textElement>
				<text><![CDATA[Request URL]]></text>
			</staticText>
			<staticText>
				<reportElement x="617" y="5" width="169" height="20"/>
				<textElement markup="none">
					<font fontName="SansSerif" size="10" isBold="true"/>
				</textElement>
				<text><![CDATA[Search Terms]]></text>
			</staticText>
			<staticText>
				<reportElement x="97" y="5" width="156" height="20"/>
				<textElement markup="none">
					<font fontName="SansSerif" size="10" isBold="true"/>
				</textElement>
				<text><![CDATA[User Name]]></text>
			</staticText>
			<staticText>
				<reportElement x="266" y="5" width="103" height="20"/>
				<textElement markup="none">
					<font fontName="SansSerif" size="10" isBold="true"/>
				</textElement>
				<text><![CDATA[Client IP]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="28">
			<textField>
				<reportElement x="0" y="4" width="97" height="20"/>
				<textElement>
					<font fontName="SansSerif"/>
				</textElement>
				<textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{Req_Date_Time}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="97" y="4" width="156" height="20"/>
				<textElement>
					<font fontName="SansSerif"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{User_Name}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="266" y="4" width="103" height="20"/>
				<textElement>
					<font fontName="SansSerif"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{Client_IP}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement x="370" y="4" width="239" height="20"/>
				<textElement>
					<font fontName="SansSerif"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{Search_URL}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement x="617" y="4" width="169" height="20"/>
				<textElement>
					<font fontName="SansSerif"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{Search_Terms}]]></textFieldExpression>
			</textField>
			<line>
				<reportElement positionType="FixRelativeToBottom" x="0" y="26" width="786" height="1"/>
			</line>
		</band>
	</detail>
	<columnFooter>
		<band/>
	</columnFooter>
	<pageFooter>
		<band height="27">
			<textField>
				<reportElement mode="Opaque" x="0" y="4" width="734" height="13" backcolor="#E6E6E6"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression class="java.lang.String"><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report">
				<reportElement mode="Opaque" x="734" y="4" width="52" height="13" backcolor="#E6E6E6"/>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<textField pattern="yyyy-MM-dd HH:mm:ss">
				<reportElement x="0" y="4" width="120" height="13"/>
				<textElement/>
				<textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="130" y="4" width="118" height="13"/>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA["Date range between: "]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="248" y="4" width="135" height="13"/>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA[new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format($P{StartDate})]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="386" y="4" width="35" height="13"/>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA[" and "]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="424" y="4" width="139" height="13"/>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA[new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format($P{EndDate})]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
	<summary>
		<band/>
	</summary>
</jasperReport>
</td></tr></tbody></table>
biztux's picture
3
Joined: Jan 18 2010 - 4:44pm
Last seen: 1 year 4 months ago
0

hiii...........good morning.................

I'm Moncy Mathai..........i'm working in a software company & is a fresher.........

i have been asked to understand ireport 3.5.2

i learned how to design & make connection between jrxml file & database.

i got stuck in a problem.

Problem is that connection is made but only the 1st data from the database is shown.

if u can help me in this matter it will be help full.

sql query which is gave is select * from table_name;

moncy's picture
-7
Joined: Apr 16 2010 - 11:00pm
Last seen: 9 years 2 months ago
0

hi..........good morning.............

I'm Moncy Mathai..........i'm a fresher.......just joined a software company.............

i have been asked to work on iReport 3.5.2.............

i learned to desing jrxml file & create connection between jrxml file & database.

I got into a problem.

Problem is that only the first data from the table is executed.

i'm sending you the code of jrxml file which i created & also the jrxml file & jasper file is attached.

I'll be thank full to u if u can help me in this matter.

Thanks a lot in advance.

 

Attach : 1) bill_report.jrxml

2) bill_report.jasper

Code:
<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports <a href="http://jasperreports.sourceforge.net/xsd/jasperreport.xsd"" target="_blank">http://jasperreports.sourceforge.net/xsd/jasperreport.xsd"</a> name="report name" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<queryString>
		<![CDATA[SELECT
     billmaster.`BILLNUMBER` AS billmaster_BILLNUMBER,
     billmaster.`POID` AS billmaster_POID,
     billmaster.`BILLVALUE` AS billmaster_BILLVALUE
FROM
     `billmaster` billmaster]]>
	</queryString>
	<field name="billmaster_BILLNUMBER" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="billmaster_POID" class="java.lang.Integer">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="billmaster_BILLVALUE" class="java.lang.Float">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="85" splitType="Stretch">
			<staticText>
				<reportElement x="20" y="26" width="126" height="39"/>
				<textElement>
					<font size="22"/>
				</textElement>
				<text><![CDATA[Bill Report]]></text>
			</staticText>
			<staticText>
				<reportElement x="184" y="47" width="41" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<text><![CDATA[From]]></text>
			</staticText>
			<line>
				<reportElement x="246" y="66" width="100" height="1"/>
			</line>
			<staticText>
				<reportElement x="366" y="47" width="37" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<text><![CDATA[To]]></text>
			</staticText>
			<line>
				<reportElement x="436" y="65" width="100" height="1"/>
			</line>
		</band>
	</title>
	<pageHeader>
		<band height="19" splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="85" splitType="Stretch">
			<rectangle>
				<reportElement x="20" y="9" width="516" height="76"/>
			</rectangle>
			<line>
				<reportElement x="77" y="9" width="1" height="76"/>
			</line>
			<line>
				<reportElement x="146" y="9" width="1" height="76"/>
			</line>
			<line>
				<reportElement x="443" y="10" width="1" height="75"/>
			</line>
			<staticText>
				<reportElement x="31" y="36" width="34" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<text><![CDATA[S.No]]></text>
			</staticText>
			<staticText>
				<reportElement x="84" y="36" width="45" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<text><![CDATA[Bill No]]></text>
			</staticText>
			<staticText>
				<reportElement x="159" y="36" width="100" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<text><![CDATA[Vendor Name]]></text>
			</staticText>
			<staticText>
				<reportElement x="361" y="36" width="75" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<text><![CDATA[Submit Rate]]></text>
			</staticText>
			<staticText>
				<reportElement x="444" y="36" width="92" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<text><![CDATA[Settled Amount]]></text>
			</staticText>
			<line>
				<reportElement x="355" y="9" width="1" height="76"/>
			</line>
		</band>
	</columnHeader>
	<detail>
		<band height="352" splitType="Stretch">
			<rectangle>
				<reportElement x="20" y="0" width="516" height="352"/>
			</rectangle>
			<textField>
				<reportElement x="84" y="9" width="58" height="58"/>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{billmaster_BILLNUMBER}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="454" y="9" width="72" height="44"/>
				<textElement/>
				<textFieldExpression class="java.lang.Float"><![CDATA[$F{billmaster_BILLVALUE}]]></textFieldExpression>
			</textField>
			<line>
				<reportElement x="443" y="0" width="1" height="352"/>
			</line>
			<line>
				<reportElement x="355" y="0" width="1" height="352"/>
			</line>
			<line>
				<reportElement x="77" y="0" width="1" height="352"/>
			</line>
			<line>
				<reportElement x="146" y="0" width="1" height="352"/>
			</line>
		</band>
	</detail>
	<columnFooter>
		<band height="62" splitType="Stretch">
			<rectangle>
				<reportElement x="20" y="0" width="516" height="50"/>
			</rectangle>
			<staticText>
				<reportElement x="225" y="17" width="100" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<text><![CDATA[Total]]></text>
			</staticText>
			<line>
				<reportElement x="77" y="0" width="1" height="50"/>
			</line>
			<line>
				<reportElement x="146" y="0" width="1" height="50"/>
			</line>
			<line>
				<reportElement x="355" y="0" width="1" height="50"/>
			</line>
			<line>
				<reportElement x="443" y="0" width="1" height="50"/>
			</line>
		</band>
	</columnFooter>
	<pageFooter>
		<band height="54" splitType="Stretch"/>
	</pageFooter>
	<summary>
		<band height="42" splitType="Stretch"/>
	</summary>
</jasperReport>
</td></tr></tbody></table>
moncy's picture
-7
Joined: Apr 16 2010 - 11:00pm
Last seen: 9 years 2 months ago
0

i think your design detail only shows one entire cell with just lines and two floating field texts. Try to use static text and field texts. For the text fields to be repeatable they need to be at the same row and i think the only values in the details section.

mike9lite's picture
Joined: Jan 14 2007 - 2:48pm
Last seen: 12 years 5 months ago
0
hiiiiiiii............matt...........hw r u???????

I'm new to ireport 3.5.2.

I'm want to pass a value stored in a variable in subreport to the main report through parameter or any other way if you can suggest.

It'll be great help if you can. Reply me here and to my mail id moncy@etipl.com & moncy_mathai@yahoo.co.in if you can.

Thanx,

Moncy Mathai
moncy's picture
-7
Joined: Apr 16 2010 - 11:00pm
Last seen: 9 years 2 months ago
0

Hi,

First of all thanks for your briliant work in iReport. Its a fantastic tool.

I have been using iReport for around 2 years now. I find that in earlier versions of iReport we used to have pop-up for property of a parameter, variable or field. This was very usefull and user friendly. With latest versions of iReport this has gone. Now we had to look around to search for different property settings (like hyperslinks, fonts, patterns). These all should be consolidated and shown in a sinlge window.

 

Thank you

rushit's picture
25
Joined: Aug 26 2009 - 3:21am
Last seen: 9 years 9 months ago
0

hi rushit,

Since u had been using ireport for quite 2 years. can u able to guide us by creating an custom variable which contain our simple calculations (+ , - , x and division )  . How can make simple sql expression and store it in a vairable and display it.

I had been trying this for quite 3 months.

efshafi's picture
Joined: Apr 28 2010 - 3:42am
Last seen: 9 years 1 month ago
0

hi , I have exactly the same proble

did u solve it? can u please tell me ??

I'm stucking there

 

marjaneh's picture
Joined: Aug 5 2010 - 11:25pm
Last seen: 8 years 10 months ago
0

Hello,  I am new to iReport.  My company is using 3.0.0.  I want to create a crosstab report.  It does not give me a count in the detail boxes.  It just displays the last value encountered in the data source.  What am I doing wrong?  Thanks for your help.

isemp0's picture
1
Joined: Jul 20 2010 - 7:42am
Last seen: 8 years 11 months ago
0

My company purchased iReport when it was told even non-programmers could use it, and we paid for maximum support but Jasper now tells us this can not be used for any help in designing reports (just running them online). Thus we are (to make a HUGE understatement) put in a very disappointing situation. I have made some basic reports but am stuck on some of the charts (for example). Nowhere (e.g. not even in the "Ultimate" guide, which really only shows a couple of screen shots of graphs) can I find any assistance on using each chart type. Though I'm not a programmer, I spent years as a computer trainer and thus just need some explanation and examples. Where can I find these for the charts (not just one explanation for a basic pie chart)... all charts? Thank you very much for your help. This is the first time I'm giving JasperForge a try.

non-programmer's picture
Joined: Aug 26 2010 - 3:22pm
Last seen: 8 years 9 months ago
0

Hi,

I have been using iReports for a period of over 2 weeks now and I must say that I like all the featues and I am almost able to do all the existing reports on it with much ease. (using variety of featues - subreports, scriptlets, graphs).

The only issue/question that I have is whether there is any feature on templates that allows me to do multiple templates for each report. The point is I always have to do an export to CSV, PDF, Text versions (and may be more depending on client's requirements) whenever I fire a report request from the website. Now the reports are quite complex and there are multiple groupings and sub-groupings on it. The PDF version that I get is lovely while the CSV version is rubbish. I have tried getting around this by printing different bands for CSV and PDF - it definitely works but is extremely tedious for complex reports - specially when CSV works best with cartesian data format (tabular) and PDF looks best when data is not arranged in a cartesian manner.

If there was a feature which would allow me to select which template to run for a given report(jrxml) i.e allowing multiple templates for the same report(.jrxml file) based on a parameter, I could easily define different templates for different expected formats rather than selecting different bands.

Can you please advise on whether any such feature is desirable or is selection of bands the only option going forward. I wouldn't want to do different jrxm files for the same report as wouldn't want the query to run twice (fairly complicated and time consuming queries)

Thanks & Regards,

Amit

 

mermaidtide's picture
Joined: Aug 26 2010 - 2:58am
Last seen: 8 years 9 months ago
0

Hi Guilio,

is Ireport has a rules to change dynamically the horizontal position of elements?

polly_vent's picture
Joined: Aug 17 2010 - 2:01am
Last seen: 8 years 10 months ago
0

 Hello there

I am having a problem with runing iReport.

I freshly installed the 3.7.6 version, and at the begining when I tried to open it, gave me the error:"Cannot find java.exe".

I created an environment variable JAVA_HOME which points to my JDeveloper java.exe file, and when I start the iReport application it doesn't do anything

Can you tell me what can I do?

Thank you

Angel

driftdone's picture
Joined: Nov 22 2010 - 4:35am
Last seen: 8 years 6 months ago
0

Check out the recent posting on drill down reports: http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=43651

(This is a response to a_madani question from 06/19/2009..I had hoped that "Quick Reply" would tie this resonse to that post instead of just adding it to the end.  In any case, I hope a_madani figured out the answer long ago or posted it as a general post instead of as a response to this QA Topic! :) )



Post Edited by cbarlow3 at 12/03/2010 00:13
cbarlow3's picture
1398
Joined: Mar 4 2010 - 8:59am
Last seen: 2 weeks 6 days ago
0

 Hi,

I want to show to a jasper-server logged-in user only reports he should see,  accoring to a mapping i have in the DB.

so i want to add his username to a 'WHERE' clause in the iReport main query to know if to allow him to see the report.

Is it  possible to get a username that logged in to the jasper server and use it in iReport query to display the relevant report according to the username.

or if there is another way, i would be glad to hear about it.

 

thanks!

 

eyale's picture
50
Joined: Dec 4 2010 - 10:56pm
Last seen: 8 years 6 months ago
0

hi there.

i'm new with ireport. can anyone help me how to call ireport 3.6.7  from netbeans 6.9.1 ide. thank you in advance.

 

simonmcrom's picture
Joined: Dec 8 2010 - 8:04pm
Last seen: 8 years 6 months ago
0

hi there. i'm stuck with my java project regading integrating ireports. can anyone help me please on how to call an ireport 3.7.6 in java. i'm using netbeans ide version 6.9.1.

simonmcrom's picture
Joined: Dec 8 2010 - 8:04pm
Last seen: 8 years 6 months ago
0

Hello, Please i need help.

Anytime i run my query using mysql GUI editor i get the correct number of rows, but when i apply it in iReports it repeats the rows and gives me more records with the same values....Please help me

sammiebone's picture
Joined: Mar 1 2011 - 5:56am
Last seen: 8 years 3 months ago
0

Hi!

I'm using jasper report 3.7.3. When displaying data in adempiere it's ok but if I export it to pdf the resutl is a blank pdf file.

It works fine if I export to Excel.

Do you know the reason?

Thanks for your help!

 

lovelylife1982's picture
Joined: Apr 4 2011 - 5:42pm
Last seen: 8 years 2 months ago
0

Hi,

 

I'm newbie to the iReports. Could you please help me in creating recursive reports?

 

I have a single query which is to be used to drill down several levels. Few has to be drilled down more levels and the other lesser level (simply I have drill down variable levels).

 

I have developed as follows....

created a report, in that report, using a hyperlink called itself again by passing the parameter.

Problem is....Its working properly sometimes, not working the other times, sometimes working on 1 PC and not on others.

I couldn't figure out what went wrong !

Can anyone help me in figuring out whats the problem?



Post Edited by rkanubaddhi at 04/05/2011 19:59
rkanubaddhi's picture
Joined: Apr 1 2011 - 10:25am
Last seen: 8 years 2 months ago
0

Hello,

 Is there a way to customize the ireport tool, means I need to hide option/functionality in the tool. How can I achieve that?

Thanks,

Anita

anitasri's picture
Joined: Dec 3 2010 - 6:37am
Last seen: 8 years 6 months ago
0


Hi
 
I want to print my field values horizontally (by default they are getting printed vertically). I palced placed a field in detail section , now insted of getting them printed :
aaa
bbb
ccc
ddd
..
.
.
.
i want the values to be printed like:
aaa     bbb      ccc      ddd.....
 
I am using ireport 4.0.0
I am searching so Manny sites but i have no correct solution. 
Please guide me .Where it can write the code 
 
Thanks
venu

venu08's picture
-11
Joined: Apr 4 2011 - 8:56pm
Last seen: 8 years 2 months ago
0
Hi,

Try using a large amount of columns and would be also better if you would switch page format to landscape (if not already).
DanielP's picture
Joined: Oct 25 2007 - 8:57pm
Last seen: 1 week 5 days ago
0
Hello Kalin Rashev,

Are you still involved in JasperRports? I like to speak to you about a possible project. Tks!

Mikael
mikaelarhelger@gmail.com

mikaelarhelger's picture
Joined: Feb 7 2010 - 3:23am
Last seen: 9 years 4 months ago
0

 Hello,

I'm using RunJasperReport to generate reports from the command-line.

I would like to add settings so I can set the correct Locale, I assume I have to set that with the '-params'  as a command-line option.

I tried  -params 'localereport:locale:DE-de' 

but I get error message: "Can't find bundle for base name localereport, locale en_US"

BTW: Setting/changing the default locale in  iReport (Preferences / Execution options) works.

 
Can anybody give me the correct command-line option to set the 'Locale'?
rempargo's picture
Joined: Jul 29 2010 - 4:39am
Last seen: 8 years 10 months ago
0

Hi everybody.  I have a java code which is producing the chart objects:

private static JFreeChart createChart(PieDataset piedataset)

I'm trying to find the way to import generated JFreeChart-Objects into the I-Report.

Has somebody an idia how is it possible?

I know how to import generated images & texts, but i can't find out what to do with the charts...

Of course, we can generate the image using the functionality of JFreeChart-Library, but it's not a solution, because of a bad quality of generated images.

I would appreciate any help.

Thanks a lot.

mayoleg's picture
Joined: May 26 2011 - 11:15pm
Last seen: 8 years 3 weeks ago
0

Hello,

I just star to create barcode with jasper report, everything is OK now.

But I'm not very familar with jasper report.

Is there a function for creating barcodes with a large amount?

Hope there's a update if not.

Best reagrds.

 

cathyben3's picture
Joined: Nov 24 2014 - 7:03pm
Last seen: 3 years 9 months ago
Feedback