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

Will do. Thanks for all your help.

Thanks again, taupirho. I was able to modify the query a little bit to get it work and it works beautifully. I am also able to generate a text file output but when I copy and paste from the text file into the 'To' field of my email message then I notice that there are new line characters...

Thanks, taupirho. I tried it but it gave me an ORA-01489: result of string concatenation is too long error message. I am pretty sure that the length of the string returned by the select statement is over 4000 characters.

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

...on set term off set echo off -- define variables set verify off define tbl_bstrndtl = 'bstrndtl' define tbl_bstrnhdr = 'bstrnhdr' /* start attributes requirements */ set linesize 80 spool e:\a.txt select rpad(nvl(a.ACCOUNT_number,' '),10)...

Thanks, lbass. I was able to use formula 17 to get what I wanted.

Thanks, Madawc. But I just want to be able to get the next business day. If today was 9/1 then the next businessday is 9/2 and if today was 9/4 then the next businessday is 9/8 since 9/7 is a holiday.

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

Thank you both for your responses. I used a link and was able to get the data that I wanted. I used a couple of formulas and variables in the main report to display the total by all company codes from the subreport. I put it in the group footer of the 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...

Thanks, SantaMufasa. I tried it but for some reason, it puts duplicates out there. Also, how do I join in another table. The query I have now is: select anumber, ltrim(substr(max(sys_connect_by_path(bu_code, ', ')), 2)) BU_CODE from (select anumber, bu_code...

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

Thanks, Santa. I used the decode and it worked like a charm !

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 tried this and it ran without any errors: select datasource || ',' || contno || ',' || tranno || ',' || tranmode || ',' || trantype || ',' || trantypedescription || ',' || primarycurr || ',' || bunit || ',' || bunitshortname || ',' || bunitfullname || ',' || cpty || ',' ||...

The select count(*) from..worked so now I am going to try and add back all the segments in steps to see where I get the error.

Hi Mufasa, The tables are part of a vendor package and they directly gave the create and insert script to the DBAs and not to the app people. We are just trying to figure out a way to get the data out of the tables in CSV format.