Recent content by Mbroad

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

ok, just to clarify, I create the three formulas but do not place (other than the last one) in my report? I will try this but I don't understand how the first two formulas execute if they are not in the report. I will try and let you know. Thanks Government Coder Mark

I am trying the lbass solution and placed the formulas in my detail line. However, I cannot seem to keep the detail line (the formulas) from printing on the report. Any suggestions? Government Coder Mark

Yes there are more than 1 DOCKET record per CASE record, so i am not sure that the group selection noted 1st above will work. Government Coder Mark

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

No errors are shown after the run. It shows successful run. Government Coder Mark

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

Wow! It's that simple!! Thank you very much! [medal] Government Coder Mark

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

Thank you!! Thankyou!! That worked superbly!! Apreciate much your assistance!! [roll2] Government Coder Mark

Sure--sorry about that. My SOS_TABLE has 640,000 rows in it. My FINAL_FILE has 160,000 rows in it. All rows from SOS_TABLE should be present on FINAL_FILE table. I want to find all rows on SOS_TABLE which are NOT in FINAL_FILE. The above query only returns 1 NULL record. Please help! Thanks...

gmmastros-Sorry, but removing the DISTINCT did not do it either---I must be missing something very elementary here-- Just want to find the rows which are on table 1 and are not on table 2--that's all Any thoughts? [pc] GCM Government Coder Mark

Sorry SQLsister, I tried the code just as you said and still only get one NULL record in return. Like I said, DB1 has 600,000 rows and DB2 has 160,000 rows and most/all of DB2 rows should be in DB1---I only want the rows which are not. [ponder] Thanks a lot, GCM Government Coder Mark