Search results for query: *

I am having what I think is an unusual problem intrying to export data from Crystal. I have a very basic report (no headings) that produces a line of data fields. When I attempt to export the report data, I only get some of the columns; the rest are "" (null) even thought I can plainly see...

I need to figure out a way in Crystal to do the following: --Read CASE file (containing CASE number) --For each CASE number, read DOCKET file (linked on a CASE_ID field) --Keep and PRINT the detail from the CASE file if -DOCKET file has either a GEFFCC and/or JAGFECC DOCKET CODE...

I am using a subreports to find records in a different database than the main report and bring these back to the main report to display. All I wish to see are the results brought back to the main report (via a shared variable). Unfortunately, the subreport displays it's findings on the line...

Hi, I am a system Administrator for Crystal Enterprise at my shop (just so that you knw my experience level) and I have scheduled a report in Crystal Enterprise which is to email the results to 3 people. The report is scheduled to run daily (and does so, successfully) Only ONE of the...

I am writing a Crystal Report which displays some database fields. After running the report, I wish to export the data to a fixed-length file. However, when using export (i.e. record-Style, or text), the record length is variable. How can I tell Crystal to create a FIXED length file (pad the...

I am using Crystal 10 with an Oracle 9 database. I am rather new to Crystal, so bear with me... I am reading a database of court jurors which are divided into something called panels. I need to SUM the total number of detail records printed at the end of each panel Group. I try using the...

Hi-I am a newbie to SQL, so please bear with me. I am trying to run a SQL server statement which will match DB1 against DB2 finding only the NON MATCHES between the two (and writing to a third DB). DB1 has azpprox 600,000 rows in it, DB2 has 160,000 rows. This is code I am using, but it is only...

Hi-Not sure if this is correct forum or not, but here goes. I am trying to create a bat file that will copy a file from my pc to a network drive. Easy enough--except that the directory names on the network drive contain many spaces and the copy does not like that. (using xcopy). Something...

I am a SQL newbie, so excuse the obvious question--I have a table which has a two-digit numeric value in it and approx. 21000 rows in the table. I need to modify (update) this number in the first 1900 rows to "01" and to "16" in the remaining rows. How do I accomplish this? Thanks, Government...

Hi i have a text data file which contains carriage returns (which we do not wnat within the data)--I am not sure if this is somethiong to be done in SQL or another platform. I need to read in this file and reaplce all carriage-returns with a space. Any ideas? Thanks Government Coder Mark

I'm a newbie to SQL--I need to do the following. Perhaps you can help: read table-A and match the zip5 and zip-4 fields against zip5 and zip4 fields of a Table-b (zip code table)-- If found on Table B, write out to table-c the entire table-A record PLUS a jurisidiction code from table-B Any...

Hi--I have a 36 character NAME field on TABLE-1 (containing first and last name) I need to separate the first-name & last-name from NAME writing them to TABLE-2 FNAME and LNAME fields the "sticking "point is that I can only use the first 15 characters of each first or last name I am not sure...

Help!! I am using the following code to divide a NAME field (containing both first and last name) into separate first and last name fields. However, I need to also only select the leftmost 15 positions of the first name and last name before writing them. How do I do this? Thanks--Mark...

I would like to import a long text field into SQL SERVER, but need to remove any [enter] keystrokes from this field. Do you know of a command to do so? thanks, Mark Government Coder Mark

Hi--I am running the following "every nth record" selection query, but would like to also add a MAXRECS ability to this query. how and where do I do this? select A.* into SOS_KEYNUMBER2 from SOS_SECOND_RUN A inner join SOS_TEMP B on A.SID = B.SID where B.seq % 5 = 0 Thanks--Mark Government...

Hi--I need to insert the name fields from table 1 to table 2. The name field in table 1 is a name like "Jones Marvin" (full name). The name fields on table 2 are first-name and last-name. How can I unstring the complete name into separate name fields? Thanks, Mark Government Coder Mark

Hi- I need to copy certain columns from table-1 to table-2, each table having a different file layout. Is there a method to copy specific fields from table-1 and place them in different columns on table-2? Your help is greatly appreciated. MB Government Coder Mark

Hi--I need to query a table based upon values which are read in a flat file. For example, I have a flat file of names and addresses and need to find each name on the name table, by reading in the name/address flat file. How do i accomplish this? Thank you---MB Government Coder Mark

Hello--I am writing SQL which utilizes several different tables to do a basic name and address extract. The name is one TABLEA and the Address is on TABLEB, however there are often multiple addresses for each name. there is a field on TABLEB which has the update date and time, so you would...

Hi--I need to develop a query which will do the following: Select * from table1 picking every nth record (sequentially) and writing to output table I appreciate your assistance. Thanks, MB Government Coder Mark