Search results for query: *

CRXI ODBC Hello all. The Report Alerts option in crystal; is the meant only to work within crystal? I mean, I've tried to view a report in Crystal Reports Viewer XI that has such an alert and the alert doesn't popup. Anyone?

crxi hello, all. my data: product receive_date purchase_price i'm querying PO's for most recent purchase pricing. my thing is, it brings in data from as far back as 1995 (too much data, man). what i need is...say, the 3 most recent purchases. thanks in advance for any help offered...

cr10 hello, all - my record selection includes a start and an end date. is there a way to show totals outside of the date parameter? i.e., user selects april, 1, 2007 to april 30, 2007. i would like to see this and also a running total from jan 1, 2007 to april 30, 2007 (the end date of the...

cr10 hello, all - i have a monthly commissions report to run where the commission is based on cash and account sales. the account sales is where i'm having the issue. the customer (account) purchases $30,000.00 over the month and say the customer only pays $1,500.00 towards that by months...

cr10 hello all; if i use a date parameter to retrieve data between a start & end date, can i still use formula to keep a running total elsewhere in the footer with the user {?end} date but use a hard coded date for a fixed start date? (i.e., user enters april 1/07 to april 31/01: i want to...

hello all; i need help to create a running total w/ a formula to use the {?end} date of my parameter and an hardcoded start date of april 1 2007. i need to keep a running total as of that start date so i can do some math with it. i could be going about this the wrong way, but i believe it'll...

hello, all is it possible to have running totals outside of my date parameter: Monthly running total of payments (even though date parameter is between two given months: i.e., Feb 1 – Feb 29). Totals Paymnt Totals Paymnt Totals Paymnt Jan 1 – 31 Feb 1 – 29 Mar 1 – 31 0...

cr10 hello, all; i have a number field that occasionally has nothing in it. it just returns a blank - no zero - just blank. how can i suppress this occurance & not have it figure in the summary. as always, thank you.

cr10 hello, all. i have a field that returns the value w/ a "-" preceeding the numbers in the field (to indicate a payment has been applied). i'd like to strip this out. could someone please set me off in the right direction. as always, thank you.

access 2002 hello, all.. i need to do a running total. my invoice field can either startwith "C" (cash sale) or "0" (account). i need only the invoices that startwith "C". in crystal reports i create a formula like this in my running total: left({INIH.INVOICE},1) = "C" can i do something...

cr10 invoice invdate outvalue tax C410947 12/21/06 621.73 87.04 C410949 12/23/06 66.60 9.33 C410960 12/29/06 -16.75 -2.35 X016120 12/08/07 -89.50 -12.53 my issue: invoices w/ outvalues that begin w/ "-" and startwith "X" need to remain, but invoices w/...

cr10 how does one go about suppressing an entire row if say one of the fields is blank or begins w/ a '-' (-303.00, etc.) thanks as always.

i use a running totals (so far anyway...still quite noobish) to summarize invoices based on the type (i.e., invoices that startwith "C" are cash & invoices that startwith "0" are accounts. i do this because cash invoice commissions are 1.00% & accounts are .50%.then of course i add the totals...

i'm trying to create a commissions report. there are two types of invoice in the sales tbl: one begins w/ a 'C' (for cash sales) & the other w/ a "0" (account sales). the commission amount is different depending on the sales type (i.e., C or 0). i need two seperate totals in my footer. am i on...