Recent content by paljnad

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

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

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