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. piazzab

    Text in Word Table Not Printing but Previews Okay

    Help. Ihave a large 11x17 document that is 38 pages long and has 6 columns. It previews fine but prints with no data in the columns except the 1., 2., numbering used per row. Help. I am using Word 2003.
  2. piazzab

    Sort on Running Total Results

    The line items are calculated based on the type from 2 different tables and if they are positive or negative. Then the running total calculates the total from this using a variable. Not sure if a regular total could have been done.
  3. piazzab

    Sort on Running Total Results

    I have a client that would like to perform group sorting on the running total invoice amount placed in the Group Footer #1. Is there a way to do group sorting on a running total field? HELP! The database is a SQL database.
  4. piazzab

    Crystal Reports displays 15 pages on screen but only prints first 13

    Why would a Crystal Report display 15 pages on the screen but only print the first 13? I have to then print pages 14-15 by selecting Print, Pages 14-15. The printer is a small desksheet I believe.
  5. piazzab

    crystal reporting using SAP r/3 logical databases.

    We have developed Infosets in SAP but Crystal Reports prompts the user for parameters when accessing a Info Set. Also the program returns no values when no entering the parameters. Should the Info Set be just a copy of the data?
  6. piazzab

    Running Total From a Formula

    I need to calculate the qtyonhand inventory - qtyordered = available inventory. Then I need to take the available - qtyordered = available on the next line item, etc. How do I do this? QTY ON HAND 10,000 QTY ORDERED 9,000 AVAILABLE 1,000 QTY ORDERED 500 AVAILABLE 500 etc.
  7. piazzab

    High-Volume Printing from MAS 200

    I have a client that prints 22,000 A/P checks every 2 weeks. They are converting to MAS 200 Client Server v. 3.70. Does anyone have a reference for me for a large volume of A/P checks using a MICR printer? I need MICR printer recommendations as well. Thank you. Please respond!
  8. piazzab

    Subtotalling with Global Variables

    I have initialized a variable and increment it in the details section of the report. When I place a third subtotal variable in the footer, it doubles the last item twice. Here is my variables: Group Header 2b: whileprintingrecords; global numbervar patinit030:=0; patinit030; Details Line...
  9. piazzab

    Arrays - HELP

    Here is my problem. I have a report where I have to keep the invoice numbers together with the payments so I have the report grouped by invoice number. My client wants to gross billings for a given month and the payments for those billings in the following months. I can not group my report...
  10. piazzab

    Max Tran Paid Date versus Paid Date

    I finally resolved the problem with the following. I appreciate your help. if {Combined.Type} = &quot;I&quot; then {@Feb00TypeI} else IF ({Combined.Type} = &quot;P&quot; and Maximum ({@paid date}, {@Service Number}) >= date(2000,02,01) and {@paid date} <= date(2000,02,28) and {@paid...
  11. piazzab

    Max Tran Paid Date versus Paid Date

    Why would this note work: if {Combined.Type} = &quot;P&quot; then ( if Maximum ({@Tran Date}, {@Service Number}) <= {@paid date} and Maximum ({@paid date}, {@Service Number}) >= {@paid date} then {@Payment}) else 0 The value of Maximum (@Tran Date},{Service Number} is 4/30/2000 The...
  12. piazzab

    Nested If Statement

    Thanks for the resonse. I have changed the formula to be as follows and the &quot;A&quot; and &quot;P&quot; types now appear but they appear in every column when they are supposed to fall under only October 2000 and forward. October 2000 (Detail Line) if {Combined.Type} = &quot;I&quot; then...
  13. piazzab

    Nested If Statement

    The first line of {Combined Type = &quot;I&quot;) does not need to be there. I added that because someone said I could create a nested if. The line could be &quot;if not isnull {Combined.Type) then&quot;. I just need the item to go thru the three choices and display the appropriate amount if...
  14. piazzab

    Vertical Page Breaks in Crystal Reports

    How can a use a vertical page break in Crystal Reports v 8? I have a header row, 4 columns, [page break] then repeat the header row on second page, 4 columns, [page break}, etc. The number of columns will vary depending on the customer so I need to be able to use a formula with a count of...

Part and Inventory Search

Back
Top