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?

they're actually wire purchases (prices fluctuate often) from suppliers. so, i'll just substitute po_ID for your custID and that should do it. the last three purchases is exactly what we're looking for (for price a comparison). as always, LB your help is so appreciated. take care, //frank

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...

thx so much for your help //frank

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...

my fault, there was no error, it just didn't work.

thx, tried that w/ this error: the result of a formula cannot be an array

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...

i'm not sure i follow what you're saying. thank you for the help btw.

{INIH.SALREP} = {?rep} and {INIH.INVCDAT} in {?start} to {?end} and {INIH.ARTOT} <> 0.00 and ( not(isnull({INIH.OUTVAL})) or {INIH.OUTVAL} <> 0 ) this is the record selection.

sry, that code should read: {INIH.INVDAT} in [(Date(2007, 1, 1)) to {?end}]

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...

sry, that's cr10

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...

if i'm following, don't suppress just don't include them period. go Report/Selection Formula/Record & enter your code there. //frank

sry, cr10

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...

yeah, that was a bit vague, however your solution did the job. thank you.

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.

it's a number field and the "-" is a negative sign - you're right. //frank