Interested to Buy Any Domain ? << Click Here >> for more details...
In which type of report we can create school time table in
cognos? [I want period numbers in rows like period 1,
Period 2, period 3, period 4, period 5 and class numbers in
columns like 8th class, 9th class, 10th class and subject
names in cells]
Genelally school time table is prepared in crosstab report,
but subject names are not measures and a crosstab cell can
not contain non-measures. This is my problem,,,,,
- 2 Answers
- 7660 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ash
Step1: Create a crosstab with row as Period and Column as
Class Number.
Step 2: create a data item Subject as
case subject_name
when 'English' then 1
when 'History' then 2
when 'physics' then 3
...
end
step 3:pull this data item as measure cell.
step 4: create a conditional string variable with
expression as
=dataitem
Create values for this variable as your subject names eg,
English, History, Physics etc.
Step 5: Apply this conditional variable on measure cells in
crosstab. Set conditional text for different values.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / beckham
My suggstion is that you can go for a list report as the
number of items in rows and columns are static in this case
and you need a descriptive item or dimensio in the
middle.... Crosstab can better be used for SUMMARIZED data
across both dimensions.. For DETAILED information like our
scenario you can use the LIST itself...
All the best...
| Is This Answer Correct ? | 1 Yes | 1 No |
explain how to create powerplay reports?
my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?
hi How Can we create rank in our report?i feel difficulty pls expain me with ex,pls pls........
what is the meaning of drill down and drill up in COGNOS 8BI
Explain the different stages in creating a report in cognos report net?
-------------How to create a PortalTab?
Hi Friends, Just want to know, day to day is increasing or decreasing Cognos Usage in the Market? New Reporting tools to driving Reporting Market Spotfire, Tableau,Qlick View, some other New Tools. Which Reporting tool can generate Lot of Opportinities in the Market? Please Reply to this, My Advanced Thank to you. Thank You Kumar
how to create calculate column in report studio
What is the importance of having monitor service in cognos?
suppose if u r report having 1000 tables i want to dispaly alternate rows means 1,3,... how we specify that pleaes ans me
-------What are the Adv of Star Schema and Snow Flake Schema?
if we have a value prompt in a prompt page and if we need to pass that prompt value to a sql used in report, what is the sql code? give me example?
Teradata 
