Recent content by piazzab

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.

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.

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.

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.

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?

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.

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!

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

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

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

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

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

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

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