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} = "I" then
{@Feb00TypeI}
else
IF ({Combined.Type} = "P" 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} = "P" 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 "A" and "P" 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} = "I" then...
The first line of {Combined Type = "I") does not need to be there. I added that because someone said I could create a nested if. The line could be "if not isnull {Combined.Type) then". 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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.