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
- 8007 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 |
what is cardinality that you can give to employee and department query subjects in framework manager?
how u create security to reports ????
What is difference between page break and section report?
what is an outer join? difference between left outer join right outer join with an example?
Can we provide Package level security to two different groups i.e for finace and HR depts should access only their data??
I need to display blue color for max Revenue and red color for min Revenue by using condition formatting how it possible........?
Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks
Explain difference between powerplay transformer and power play reports?
hi Cognos Experts Pls Expalin me what is the diffence between list report query and crosstab report query?pls explain me.....
What is called materialized view?
how to create relationship between emp and salgrade tables in frameworkmanager?
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
Teradata 
