Alternative to Singleton in Active Report

[garfunkal]

Hiya

A while back I built a dashboard which used a couple of charts, and lists.  As the customer is one of these info-graphic freaks, he was keen to have some info in sentences, drawn on clouds.....

very hip....

but anyway, in the normal report I did this using a load of singletons, and then wrapping them alongside text items - eg 'GWP for ' singletonforyear 'was ' singletonforpremium


That worked fine, but now when I try to rebuild as an active report I get trauma, as you cannot create a master detail relationship between the data deck and the singleton, and therefore can't control the interactivity.

I've tried a few things, including replacing the singleton with a single column list and making the data item the sentence,   but that isn't ideal as I can't format specific elements for size and colour.

Any ideas how I get around it?

using Cognos 10.2.1 - Sqserver db, relational data.

[MFGF]

Hi,

If your singletons share the same query as your data deck, you shouldn't need a master/detail relationship to show the correct content. For example, if your data cards are driven by Year and you have the same content you posted above (with the singletons for year and premium using the data deck query) you should get the relevant year and premium on each card without needing master/detail.

Am I missing something more complex, though?

If you really do need master/detail relationships, just use repeaters instead of singletons.

Cheers!

MF.

[garfunkal]

The singletons could perhaps share the same query as the deck with some more careful build!  I'll have a try. I'm a bit new on Active Reports, so I get confused about the best place to put the data to make it more efficient

I'll also see about the repeater option. Many thanks!