Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: CarpalT
  • Order by date
  1. CarpalT

    Crystal Constant for hidden ?

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

    Crystal Constant for hidden ?

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

    Check "no printer" sets landscape rpt to portrait

    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!
  4. CarpalT

    Join table to itself in query

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

    Join table to itself in query

    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)...
  6. CarpalT

    Join table to itself in query

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

    Join table to itself in query

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

    Join table to itself in query

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

    Legal Size Report Only Shows Letter Size

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

    Using Mail Label expert from Report Gallery.

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

    Formula to combine amount fld from 2 diff tables into 1 field

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

    Formula to combine amount fld from 2 diff tables into 1 field

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

    Drop Table List

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

    Drop Table List

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

    Drop Table List

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

    Excel 2003 sort doesn't take cell borders along with data

    You guys are making my little head hurt! I had to figure out how to make a vb macro in order to test drive them, but I've got them both running after a few false starts and some digging into online help and my big fat Excel book. I appreciate all the extra suggestions, it moved me to a new level...
  17. CarpalT

    Excel 2003 sort doesn't take cell borders along with data

    Thanks a million, I'll be able to use that sometimes. On the one I'm doing today, it is an exported report, so sometimes it throws in a few extra blanks before the next section, so it's not predictable after the first section, but I understand what you're saying. The world is full of good people.
  18. CarpalT

    Excel 2003 sort doesn't take cell borders along with data

    Great - works like a champ! I learned three things today thanks to you, John [medal] and Ken[medal] . Have a great day! The world is full of good people.
  19. CarpalT

    Excel 2003 sort doesn't take cell borders along with data

    Thank you both for your attention to my problem. I can't make either one of these solutions work, but it's not your fault! I should have at least five columns that never have a blank, so started out hopefully. Although I can't find them, there must be a handful of blanks in every one of them...
  20. CarpalT

    Excel 2003 sort doesn't take cell borders along with data

    They just upgraded my pc to Office 2003. I periodically obtain a download from a mainframe that has a line of data, then a blank line, then a line of data, on and on for hundreds of records. I have always sorted this on one of the fields and that puts all the blanks in one area where I delete...

Part and Inventory Search

Back
Top