Creating Drill down

0

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
A
B
C

Subreport.
A1
A2

I need to display as shown below,assuming i had clicked A

A
   A1
   A2
B
C

Is there any other approach to do achieve this drill down instead of using master report and subreport.
 

kumarsrs's picture
Joined: Jun 28 2009 - 11:51pm
Last seen: 9 years 11 months ago

30 Answers:

0

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

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

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
  A3
B
  B1
  B2
C
 

I am getting as follows

A
 null
 null
 null
B
 null
 null
C

Attached the jrml file.

 

 

kumarsrs's picture
Joined: Jun 28 2009 - 11:51pm
Last seen: 9 years 11 months ago
0

You missed to set the connection expression:

1. Right click the List element and select Edit List Datasource

2. In the Datasource/Connection expression box set Use Connection Expression and accept the default expression set (which is $P{REPORT_CONNECTION}

Giulio

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

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 following

Ireport - 3.5.2

Server - 3.5.0

Attached the jrxml file





Post Edited by kumarsrs at 07/21/2009 15:34
kumarsrs's picture
Joined: Jun 28 2009 - 11:51pm
Last seen: 9 years 11 months ago
0

You need to update the jasperreports jar in JasperServer to 3.5.2. As said List are supported starting from JasperReports 3.5.2

Giulio

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

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!!!!

mhanspmk's picture
Joined: Jun 18 2009 - 3:56am
Last seen: 10 years 1 day ago
0
kumarsrs's picture
Joined: Jun 28 2009 - 11:51pm
Last seen: 9 years 11 months ago
0

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.

Madhan



Post Edited by mhanspmk at 07/22/2009 06:12
mhanspmk's picture
Joined: Jun 18 2009 - 3:56am
Last seen: 10 years 1 day ago
0

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/

 

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

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 hyperlink

Anchor Name Expression as $F{Name}

Bookmark level as 0

Hyperlink target as self

Hyperlink type as Localpage

Link Parameter as

Parameter name     Expression

Name                         $F{Name}

kumarsrs's picture
Joined: Jun 28 2009 - 11:51pm
Last seen: 9 years 11 months ago
0

i dont find  jasperserver-3.5.2-windows-installer.exe in the link given. Can you please send me the link to download it.

mhanspmk's picture
Joined: Jun 18 2009 - 3:56am
Last seen: 10 years 1 day ago
0

i dont find jasperserver-3.5.2-windows-installer.exe in the link given. Can you please get me the link to download it.

mhanspmk's picture
Joined: Jun 18 2009 - 3:56am
Last seen: 10 years 1 day ago
0

 

jasperreports-3.5.2.jar

http://sourceforge.net/projects/jasperreports/files/

iReport-nb-3.5.2-windows-installer.exe

http://sourceforge.net/projects/ireport/files/

 

 

kumarsrs's picture
Joined: Jun 28 2009 - 11:51pm
Last seen: 9 years 11 months ago
0

No. I need the server installer for jasperserver-3.5.2

mhanspmk's picture
Joined: Jun 18 2009 - 3:56am
Last seen: 10 years 1 day ago
0
giulio's picture
21446
Joined: Jan 2 2007 - 4:15pm
Last seen: 4 months 1 week ago
0

Kumar,

Did you get solution for drilldown?. If you get the solution for drilldown then please post it.

Madhan

mhanspmk's picture
Joined: Jun 18 2009 - 3:56am
Last seen: 10 years 1 day ago
0
Sure....
kumarsrs's picture
Joined: Jun 28 2009 - 11:51pm
Last seen: 9 years 11 months ago
0

what happened kumar. can you able to do drilldown now?

mhanspmk's picture
Joined: Jun 18 2009 - 3:56am
Last seen: 10 years 1 day ago
0

Downloaded Workbench

working on OLAP Schema prepartion.



Post Edited by kumarsrs at 07/23/2009 08:46
kumarsrs's picture
Joined: Jun 28 2009 - 11:51pm
Last seen: 9 years 11 months ago
0

what is that workbench. is that related to drilldown? where can i download it?

mhanspmk's picture
Joined: Jun 18 2009 - 3:56am
Last seen: 10 years 1 day ago
0

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
kumarsrs's picture
Joined: Jun 28 2009 - 11:51pm
Last seen: 9 years 11 months ago
0

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....

mhanspmk's picture
Joined: Jun 18 2009 - 3:56am
Last seen: 10 years 1 day ago
0

JasperAnalysis-Workbench-3.5.4.zip
 
Download URL
http://jasperforge.org/plugins/esp_frs/?group_id=112

kumarsrs's picture
Joined: Jun 28 2009 - 11:51pm
Last seen: 9 years 11 months ago
0

Create OLAP Schema and obtained the desired result,

 SELECT
[Measures].AllMembers ON COLUMNS,
Hierarchize([New Dimension 0].[New Level 0].Members) ON ROWS
FROM [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
kumarsrs's picture
Joined: Jun 28 2009 - 11:51pm
Last seen: 9 years 11 months ago
0

 I try creating a drill-through report using the list concept linking the an attribute to the list, and cannot seem to get the list to show when I click on the hyperlink.  

 

Any help is appreciated.

sjagusch's picture
Joined: Aug 24 2009 - 2:24pm
Last seen: 9 years 9 months ago
0

What do you specify as the Hyperlink Anchor Expression for creating a drill-to list. I assume you would need to use a Local Anchor for this. I have attached a jrxml report below.

sjagusch's picture
Joined: Aug 24 2009 - 2:24pm
Last seen: 9 years 9 months ago
0

An interactive drill down could also be done with Jasper Analysis. However this seems to be mind bogglingly complicated for a layman to set up as far as I can see.

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

Thanks for your reply. I agree, this seems like it should be more simple that it is. I am in the process of installing Jasper Analysis to try this out. However, I have a specific reporting requirement that requires only two levels with the same measures. Alternatively, I could have two different reports with the same data at both levels, but I would like to keep as simple as possible for the user. OLAP is more intended for those data diggers, where the reports i need to write are more for the primitive users.

sjagusch's picture
Joined: Aug 24 2009 - 2:24pm
Last seen: 9 years 9 months ago
0

 Hi,

I have to create drill down jasper report. I followed the steps given in this forum for creating drill down report. But I am not able to see the listview contents when I click the Hyperlink.(Attached the .jrxml created.)

I am using iRpeort 3.7.4 with compatibility for jasper report 3.6.0. Please guide me regarding creating the drill down report.

Thanks,

SriPrasanna

sriprasanna's picture
Joined: Aug 8 2010 - 11:08pm
Last seen: 8 years 10 months ago
0
me too iam not able to see the listview
polly_vent's picture
Joined: Aug 17 2010 - 2:01am
Last seen: 8 years 10 months ago
Feedback