Answer Posted / naga sudha
First
Run the report with Excel as Run option and take that data
in the first page of the Excelsheet.
Second.
Generate the sql of the report for the same parameters to
be filtered in the report and execute that sql against the
database environment....Point to be noted both should be
Dev or Test or Prod...Then take that data into the second
sheet of the excel,
Then Apply Condition Format of the Two excelsheets like
SHeet1 1*1=Sheet2 2*1 Then Green Else some Red.
Then u can able to Find the presentation of the data with
respect to the report and against the database in the
excel sheet.
Regards,
Sudha
Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
WHAT ARE THE DISTNICT VARIABLES?
9. What was the most complex type of report you dealt with?
What is Online View?
how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?
how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??
how you migrate reports to cognos 8 from previous versions?
I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt
What do you understand by the cognos?
in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt
How do we convert from Numeric to be Words?
How to Reset Pagenumbers in one report.
What is set to be cardinality?
What are the types of catalogs in cognos?
New coloums are added in database, then how you know in report level
Give me any example of semi and non additive measures?