Search results for query: *

I have a finished report with one prompt page. This prompt page has two drop down list prompts. In my first prompt I have 2 static choices. Depending on what is chosen in this first prompt I then want to display three more static choices in the second prompt, the values of which will depend on...

Hi, I have two query subjects that have the exact same table entries in each of them. For one of the entries I have a different filter value applied for each query. QS1 BatchId Parameter (Filter:Parameter=Volume) QS2 BatchId Parameter (Filter:Parameter=Height) I now want to join these two...

Hi Steve, I don't think your solution will solve my problem. For example, if a process starts on Monday 15th and finishes Friday 26th, that means that there is 12 days between the start and end date. What I want to do is remove Saturday and Sunday from the result so that I can show...

Hi, I am using Report Studio to develop reports for a manufacturing plant. In one of my reports I have a start-date and a finish-date, which I subtract from one another in order to get the number of days it took for a process to run. The start and finish date can be weeks apart and...

Sorry, I'm using Report Studio, Cognos 8

I would like to store a value in a variable and then use this variable in a calculation with a value from a similar but unrelated record. For example in Record A, I am receiving back the finishing time of a task. In Record B, I am receiving back the starting time of the new task. The...

In my report I have two columns (AllUnits, TypeA) each of which has a total count value at the bottom. I would like to get a percentage of the total count of TypeA units against the total count of AllUnits. Something like [Count(AllUnits]\[Count(TypeA)]. This does not work because the total...

Apologies if this is a beginners question but I'm using Cognos for the first time. I've just created six reports in Report Studio (Cognos 8) which I now want to merge into one report. There is a common unique ID column in each of the reports that will be used to join up the results from the six...

Cheers Dave, that worked a treat. Grouped on INPUT DATE. ID CODE is the unique value in each record. [INPUT DATE] = maximum([INPUT DATE] for [ID CODE])

I am creating a report that is currently returning a number of records. One of the columns in this report is a date entry. Of the records that are being returned I only want to use the one that has the latest date value. Is there any filter I can use to apply to this column so that only the...