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 strongm 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: *

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

    subreport speed

    I am having the same problem with my report. I am not sure how I can restructure the report to accomodate a second detail section. In my detail section I have two sub reports. To better understand what I am doing, here is what report "looks" like. Each detail line is a tenant in a...

Part and Inventory Search

Back
Top