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...

Your knowledge has been invaluable to me. Thank you and enjoy retirement! Di

I think I found what I need but it's not working. It keeps saying the result must be boolean, but I can't figure out why it is saying that. Here's what my formula is that is saying it must be boolean: NthSmallest (1,{@actualprice}, {fuelprices_.State/Prov} ) (Grouping is by route then by...

ok, I found that you need to have a summary field to show that. So now it is showing by Route (the group field) but it's showing all within the bottom 5 groups. I want to sort within each group. Group (by route) then detail shows state, pump price, actual price (formula field) I want to show...

That option is grayed out for me.... i tried clicking on the different fields, but nothing makes it available to me. Actual Price is a formula field, so I thought maybe that is the issue? Thanks, Di

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...

Thanks! I will take a look at those. Thanks so much! Di

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...

Thanks. I think I see my problem. In trying to learn this, and iis 7, I've repeatedly set up new servers somehow, each with a web configuration file. I have to figure out which ones work and which ones don't, I guess, and go from there. This is frustrating when you have to take months off and...

Thanks for your response. ok, i found several web.config files, and they are all different. I'm sorry, I'm not familiar with this file. Here's the one I changed to add that part: <configuration> <system.web> <customErrors mode="Off"/> <compilation debug="true"/> </system.web>...

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...

Nevermind, my field was Null. I never thought of that because it doesn't show up in the report. I now have the following working formula: if isnull({Dispatch2012.StopFee}) then {Dispatch2012.LineHaul} else {Dispatch2012.StopFee} + {Dispatch2012.LineHaul} I knew it had to be a simple...

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...

That worked beautifully. Thank you both for your help!!!! Have a great day! Di

lbass, you are correct. My database says "date" for type, but when I put my cursor over it in Crystal, it says string. Why does it do that? So I am guessing i will have to do something to convert it to a date, correct? Thanks! Di

Thanks Mike. That isn't working, it is highlighting {dailyvehicletracking.trackingdate} and saying that a date is required here, which doesn't make sense to me because it is a date... Thanks, Di

Hi Mike, thanks for your response. I tried to do that, but it's telling me I need a datetime field. Here are my two tables I am using and the fields/types: DailyVehicleTracking PK DailyVehicleTrackingID (int) VehicleNO (Varchar20) TrackingDate(date) Mileage (int) TimeStarted (Time(7))...

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)...