Search results for query: *

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

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

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?

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

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

The below formula will not give me the "Gross Amounts" for the fourth line of logic. This formula works if I separate it out and it works in the exact layout in sql query but when I put it in report it seems to ignore the Transaction_History.Social_Code} = "059") part. Any...

I have two formulas from two different reports that I have to get together into one formula - I know it sounds easy, but after 3 days of turning them inside out - I have given up. My results are either it omits all of "075" or counts only "075" regardless of what the name...

Original question was correct: Its the running total not sub total that I am having problems with - Does anyone know why a running sub-total changes if I hide the details section? If I show the details, the total is correct but if I supress or hide, it changes. Any help appreciated

Does anyone know why a running sub-total changes if I hide the details section? If I show the details, the total is correct but if I supress or hide, it changes. Any help appreciated. Thx.

I have several stored procedures that create a temp table. We have recently had a situation where the database was hung up because of one of my procedures and I was told that there was a way around creating temp tables which may cause this hang up. Does anyone know what this is? Thanks for...

Why do I get "not enough arguments have been given to this function."? This formula is in Select Expert. Date({sp_WTD_MTD_YTD_AllProducts.Post_Date}) in Date(Year({?@EndDate}),Month({?@EndDate}),01) to {?@EndDate}

I have a report in crystal that takes over 15 minutes to run so i need to create a stored procedure. What takes up the time is I have week to date data and mtd data in the main report then year to date data in a sub report - The following are the formulas in Report Select Expert for each...

I have a report in crystal that takes over 15 minutes to run so i need to create a stored procedure. What takes up the time is I have week to date data in the main report then in two sub reports - one is month to date and the other year to date data. The following are the formulas in Report...

I have a report in crystal that takes over 15 minutes to run so i need to create a stored procedure. What takes up the time is I have week to date data in the main report then in two sub reports, I have month to date and year to date data. The following are the formulas in Report Select Expert...

I have the below formula in select expert to get last full quarter data automatically , however as the report is downloading, you can see that it is going through every single record (0 of 250000). As a result, when the report gets to the web site, the processing time is not acceptable. Any...

Am creating stored procedure and am getting error "incorrect syntex near "then" if (datepart(month,(CurrentDate))between 1.00 and 3.00 then datepart(month,(Transaction_History.Post_Date)) between 10.00 and 12.00 else... thanks.

I have the following formula in Report Select Expert to automatically capture quarterly results without a date prompt (excuse month format, that's how it is on the database for whatever reason) if month(CurrentDate) in [1.00 to 3.00] then month({Transaction_History.Post_Date}) in [10.00 to...

The second formula brings down what I want, but I need the formatting part that is in the first formula. No matter what I try I get "too many arguments..." or "summary field could not be created". Any ideas? Week Ending: " +...

Can anyone tell me what the correct syntax would be for the below formula. Am getting "string needed here" and the cursor goes to the begining of Maximum. Have tried all I know. "Week Ending: " + Maximum ({Transaction_History.Post_Date}, {Transaction_History.Post_Date}...

Does anyone know why the formula in Group1 header brings down Monday's date and the one in Group1 Footer brings down Friday's date. I would like them both to be Friday's. Formula in Group1 header "Week Starting: " + totext(date({Transaction_History.Post_Date})...