kumarsrs Posted July 20, 2009 Share Posted July 20, 2009 I had created main report and sub report , i can pass a value from main report and display the value in the sub report.Now i am getting as Main report ABCSubreport.A1A2I need to display as shown below,assuming i had clicked AA A1 A2BCIs there any other approach to do achieve this drill down instead of using master report and subreport. Link to comment Share on other sites More sharing options...
Giulio Toffoli Posted July 20, 2009 Share Posted July 20, 2009 If the subreport is simple enough, you can use the List element (JR 3.5.2 and greater).It is a kind of light subreport, but it does not require a separated jrxml.Giulio Link to comment Share on other sites More sharing options...
kumarsrs Posted July 21, 2009 Author Share Posted July 21, 2009 Downloaded JR 3.5.2 found the List element, i tried to use the same in the ireport to obtain as mentioned below A A1 A2 A3B B1 B2C I am getting as followsA null null nullB null nullCAttached the jrml file. Link to comment Share on other sites More sharing options...
Giulio Toffoli Posted July 21, 2009 Share Posted July 21, 2009 You missed to set the connection expression:1. Right click the List element and select Edit List Datasource2. In the Datasource/Connection expression box set Use Connection Expression and accept the default expression set (which is $P{REPORT_CONNECTION}Giulio Link to comment Share on other sites More sharing options...
kumarsrs Posted July 21, 2009 Author Share Posted July 21, 2009 When i try to deploy in the server, i am getting The selected Jrxml could not be parsed, as a error message. I am using the followingIreport - 3.5.2Server - 3.5.0Attached the jrxml filePost Edited by kumarsrs at 07/21/2009 15:34 Link to comment Share on other sites More sharing options...
Giulio Toffoli Posted July 21, 2009 Share Posted July 21, 2009 You need to update the jasperreports jar in JasperServer to 3.5.2. As said List are supported starting from JasperReports 3.5.2Giulio Link to comment Share on other sites More sharing options...
spmkkmps Posted July 22, 2009 Share Posted July 22, 2009 Guilio,Can you get me the link to downloaded JR 3.5.2. Am also need to implement drilldown in one of the report.Madhan!!!! Link to comment Share on other sites More sharing options...
kumarsrs Posted July 22, 2009 Author Share Posted July 22, 2009 Please find the URLhttp://sourceforge.net/projects/ireport/files/ Link to comment Share on other sites More sharing options...
spmkkmps Posted July 22, 2009 Share Posted July 22, 2009 Thanks kumar. Can you please attach your drilldown jrxml which will be useful for me. Also if you have any other document for creating drilldown report please attach it too. Its very urgent. It is of high priority work to be done from my side. So please send me as soon as possible.MadhanPost Edited by mhanspmk at 07/22/2009 06:12 Link to comment Share on other sites More sharing options...
Giulio Toffoli Posted July 22, 2009 Share Posted July 22, 2009 iReport 3.5.2 (which contains JasperReports 3.5.2) can be found here: https://sourceforge.net/projects/jasperreports/files/JasperReports 3.5.2 can be found here: https://sourceforge.net/projects/jasperreports/files/ Link to comment Share on other sites More sharing options...
kumarsrs Posted July 22, 2009 Author Share Posted July 22, 2009 I had created jrxml to generate a output as attachment (drilldown.JPG)Please let me now how to generate a drill down report, i had provided the hyperlinkAnchor Name Expression as $F{Name}Bookmark level as 0Hyperlink target as selfHyperlink type as LocalpageLink Parameter asParameter name ExpressionName $F{Name} Link to comment Share on other sites More sharing options...
spmkkmps Posted July 22, 2009 Share Posted July 22, 2009 i dont find jasperserver-3.5.2-windows-installer.exe in the link given. Can you please send me the link to download it. Link to comment Share on other sites More sharing options...
spmkkmps Posted July 22, 2009 Share Posted July 22, 2009 i dont find jasperserver-3.5.2-windows-installer.exe in the link given. Can you please get me the link to download it. Link to comment Share on other sites More sharing options...
kumarsrs Posted July 22, 2009 Author Share Posted July 22, 2009 jasperreports-3.5.2.jarhttp://sourceforge.net/projects/jasperreports/files/iReport-nb-3.5.2-windows-installer.exehttp://sourceforge.net/projects/ireport/files/ Link to comment Share on other sites More sharing options...
spmkkmps Posted July 22, 2009 Share Posted July 22, 2009 No. I need the server installer for jasperserver-3.5.2 Link to comment Share on other sites More sharing options...
Giulio Toffoli Posted July 22, 2009 Share Posted July 22, 2009 http://jasperforge.org/projects/jasperserverGiulio Link to comment Share on other sites More sharing options...
spmkkmps Posted July 23, 2009 Share Posted July 23, 2009 Kumar,Did you get solution for drilldown?. If you get the solution for drilldown then please post it.Madhan Link to comment Share on other sites More sharing options...
kumarsrs Posted July 23, 2009 Author Share Posted July 23, 2009 Sure.... Link to comment Share on other sites More sharing options...
spmkkmps Posted July 23, 2009 Share Posted July 23, 2009 what happened kumar. can you able to do drilldown now? Link to comment Share on other sites More sharing options...
kumarsrs Posted July 23, 2009 Author Share Posted July 23, 2009 Downloaded Workbenchworking on OLAP Schema prepartion.Post Edited by kumarsrs at 07/23/2009 08:46 Link to comment Share on other sites More sharing options...
spmkkmps Posted July 23, 2009 Share Posted July 23, 2009 what is that workbench. is that related to drilldown? where can i download it? Link to comment Share on other sites More sharing options...
kumarsrs Posted July 23, 2009 Author Share Posted July 23, 2009 These drill down comes under analysis for that we need OLAP Schema, manually creating is not a easy stuff, for that I had had download this workbench.Once it is successful , we can move the schema and the query to jasperserver. Post Edited by kumarsrs at 07/23/2009 10:52 Link to comment Share on other sites More sharing options...
spmkkmps Posted July 23, 2009 Share Posted July 23, 2009 ok. once drilldown is done please let me know and send the files. it will be helpful for me. tell me from where can i download that workbench so that before getting the solution from you i will go through what is there in the workbench,etc.... Link to comment Share on other sites More sharing options...
kumarsrs Posted July 23, 2009 Author Share Posted July 23, 2009 JasperAnalysis-Workbench-3.5.4.zip Download URL http://jasperforge.org/plugins/esp_frs/?group_id=112 Link to comment Share on other sites More sharing options...
kumarsrs Posted July 23, 2009 Author Share Posted July 23, 2009 Create OLAP Schema and obtained the desired result, SELECT[Measures].AllMembers ON COLUMNS,Hierarchize([New Dimension 0].[New Level 0].Members) ON ROWSFROM [cube]; when i try to use the same in jasperserver, i am getting error as"The following is not a valid MDX Query: Internal error: Virtual file is not readable: repo:/analysis/views/ttt"Attached the screen shot.Please let me know, why i am getting the above error. Post Edited by kumarsrs at 07/23/2009 10:46 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now