If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Maps - Report Studio

Started by mbomabe, 21 Feb 2014 05:15:02 AM

Previous topic - Next topic

mbomabe

Hi, Anyone knows how to setup a Master-Detail relationship between a map and an another object, as a List. The master would be the map and the detail will be the detail. It works when I use a Active Report, using a deck, but I wanna use in the standard report.

  Best regards,

      marcelo

Raghuvir

Hi,

if u want to bet redirected to a detailed report, u should use drill through definitions.

just try it once and check if u have the desired output.


MFGF

Hi,

You can embed a map within a list, but not a list within a map. This means the list will always be the master and the map will be the detail.

Drilling through (as suggested) seems to be the solution you need here.

Regards,

MF.
Meep!

mbomabe

So, the objective of the report is when the user click in a state on the map, the list is filtered by this state. In active reports works, but in standard report ( no active report ) the master-detail option in list is not available. I know that in Active Reports works cause the map and the list are inside a Deck, but there isn't a Deck object in standard reports.

MFGF

Hi,

You can't have a map as a master in a master/detail relationship. In your Active Report you are filtering a list based on the selection made from the map, but the map isn't a master query. To achieve similar functionality in a non-Active Report you will need to set up a drill-through definition from the map to pass the selected region value. Your drill-through target will be the same report, and your list will be filtered based on a region parameter. You can either hide the list using conditional rendering when the report is first run, or you can define a default value for the parameter which corresponds to all regions.

There are a few posts on here that discuss drilling through to the same report, if memory serves. Do a search and take a look at the recommendations. Come back to us if you get stuck.

Good luck!

MF.
Meep!