Search results for query: *

I am using CR 10. I have a report where I am using a formula to use as a column header for a cross-tab. Below is an example of what I am trying to achieve. ATLANTA INVOICE ATLANTA SERVICE ATLANTA WARR. BIRMINGHAM INVOICE BIRMINGHAM SERVICE BIRMINGHAM WARR. ETC.. Below is the array in my...

Hi, I am using CR 10, and I am trying to populate the columns to look like below: ATL INVOICE ATL SERVICE ATL WARR. BIRM INVOICE BIRM SERVICE. Below is the array I am trying to use, but CR is telling me I cannot use it. Can someone please help me. The Array: StringVar Array Companies := [...

I am trying to list the dates of the working days. I am using Ken's code. Below is the code. WhilePrintingRecords; Local DateVar Start := {?StartDate}; // place your Starting Date here Local DateVar End := {?EndDate}; // place your Ending Date here Local NumberVar Weeks; Local NumberVar...

I forgot to mention that I am using CR10, but it's not the full version. It came with MAS 500. Thanks for your help.

I need to have a cross tab look like the following. Jan Feb Mar YTD 2006 YTD Plus/Minus % 2007 Full Year A&W $50 $10 $30 $90 $100 -10 10% $1500 Buddy $10 $10 $10 $30 $15 15 50% $1000 Right now I have Jan Feb Mar YTD 2006 YTD...

Below is the code I used. WhileReadingRecords; If (Not IsNull({@PostDate})) and (Not IsNull ({tciMemo.MemoID})) then If {@PostDate}in {@WeekNine} to DateAdd("d",7, {@WeekNine}) then If Not IsNull({tciMemo.MemoID}) then If Trim({tciMemo.MemoID}) = ("BIO")...

INV would be the priority over CON. Thanks

Every week in the perfect world, the salespeople are suppose to contact their customers. When they contact their customers they make a note in MAS 500 which is using SQL Server. The notes will have a Memo ID of Contact or Bio. Under each week, I need to show on the report if they Contacted or...

Sorry about that. .docx is Word 2007. Enclosed is a Word 2003 .doc attachment which has everything I am looking for as well as the formulas. Thanks for your help.http://www.box.net/shared/8k02y27sw0

I have enclosed the formulas and screen shots. I think it may be a null issue, but I put in the formula a not isnull(fld), but it seems to ignore it. Please help me. Thanks, Chrishttp://www.box.net/shared/ol1gnrcow0

I have ten different formulas, all are the same for the exception that each one only puts information in the group footer if the date is in the specified date range. The problem I am having is that it is not putting hte correct information in the group footer. Below is one of the formulas...