Search results for query: *

Thanks, one question the file name is not known and between each set of 000 through 0003 there is a newline. Would this still work?

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?

Ties, Thanks so much! worked wonderfully.

no, how would I 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...

thanks that helped!

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

Divya, Without more detailed information, the best way to create links would be to use Report Studio's Query Explorer to link the tables.

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

thanks, the problem has been solved..the error was due to the computer had not had a service pack installed. Thanks!

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

works great! Thanks lbass!!!

I see them but the functions are very sparse. I've got Difference(); basic date functions such as DAYOFMONTH() and only basic Arithmatic options

It is a Windows 2000 server I believe

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

Ian, Thanks it didn't work but I figured out a work around. If isnull({?receipt Date}) then {table.receipt_dt} in {?receipt Date} Else {table.receipt_dt} in [CDate (1800, 01, 01) to currentdate] ) I appreciate you're help!

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