Search results for query: *

Okay - let me start over. What I would like to do is to "redefine" what a month period is, so that for instance, if I input a parameter month of January, then it would know that the January parameter value means the month range from the 14th BUSINESS DAY of January through the 13th...

But will this give me BUSINESS DAYS? or just CALENDAR DAYS?

I have to create a report in which the time periods will be outlined like the following: Monthly - See example below: Jan 14th business day through Feb 13th business day (run on Feb 14th business day for this time period) So, in a nutshell the report will run monthly on the 14th business...

Can you illustrate that a bit? I'm trying a few things but I'm not sure that I am following you or maybe you don't understand what I need. The ranking I am doing is at the group 5 level by Production Center, however, the ranking has to be overall. Meaning 1 and 2 could be in separate regions...

I have a report in which I need to give a 1,2,3....etc ranking based on a percentage of a total. My report looks similar to this: Florida Ranking State is Group1 Northwest 65% 4 Region is Group2 Southeast 72% 2 Northeast 43%...

I have a production report showing totals for previous months and detail for current month. Jan 2002 Feb 2002 Mar 2002 Apr 2002 May 2002 Jun 2002 Jul 2002 (last day is on a Wednesday) 08/01/02 (Thursday) 08/02/02 (Friday) 08/03/02 (Saturday) 08/04/02 (Sunday) My problem is reporting the last...

I have a report of which I am using one stored procedure. I had placed fields in my detail section and did summaries in the footers suppressing the detail. When I refreshed the report the grand total was there but the summaries were not. The strange thing is, that if I deleted the field...

How would I display all dates of the month regardless of whether any records were extracted? Example: Stat_Dt # Records 06/01/2002 1 06/02/2002 06/02/2002 5 06/03/2002 3 06/04/2002 06/05/2002 8 Even though 06/02/2002 and 06/04/2002 had no...

I have created a formula to select specific loans @SelectBRMo If Status.Date in LastFullMonth and Refer.Src.Code in ['BUILDER','REALTOR'] then Ln.Number Then created a formula to count those loans @CntLnNoBR DistincCount({@SelectBRMo},{Prod.Ctr.Name}) I have a group for prod.ctr.name When the...

I am writing a report that shows totals for current date and I need totals for the same date last month. How would I write that formula and how would I handle leap year and if the number of days in current month doesn't equal the number of days in last month. If, for instance, if there was a...

I am working on a report that calculates the percentage of loans by branch. I have to calculate the total loans by branch, then the total secondary loans by branch, then I have to calculate a percentage showing what percent of each branch's total business is secondary loans. I have grouped...

I am working on a report where I have to extract data in the following format: ___________________________________________________________ YTD 2000 Total January 2001 MTD Total February 2001 MTD Total March 2001 MTD Total April 2001 MTD Total May 2001 MTD Total 6/1/01 6/2/01 6/3/01 6/4/01...