Recent content by jcfowl

All the programmers agreed to use a value of '12:00:00 AM' for sentinal values on DateTime columns for our database. The problem is that when we INSERT or UPDATE '12:00:00 AM' into the column it is stored as '1/1/1900'. Does anyone know a way to store '12:00:00 AM' in a DateTime column?

My SQL statement returns the correct number of records in the SQL Query Analyzer, but Crystal only returns one record. Crystal Record Selection Formula: {TblMaster_Schedule.DayOfWeek} = {?DayOfWeek} And ({TblSpotChanges.DateEffected} = DateValue("8/1/2004") Or...

I know how to join tables in different databases, but I can't seem to join tables that are on different databases and also on different servers. Is there anyway to do this? If anyone knows the syntax please let me know. Thanks.

to simplify this question let me rephrase it like this: I have 1 Group In the details of that group are 3 fields: location, sequence and Type In the crosstab: Row = location Column = Sequence Summarized field is the Max of Type The problem is I am not getting the correct data in the...

I have a location row and a Sequence column. I am summarizing the Items delivered to a location and in what sequence they are delivered. If I look at the report I get data like this in the details: I006 FEED I006 OTHER In the crosstab I get an entry like 1 2 I006 BOX BOX...

I am using a crosstab that has given me problems. I am wondering where the crosstab pulls data from, if you were to compare it to a report. I realize it is in the footer of the report, does that mean it uses subtotals of the information used in each group. I am getting weird results for some...

I appreciate all the responses but I got it to work. The Tables: TblMaster_Schedule -> TblMaster_Day TblMaster_Schedule -> TblSpotChanges The TblSpotChanges is a duplicate of the TblMaster_Day table. Both contain the fields fkMaster_Schedule linking a daily schedule to a master loction...

I messed up the dates. It's start then End date. Specifying "y" is the same as "d" which gives the number of days different between the two dates. DateDiff("yyyy", {Table.DOB}, CurentDate)

Use the datediff function and specify the interval as "yyyy". DateDiff("yyyy", CurrentDate(), {Table.DOB})

I'm sure it's possible. What does your database table relationships look like?

Couldn't you use 2 parameters: ProductType and PriceRange. Both would allow multiple values. ProductType would allow multiple discrete string values. PriceRange would accept multiple numeric range values. Each parameter returns an array of values that can be matched. The problem is the user must...

mulema, Are there a limited number of items that can be selected. In your example you gave 3 selection criteria, although each has 2 criteria within it(product type and price range). Is there a limited number of selections that you would like to provide, or is it unlimited?

lbass, Thanks for the response. What you posted is the exact setup I have right now but there is a further complication. The data summarized describes the Item Type being delivered to a customer. I need to output the Highest ranking item, which is ranked based on it's type. I made a Formula...

IF DateValue(StartDate) = DateValue(EndDate) THEN Time(EndDate) ELSE DateTime(EndDate) //same as EndDate

I have to create a report where there is information to be summarized from 1 of two tables: TblMaster_Schedule (1 to 1)-> TblMaster_Day TblMaster_Schedule (0 to n)-> TblSpot_Changes For the crosstab: The rows run off of The Location field in the TblMaster_schedule table and the columns run off...