Search results for query: *

Hi, I use CR XI R2 with DB2 database. I am trying to use a command object to replace the database fields in a report. The command object works fine and I was able to replace the database names with the command object name in the formulas by doing a find and replace option in Formula...

Hi, I use CR11 ith SQL server 2000. I have a report where the parameter accepts sales rep Number and the report currently displays the numbers separated by a comma. New requirement is to display the sales rep name instead of the number in the report. I have modified the formula to display...

Hi, I use CR 9.2 and Oracle 9i. I am looking at an option to select the database to be used for the report using a parameter while running the reports. For example, I would like to have one of the parameters for selection between 'TEST' and 'PROD' and depending on the selection the datasource...

Hi all, Greetings. I have a subreport in a report with volume and price. I would like to get the total of the top 2 volume * price based on the usage. Sample data and required result is as follows: Period volume Price Rank vol*Price 1 100 7 6 2 200 8 5 3 400 9 2 3600 4 300 8 3 5...

Hi, I use CR 9.2 and Oracle 9i. I use a SPORC for the report. The SP sends back data for 2 different kinds of reports produced from one CR report file. The formats and contents of the reports are very similar and hence we try and use the same SPORC and report. But there are unique...

Hi, I am using CR 9.2 and Oracle 9i. I would like to get some help on conditional horizontal alignment of text fields. I want to align the fileds Right justified except the first 3 fields which are to be centered and would like to know if there are constants available for this purpose...

Hi, I use CR 9 with Oracle 9i. The following is the output obtained from an SQL query with 3 UNION statements. The SQL output is as follows: PERIOD CODE USAGE 1 USAGE 12911 2 USAGE 14762 3 USAGE 13657 4 USAGE 10356 5 USAGE 6301 6 USAGE 1703 1 Mkt 8.14 2 Mkt 8.87 3 Mkt 8.95 4 Mkt 8.8 5 Mkt...

Hi, I use CR XI with the source data read from am XML file using XML native driver. I need to create a report that needs to calculate the time elapsed in the PASS status and Fail status Sample Data is shown below: Timestamp Status 3/28/2007 1:00:00AM Pass 3/28/2007 2:00:00AM Pass...

Hi, I have the following in my Open Object REXX script in Windows and I would like to know how I can make the search case-insensitive? if left(line.i, 9) = "<!DOCTYPE" then if pos("<errorCode>", line.k) > 0 then say line.k Here I want to make the search case insensitive of the strings...

Hi, I use Open Object REXX in Windows XP machine. I am fairly new to REXX and I need some help. I have a text file with lots of data and I need to parse certain lines based on the following logic: The input file looks like this: I am fairly new to REXX and I need some help I have a text...

K, Thank you for the post. I had a look after posting and though I was not able to scroll and see the whole text, I was able to view some of the code and when I copied and pasted the data in notepad, it was complete. Now, I had wordwrapped the whole thing and removed unwanted part of the...

I use CR XI and the data source is a UNIX log file that has about 200,000 lines. Sample data is as follows: 2007.01.09 13:41:30 [ExecuteThread: '44' for queue: 'weblogic.kernel.Default'] [5] weblogic APIEJB.PROCESSMESSAGE(String,int) Client request = &lt;?xml version=&quot;1.0&quot...

Hi, I have a logfile (originally from a UNIX server) that has been placed in a directory in my c: drive. The file has an extenstion of *.log. When I create a new connection as Access / Excel and select the file type as Text, I do not find the log file listed for selection in the file list...

Hi, This is part of a post from Data access forum titled "Access logfile from UNIX server in CR XI", posted yesterday. I have been trying to get the data in CR today. I have had good success in that respect though there are some "exception handling" issues I need some advice on. I use CR 11...

Hi, I have couple of questions here. We have a logfile in a UNIX server based on which we want to create a CR (CR Professional 11) report. Currently, we get the file FTP'ed and sent via email and we process this using a REXX script to eliminate unwated text and prepare a csv formatted script...

Hi, I have used SQL command object (Add Command in DB expert) get some numbers grouped on a column. I have two such sets of data which I want to display in the report, one group below the other. (use CR XI and Oracle 9i) I can display one of the two group of results in the details section...

Hi, Does anybody have some insight into using SQL commands for importing (or using as is) Oracle Stored Procedures in CR. I am using Oracle 9.2 and CR XI. We are trying to use existing SPs in CR without any changes (or minimal changes). I have been advised that SQL commands are the option to...

Hi, I am trying to use SQL statements as Command under Database Expert. I have couple of questions on this and hope somebody would be able to help me there. 1 Once a command item is added, is there anyway we can change the name of the item? For example, I see the name for the first code...

HI, I use CR XI with Oracle 9.2. I have a requirement to use some functions created in SQL/PLSQL in CR. An example function is as follows: FUNCTION total_new_users(end_date DATE, time_frame NUMBER) RETURN NUMBER IS return_value NUMBER(20) := 0; BEGIN SELECT COUNT(1) INTO...

Hi, I have defined two variables as follows: currentBeginDate := TO_date(ADD_MONTHS(LAST_DAY(ADD_MONTHS(sysdate, -1)),-1)+1, 'YYYY-MM-DD'); currentEndDate := TO_date(LAST_DAY(ADD_MONTHS(sysdate,-1)), 'YYYY-MM-DD'); testbegindate := to_date('2006-10-01','YYYY-MM-DD'); testenddate :=...