[Logo] SpagoWorld Forums
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing  
[Groups] Back to home page  [Moderation Log] Moderation Log   [Register] Register /  [Login] Login 
Drill down report in Composite document [SOLVED]  XML
Forum Index » Technical Help - SpagoBI Server - COCKPIT
Author Message
bhagya.spw

Newby

Joined: 09/09/2015 10:23:50
Messages: 34
Offline

Hello friends,

I have created the birt report called "MONITOR_DASH_SEARCH.rptdesign". When I click on the column value another report opens. here is the source that I used to create them.

[youtube]https://www.youtube.com/watch?v=xa2kSEjLCMc[/youtube]

Then the parent report was added to the composite document. here is the template.



After adding to the composite document drill down doesn't work. Even though I have already read the
http://wiki.spagobi.org/xwiki/bin/view/spagobi_server/Document+Composite#Attachments
and some Spago world forum post, I couldn't get the clear idea. Can any one help me?
I am using SpagoBI 5.1

Thank you.

This message was edited 4 times. Last update was at 01/12/2015 10:56:33

giachino

SpagoBI hero
[Avatar]

Joined: 05/07/2010 15:41:54
Messages: 355
Location: Turin, Italy
Offline

Hi,
if you want enable the cross navigation to other documents you need define OUT parameters type, as you can read at wiki.

A parameter like this:



In the previous example it defines a cross from the parameter state (in this example is a value of a map zone). It refresh two documents (present in the composition): chartSales and rptBestSales. And when it refreshs these documents it passes the new state's parameter value.

Hope this help.

Antonella Giachino
SpagoBI Consultant
[Email]
bhagya.spw

Newby

Joined: 09/09/2015 10:23:50
Messages: 34
Offline

Hi,
Thanks for your help. but my child report is not in the Composite document. What I want to do is when a column value of a birt report which is in composite document, is clicked, another birt report should be opened from getting the column value of first report.

What I did is, I created two reports and make a drill down functionality from one report to another. Then I added only the parent report to Composite document. After that When I clicked the column value in parent report, nothing happens.Can you help me with this?

Thank you.

giachino

SpagoBI hero
[Avatar]

Joined: 05/07/2010 15:41:54
Messages: 355
Location: Turin, Italy
Offline

Hi,
you could try with an external cross definition, something like this:



With the typeCross property you are able to call a document that is external to the composition..the only limit that I can see is that it shows the new document in a new tab.

An alternative could be re-call the same document that you want drill down passing the selected value... obviously the report must be able to manage this type of recall ...

Regards.

Antonella Giachino
SpagoBI Consultant
[Email]
bhagya.spw

Newby

Joined: 09/09/2015 10:23:50
Messages: 34
Offline

Hi,
I tried it. but nothing changed. here is my template.



Thank you.
giachino

SpagoBI hero
[Avatar]

Joined: 05/07/2010 15:41:54
Messages: 355
Location: Turin, Italy
Offline

Hi,
I think that the template is wrong... because the <PARAMETER ../> tag is out of the <PARAMETERS> tag.

Try changing it in this way:



Regards.

Antonella Giachino
SpagoBI Consultant
[Email]
bhagya.spw

Newby

Joined: 09/09/2015 10:23:50
Messages: 34
Offline

ooopz my fault....!!!
It worked...!!!! Thank you very much for your help.

Regards & Thanks.
 
Forum Index » Technical Help - SpagoBI Server - COCKPIT
Go to:   
Powered by JForum 2.1.9 © JForum Team