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

Using Images as Buttons to show different Screens in Cognos 10.1

Started by GeethaKL, 26 Oct 2015 10:12:19 PM

Previous topic - Next topic

GeethaKL

Hi All,
I am building an Active Report where in I have to build in such a way that the users click the images to see different screens.
for this I have created few images using Paint Brush and copied it to Cognos Server.
Then in the Report Studio, I have created five lists and embedded an image each in each of the five lists and formatted. it is appearing as expected.
then I have created a deck with 5 cards and included five different report objects in each of the card.

my question is how to link the top lists to the deck so that I can show my images as buttons to show 5 different screens
please advise
thanks

Regards
Geetha

MFGF

Quote from: GeethaKL on 26 Oct 2015 10:12:19 PM
Hi All,
I am building an Active Report where in I have to build in such a way that the users click the images to see different screens.
for this I have created few images using Paint Brush and copied it to Cognos Server.
Then in the Report Studio, I have created five lists and embedded an image each in each of the five lists and formatted. it is appearing as expected.
then I have created a deck with 5 cards and included five different report objects in each of the card.

my question is how to link the top lists to the deck so that I can show my images as buttons to show 5 different screens
please advise
thanks

Regards
Geetha

Hi,

In Cognos 10.1 this is a little more involved than in later builds, as in your (early) version, static repeater tables do not exist.

I have written reports in the past where all my buttons are shown in a list. The list was based on a query fed by SQL - not SQL from any real table, but a piece of virtual SQL, written using the following approach:

SQL - Syntax = IBM Cognos, Data_Source = great_outdoors_sales, Name = ButtonQueryVirtualTable

select * from (
values
(     cast('http://<servername>/graphics/one.png' as varchar(60)), cast('ONE' as varchar(10))    ),
      (    'http://<servername>/graphics/two.png', 'TWO'    ),
      (    'http://<servername>/graphics/three.png', 'THREE'    ),
      (    'http://<servername>/graphics/four.png', 'FOUR'    )
)
MainButtonImages (imageName, buttonValue )


This then gives you a URL (imageName) and a value (buttonValue) you can use in your list. The URL points to the image and the value is something you can use in an active report variable to drive your deck. You can include both items in your list, and set the Value column to "is hidden = True"

Cheers!

MF.
Meep!

GeethaKL

Thanks MFGF.
I am able to build ButtonQuery Virtual SQl with 5 image urls(.jpg) in the Query explorer and created two data items Image Name and Button Value.
As I am on 10.1, and cant use Repeater table, I dragged a 5 Different Lists and wanted to embed an image each in all the 5 lists.
how to get image in the list instead of URL
Please advise

Thanks
Regards
Geetha

MFGF

Quote from: GeethaKL on 27 Oct 2015 06:59:54 AM
Thanks MFGF.
I am able to build ButtonQuery Virtual SQl with 5 image urls(.jpg) in the Query explorer and created two data items Image Name and Button Value.
As I am on 10.1, and cant use Repeater table, I dragged a 5 Different Lists and wanted to embed an image each in all the 5 lists.
how to get image in the list instead of URL
Please advise

Thanks
Regards
Geetha

Hi,

You *can* use a repeater table in 10.1 - you just don't have static repeater tables (which would make use of a list redundant).

Drag in a repeater table, and base it on the query fed by the SQL. Drag in the Buttonvalue item to the repeater table.
Drag a list inside the repeater table, also based on the query fed by the SQL.
Drag both items from the query into the list.
Drag an Image object into the list. Select the Image object and set its Source Type property to be "Data item value", then set the Data Item Value property to be the Imagename item.
Create a master/detail relationship between the list and the repeater table based on Buttonvalue.
Set the Column Visibility property on the Imagename column and the Buttonvalue column in the list to "Hidden".
Cut the Buttonvalue item from the repeater table.
Hide the list header for the Image column and remove the borders around the list cells.

Cheers!

MF.
Select the Imagename column in the list
Meep!

GeethaKL

Thank you very much for your time MFGF... Its working perfect..

Regards
Geetha

GeethaKL

Hi Again,

Just one more..
The 5 images are working perfectly..
Here I have a deck with five screens/cards. my task is click each image it should open one screen each in the MHT file.
for that I tried to create Active Report Variable in the List Report and link List Report Button value to Deck with five screens on label..
but its not changing the screens in the output.. the images are clickable but not changing the screens..
Where am I committing mistake here?? Am I missing something? please advise

Regards
Geetha

MFGF

Quote from: GeethaKL on 27 Oct 2015 08:06:05 PM
Hi Again,

Just one more..
The 5 images are working perfectly..
Here I have a deck with five screens/cards. my task is click each image it should open one screen each in the MHT file.
for that I tried to create Active Report Variable in the List Report and link List Report Button value to Deck with five screens on label..
but its not changing the screens in the output.. the images are clickable but not changing the screens..
Where am I committing mistake here?? Am I missing something? please advise

Regards
Geetha

Hi,

The Buttonvalue values in your SQL (and therefore in your list query) should match exactly the names of the cards of your deck. You can then have the list set an active report variable to Buttonvalue, and your deck should be selected by this same variable.

MF.
Meep!

GeethaKL

Thanks a lot for your time MFGF.. Now that its working..
Was struggling to link because I had put Button VAlue data item to Box Type None instead Column Visibility 'Hidden' in my Image List report.
now I put Hidden and its working as expected.
thanks a lot
Regards
Geetha