Search results for query: *

I'm new to TCL and need to add a header row to the first line in a text file as it is processed within Cloverleaf interface engine. Example input file 000 001 002 000 001 002 Required output: "This is the test file for ABC" 000 001 002 000 001 002

Hi, I have a trend line graph for a full year with the X axis based on a Year-month field (Character). I've been requested to put a marker on the graph deliniting the current date ... any ideas how to do this?

Hi, I created a layout calculation for a date parameter. The date parameter is based on a date time field which I cast as a date. The result is ex. Oct 19, 2009. I would like it to display October 19, 2009. I have tried changing the properties of the parameter display to include the Long...

Hi,I'm a very new Cognos user and working in Report studio and need a report done today. I have created two queries (A & B)to pull data for current month and prior month (based on a parameter for Location & Date). Each query (A & B) groups data by Location & division and does counts, ratios of...

I'm quite new to Cognos. My goal is to report "Current Month" (based on a YYYY-MM) parameter and then also report the prior month(and in the case where current month is January,then December of the prior year). My parameter is based on a Varchar date field YYYY-MM. I created a current...

Hi, I'm working in Cognos Report Studio 8.3. I have a line graph by week and amount with each employee's production represented by lines. Only 5 employees out of the 10 are displayed. A down arrow appears at the bottom of the legend, but appears to be non-functional. Any ideas on how to...

Hi, I built a report CR10 and it runs fine... the user however is having records display when they shouldn't (via supression formula). The user is using the same report on the save server and database. I had several other users open and run the report and they did not have the problem the...

Hi, I'm using Cognos 8.3 Report Studio and a newbie to reporting in Cognos (prior experience with Crystal & Access). I'm working on a Crosstab that I only want to show percentages. I have developed multiple queries with the final one having the calculated percentages by month and Plan I need...

I'm using CR10 and I have a command based report. I need to change part of the command that reads WHERE ELIG.EndDate > {?End Date}AND ELIG.BeginDate<={?Begin Date} To find the first day of the month based on the ELIG.EndDate. I tried using the formula in the command but it doesn't work...

I'm using CR10 and working on a report where the user can select several parameters. One of which is the user can select the reciept date to be between two dates or "All dates". I've set a date parameter {?receipt Date} with a default date of 12/31/2199. In the record selection I'm...

I'm using CR10 and trying to accumulate strings of transaction IDs and am hitting the 65334 limit. I've tried to get around this and am hoping someone can assist in figuring how to accumulate strings into separate "buckets" if a bucket of strings exceeds the length limit. (@accum)...

Hi, I'm using CR10 and have a report grouped as follows GR#1 Store ID GR#2 employee ID GR#2 Txn Details (multiple lines per txn) I need to find a percentage random sample of the txns over the entire report (each store & employee). I can't change the grouping of the report though. I created...

I'm using CR10 and have a report where I need to get the difference between consective groups. Group 1 by date of service (table.dos)- displayed as "month/year" Group 2 by product - suppressed Detail Group footer1 Sum of product sales (table.salesamt) I need to take the difference of the sum...

Hi, I'm using CR10 and have a report with a subreport. Both reports are grouped by person ID and I want to pass a variable from the subreport when the person ID's match. I have linked the main to the subreport by person ID and the variable is passing. The issue is the passed variable doesn't...

I'm using CR10. Pulling information on complaints. The manager wants to see all possible complaints categories within complaint subjects in the report and totaling the # complaints per category & Subject. Since no complaints have been registered in several categories is there a way to display...

Hi, I have in table two fields First Name (FNAME) and Middle Initial (MI). In some case the MI is populated. When it is not then the true middle initial is occasionally typed in FNAME with a space " " then the Middle initial example:"Jane M". I want to pull the "M" and place it into a new...

I'm trying to audit two tables to ensure the records in one table are in the other. My problem is when a date/time field has null values in both tables the records don't match. Any ideas? SELECT [SHS_IHN_ELIG - July & Aug].FileDate, [T834chg_wkly_20070709_0704_001-flat date...

I'm using CR10 and have a parameter value (allows multiple values to be selected) to search by product code. I'm using the formula from the above thread to have the user select "" or 000 if they want to pull all product codes.... If ( IsNull({?Prod code(s)}) or Trim({?Prod code(s)}) = "" or...

Hi, I need to pull a random sample (210) of orders out of over 46,000. I would like to split the sample between two subgroups (M & H). Can anyone help?

Hi, I am trying to pull customers who have exceeded costs within the last two years on specific products of $125.00. I have grouped on the customer ID and have a grand total by the ID. In the Group selection I have eliminated those who have cost less than $125.00. I have in the selection...