Search results for query: *

Hello, I am using FC on a Windows Server 2003 machine as follows: @ECHO OFF if exist EmptyFile.xls goto :EXECUTE goto :END :EXECUTE FC ErrorFile.xls EmptyFile.xls | FIND "FC: no dif" > nul IF ERRORLEVEL 1 goto :hasdata IF ERRORLEVEL NOT 1 goto :END :END exit :hasdata echo "hello" goto...

Hello, I am using FC on a Windows Server 2003 machine as follows: @ECHO OFF if exist EmptyFile.xls goto :EXECUTE goto :END :EXECUTE FC ErrorFile.xls EmptyFile.xls | FIND "FC: no dif" > nul IF ERRORLEVEL 1 goto :hasdata IF ERRORLEVEL NOT 1 goto :END :END exit :hasdata echo "hello" goto...

Hello, What would the crystal equivalent of the following be: MAX(NVL(field, ' ')) I tried using isnull and field = " " and maximum but they did not work. Thanks.

Hello, We set up a Windows SharePoint Services 3.0 application to collect information about various systems that 5 departments in our company support. We created a list and had users update information. Now some of the users have attached documents too. What is the best way to download all...

Hi, We have a field in the database that is of type long and it wont show up properly on a crystal report. Our DBA wrote a custom function to convert that field. How do I use that custom function in the crystal report. We use Crystal Reports 10.0 and Oracle 9i. Thanks.

Hi, I have a very limited knowledge of Sharepoint and I have just used it once to put up a list to collect information. Are there any good resources out there on how to use Sharepoint to set up an online event registration site. I have downloaded the template but I havent gotten very far with...

Hi, There is a Crystal Reports v 10 report that uses a command. One of the parameters in this command needs to accept multiple values but I am unable to change the parameter. There are about 25 formula fields that this report uses and I was hoping that there would be some way to change the...

Hi, I have this query that displays the detail records first and then the summary records: select '10' || '050' || '1234512345' || rpad(substr(a.check_number, 2, 10) || ' ', 10) || rpad(to_char(a.check_date, 'yyyymmdd') || ' ', 8)|| rpad(lpad(trunc(a.check_amt * 100, 0), 11, '0') || ' '...

Hi, I have a crystal report (version 10.0) that calculates account balance in the detail section. The report is grouped by various fields and I have put the summary of the account balance in one of the group footer section. The summary displays the right sum when I run the report. Then I used...

Hello, I have a SELECT query(pasted below) that I use to output a file. The users now want the total number of checks and sum of checs outputted at the end of the file with labels. I thought dbms_output.put_line would work but it gives me an error. Please help ! SET FEEDBACK off SET HEADING...

Hi, I have 3 groups in a report - Location ID, TypeID and Project ID. There is a column in one of the tables called 'Title' and I want to be able to sort in an ascending order on the title which is inside the Project ID. But the problem is that it wont sort. I used the Record Sort Expert to...

There is a fixed length flat file - each 'record' in the file has a length of 80. I need to extract data from each record from different positions and format another fixed length flat file. e.g: the input file looks like this: 74807932020002100010020808 0000002355 26240992...

Hi, I have a fixed length flat file - each 'record' in the file has a length of 80. I need to read this file and then extract data from various positions within each record and then write it to another file. For example: the input file has data like this: 74807932020002100010020808...

I have a query (shown below) that I use to produce a CSV file. Now, the first 2 columns need to be enclosed in ". The query: select BUDGETCENTER ||','||ACCOUNTNUMBER ||','||TOTALAMOUNT from (select c.bu_type BUDGETCENTER, a.account_number ACCOUNTNUMBER, sum(a.converted_amount)...

This is my final query: SET FEEDBACK off SET HEADING off SET TERM off SET VERIFY off SET ECHO OFF SET SPACE 0 set linesize 140 col col3 format a140 truncate col col2 format a140 truncate col col1 format a140 truncate SPOOL C:\FTPtoBank\text.txt select '01' || '987' || '1234512345' ||...

Hi, I need to count the number of checks issued for a given day. This needs to go in a fixed length flat file and be right justified zero filled across 10 places. When I use rpad(to_char(count(a.check_number),'0000000000')||' ',11) Then I get an additional space in the front( 0000000005). If...

I have a check amount field in the DB. The values stored in the DB for the check amount look like this: 2637.500, 150.000, 7128.000, 1320.310 etc. I need to format this field to look like this: 00000263750, 00000015000, 00000712800, 00000132031. Basically, I need to display the check amount...

Hi, I am using Crystal Reports 10.0 and I have a main report and a subreport. I have placed the subreport in the report footer. The key in both these reports is the ID number. Is it possible for me to sort the entire report (main and sub included) by the ID number? I am not passing any values...

Hello, I use Crystal XI. I have several detail sections, but no group sections. The report looks like this: RH PH Details a-z Details aa-ar RF PF There are certain sections that I want to print continously witout starting on the next page. I've tried messing around with the keep...

Can I use anything in Oracle that is similar to the TOP function in MS SQL. This is what I would like to do in Oracle: Select * from <table_name> where rownum > 1 and rownum <= 10