If you have a report with list and cross tab in the same page. How do you restrict one user can see only the list and the other user can see both.
- 4 Answers
- 8047 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / prathik
We can achieve this by using condition blocks.So that user can select the block which he wants to see based on the condition.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / seshu
We can do the same by using render variable but if you use the render variable that is better way to take two pages on one page you should have the list and on other page you should have both that are list and crosstab.
use one prompt with static choices that are as follows:
1>List
2>Both
make any boolean variable or string variable where you need to define the condition that if (?promptdisplayvalue?='list')
then
1
else
2
assign that 1 variable to the page where you have list and assign the value of 2 where you have both list and crosstab
| Is This Answer Correct ? | 1 Yes | 0 No |
OP, Can you clarify how to differentiate between the first user and the second user?
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / mohana krishan kapa
You can use the layout calculation,
This will return the user Name and based on user name you can restrict the data.
| Is This Answer Correct ? | 0 Yes | 3 No |
I have a value prompt in my prompt page.Now if I set the filter to required then I have to select a value from the list and I will get the respective data in the report page.But If I select nothing then I will get the complete data in the report page. I want that if I select nothing from the prompt list then nothing is displayed in my report page. How should I do this?
hi, I want to create this report... List View--- -(Drop down list) Order Date From: \/ To: Customer Employee Order customer ------------------------------------------------------------ ------------------------------------------------------------ ------ customer c-name c-address c-phone c- city.................... ------------------------------------------------------------ ------------------------------------------------------------ ----- c-id c-type . . . ------------------------------------------------------------ ------------------------------------------------------------ ---- Employee .............same like one list Order.....................same like one list These are all in one page....i want u show... condtions *when i select in view type ex:employee and date as 10-05- 2007 to 10-05-2010 I need to go the employee list table and display the items .. And Iam trying in value prompt for creating of (cust,emp,ord)in a single value prompt,that will not created... and how to create 3-list and connection for those in value prompt.. Pls any one knows explain me (by step by step) of creating that report? Thanks Vannur
1.WHAT IS XML SPECIFICATION WHAT IS PURPOSE,WHERE YOU ARE GOING TO USE.2 DIFFERENCE BETWEEN RENDER VARIABLE AND CONDITIONAL BLOCK.3.WHAT IS LINK AND SEGMENT.4.WHAT IS CONDITIONAL LAYOUT.5. DIFFERENCE BETWEEN DETAIL FILTER AND SUMMERY FILTER AND HOW YOU ARE GOING DEFINE IN SQL (DETAIL AND SUMMARY FILTER ).. WELL THESE QUESTION I BEEN FACED IN IBM COULD SOMEBODY GET SOLUTIONS PLZ..THANKS IN ADVANCE
16. How can we create top 10 and bottom 10 records in the same list?
----------------Describe DWH Architecture?
Can any one give the example for slicing and dicing of data ?(with simple query)
How can we find out cardinality between two tables?
what is mean by complex starschema ,star schemagrouping?
How applying "Level Span" in Cognos 8.3?
any difference between cognos and real time cognos
In Drill through, Reports are executing successfully when rename & run the created reports? Pls tel me the reason?
what is the difference between application based and web based in cognos?can you please give a example from out of EP 7 series and 8 series?genrel exampel please?
Teradata 
