Search results for query: *

================== MS-Access 2002 sp3 ================== Hi everyone, I've got a brand-new table with 7 fields. Fields 1, 2, 3 need to get their information from another table linked via an ODBC connection. I would like to be able to use a List Box on Field 1 to select the proper row from...

HOLY CRAP! [surprise] You're right! Thanks LB! Wow... I feel really stupid, I think I'll go get a cup of coffee. [purpleface]

...n1; numberVar n2; numberVar n3; numberVar n4; numberVar num; numberVar answer; dif := .003; if(dif < 0) then n1 := (dif * 10) else num := dif; if(n1 < 0) then n2 := n1 * 10 else num := n1; if(n2 < 0) then n3 := n2 * 10 else num := n2; if(n3 < 0) then n4 := n3 *...

Hey thanks for the simplifying tip...I always like to get rid of clutter. As for the logic problem, you are right! My subreport does fire for rows that are getting suppressed by its own details X-2 formula. Since there are records after the one with the SPC requirement that do not have this...

...shared numberVar x; if {JobOper.OprSeq} = x AND trimleft(trim({JobOper.AnalysisCode})) = "SPC" then ( DHsuppress := False; // show spc chart "*** SPC Charts are required at this operation. ***" + chr(13) + "Value of DHsuppress is: " + ToText(DHsuppress); ) else ( DHsuppress :=...

Thanks, Ro & SV for your advice and helpful links. In the future, I will look in the crystalusergde.pdf before i post to this forum! best regards, CMoyia

Sorry, I forgot: Crystal 8.5. Progress database over ODBC connection. 7 tables in the main report + 32 tables in 18 subreports. Grouping is done at the client. "flow of evaluation" refers to: Record #1 - Evaluate RH, then PH, then GH1, then GH2, then ..., ... then RF, then PF (or...

Good day, all: This is probably an elementary question, but no less important to straighten out the flaws in my logic. I've got a report that uses the structure outlined below to display 21 records. What is the exact flow of evaluation in the report for each record...

My thanks to everyone for all their helpful suggestions. Even those that didn't work, they helped me to "think around the corner". I finally solved the problem of reclaiming the space by using a Group Footer instead of a page footer (thanks Naith) and a few fancy bits of suppression. Cheers...

hmm, group footers? I hadn't thought of that! Thanks, Naith, I'll give it a shot. Er, the checkbox thingy didn't do anything, so it looks like IdoMillet is correct. But thanks anyway for the suggestions! [cheers] -Geo

Naith, thanks for your response. I think i've seen that check box, but haven't known what it's for. I'll give it a try, thanks!

Let me give you some particulars about my problem... I have an image database containing jpegs that I want to print on a special details section of my report (for more details on the report structure, see thread767-1055582). I would like to use as much of the 8.5 x 11 in layout as I can...

Thanks for your reply kskid, But can I do this conditionally in a formula?

Greetings everyone: Is it possible to conditionally hide a page header/footer? I have successfully suppressed my footer (ref. thread767-1055582), but cannot reclaim the space (1.125 in.) at the bottom of the page that was allocated for it. I am using Crystal 8.5. Thanks in advance for...

Oh by the way..... Johnny Damon is the shaggy CF for the Boston Red Sox. He's also doing commericials for Dunkin Donuts & Puma...and they are on ALL the time. Arrgh! [banghead]

Ah-HA! A formula in Details A did the trick! ========================================================= Details a, formula @Da - PFSuppress: ------------------------------------ WhilePrintingRecords; Global booleanVar PFSuppress := False...

K- Thanks for your response. I gave it a try and these are my results: My report has 21 records under Group #3, 21 Operations if you will, (numbered 10 to 210). At Operation 120, the planner wishes to print a related scanned document, and so checks the CheckBox01 (setting the field...

Feliz Cinco de Mayo, Everybody! - I'm using CR 8.5 to generate a "Job Traveler" report that circulates around our shop with each part we make. Every part has a unique job number ({JobHead.Jobnum}), assembly number ({Jobasmbl.AsmSeq}), and BOM sequence ({Jobasmbl.BOMSEQ}) which directs the...

hmmm, TEM3, maybe you could use a Cross-Tab thingy to arrange your records with your item numbers horizontally?

This is kinda clunky, but it might just work: If (<Account Bill-to State><>"PR") Then If (<Account Bill-to State><>"VI") Then <Account Bill-to Country Name> Else "VIRGIN ISLANDS" Else "PUERTO RICO" Good Luck! [pipe]