Search results for query: *

please let me know how sub reports are created in report studio and how it is called in the main report?? using cognos 8.4 Thanks

I have a Scenario where one main report pulls in many sub-reports around 10. Remember each report has a union of 6 queries pulling for a particular month. This can be done in separate 10 reports also but if cognos has that capability then thought of trying it. Wouldn't be a good report design...

XX XY XZ Total /Avg _________________ A M1 10 10 10 30 M2 4 10 1 5 M3 3 3 15 7 where M1 M2 M3 are measures. M1 should give Total M2 and M3 should give average how it is possible incognos??? conditional formatting? please help..

here is the scenario .. In a crosstab report, need to dynamically change the column based on prompt , so created a calculated column 'x' and placed in the report as crosstab row. x=if(?prompt1? is not null and ?prompt2? is null) then 'column1' else if (?prompt2? is not null and ?prompt3? is...

how to hide cross tab row based on prompt value without messing up the column title?? I did: I created a boolean variable on report page, clicked on the row which I want to hide. set the boolean variable to style variable select box type = none. o/p: the required row was hidden based on...

Here is the scenario .. Level 1 (Required Prompt)-> Level 2(Required Prompt)-> Level 3 -> Level 4 -> Level 5 -> Level 6 High Level -> Low Level In a crosstab with multiple measures , If the user selects Level 3 prompt, the o/p should group by Level 3 and in o/p shows Level 4. If a user...

Ideas To improve the runtime of report at report level? using UNion query of combinng 3 query in a crosstab with 5 measures. All the calculations and filters are done at union query only , as at individual query it throws some error , thus doing it at union query. The execution time is very...

I have a union of 3 queries each has a record id and field X. NOw , I need to do record count grouped by X. In report studio , we can easily get record count = count(distinct record id) but need to group by X. I am using cognos 8.2 report studio , crosstab report with union of 3 queries. I...

I have a report where there are multiple prompt queries got from single table , the final prompt I need to get from different table ie from union query(its a union of 3 tables). prompt 1 ------ prompt 2 ------ prompt 3 ------ All these 5 prompt are got from TABLE 1 prompt 4 ------ prompt...

When trying to union 2 queries , the data type is Date Time for both but the usage property is attribute and identifier respectively.Hence not able to perform union instead getting 'ORA incorrect name' error. PLease help. RQP-DEF-0177 An error occurred while performing operation...

2 measures are calculated measures. Thanks

Hi I got a requirement to group the rows in a cross tab report . When I tried to do so , it came 'this object cannot be grouped' . I know it is easy in List report but is there a way in crosstab or any limitations???? Please help. Thanks

I have a requirement to create a report on a daily basis, in which the result data should appear only once. For eg., If I need to create a daily financial report to XY company, in which I need to determine which customers have exceeded their duedate from paying their credit card bill.Their name...

I created a line chart with x axis and y axis ,measures defined .The report works fine. But have a requirement to display the measure on the line at each point.How it is possible in LIne chart,report studio 8 version. ie., How to include the measure(record count) on the graph. Showing the record...

Like Text box prompt in Report studio ,in Query studio i want to allow the user to type in the value and based on that he should select the prompt value in query studio ? eg.,bob richard , when he types bob , it should populate all names starting with bob and then he selects from the list ...

Hi I need to create a template with 3 prompts in it , which must act as a base to generate future reports.Do we need to code javascript for this or what is the method ??? I have to save this template for future use with prompts in it .

we are asked to convert the IWR reports to cognos 8.3 , we have to re-write them ,instead of using migration tools we are asked to re-create in cognos 8.3 , we have to do catalog conversions to Fm , do we need to follow a specific style to do this conversion ..what are the stratergies to convert...

Urgent ... can anyone list the steps how to convert crystal reports into cognos reportnet?? ..please any idea or brief explanations will be great, iam new to crystal reports and in my project they wanted to convert crystal reports to cognos reports.

hi .. With windows XP Professional &oracle 9i and IIS 5 installed, I tried to install cognos reportnet 8.2 the following error was displayed in the cognos configuration window , when I tried to start the service .. Error: A Content Manager configuration error was detected while connecting to...