---------------How to identify First Record and Last Record?
Answers were Sorted based on User's Feedback
Answer / sowji
Using Head function u can get first record ,Using tail
function u can get last record.
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / rashmi
First Record : head(FieldName,1)
Last REcord : tail(FieldName,1)
| Is This Answer Correct ? | 0 Yes | 1 No |
can we create master detail report where master and detailed container is separate?
Which one is better among Value and select & search prompts,in terms of performance?
What are all the types of hierarchies?
What is the difference between filter & Condition?
How to perform single signon in Cognos by using URL?
How to configure the Cognos configurations to work in the Windows 2000 Server machine?
Hi I have Columns A, B, C, D, E in a Crosstab Report, Cost Budget Column A Column B Column C Column D Column E Total of A+B+D+ E Product 1 100 200 300 400 500 1200 Product 2 500 300 400 500 800 2100 Column A Column B Column C Column D Column E is coming from the Query Item: Category I dont want to include C Column value in the Total Column Column Chas to display in the Crosstab Report how to achieve it Any idea Thanks Sumith
what is stitched query???
What are slice and dice?
Mention the difference between ‘macros’ and ‘prompt’?
How to create a completed dashboards in cognos report studio? and how to change the bar colours for differencet columns in bar charts?
Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!