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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by goduke

  1. goduke

    Formatting Group

    Thanks lbass - that worked perfect. I was close but not close enough.
  2. goduke

    Formatting Group

    Usually when I design a report I like to alternate the color of the rows so that it is easier to read. If my data is in the details I use: if remainder(recordnumber,2) <> 0 then color(235,235,235) else white If my data is in the group footer, I use: if remainder(groupnumber,2) <> 0 then...
  3. goduke

    Returning Too Many Records

    Here is my record selection formula: {users.status} = 1 and {region.regionid} <> 2 and {points.payable} = 1 and {points.awarddate} in {?Date_Range} Here is a screenshot of how my tables look. http://img685.imageshack.us/img685/263/tablesm.jpg http://img685.imageshack.us/img685/263/tablesm.jpg
  4. goduke

    Returning Too Many Records

    My apologies on my typo for my SQL statement. I have it correct in the report, just typed it wrong. The last left join should be LEFT JOIN region on location.regionid = region.regionid. SELECT users.uid, users.name, points.award_date, points.points, points.type, points.payable, location.desc...
  5. goduke

    Returning Too Many Records

    I hope I didnt confuse you. I am using the actual tables and linking them through crystal - I just put the SQL Query to show how my tables are linked. That said, yes, I do have something in the selection criteria. I have: user.status = 1 AND points.payable = 1 AND region.regionid <> 2 AND...
  6. goduke

    Returning Too Many Records

    I have a report that is very simple but when it runs, it seems to be filtering through more records than what it should. I have 4 tables, a users table, a points_history table, a location table, and a region table. They are linked as follows: SELECT users.uid, users.name, points.award_date...
  7. goduke

    Parameter with Null Values

    WOW - that worked perfect! Thanks so much for the help briangriffin!
  8. goduke

    Parameter with Null Values

    Guys, I will do my best to explain my problem. I am using Crystal 11.5 and MS SQL Database. I have a report that I am wanting to use three different parameters to filter the data. I have all three set up correctly, but I have one issue with one parameter for a field called Tenant. What I want...
  9. goduke

    Need Help Wild Card In String

    I got it to work. Thanks everyone!
  10. goduke

    Need Help Wild Card In String

    LB - thanks for the quick response. However, since the data is stored like: Mears, Clint **VIP** then your forumula returns: Mears, Clint VIP. So I wont be able to do it that way.
  11. goduke

    Need Help Wild Card In String

    Guys, I have a report that is looking for a specific string pattern and I am trying to filter to pull in only records that meet that pattern. The problem is, the data is stored using the asterisk, which is also the wildcard character for Crystal Reports. For example. They are storing VIP...
  12. goduke

    Why Is This Running So Slow

    Hi IanWaterman, Your help was very useful. I think since the data in my report is converted using DST, then I wont get a match, or I will be excluding particular records. I will see if I can use a command and SQL to get what I need. Thanks again for your help. Clint
  13. goduke

    Why Is This Running So Slow

    I think what you gave me is working the way you inteded it to work, however, its still not exactly what I needed. I get results, however, I am using my converted date to display the closed date in the report, and I am getting all records between 2/28 and 3/30 instead of 3/1 and 3/31. That date...
  14. goduke

    Why Is This Running So Slow

    Hi IanWaterman, Unfortunately that did not return any records. I even took the rest of my criteria out, and just put in your date range, and still didnt get any records. FYI - I dropped datediff("s",minimum (lastfullmonth),date(1970,1,1)) into the report and it returned -1,267,401,600.00. Is...
  15. goduke

    Why Is This Running So Slow

    I apologize for not specifying - I am using a SQL database. All my date/times are stored in Unix. I only have access to the tables directly, so if I cant get someone to create a view for me, then how would I use one of those date/times in my select criteria?
See more

Part and Inventory Search

Back
Top