Search results for query: *

I have a database that, for every single date within, breaks out century, year, month and day. So, in the century field in, say, the orders table, today would be 20, the year would be 11, the month would be 1 and the day would be 21. Thus, whenever I have to report on date ranges, I first have...

I have a field that shows the date as such: 20100901 I have written this formula to build the date: date(tonumber(left(totext({date}),4)),tonumber(mid(totext({date}),5,2)),tonumber(right(totext({date}),2))) I use the formula in the select expert to pull @Date in LastFullMonth. When I run...

Is something like this possible? Basically, every formula either returns a 1 or a 0, but it only reads down to "Cable/Internet" and then everything else comes as a blank value. SELECT {@CABLE} CASE 1 : SELECT {@INTERNET} CASE 1 : SELECT {@PHONE} CASE 1: "THREE PLAY"...

I have a table where the "Address" field can be typed in either uppercase or lowercase or a mixture of the two. Thus, we mail information to people at for instance: 3021 TaylOR DRive I thought I could write a formula called UAddress: uppercase(Address) And then another formula called Match...

I have this formula. It's pretty straight forward, but Crystal is telling me that I need a closed parenthesis and is highlighting the word "else" in line nine. I know one doesn't need to go there. I'm thinking I have a syntax error. If you need any more info about the fields, let me know...

I have a table with four different columns that would figure date. They are all numerical... Century (20) Year (9) Month (1) Day (19) I use the following date formula NumberVar input := (1000000*{Century})+(10000*{Year})+(100*{Month})+({Day}); If input < 19720101 then Date (1972, 01, 01)...

I have a table with five different columns that would figure date and time. They are all numerical... Century (20) Year (8) Month (6) Day (3) Time (1350) I need to write a formula to get them all into one date/time field. What is in the parenthesis is just an example of what one field in...

This is likely pretty simple, but I am a SQL newbie. I've been working around it for quite some time, but if I want things to be automatic, I need to figure little things like this out... If I type this: SELECT CAST((CENTURY*1000000+YEAR*10000+MONTH*100+DAY) AS VARCHAR(8)) AS DATE, ACCOUNT...

If there is a date in the database I'm using, it is broken into four columns for Century, Year, Month and Day. I have been able to write a formula to put this into a date format in Crystal, but I need to write a SELECT statement in SQL to turn the four columns into a readable and usable date...

I have a table that includes these four columns: Account # Service Code Start Date End Date I have been able to see how many accounts have a certain service obviously quite easily by simply using the select expert and saying start date < x <= end date. Is there any way to group a report for...

I have two databases. One keeps the account number as a numerical field (1234567). The other keeps it as text, with a leading zero (01234567). Is there any way to link these two together?

Is there an easy way to do a select expert for the next full month as opposed to next30days. I have a report that has to be run late in the month for the next month, and it cannot be run on the same day every month.

I have a bunch of daily reports that I run using monthtodate. The problem I have is that currently, I have to copy all these reports and change monthtodate to lastfullmonth to run them on the first, so I get the information for the previous month. Is there some type of selection formula that...

I have a list of six scores. Let's call them: Score 1 Score 2 Score 3 Score 4 Score 5 Score 6 Each score can be given a value of 0 to 6. What I want to do is have another number (named MRC) multiply by a certain amount depending on the six scores. For instance: If all the scores equal six...

I have a report with the following fields: event.eventdate event.duedate event.modifydate Basically, the person is given an assignment on the event date, and they have seven days to modify the event. Due date is basically eventdate + 7. The problem I am having is just in the record...

I wrote a report a long time ago using a distinct count of work orders. In the details section I wrote the formula: if {orders.servicecode} = "BAS" then {orders.workordnumber} else 0 I then wrote a formula in the group field for the distinct count of work order numbers minus one to get the...

I have a database where there is a modify date within it. Unfortunately, the database took a crap on itself for about a week and there are a number of accounts without this modify date. It just shows as blank. I want to count all these dates as "Done" if possible within this formula: if...

I have a field named {VODTRN.VTTDAT} that gives the numberical date (ex: 20060101) for the date. I have converted that date to 1/1/2006 by using this formula: //true date WhilePrintingRecords; NumberVar input := {VODTRN.VTTDAT}; If input < 20000101 then Date (2000, 01, 01) else Date ( Val...

I have a database that has start dates but no end dates. I am trying to figure out what pieces of inventory were in a certain status on a certain date. The DB looks like this: Inv # Status Start Date 123 AS 20060101 123 CAN 20060201 123 AS 20060301 If there were end...

When I do this... http://www.sunflower.com/~chrisg/question.bmp I get this... http://www.sunflower.com/~chrisg/question2.bmp As you see, it adds another line for account for every service the account has. What I can't figure out how to do is to get a list of accounts that have one...