Search results for query: *

I have a file that has data in a fixed-length format like this: 01/29/2010 INT CN 01/29/2010 NAT CN 01/29/2010 TSS CN And I want the output to be: 01/29/2010 INT CN 08/17/2010 01/29/2010 NAT CN 08/17/2010 01/29/2010 TSS CN 08/17/2010 Basically, I would like to append current date to the...

I have a crystal report v 10.0 within which I have setup a string parameter called 'AccountNumber'. Under 'Edit Parameter Field' - I have checked the 'Allow multiple values' option and also checked the 'Discreet Values' button. And then under default values, I have typed in 'All'. In my report...

Hello, I have this query that returns all the valid email addresses from a table on the database: SELECT distinct trim(user_email_address) || ';' FROM table a WHERE active_status <> 0 and user_email_address is not null ; The records returned are in the following format: abc@ws.com...

Hello, We currently have some SQL code that we call from another BAT file but the log file produced from this process does not have any meaningful information. For example, we have a command file that has this line: C: c:\Oracle\10.2.0\bin\SQLPLUS.EXE UID/PWD@DB @e:\a.sql >e:\a.log a.sql...

Hello, I have a Crystal Report v 10.0 that has dates and the balances for that day in the detail section and it is grouped by account number and date so it looks like this: Acct Num: 1234 9/1 1000.00 9/2 134.56 9/3 877.34 9/4 3444.44 9/8 635.78 Acct Num...

I have crystal report developed in v 10.0 and it has 4 groups and all headers except GH2 are suppressed. When I right-click and select 'Change Group' for GF3 and then click on 'Specified Order' then the report seems to hang - it takes a lot of time for the data to come back up. And then when I...

Hi, I have a main report that has company code values and I have a subreport that has totals in the {GF by company code}section. I need to pass the total from the subreport to the main report based on company code. My main report looks like this: RH - Suppressed PH - Report Headings...

I have the following query: select a.anumber, (case when b.bu_code = 'DIST' and b.req_flag = 'R' then 'TRUE' else ' ' end) as DIST, (case when b.bu_code = 'BCTR' and b.req_flag = 'R' then 'TRUE' else...

I have a query that joins two tables based on column A. select * from table a, table b where table a.column a = table b.column a Column A in table A has a value of 'SEP A' Column A in table B has a value of 'SEP_A' How do I put a decode in the where statement so that it does a correct...

I have this query that I am using to export data from multiple tables to a CSV File but I keep getting 'ORA - 12704 Character Set Mismatch' error message. The query is: select case rownum when 1 then '#DATASOURCE,CONTNO,TRANNO, TRANMODE,TRANTYPE, TRANTYPEDESCRIPTION, PRIMARYCURR...

I have two tables that have columns as follows: Table A has columns: UserID, Proxy ID And the data in Table A looks like: UserID Proxy ID 1 4 2 4 3 4 The data means that 4 is the proxy for userIDs 1, 2 and 3 The second table is Table B which has...

Hello, I have a crystal report v 10.0 that has two groups defined: Group A: Company Code Group B: Entry Operator The report currently is summarized by entry operator within a company and then by company. A sample report would look like this: GH1: Company 01 Detail: ABC 123...

Hello, I have a crystal reports 10.0 report that displays all the transactions from the general ledger for a given day or a range of days for a given account or a range of accounts. For example, if the input parameter values for start date and end date are 01/06/2009 and 01/07/2009 then it...

Hi, I have a Crystal Report v 10 report that is grouped by Manager and Unit. I have the following formula in the detail section: @Redemption: IIf({NET}='Y',IIf({DOLLARS}<0,{DOLLARS},0),IIf({REDEMPTIONS}+{CHARGE}<{PURCHASES},0,{PURCHASES}-({REDEMPTIONS}+{CHARGE}))) And I have the following...

Hello, I am using Crystal Reports v 10.0 and I am just not able to think this one out :( I am displaying credit and debit on a report that has just the detail section. The users want the report to also display a balance field so I wrote a formula: WhilePrintingRecords; numbervar balance...

Hello, I have a query that I run on Oracle 9i that involves 3 tables. Table Master Table JHistory Table GTNC The primary keys in the above 3 tables are all different but there are parts of the primary key that are common to all 3 tables. Here is my query: select DISTINCT b.FPS_NUMBER as...

Hello, I have this query that I run on Oracle 9i: SELECT DISTINCT b.amount_code_description, to_char((CASE WHEN b.year = '2005' THEN to_char(b.ytd_amount, '9999999999.99')...

Hello, I am on Oracle 9i and I am trying to format the output in a query as follows: SELECT DISTINCT SUM(CASE WHEN b.year = '2005' THEN to_char(b.ytd_amount, 9999999999999999999999.99') ELSE...