Recent content by CarpalT

Good afternoon, -k I can't find a way take the simple straightforward approach on this. The fields are in GF1. I want to suppress it if the values of two fields in GF2 immediately above it are 0. And I want to embed it in a text box with some other text so that there are no spaces. I thought...

Crystal 8.5 I have been looking for a list of the constants that can be used in formulas. I can find partial lists in CR "help", but nothing at all on the BO web site. What I am specifically trying to do today is hide a field depending on the value of another field, whether it is hidden or not...

Crystal 8.5 - SQL Stored procedures or directly to tables. This is driving me crazy... Create a report, make it landscape, check "no printer", sets the report to portrait, dumps all the fields off the page that won't fit. Is there a way around this? [banghead] Thanks!

I used SELECT DISTINCT to get one record per. Thanks for the help!

SQLDenis, thanks for your help and making me think! Closing in on it... Adding the r2.complete criteria reduced my record count from 10,000 to 8,000 but still lots of duplicates. I stumbled on a second consideration while I was checking that: For one r1.Key# record, I can have many (1, 2, 150)...

I'm looking at the results now. Still have some dups but it dawns on me there may be another cause. Thank you for the suggestion, I'll think a minute and let you know. I appreciate your help!

Yes it should be in order for the r1 record to be a candidate for deletion.

I apologize to you pros for what must be an amateur question. I have a table with records that have been closed, (complete = 1)and nearly duplicate records that need to be closed (complete = 0)or deleted. They will have the same purchase order number, line, and release. Here is my query, which...

I know this much: Crystal picks up whatever the properties of your windows default printer. So if you are developing a report for legal/landscape for other users you don't really need to have that printer, but you do need the driver for it on your pc, and to select it when developing and saving...

I second Ido's advice - The advantage of avoiding the Label Wizard (Report Expert) is that you can change the label size in the future. The Report Expert creates a right and bottom margin that can't be changed afterward. You can make it LOOK like it's bigger, but you can't do anything with the...

Thank you lbass (I was HOPING you'd see my post! ) for bringing to my attention the possibility of a null in the history table. That may be what I need to make my little work around report give me what I need. To answer your question, yes I need all the effective dates in one column, and all...

I'm using CR 8.5 against ABRA payroll Foxpro tables. The connection is a proprietary ADA (Abra Data Access) connection that will not allow SQL queries. (Otherwise I would try a union query.) I have two tables. People has three fields people.id people.EffectiveDate people.Salary History has...

Many thanks to all of you, and thank you for the SQL help blog link. I'm sure I can learn a lot from it. The world is full of good people.

Thank you both, I'll take a look at that. Sure, I'll just go tell my boss to hire a programmer. The world is full of good people.

I'm just learning how to write SQL queries. Reading manuals a& help like crazy but sometimes that doesn't help. I have this, that works: IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'Sam') DROP TABLE Sam Can I modify it to something like - - IF...