|
More site info...
Business Objects: Crystal Reports 1 Formulas | Forum profile
|
|
Forum profile page for Business Objects: Crystal Reports 1 Formulas on http://www.tek-tips.com.
This report page is the aggregated overview from a single forum: Business Objects: Crystal Reports 1 Formulas, located on the Message Board at http://www.tek-tips.com.
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "Business Objects: Crystal Reports 1 Formulas" on the Message Board at http://www.tek-tips.com is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on Business Objects: Crystal Reports 1 Formulas:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
68
|
251
|
680
|
|
Post:
|
199
|
702
|
1,952
|
|
|
Business Objects: Crystal Reports 1 Formulas Posting activity graph:
|
Top authors during last week:
user's latest post:
Sum Problem
Published (2009-12-04 16:22:00)
Insert a running total that sums the calls, evaluates on change of field: {table.datetime}, resets never if at the report level, or on change of group, if at the group level.Be sure to place the results in the group or report footer section. -LB
user's latest post:
Search for text in two different...
Published (2009-11-30 18:04:00)
Glad it worked! _____________________________________ Crystal Reports XI Developer Version Intersystems Cache 5.X ODBC connection
user's latest post:
Suppressing group based on record
Published (2009-11-27 12:02:00)
Thanks LB, that did the trick. I wasn't sure of how to use sql expressions and now I understand it.
user's latest post:
Convert String Elements to Date
Published (2009-12-03 12:44:00)
Have you listed ALL your Call_No values? I'd particularly want to see a DISTINCT list of the first 2 characters... CODE Select DISTINCT {fn substring("CSMAST_VIEW"."Call_No",1,2)} From .... What are these values? Skip, Just traded in my old subtlety... for a NUANCE!
user's latest post:
Search for text in two different...
Published (2009-11-30 18:03:00)
CoSpringGuy, That was it, how dumb am I! Works great and quick and dirty data analysis makes the data clean!!!!! Thank you!
user's latest post:
Calculating Days, Hours,...
Published (2009-11-27 16:26:00)
LB- thanks, it works perfectly. They just told me about the business hour change this morning. thanks again for your help! CLK
user's latest post:
Convert String Elements to Date
Published (2009-12-03 17:13:00)
LB / Skip - I found one record that has a null field in "Call_No". This is in 2005 and these records go back to 2002. This is the exact SQL expression I am attempting. Note that there are no other SQL expressions in this report. to_date('20'||{fn...
user's latest post:
Need to split string so user can...
Published (2009-12-04 09:51:00)
That did it lbass! You've made my day!!!!!!!! Thank you so much!
user's latest post:
Reverse Calculation
Published (2009-11-27 04:44:00)
Thanks as always LB. if {table.value} = maximum({table.value},{table.group}) then {@yourexpectedvalue} - (sum({table.value},{table.group})-{table.value}) else {table.value} worked perfect. ----------------------------------------------------------- I used somehow same but different logic earlier and am just glad your suggestion though shorter and neater is close enough to what i used. What i did was create 3 formulae where: Formula name: Val1...
user's latest post:
Sum Problem
Published (2009-12-04 16:09:00)
Good Afternoon: I am running into a duplicate row appearing. I need to sum the values of that record without including the duplicate items. I can't use "suppress if duplicated" for the fields (choosing that option for just 1 field doesn't work) because that will suppress other, legitimate records, such as the "5" values below, but when I do a sum, I don't want the 2nd...
|
|
|
|
Latest active threads on Business Objects: Crystal Reports 1 Formulas::
Started 1 day, 14 hours ago (2009-12-05 00:19:00)
by Turkbear
Hi, when you displayed the @birthday formula to see what actually displays, were any birthdays incorrect ( like more days than in a month?)? Also, it looks like some extra parens are in there try: CODE date ( val({corebrthyr}) ,val({corebrthmn}), val(corebrthdy}) ) Also be sure the year is 4 digits. Did you try, for the boolean, CODE If @month = Month(@birthday) then True Else False...
Started 1 day, 22 hours ago (2009-12-04 16:22:00)
by lbass
Insert a running total that sums the calls, evaluates on change of field: {table.datetime}, resets never if at the report level, or on change of group, if at the group level.Be sure to place the results in the group or report footer section. -LB
Started 2 days, 20 hours ago (2009-12-03 18:05:00)
by lbass
Create a formula like the following: numbervar cnt; numbervar j := 10; stringvar x := ""; for cnt := 1 to j do( if {table.date} > = currentdate then x := x + totext(dateadd("m",cnt*6,{table.date}),"MM/dd/yyyy ")+ chr(13) ); x Format the formula to "can grow". This, however, places all dates in one field--not sure this is what you are looking for. -LB
Started 3 days, 21 hours ago (2009-12-02 17:04:00)
by lbass
Why not just test the presence of the number in the string if a parameter will be used to limit to one interest, instead of trying to create separate records for each interest? -LB
Started 3 days ago (2009-12-03 14:12:00)
by fisheromacse
i think this should work.... create a SQL expression to determine the day of the week like this: {%dow} = {fn DAYOFWEEK("TABLENAME"."FIELDNAME")} Then in the select statement use the above expression to have it choose any day of week that is not Saturday or Sunday (1 is Sunday and 7 is Saturday). Also in the select statement, use your date field and select 'in the period' then use the option "...
|
|
Hot threads for last week on Business Objects: Crystal Reports 1 Formulas::
Started 6 days, 1 hour ago (2009-11-30 12:53:00)
by CoSpringsGuy
IF {EDMS_ARC.F3} IN ["Ambulance","EMS","Rural","Grady","AMR"] then 1 else IF {EDMS_ARC.F4} IN ["Ambulance","EMS","Rural","Grady","AMR"] then 1 else 0 _____________________________________ Crystal Reports XI Developer Version Intersystems Cache 5.X ODBC connection
Started 5 days, 1 hour ago (2009-12-01 12:30:00)
by lbass
Try the following: stringvar x := {table.string}; dateadd("d",val(mid(x,3,3)),date(2000+val(left(x,2 )),1,1))-1; Not sure why you want to eliminate the parameter. I would think you would want to set up a date parameter, and then use a record selection formula like: {@aboveformula} = {?date} -LB
Started 3 days, 21 hours ago (2009-12-02 17:04:00)
by lbass
Why not just test the presence of the number in the string if a parameter will be used to limit to one interest, instead of trying to create separate records for each interest? -LB
Started 1 week, 1 day ago (2009-11-27 14:28:00)
by CoSpringsGuy
numberVar avedelay; numberVar hrs; numberVar min; numberVar ss; Stringvar hhmmss; if {iApplicationStat.CallsAbandoned} > 0 then avedelay := ({iApplicationStat.CallsAbandonedDelay}/{iApplicat ionStat.CallsAbandoned}); hrs:= Truncate(Truncate(Truncate(avedelay/60)/60)); min := Remainder(Truncate(avedelay/60),60); ss := Remainder(avedelay, 3600); If {iApplicationStat.Application} = "Cust_Svc" ...
Started 1 month ago (2009-11-03 14:48:00)
by CoSpringsGuy
try modifying your code to this Numbervar T := ToNumber({IRSCLAIM.MISC4_DESC}); T := if isnull({IRSCLAIM.MISC4_DESC}) then 0 else T; T := if T =2400 then 0 else T; stringvar n := totext(T,'0000'); numbervar Hs := ToNumber(left(n,2)); numbervar Ms := toNumber(right(n,2)); time(hs,ms,0) _____________________________________ Crystal Reports XI Developer Version Intersystems Cache 5....
Started 6 days, 1 hour ago (2009-11-30 12:37:00)
by lbass
Create a formula like this: if minute({table.datetime}) < 15 then "00 to 14" else if minute({table.datetime}) < 30 then "15 to 29" else if minute({table.datetime}) < 45 then "30 to 44" else "45 to 59" Insert a group first on {table.datetime} on change of date and then a second time on change of hour. Then insert a group on the above formula. Then you can insert a summary on your amount field ...
Started 4 days, 2 hours ago (2009-12-02 11:34:00)
by SkipVought
hi, how are the two tables logically related? Skip, Just traded in my old subtlety... for a NUANCE!
Started 3 days, 21 hours ago (2009-12-02 17:01:00)
by lbass
No, they are not attached. Why not just show some mock data that reflects the current layout? Please show the content of your accumulation formula and explain in what report section you are displaying the results. Then show how you want it to display. -LB
Started 3 days ago (2009-12-03 14:12:00)
by fisheromacse
i think this should work.... create a SQL expression to determine the day of the week like this: {%dow} = {fn DAYOFWEEK("TABLENAME"."FIELDNAME")} Then in the select statement use the above expression to have it choose any day of week that is not Saturday or Sunday (1 is Sunday and 7 is Saturday). Also in the select statement, use your date field and select 'in the period' then use the option "...
Started 5 days, 20 hours ago (2009-11-30 17:34:00)
by lbass
Have you tried inserting a crosstab that uses ID as the row, key as the column and maximum of comment as the column field? -LB
|
|
Size: 904 bytes
