Recent content by Jcfx

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