Search results for query: *

I have two reports (both have several subreports in them) that will not open up as long as the network connection is active. If I diable the network connection the report will open, then I can restore my network connection and everything works fine until I close the report. This happens on any...

I want a report the shows Part Numbers that have had activity in any one of three date fields that during a date range. I have the following. PartNum which is the partnumber.. Date1 which is a partnumber revison date.. Date2 which is the last date the partnumber sold.. Date3 which is the last...

I would like to add a filter to a trigger but I am not having any luck at getting it to work. Here is the filter. It uses the Table Absence and column CurrentYear. I don't know the correct SQL terms to use in the formula but what it does is provide a year based on todays date minus 3 months...

Can a SQL trigger do this? Hi, I'm new to the whole SQL thing and have been reading about triggers in my SQL books. Hopefully a trigger can do the following but I have no idea on how to properly write it. I have two tables Employee and TimeOff. (1 to many relation) They are related to each...

Using Crystal Reports 9 - SQL 2000 Database... I have several hundred "accounts" which contain a date, account# and amount. I have used the Select statement to break these accounts into groups as follows. //{@MakeAcct} Select {Account} Case "1001", "1005", "1006": "Supplies" Case...