Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. handpass

    Cascade prompts with static choices

    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...
  2. handpass

    Self Join using two query subjects. Cognos 8

    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...
  3. handpass

    Report Studio: Remove Sat and Sun from date timeframe

    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...
  4. handpass

    Report Studio: Remove Sat and Sun from date timeframe

    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...
  5. handpass

    Cognos variables

    Sorry, I'm using Report Studio, Cognos 8
  6. handpass

    Cognos variables

    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...
  7. handpass

    Percentage of two count values - Report Studio

    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...
  8. handpass

    Merge multiple reports - Report Studio Cognos 8

    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...
  9. handpass

    Report Studio - Select Latest Date Value

    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])
  10. handpass

    Report Studio - Select Latest Date Value

    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...

Part and Inventory Search

Back
Top