Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: geoffreyg
  • Content: Threads
  • Order by date
  1. geoffreyg

    Chart - Change Markers Shape for each line

    Re: CR 8.0 In the Chart Option window>General tab, there is an option to change the shape of the marker (i.e. Rectangle, X-Shape, Circle, Diamond, etc.). I am printing in blank and white, so what would be helpful is... if each line had a distinct shape. Is this possible? Thank you!
  2. geoffreyg

    Protect Automated Word Merge Document

    I have a Word Document that automatically merges with data when it opens (Word document is called from a VB Application using the PrintIt() or ScreenIt() function. However I would like to be sure that the document is protected immediately after it merges. What is the best and securest way to...
  3. geoffreyg

    Suppress Group Header Problem

    I am trying to suppress a Group Header and Footer based on the number of detail records in their section. If there is only one record I do not want either to show. My thought was to create a Running Total (count) for the number of records. This works perfectly for the Footer. But since the...
  4. geoffreyg

    Check Box on Report?

    Is there a way to display a check box (or somthing similar) if the value of a field/column is "true"? Thanks!
  5. geoffreyg

    Cross Tab Column Order

    I would like to have the columns headers of the cross tab to be January 2001/February 2001/March 2001...December 2001 However, when the cross tab displays, it is in alphabetical order i.e. April 2001/August 2001/December 2001... etc. How do I get the headers to sort correctly? Thanks!
  6. geoffreyg

    Cross Tab Layout

    When I create a cross tab with multiple "Summarized Fields" the program stacks the data (puts them on top of each other). Is there a way to put the "summarized fields" side by side? (I was looking for a way to convert the summarized fields in to Columns for the same affect...
  7. geoffreyg

    Formula within a Cross Tab

    I have a cross tab in the report footer of a report. It is setup as follows: Row: Customer Name Summarized Field 1: Count of Estimates (how many estimated sent to the customer) Summarized Field 2: Count of number of orders (how many order were actually created for the client). Question: I would...
  8. geoffreyg

    Putting the "Revision #" on the report

    Hello! CR8 - How do I insert the revision number of a report on to the report (i.e. in the report footer)? The particular field I am looking for is located in the Report Summary Info>Statistics page>Revision Number. I could not find it as a "special field". Thanks!
  9. geoffreyg

    Adding fields in a cross-tab

    I have a cross-tab report with clients as the rows and dates as the columns. In each "cell" of the cross tab are two numbers. (1) The amount I have billed the client that day and (2) The amount I have received from the client that day. This works perfectly. I would now like to add a...
  10. geoffreyg

    Best way supressing entire page based on a condition

    I created a customer statement. Sometimes I want to print statements with zero balances, other times I do not. I created a parameter called SuppressZero. What is the best way to suppress invoice printing based on the parameter (SuppressZero) and the "InvoiceTotal" field? Thanks!
  11. geoffreyg

    Aligning on pre-printed forms

    I am trying to print on an IRS 1099-MISC form. This form is a laser form (8.5 x 11) 3 on a page. I am having the toughest time aligning the printer. In my CR design, I only setup the form once rather than 3 times and adjusted the margins and size so that it would fit 3 perfectly. Is this...
  12. geoffreyg

    Cross-tab in group footer

    Clearly cross-tabs in a group footer are wonderful and easy to use when the data is in the detail section. However, how can I use a cross tab when the data is in a subreport that is in the detail section? (Due to formatting I must keep the data in a subreport.) Do I need to put the cross-ab in...
  13. geoffreyg

    Better way to summarize at the bottom of a report?

    I have a report structured in the following way Customer Inv # Inv Amt. ======================= Jeff 101 $40 Jeff 102 $50 Warren 103 $50 Mary 104 $50 Jeff 105 $10 Mary 106 $15 At the bottom of the report, I would like to see: Customer Totals: Jeff $100 Mary $65 Warren $50 What is the best...
  14. geoffreyg

    Avoid Subtotaling when only one detail line

    I am looking for a way to suppress a subtotal when there is only one detail line, avoiding the same subtotal as the detail amount and making the report much shorter. Any ideas? Geoffrey

Part and Inventory Search

Back
Top