Search results for query: *

Thanks, LBass. That worked great! -Gene

Two tables--EmployeeAttributes has codes for Attributes by Employee, Attributes has the list of Attributes: Tables: EmployeeAttributes Attributes Fields: AttributeCode---------AttributeCode Employee AttributeName Each page of the report is for 1 Employee, and I want to...

The report query produces a "Callee" table (which works fine) and a "Caller" table like this: Order Caller Alt 1 Smith 0 1 Jones 1 1 White 2 2 Jones 0 3 Posey 0 3 Black 1 4 Green 0 My report looks like this: Group Header 1...

CR XI R2: I need code that would do the job of Next(Next()) (which obviously doesn't work). I'm sure it's some For/Do While but I'm not good at those yet. What I have now is If Next({Table1.Field2})>0 Then ToText({Table1.Field2}) Else "" This looks at the next record, but I need to look at...

Sorry: Version 8. The record selection formula is Table A.Supply Code = Table B.Supply Code

My report is grouped by distinct (no duplicates) alphanumeric Supply Codes from Table A. Those records are only selected if they match a Supply Code in Table B, in which there are duplicate Supply Codes. My report correctly shows only 1 instance of each Supply Code (there are no...

Thanks, LB, but it was unchecked. And the order in which I put IsNull and "" didn't make any difference. Are there times when it will? I am having another weird problem though: The Sum method is producing correct results for each field except the 1st one on the left (just to the right of Group...

Hi IanOctDec. Thanks for responding, but that doesn't work, because as I said in my original post, I can't use DistinctCount (there are duplicate titles). If I use Count on @CountedField it counts all records, null or not.

I did find a cheesy way to do this. I created a formula field: if {TABLE.TextField}="" or IsNull({TABLE.TextField}) then 0 else 1 Then I suppressed it and put it on top of the text field. Then used Sum to get a count of non-blank fields. Not very satisfying, but is this the way it's SUPPOSED...

In Crystal Reports 8, in the Report Footer, I need to get Count to stop counting text fields that have nothing in them. I'm surprised that it's counting them at all. I can't use DinstinctCount in this case.

Thanks, Hilfy. People like you should be writing those Help files. :-)

I have CR 8.0, unregistered, that came with LDRPS from Strohl. There are canned reports that have database fields pasted into text boxes, and it says that I should be able to paste DB fields into text boxes in text edit mode by holding the mouse pointer directly over the blinking text box...

In QuarkXpress 6.1 on Windows XP, I had collected the frontmatter and all 34 chapters in a book file. I had spent half the day checking that the pictures were properly updated in each file. For some reason many of them were shown as "modified" but I checked that they were the correct files and...

Mark, Thanks. That could be useful eventually, but I rarely use text boxes in Word. How about to the left of the cursor anywhere in the document? And I don't use forms, just macros. -Gene Ha ha. Molehill story funny.

Wolfert, Thanks. Now how do check what's BEFORE the cursor? BTW: Oh. I was looking at the left column of this page for the forums and I didn't see those on the right side. Thanks again. -Gene

Seems like this should be the easiest thing to find in all those VB for applications books, but I can't find it. I'm used to WP macro (?rightchar) etc. commands, but cannot figure similar function for MS Word macros. Sure would save me a lot of time if someone could answer this (newbie?)...

ACK! I can't believe TwistedAdmin told you to delete your Normal.dot file without first asking you a few IMPORTANT questions, like: Are there any template documents or macros or button rows you've created in the past taht you'd like to keep? Erasing Normal.dot erases all of those and more...

Klick: Oh, "keyboard shortcuts." Geez, we don't even have common terms for anything anymore, since Bill Gates keeps renaming things when we get used to them. I work in MS Word and Wordperfect a lot, so I tend to think of things in terms of those. Also, I don't do Windows shortcut...

Klick, what are you talking about? "RegEdit.exe"? My shortcuts worked fine.

The best reason I have for removing the arrow is that it covers up part of my girlfriend's face in her icon. :-( I'll try tweakui and see if that works.