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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.