Search results for query: *

We are trying to print a Crystal Report to a User Defined paper size and are getting a series of dots printing. When it is printed using Letter Size it prints fine. I'm hoping that there is something simple and obvious that we are missing. Any suggestions? Joyce

I am not a VBA expert but I have been asked to make some minor adjustments to an existing Excel file. The file is sent to customers and there is no control as to what level their security is set to. The file has an auto_open macro and my question is whether there is a way to force the file to...

I am getting 2 errors on a macro I wrote in Excel 2002 when it is used with Excel 2000. Works fine with 2002. 1. Run-Time Error: Application-defined or object-defined error The code is: Selection.Sort Key1:=Range("A2"), Order1:=xlAscending, Header:=xlGuess, _...

In Word 2000, I want to autogenerate a TOC that shows Heading 1 and Heading 2 but I only want the page number to appear beside Heading 1. ie. it should appear as follows: John Jones ........1 ABC Company Jane Smith ........2 XYZ Company Is this possible? Or is there another way to...

I need a way to delete all rows that contain a "B" in column C. Any suggestions? Thanks, Joyce

I have a report that has a page break after each customer. Each customer may have several invoice listed. I would like the number and date of the first invoice for each customer to appear at the top of each subsequent page. Is there a way to do this? Thanks, Joyce

I am using a running total for a subtotal in a report. When the Group Footer that holds the subtotal is forced to the page following the detail section, it is blank. I have tried using a manual running total and it appears as 0. What am I doing wrong? Thanks, Joyce

I have a report with one subreport which prints the same info as the main report. I want to set up so that if there are more than 19 detail lines, it will print to a new page. Page 1 of the main report and page 1 of the subreport should appear on the same page. I am able to get the following...

I have a report where I have specified to start a new page after the group footer for Customers. I want to number the detail lines for each customer - is there a way that I can reset the recordnumber counter for each new page? Thanks, Joyce

I have a report that repeats an invoice if more than one payment exists. I need to include the invoice amount in a subtotal only if it is unique. Is this possible? Inv. Amt. Pmt. Amt. Inv 1 100.00 100.00 Inv 2 200.00 100.00 Inv 2...

I have a report in CR7 with a subreport which both have a parameter for "year". These reference fields in different tables but will always be the same value when the report is run. Is there a way to set this so that when the report is run, the value for "year" needs to only...