Sorry, I'm using SQL Server 2000 (though I hope to be on 2005 sometime next year).
--
"I'm not talking to myself, I'm just the only one who's listening." - JCS
I'm working on cleaning up some of the data our company has in its databases, and I need to quantify how similar two text fields are.
e.g. Database1 has a table with employee information, one of the columns has name stored as "Susan Smith"
Database2 has a table with employee information, one of...
I understand they're not the same thing. I'm sorry for even posting an option that may have not been thought of. It was explicitly stated as a month, and even showed the output for comparison.
Yes, the parens affect it...
I was just giving options, and hadn't realized you already posted {?StartDate}+30 for the 30 days ahead.
There was a small error with parenthesis. If you want to do it they way you mentioned do the following:
dateserial(year({?Start_date}),month({?Start_date}),day({?Start_date})+30)
Unfortunately, that would be attempting to do the following in your example:
Cdate(2007,5,52)
When that happens, it loops back to the 1st again, so the output of that would be 5/21/2007.
If you want to add 30 days and the parameter is a date, simply do the following:
{?StartDate}+30
output...
If you don't want to show other years, use the select expert to select just the years in the parameter. If you want to show multiple years, group it by the year, and put the formulas in that group instead. This way it will show:
AcmeCo
2006 - 500
2007 - 600
GenCo
2006- 200
and so forth...
I'm guessing you want to add the hours if the client has 2 records.
If it's grouped by client name then replace the formula as follows:
If {tbl_BgtYrHrs.budget_yr} = Year(CurrentDate) Then "Grand Total (" & CStr(sum({tbl_BgtYrHrs.total_hrs },{tbl_BgtYrHrs.client_name}),0) &"): "
--
"I'm not...
In the group header of the store place a formula that resets the shared variable to '0'.
Just my opinion, but wouldn't a comparison of the monday of the 34th week this year compared to the monday of the 34th week last year be a better comparison? Not trying to complicate the report.
This...
Thanks for the response Ken. I've found your website very handy on many occasions.
I already have a group on the appendage:
Group1: Kingdom (animal/plant)
Group2: Type (dog/cat/human)
Group3: Appendage (Leg/Arm)
then for example dog leg chart does this:
average({# of}, {type}) -
outputs 2...
You say you imported the excel file originally. Did you import it into a SQL database, or did you actually use crystal reports to pull data from the excel file? If SQL, just import the new data into SQL, if not, add the rows to the current excel file. Then simply refresh the Crystal Report.
We would need to know what the variable is used for.
If the variable is counting something for example, use:
Max(variablename)
in a formula, and use the formula in the graph.
With the way the database is normalized, this is how the data is returned to Crystal.
Kingdom|Type|Appendage|# of|
Animal|Dog|Leg|4
Animal|Dog|Arm|0
Animal|Cat|Leg|4
Animal|Cat|Arm|0
Animal|Human|Leg|2
Animal|Human|Arm|2
Animal|Caterpillar|Leg|100
Animal|Caterpillar|Arm|0
Plant|Carrot|Leg|0...
There is an minuscule performance hit taken on the second one you display since it has to process more conditions. The condition itself returns True or False, so there's no point in telling it to return True or False. In the end, the Select formula is *usually* only processed once, and the...
Create a 3 running totals that do a count on the field. Under 'Evaluate' select 'Use a formula', and put in {field} = "value1" in the x-2 for the formula.
I have only seen Crystal Reports implemented with asp classic, and asp.NET. Though I would be interested if anybody could shed some light on this subject.
Thanks Turkbear, I hadn't seen that before, but after testing, it doesn't work the way intended.
For example:
stringvar strvar1 := "bike,cab,bus";
stringvar strvar2 := "ike";
strvar2 in "[" + strvar1 + "]";
Returns True when it should return False since ike is not one of the elements, but the...
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.