Search results for query: *

I've run across an interesting bug in Access and/or SQL Server. My set up: Access 2007 SQL Server 2008 Here is a way to see what I'm talking about. In Access create a pass through query. Use any legit DSN. For the source use Select 1 don't save yet though. open profiler and set it to look at...

I'm looking for a way to easily tell yesterdays date in a business week. I can get Tue through Friday easily enough but I can seem to get Mondays yesterday (Friday). Thanks in advance for any assistance.

Using CR8.5, DB2 v7 I am writing reports against a series of table where the dates are defined as DateTime. Here is a sample of the fields data: 2004-11-07-21.00.01.000000 I create a parameter and set it's data type to be date, range values. In the report record selection criteria I enter...

Using CR8.5 I have a sub report on the detail line. It calculates the sum of Other_Charges based on a Bill_Number (Link from main report to sub report) On the sub report I get the total via this formula: //Placed in Detail B WhilePrintingRecords; shared numberVar OtherChargesTotal :=...

Creating a report in CR 8.5 Data from tables looks like: Trip Miles Cost Other$ Fuel 1 150 57.5 2.5 0.0 1 150 57.5 0.0 23.5 2 130 69.0 13.5 0.0 2 130 69.0 4.5 0.0 2 130...

Using CR8.5 The sub report is on the detail line of my report. It calculates a Functional_Amount based a Detail_Line_ID. The sub report consists of a single group, Detail_Line_ID. In the group 1 header is a reset formula //{@reset} Group#1 Header whileprintingrecords; shared currencyvar...

Using CR8.5 I have a date field called Plan_Departure. I created a parameter called Dates as a date field, range values. When I try to create a record selection criteria linking the parameter to the field I get a "String required here." error. The criteria I'm adding is {TRIP.PLAN_DEPART} =...

I have created a parameter for my report named CutOffDate which has been set to a date field. I set a record selection criteria to be the tables date fields equal to the parameter. My data is in DB2. When I run the report I get no records. When I look at the sql statement used by Crystal...