Search results for query: *

I have a database I use for reporting demonstration purposes. It currently has one full complete year of data (2011) and two partial years of data (2010 and 2009) I would like to change the dates, based on a particular field called modified which is in the following format 2011-12-04 15:00:00...

Hello, Using crystal 11 on a sql db. I have to compare workorder to invoice details side by side by line type. ie Parts, Labor, Fees, Discounts. This information is stored in the same table defined by ordertype, so I had to alias table. Order_Invoice linked to Order_Work on...

Greetings, Using Crystal Report 11, SQL 2005 database. This older thread here: http://www.tek-tips.com/viewthread.cfm?qid=1545432&page=1 Has exactly what I needed, and it works.. almost. If I comment out the 'Specified Range' the period ranges perform perfectly. If I don't comment out the...

I have to duplicate and excel spreadsheet. I had to create a manual cross tab. The columns (categories) are created by if then else formula similar to the following: If left(v.catcod,3) = "002" then v.price else 0 There are five separate columns with five separate formulas. The report is...

I am working on an inventory usage forecast that I have to port from a spreadsheet to Crystal and have stuck on the final calculation. This calculation will be used to identify which 'forecast' is the correct one to use for a particular part. I am trying to calculate the minimum of a series of...

Greetings, Can someone pinpoint where I may have gone wrong with my code here? CurMonth results are correct, but the rest are coming up as zero. Sample Data: 50012 12-01-08 100 50012 12-02-08 36 50012 11-28-08 52 50012 10-01-08 46 50012 10-15-08 12 output desired: 50012 136 52...

Good afternoon, I have been instructed by the powers that be to create either a stored procedure or view that will create ranks for our inventory that can be used at a later date for reporting purposes. This is what I have so far, the data is pulled from three existing views that contain sales...

I need to come up with a formula that calculates cost by day. Currently I have the following details pulled from a view. Report is grouped by Unit. Detail YearCharged Labor Parts Cost4Yr CostPrDay 2006 162.50 16.550 179.00 2007 880.75...

Hello using GP 10, We have several allocation accounts that we would like to change. Currently these accounts allocate by percentage to 5 distribution accounts. Like this: Allocation account 5001-75 -Supplies Distribution account 5001-05 10% Distribution account 5001-10 10% Distribution...

Hello, we are using Crystal Reports 11 release 2, SQL server 2005. Over the weekend my IT department decided to move our accounting database from one server to another, as such all of our Crystal Enteprise reports failed. I've been remapping all of the original reports and the republishing...

I am converting some crystal reports over to reporting services and have to have some of the formulas results done on the sql side. what would be my syntax for the following conditional statement? //@Location if {stops.stp_event} = "LLD" and {stops.stp_status} = "OPN" then "On Way" Else if...

CR 11 on a sql database. This report is a logistics report that is supposed to replace a spreadsheet. The idea behind the report is to track a load from the point it is dispatched until the load is dropped off in the customers drop lot. The unit moves through three 'groupings' the first being...

I have a Report SErvices report that is giving me fits. The main reason is duplicate data that occurs for certain records. Someone suggested I use Row_number() in the following manner for the fields that like to duplicate. Select vo.ord_bookedby AS BookedBy ,vo.ord_startdate ,vo.Office...

I have a crystal report that I am moving to reporting services that flags deliveries that are running late. In crystal I used formula to convert seconds to the format I need, in the new report they would rather I used minutes as my base, either way I am a bit lost as doing date formula...

Using CR XI against a SQL Database. This is a summarize grouping question, one that folks dealing with Merchants and Credit Card purchases may have already addressed. Basically I have an expense report where I need to show the top 10 merchants, but… they want the merchants ‘rolled up’ into...

Hello, I am new to sql and have inherited a project that has my grey hair turning silver exponentially. You've all been of great assistance before, I hope you will be able to help me now as well. The following code is part of a stored procedure that is used on a GL account report. For each...

We are a Tractor Trailer maintenance facility and Dealership for heavy duty equipment. We have three shops and apx 12000 parts in inventory, we have over 200 service invoices a day as well as apx 75 or so 'over the counter' parts sales. We do all our invoicing, warranty, purchasing and...

I used this thread as a starting point for my where clause: thread183-1185537 <by the way this is an awesome group for examples> Here is my current code. This is for a report run from sql reporting services web server. @BeginDate datetime ,@EndDate DateTime ,@Vendor varchar (15)= NULL...

I've been assigned the task of creating a dynamic report that will allow the user to delve into Payables down to the GL level. Basically the accounting department is fed up with haveing to follow hot links in the inquirey windows to figure out where a gl amount has originated from. We are...

I have a query that checks a set of data to see if I need to start charging detention on a delivery. I need to turn it into an 'email alert'. It works when the dataset returned is only one late delivery, but if there are multiple deliveries the part that builds the email fails. What would be...