Search results for query: *

Okay - the formula works but the parameter is showing the time as well as the date- my users only want to see the date. This is running off of a stored procedure - should I be doing some sort of conversion in there to go from datetime to date or can I do this in the formula?

Am now getting "a datetime is needed here" (cursor is after the -1,. The field is a datetime field but the "MM/dd/yy" just gave me the date which is what I need. totext(dateadd("m",-1,{?StartDate}),"MM/dd/yy") + " - " +...

Unfortunately am using Crystal 7.1 and dateadd does not work - any alternative? Tried doing: totext(Date("m",-1,{?StartDate}),"MM/dd/yy") + " - " + totext(date("m",-1,{?EndDate}),"MM/dd/yy") but I get message of need number here

Am trying to put in a formula the prior months date. In other words the user puts in the date parameters then in the report are the totals for that date parameter and the previous month's totals but I can't get the formula right to say what the previous month is. Here is the formula for the...

Can't thank you enough - don't think I ever would have gotten this on my own

Again I hope this is what you mean - my selection formula {Transaction_History.Trade_Class} = "R" and (({Transaction_History.Fund} in "0100" to "0399") or {Transaction_History.Fund} = '0744') and not ({Transaction_History.Dealer_Number} in ["00418&quot...

Here is the original formula for the previous month if {Transaction_History.Post_Date} in LastFullMonth and ({Transaction_History.Dealer_Number} = "40158" and {Rep_Profile.Territory} = "00" and {Transaction_History.Trade_Type}='R') or {Transaction_History.Dealer_Number}...

The current formula works but the previous is still combining both months - any ideas?

I should have told you that I am in Cr7 - in any case I fooled around with what you gave me and got it to work on: {Transaction_History.Post_Date} in Date(Year({?StartDate}),Month({?StartDate}-1),Day({?StartDate})) to {?EndDate} - so when the user puts in start date:8/1/03 and enddate 8/31/03...

My report has two parameters - a startdate and an enddate. Besides getting the data for the date range the user puts in (ie, 7/1/03 to 7/31/03), I also need prior months data for another column. I have done this in a sp but cannot figure out how to do it in Select Expert. Here is the...

Thanks - that didn't quite work out for me as "While" and "Do" are not available to me. i am using Crystal 7.1. I tried using If and Then but got 0 for total. But then realized that SumOnlyTop2 gave me "other" total so I created another formula taking the...

I have the part you show above but now - and for this lets use top 2 as an example If I want to grand total only those 2 not "other" - I turned off the "other" option in Group Sort Export but it still adds 748,755 + 710,401 + 2,624,507. I don't want the 2,624,507. Thanks...

I am doing a top 1000 producers report - but my grand total is totaling everything, not just the 1000 - how can I get this to work?

yes

Please ignore - not possible - don't know what I was thinking

I have two groups, and within one of the groups I have 12 months of subtotals (12 columns if you will). How can I sort all of these columns in descending order? Everything I tried (Report Top N Sort, Report sort records)only sorts the first subtotaled field(column) correctly. As usual, any...

never mind - I got it

I have a very inefficient select expert formula - it takes way too long. This was the original query: (({Transaction_History.Social_Code} = "047") or ({Transaction_History.Social_Code} = "075" and {CONTACT.C_ADR_1} = "Fidelity Investment Advisor Group"))...

no it still does not show for 059's

This one does not give me the 059's - at least I know it wasn't me! I still don't know why they don't work - they sound and look so right!!