teamireport

HI All, First of all i'm very sorry for this post. i have been gone through all the forum related to making a hyperlink in a chart / different scenarios and most of the forums are not answered. Can anyone please guide me how to make a hyperlink in StackedbarChart scenario. My requirements are as follows. i have a one master report say 'MasterReport' and 4 subreport say 'SubReport1' , 'SubReport2','SubReport3' ,'SubReport4' . My MasterReport have 'stackedbarchart' report with 4 bars with PASS/Fail count and have subreports in 'PIE' charts . I want to create a hyperlink on MasterReport on 'FAIL' bar. it has to take me to one of the 4 subreport. Can anyone plz. guiddme on creating the hyper link on bars that should open a one of my 4 subreports? Post Edited by teamireport at 09/09/2009 16:34 Post Edited by teamireport at 09/09/2009 16:35

Hello Perry, Pl. look at this forum .Hope you can get the solution from this forum links. http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=50149 http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=53327&page=2 http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=53327&page=2 http://www.raj2u.net/jasperserver-installation-on-linux.html All the best !

Seems i-report version issue. ..in what version of ireport you have used to create a chart ?

HI Folks, This might be a simple question for you all :-) I would like to create stacked3dbar chart showing sum of PASS /FAIL count as a bar in toolwise say (link checker,image compare,html validator) in x-axis for one input parameter ( i.e id=xx) . i only pass id value as parameter in thq query following is the query results this is how my query returns ============================= tool resultflag count ============================= linkchecker Fail 1 linkchecker Pass 1 html validator Fail 1 image compare Pass 1 image compare Fail 1 ======================================================== I want to show a sum of each tool's PASS/FAIL count as stacked3dbar report for the above data. I tried to generate a report but my chart data is not showing correct count . Somewhere in creating a group i'm doing wrong? Here with i'm ataching my jrxml ,please look at my attached jrxml and correct me where i need to change to get a correct chart result. Thanks in Advance, teamireport. Post Edited by teamireport at 09/07/2009 10:43

HI emiii0, Yes it's possible.. Do the following steps 1.Login in as jasperadmin/jasperadmin user. 2. In the left side tree view select the folder that you want to hide from users/roles and right-click. 3. Select 'Assign Permissions' In there u can restrict the folder access to view/read/no access. Hope this helps for you. thanks, teamireport Post Edited by teamireport at 09/03/2009 12:21

HI Folks, This is regarding user authentication for jasperserver login from existing users table. I know the flow of how the user are storing into jasperserver database table and login credentials. I would like to know ,is there way to authenticate the users for jasperserver login from my application users table. -Ram Post Edited by teamireport at 08/18/2009 08:26 Post Edited by teamireport at 08/18/2009 08:27 Post Edited by teamireport at 08/18/2009 08:28

Hi Friends, I am trying to use a different database for jasperserver instead of default database jasperserver. ie for authentication purpose i would like jasperserver to use my own database. How can i acheive this. can u plz let me know the corresponding changes i have to do in the code. Thanks in Advance.

HI Giulio, I taken your's attached jrxml for sample to achieve my requirement. I succeed with expected tabular format with nice look and feel i-report preview. And then i liked to view the same report in jasperserer by uploading. The problem that i facing is,when i run the report in i-report. The tabular format looks cool in ireport preview , but it is not showing same kind in jasperserver. Please look at my attachments (

giulio, Yes,its opened in ireport 3.5.2 versio and try designing with your way :)

Awesome giulio,you're great ! Thanks for providing me a solution with near example. I taken look test.pdf .superb the same kind report look and feel i need to achive. I tried to open the attached 'report92.jrxml' using i-report version (3.5.0) to understand how you achieve? But attached jrxml not opening getting an error Error loading the report template: org.xml.sax.SAXParseException: cvc-complex-type.3.2.2: Attribute 'splitType' is not allowed to appear in element 'band'. In which version of i-report you have created the jrxml ? Post Edited by teamireport at 06/30/2009 18:08

HI Giulio, Thanks for your quick reply and info provided about customizer class and scriplets. Herewith i'm attaching the screenshot of our application tabular format CSS. I want to bring the same look and feel using i-report(i mean to design like similar color ,header) ? Can you add please advise me on this how to achieve ?

can you provide me more info about your requiremnt with sample data ?

HI Folks, I have a requirement to create a tabular kind of jasperreport for our report data.For this i want to design a tabular format and that should be similiar to our site CSS. I tried to design a tabluar format report simliar to our site css (i mean same color and lines header section) using i-report 3.5.1 ,but i can't bring it out with same look and feel . How i can acheive using same css of my application for tabular format design using i-report.? Is it possible by using Customizer class or scriptlets ? If so, how to proceed with that. please take me on to right direction on this. Thanks, Ram

HI All, I want to know how you guys achieved resizing the chart height and widht using parameter. How you pass the parameter value to jrxml? Can someone tell the way to do with sample example?

HI Malt, I have successfully generated 'Stacked3DBarChart' report in jasperserver. Now,i'm facing some issues with seeing the x-axis labels are very hard to read for large date range of records chosen ,it looks overlapped. I gone through all the forum posted for this in jasperreprots , ireports and jasperserver projects. I didnt get exact way to proceed. Can you please advise me how to go deal with long date range? here with i'm attaching the screenshot. Thanks in advance, Ram Post Edited by teamireport at 06/18/2009 05:36

Whether the charts can also rendered to the php page using ireport webservice?

In forum they mentioned their is a example for running the webservice to integrate it in my php application. But i couldnt find any thing in the link .Can any one give the URL for download that example. http://sourceforge.net/project/showfiles.php%3Fgroup_id=162962-->Not working

I am working in PHP.we planned to integrate the jasperserver to our applciation.Since how to configure Single Sign on with both the php application and jasper server. Thanks in advance,

i have changed the value of tickinterval="1000".But still this doesnt work.Can you suggest to which value i have to enter for tickinterval?

Can you give me any suggestion where to change in the jrxml,so that i ll get the tick intervals. Thanks in advance.

I have attached the jrxml .I opened in linux-Pdfviewer.It works fine in adobe pdf.

When i used to generate meter chart using ireport 3.0.0,i couldn't get the tick intervals ,even i have given the tick interval value as '50' and data minimum range as 0 and maximum range as '100' And, also downloaded report as pdf looks reddish color. I have attached the screenshot of both 'Meter interval' & 'pdf' issue. Can someone give me a solutions for making nice meter chart.? Thanks, Harikrishnan Post Edited by Harikrishnan R at 04/18/09 11:30 Post Edited by Harikrishnan R at 04/18/09 11:31