Search results for query: *

Thank you! Here is a star Julie SSRS & CR2011 / RS2008 Sql DB

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

As Stated earlier, Select Distinct is already checked. With the report sample provided, are there any other possible solutions? Thank you Julie CRXI CE10 / RS2005 Sql DB

bah, for the link please replace the '+' with spaces. shop productivity report.pdf. Thanks Julie CRXI CE10 / RS2005 Sql DB

I have already done this. I'll attach a sample so that you can see what I have already. I am concentrating on the detail level. On the left you see the workorder information as you can see I have multiple labor lines for one labor line on the invoice level. I MUST keep the part detail. I...

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

Thank you everyone for your replies, I apologize for not getting back earlier, had to replace someone else on an out of town trip. Entering the date parameter worked. Though it's awkward. I appreciate all of your assistance Julie CRXI CE10 / RS2005 Sql DB

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

Please disregard, I must have just been having a duh moment. I solved my problem by going into Chart expert, advanced, and changing the drop down from "on change of" to "For all Records". Bingo. Thanks Julie CRXI CE10 / RS2005 Sql DB

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

Thank you both, That hit me about two hours after I left work with a wonderful Homer Simpson type of DUH!! Julie CRXI CE10 / RS2005 Sql DB

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

Thank you Ryan, I will try this. Julie CRXI CE10 / RS2005 Sql DB

Here is a portion. I've dropped the year column for now. itemid PARTN AnlTrans AnnualQty AnnualCoGt AnnualSale 4 12345 1725 2391 $1,471.57 $2,184.56 5 14582 1685 2191 $487.59 $727.78 4369 145712 1430 6649 $642.21 $960.32 5318 100012 1287 1626 $2,715.65 $3,997.18 1487 78450 1176...

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

Thank you, That works Appreciate your assistance. Julie CRXI CE10 / RS2005 Sql DB

Apologies. [1]You haven't shown us whether you have returned the first and last dispatch date of the year in the view, or whether that needs to be calculated They need to be calculated. The view stores all dispatches by date completed. I was thinking I could use min and maxes by year? Then...

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

Try it like this: Replace All with * If {?division} = '*' then {a.division} Like '*' else {a.division} like {?division} Assuming your parameter value looks like below * DivisionA DivisionB DivisionC DivisionD Julie CRXI CE10 / RS2005 Sql DB