Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
In my report i have staright table like Webserver | Specifiction(Column Headers)
aaaaaaaa | xxxxxxxxxx(Fields)
bbbbbbbb | yyyyyyyyyy
Iwant this table as in first row webserver names and below that(secondrow) respective servers specifications. like below.......
Webserver | Webserver
Specification aaaaaaaaa | bbbbbbbbb
xxxxxxxx | yyyyyyyyy
how can we implement this, I have attched sample file also.
Hi,
Have a look at the attched application.
Regards,
Kaushik Solanki
Hi Kaushik thnc for your replay i did the same using pviot table but here how to hide the expression same thing i have done using staright table and i got the property for that also(Properties->Presentation-> Horizontal)
Thnx for your idea!!!
Reagrds,
Anil
Kaushik i have one more issue am working on dashboard in the dashboard i have nearly 12 sheets, whenever user opens the dashboard it has to open one default sheet i.e. main dashboard sheet every time
Hi,
I am not clear what you want. Can you please explain in detail with example.
Regards,
Kaushik Solanki
Hi,
Please look in to attached screen shot from the screen shot i have Dashboard frm that i have sheets starting from shair main dashboard to Trending and am displaying all sheets with condtional display using the below condition for shair main dash board sheet =[ShairA&I]='SHAIR Main Dasboard' and for Infrastructure sheet am using
=[ShairA&I]='SHAIR Main Dasboard/Infrastructure'...............for all sheets....
here what i want is when ever we open the Dashboard it should open with the Shair main Dashboard sheet this is the start up page of the dashboard,,,, suppose if we save the Dashboard in Server sheet if we opened next time instead of opening with Server Sheet it should open with Shair Main Dashboard sheet.......
I think this is clear.....
Regards,
Anil
Hi,
You need to create an trigger called "On Open" to active that sheet.
Go to Settings-> Document Properties -> Triggers -> Document Event Triggers -> Click on OnOpen ->
Add Actions -> Add -> Layout -> ActivateSheet-> Provide Sheet Object ID ( Of sheet which you want to shoe by default)
Regards,
Kaushik Solanki
Hi,
Thnx for you replay Kaushik, i have tried as you said but not getting the Shar main Dash Board(Default sheet) as start up,, for sheet object am providing Shair main Dashboard as sheet object instead of object ID because earlier i have changed sheet object ID for conditional display ,,
After setting the property i have saved the file and reopened again but its opening the sheet wheer i have saved it and closed it...........
Regards,
Anil
Hi,
Yes sometimes OnOpen trigger doesnt work.
Thats the only way i know.
Regards,
Kaushik Solanki
Hi,
Do the following
Settings Menu -> Document Properties -> Triggers -> Document Event Triggers (on Open) -> Add -> Layout -> Activate Sheet-> Give sheet name (you required).
Hope this helps you.
Regards,
Jagan.