what is render variable
Answers were Sorted based on User's Feedback
Answer / vanthian
As far as i know
Render variales are generally created to conditionally
render a particular page or chart or list or block etc...
Though the purpose of the render variable is to hide the
particular item..we can't say that it is use to hide a
particular item...
Consider a scenario..
You have created two list reports for two countries
List1 is for both country1 and country2
List2 is for country 2 alone
List1 is created from the query1
List2 is created from the query2
Now u create a conditional string variable called 'Country'
which uses country name as a parameter
Now u associate Variable 'Country' as render variable for
List1 and List2
Now whenever u run the report..when u select country1 then
automatically the two queries will be rendered to the two
list and the two lists will be displayed
But when u select Country2 as parameter then only Query2
will be rendered and the list2 will be displayed in cognos
viewer window...
Note...
When u use Conditional variable u r just hiding the output
from the user..but in the backend the two queries will be
processed by cognos....hence ur precious time will be
wasted..
But when u r using the render variable only the Queries
which satisfies the parameter will be rendered and hence
the other queries will not be processed in backend by cognos
I hope this helps you
| Is This Answer Correct ? | 50 Yes | 1 No |
Answer / s sri harsha mediboyina
Render variable is something like hiding(rendering)
anything using a variable(Condition)
| Is This Answer Correct ? | 32 Yes | 3 No |
Render Variable: - Specify a variable based on which object
can be conditionally rendered.
Example for Render Variable:--
if the case is like you want to see the particular page in
HTML or PDF or CSV format then
1)Create 3 pages in your report
2)every page conatins some specific data
3)name these pages as HTML PDF CSV
4)create a String vaiable with 3 values as HTML PDF and CSV
5)now in string variable put expression as .....
case
when ReportOutput() 'HTML' then 'HTML'
when ReportOutput() 'PDF' then 'PDF'
when ReportOutput() 'CSV' then 'CSV'
end
6)now go the page named HTML and select page object
7)in properties pane click on Render Variable select that
string variable
8)check only HTML check box value for HTML page
9)repeat step No. 6 to step No.8 for remaining 2 pages.
now run the report :-)
hope it will answer your question .
regards
vij
| Is This Answer Correct ? | 22 Yes | 3 No |
Answer / subhash
when u want to hide the column based on some condition then
we will go to the render variable option.
| Is This Answer Correct ? | 25 Yes | 12 No |
Answer / sirisha
Render Variable: - Specify a variable based on which object
can be conditionally rendered.
Example for Render Variable:--
if the case is like you want to see the particular page in
HTML or PDF or CSV format then
1)Create 3 pages in your report
2)every page conatins some specific data
3)name these pages as HTML PDF CSV
4)create a String vaiable with 3 values as HTML PDF and CSV
5)now in string variable put expression as .....
case
ReportOutput()
6)now go the page named HTML and select page object
7)in properties pane click on Render Variable select that
string variable
8)check only HTML check box value for HTML page
9)repeat step No. 6 to step No.8 for remaining 2 pages.
now run the report u can see what ever type of Format u
rendered........
This is the right answer for u r question.
Regards
Sirisha
| Is This Answer Correct ? | 7 Yes | 2 No |
faq's on cognos
I want to display popup menu or alter message in my report? How to you solve this problem? Give me the answer with example?
Define the cognos reporting tool?
Can someone tell me whether we can apply filter on list of values in the 'Value Prompt'? e.g. I have a value prompt (named city) and the prompting is holding around 2000 cities but I want to apply filters on cities so users can select only 15 cities out of 2000 and then run the report. Users should be flexible enought to select any 15 cities from the list. Is it possible. Please advice!
what are slowly changing dimensions? Why we are used scd?
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
This question is asking in many interviews,,,,, What is your challenging task in report studio? anybody pls tell me some 2 or 3 challenging tasks,,,,
If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.
1.How can we driil through from a page report having query1 to list report having Query2 in master detail relationship n Drill through? 2.In database i have 50 records but when it is displayed on the report i'm getting 100 record with duplictes.How can we solve this to eliminate duplicates? 3.Exact Diff B/W Filter n Condition? 4.Render Variable? 5.I have leftouter join when right table does not have any matched records with left table what will be the output of the report whether it will be dispalying Null or blank in that particular row? 6.How to test the reports i.e Unit Testing? 7.How canwe drill through when there is no common column between the parent n child report? 8.How can we do performance tuning? I kindly request all the experts to give reply with correct answers and if possible send me some examples regarding that at srini.madhala@gmail.com
How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?
-----------What is member Description?
what is the difference between Cognos EP7 series and Congos8?