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
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...
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...
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.