Search results for query: *

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

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

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

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

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

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

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

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

I got it to work. Thanks everyone!

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.

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

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

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

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

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?

I am using the formula below to convert a unix time stamp into central standard time, and account for DST. However, when I use the formula in my select criteria, like @closed_date in lastfullmonth, it takes forever to run. Is there any way to speed this up? @closed_date local datetimevar...

Thanks Fisheromacse - that worked perfect!!

Fisheromacse, This is exactly what I asked for, however, I have been looking through my data, and I think I need to change it up. What I need to do, is just show the last name. So that would be anything after the first space, to the end, taken off. (there are some commas after the first name...

Hello, I need help with a string formula. What I have is a string that is a combo of First Name, Last Name Initial, a dash, and then the company name. What I need is the dash, to the end removed. Example of Data: Kraft, D - Other Fabrie J-Intel 3 Lindberg H-Unix-2-Tech Solutions Results...

Hi rheard, Thanks so much for the reply. I modified the code and hopefully the DLSStart and DLSEnd variables will be correct each year. I tested them and I think they are correct. Maybe you could take a look for me. Thanks again!! local datetimevar rec_date :=...