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:
|
85
|
311
|
884
|
|
Post:
|
251
|
916
|
2,625
|
|
|
Business Objects: Crystal Reports 1 Formulas Posting activity graph:
|
Top authors during last week:
user's latest post:
Peachtree sales report
Published (2008-11-21 18:06:00)
You shouldn't be selecting by the rowtype, since this isn't the only rowtype value you want in the report. Instead, go into the field explorer-> formula-> new and enter: if {JrnlRow.RowType} = 6 then {JrnlRow.JrnlRowType_Freight} //just a guess--this should be the field that holds the freight amount I'm not really familiar with PeachTree, so I can't really tell you for sure what value field should be used. -LB...
user's latest post:
Difference between two date and...
Published (2008-11-21 12:41:00)
Just convert your numbervars to text. Last line of formula should be totext(hour,0,"")&":"& totext(minutes,0,"") Ian
user's latest post:
record selection
Published (2008-11-21 14:45:00)
Other than upgrading to Professional or Developer is there any possible way I can use a dynamic parameter in my reports?
user's latest post:
Difference between two date and...
Published (2008-11-21 13:47:00)
My formula now reads: datetimevar Presc; datetimevar Pharm; numbervar timediff; numbervar hour; numbervar minutes; Presc:= dtstoDatetime(totext({PATDRUG.PRESC_DATE}, 'yyyy/MM/dd')&" "&{PATDRUG.PRESC_TIME}); Pharm:= dtstoDatetime(totext({PATDRUG.PHARMCHECKDATE}, 'yyyy/MM/dd')&" "&{PATDRUG.PHARMCHECKTIME}); minutes:= remainder(timediff, 60);...
user's latest post:
record selection
Published (2008-11-20 10:26:00)
I don't think you can do that in Crystal. Has anyone else got a suggestion? Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10
user's latest post:
Why my formula not working!?
Published (2008-11-20 07:57:00)
Now it's giving error upon runtime String is non-numeric under the QTY (Data type=Number) formula. CODE if {foccredsum.line_type}="F" then {foccredsum.qty} Else tonumber({@null}) Regards jehanzeb Jehanzeb Crystal Reports 2008 Visual Studio 2008 Informix Database
user's latest post:
How to count only the last calls...
Published (2008-11-21 04:14:00)
Ok I did not get to attach a sample so I put you the display of the data, in bold is what I am looking for, the rest is working fine # COMPL.CALLS %CALLS #PENDING CALLS #CUST_CALLED %CUST_CALLED Agent: RAFAEL Call type: PROSPECTION 261 100%...
user's latest post:
CRXI chart , count items if...
Published (2008-11-20 09:07:00)
I sorted it out, the Chart object has an absurd number of dialog boxes that overlap a lot in function. here is the answer for anyone who may come searching. Click on the Y axis, Bring up the Data(Y) axis settings dialog. check axis on both sides. The Chart options dialog Multi-Axis tab will now be active. I still can not work out why the number tab of the Group X axis options dialog is greyed out, or why when the X axis displays perfectly to...
user's latest post:
Week of the Year
Published (2008-11-21 12:12:00)
datepart("ww",{table.date}) ^^ Reposting LBass's solution offered in another post (Search helps!) All kudos goes to her. 'J CR8.5 / CRXI - Discovering the impossible
user's latest post:
Need help with multi-select field
Published (2008-11-18 12:51:00)
No luck. Still get the same error. Thanks so much for your help but it doesn't look like this will work for me. I'll start looking for another solution. Thanks again.
|
|
|
|
Latest active threads on Business Objects: Crystal Reports 1 Formulas::
No activity within last 3 months.
|
|
Hot threads for last week on Business Objects: Crystal Reports 1 Formulas::
Started 5 days, 4 hours ago (2008-11-18 08:30:00)
by gromboy
Hi, I have a sql server db which has a field in a table called DRUGDETS. In this field is the following: Drugname Drugstrength Unit of measure, Route, Vehicle Example CISPLATIN 50 mg, IV Infusion, Saline 0.9% I want to be able to report on the Drugname and route eg CISPLATIN IV INFUSION There might be different routes for each drug so what I'm trying to do is report on all the CISPLATIN IV ...
Started 1 week, 3 days ago (2008-11-13 12:49:00)
by jehanzebn
Dear all I have created a report with number of set date ranges, daily, last 5 days,last 4 weeks, year to date etc. The report is pulling everything correctly meaning the total number of jobs, lenses, sub total and grand total are coming correctly. However when I introduced the percentages, they don't come up correctly. What I am trying to do is to get the report setup with YTD date range and ...
Started 3 days, 16 hours ago (2008-11-19 20:44:00)
by cdulong
I have a seniority list I am working on, most of the time employees join the seniority list once they have reached 520 working hours. In rare occurances we extend a employees probation further and this causes them to stay off the seniority list until the have passed their probabtion. I have been able to remove the employees that have less than 520 hours by using the select expert, but my ...
Started 4 days, 22 hours ago (2008-11-18 14:35:00)
by cdulong
Its been a busy day for me.... I am trying to generate another seniority report, the first one I did was a full time report and used Table Linking to get the required information. This is currently how I had it set up. I have two tables were I get my information from, FULLTIME & PARTTIME, they both have a field for a name, I have figured out how to get the information I need for the full ...
Started 4 days, 5 hours ago (2008-11-19 07:27:00)
by johnwolf
Using CR8 with Oracle I am currently counting calls to customers in our call center, using a table which is as following CALLS_TBL CALL_ID AGENT_ID CUSTOMER_ID CALL_TYPE (PROSPECT, NEGOTIATE, SELL...) CALL_RESULT (UNAVALAIBLE, QUALIFIED, SALE,...) CALL_STATUS (COMPLETED, PENDING) CALL_DATE On a given period established with parameters and record selection formula. Groups are the following:...
Started 1 week, 2 days ago (2008-11-13 15:10:00)
by ltidquist
This post refers back to thread766-1436069: CR 9.0 - Need expansion on multi-select field . I'm using CR 9.0. I have a field that is multi-select and stores the codes separated by a comma. So, for example the field has the following: 301,302,303 There is a lookup table that stores the descriptions for those codes that I need to display in my report. I can successfully display the ...
Started 3 weeks, 2 days ago (2008-10-31 08:30:00)
by gromboy
Hi, I have an sql server db and want to calculate the difference between two time and dates, in hours. Field 1: {PHARMCHECKDATE} Datetime field (with no time entered) Field 2: {PHARMCHECKTIME} String field Field 3: {PRESC_DATE} Datetime field (with no time entered) Field 4: {PRESC_TIME) String field What I need to do is get the hours difference between - ({PRESC_DATE}{PRESC_TIME))-({...
Started 1 week, 4 days ago (2008-11-12 10:56:00)
by valgore
Hi, im writing a report and i want the report to only show date range for every 6 months or month or 12 months. can anyone help me? thanks JB
Started 2 days, 21 hours ago (2008-11-20 15:41:00)
by XavierMac
Hello, I saw this message in another thread but didn't view an answer. It pretty much describes what I'm going after. "How do you get the cost for an item sold in Crystal Reports v9? I have tried: if {jrnlrow.rowtype} = 1 then GetPeachRowAmountv2 but it only returns 0.00's for every item sold. I have a record selection: {jrnlrow.journal} = 3 3 = the sales journal columns on my report ...
Started 1 week, 2 days ago (2008-11-14 10:58:00)
by talibm
I am trying to create a flat file for an electronic data conversion to a new software system. I am using crystal x and our database is ms sql server 2005. Each field has a specific start position, length and data type. They must be in order e.g., {case no}, {lname}, {fname}, {dob}, etc. The file can be fixed with or asterisk delimited. I have created a file but I can't figure out how to ...
|
|
Size: 752 bytes
