Creating Drill down

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.

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

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

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

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}

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

No. I need the server installer for jasperserver-3.5.2

Kumar,

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

Madhan

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

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

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

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.

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.

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.