Search results for query: *

Good morning! I can't seem to wrap my head around this, as I don't get to create crystal reports every day. Working in Crystal 2008 with a SQL Server database. Database Fields are RecID, FleetName, Truck, FullName, OccuredOn,Odometer,PositionLatitude, PositionLongitude, City, and State...

Good morning! I have a report I did for our fuel taxes that uses the insert-summary command to put the totals in (I didn't write the formulas). Somewhere within the first and second quarters, the grand total is off by 1998. If you add up the subtotals for each state for each quarter, the...

I have a report that shows fuel prices grouped by the route. It contains the diesel pump price, the state taxes, and the actual price (pump-tax). I have it grouped to pull the first 5 characters of each location (for example, I-80, or I-90, or I-95, etc). Then it is sorted from lowest to highest...

Good afternoon! I am looking to build a custom, interactive web page that users will be able to click options and add comments to create another page that combines all the results and makes it easy for users to look up "what's going on". For example, if an employee calls and speaks to one...

Hi! I have had experience with asp, but not much with asp.net. I have an iis 7 web site on a remote virtual server. When I develop a page on the remote virtual server (using remote desktop) and open it in the browser, it works. However, when I'm at any of our "regular" computers, when I open...

I have two columns - stop fee and linehaul. I have the formulas sorted by month then driver then truck. I want to add up the stop fee and linehaul for each level, so I used LHplsSF= dispatch2012.stopfee + dispatch2012.linehaul it only gives me an answer if there is data in BOTH fields. If...

Hi, I hope I can explain this in a way that makes sense... I'm trying to create a report that will list all work completed on our equipment over the last 10 days. This will include trucks and trailers. So far, I started trying to create a formula that would show the date range it is displaying...

I haven't used access much since the 2000 version, and I can't seem to get my search to work. So here is what I need to do. I have a form that includes the CustomerName, CustomerCity, and CustomerState fields (among others, but these are the three I would like to give the option to search)...

Good morning! I am using Crystal Reports 2008 and SQL Server 2008. I have two fields: MonthLoaded and DateLoaded. I'm trying to put these together along with the year to create a formatted date: 07/01/2011. I'm getting 7.00/1.00/2011. My formula is (truncate({Dispatch2011.MonthLoaded},0)) & "/"...

Hi! I have some experience with ASP pages, but am new to ASP.Net and visual studio 2008 and visual studio 2010 web. I have a database on a virtual server, which is also where my IIS is set up. I'm trying to create an internal web site that we can use to access our database. No matter what I...

I am baffled. I have a report (work completed) with two subreports (parts and hours). Using variables, I created several formulas to pull totals from each subreport and add them up in the main report. It works... with a little flaw. If there are not any parts and/or hours for the current job...

Does anyone know of a good book on Crystal formulas? I'm thinking that would be a valuable resource. Thanks, Di

Good morning! I have a report with two subreports in it. The first subreport is the parts used cost report and is in group footer #2a. The second subreport is the time worked by job report and is in group footer #2b. They are linked to the main report by JOB ID. I'd like to be able to...

Good morning! I'm not sure if this is the best place to post this or not, but I'm using Crystal Reports 2008 with Sql server 2008 express, so I thought I would start here. I have a database that is tracking fuel mpg, idle time, trip time, mileage, etc. This information is pulled from our...

Good morning! I have the following tables (with fields shown): DailyVehicleTracking DailyVehicleTrackingID VehcileNo TrackingDate Mileage TimeStarted TimeStopped Addlcomments PartsUsed Partsrecid dailyvehicletrackingid partno numpartsused partsnotes PartsList part_no manufacturer...

Good afternoon, I'm sure I am missing something obvious here, but I'm so frustrated with it I thought another pair of eyes might help. I am using Crystal 2008 and SQL Server 2008 express. I have this formula: DateDiff ("n",{DailyVehicleTracking.TimeStarted} ,{DailyVehicleTracking.TimeStopped}...

I have one table with the following fields: recordid truckno date workitemcompleted completedby mileage timestarted timestopped complaint_symptoms code addlcomments After I entered over 500 rows, I realized how I should actually have set this up. I want to have one table for the information...

Good morning, I am getting a run-time error '438' Object doesn't support this property or method when I click on my button. Here is my code: Private Sub searchname_Click() Me.Filter = "[customername] LIKE " & Me.searchname Me.FilterOn = True Me.Requery End Sub customername is the database...

Good morning! I am trying to use the following formula in Crystal 2008. (CurrentDate - {Employee.DOH}) /365.25 Employee.DOH is in the date format. It is telling me it needs a number at the employee.DOH field. no matter what I try to convert it to, it just tells me that it needs to be some...

I am pulling reports in Crystal 2008 from an Access 2007 database. I have a field that sums up three fields in the database. If one of those fields is empty, it doesn't display the total for the other fields, it leaves the sum field empty. Is there any way to resolve this? I figured out to use...