Jump to content

Creating Drill down


kumarsrs

Recommended Posts

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.
 

Link to comment
Share on other sites

  • Replies 30
  • Created
  • Last Reply

Top Posters In This Topic

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.

 

 

Link to comment
Share on other sites

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
Link to comment
Share on other sites

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
Link to comment
Share on other sites

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}

Link to comment
Share on other sites

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

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

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
Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...