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!

Register Log in
  • Congratulations derfloh 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: *

  • Users: paljnad
  • Content: Threads
  • Order by date
  1. paljnad

    Adding date to end of line in fixed length file

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

    Using default values with 'Allow multiple values'

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

    Converting multiple rows into a single row

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

    Writing out meaningful output

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

    Calculating next business day

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

    'Change Group' performance issues

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

    Passing values from subreport to main report

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

    rows data to columns

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

    decode in WHERE

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

    Exporting to a CSV file output

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

    Self Join + outer join

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

    Sum of Running Totals in Report Footer

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

    Beginning Balance Calculation

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

    Summary

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

    Running Total

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

    Join with 3 tables

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

    Case..When..Statement

    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')...
  18. paljnad

    Number Formatting

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

Part and Inventory Search

Back
Top