Using Crystal Reports XI on windows XP accessing SQL 2000 running on windows 2003 server using a Visual Manufacturing database.
This is hard to describe accurately but here goes...
I am running a report that uses QUOTE, QUOTE_LINE, QUOTE_PRICE and QUOTE_Binary_to_notes.
QUOTE_Binary_to_notes is a view in the DB:
CREATE VIEW dbo.[Quote Binary to Notes]
SELECT TYPE, OWNER_ID, CONVERT(varchar(8000), CONVERT(binary(8000), NOTE)) AS cnote
WHERE (TYPE = 'Q')
I am running the following to get @Quote Line Dollars:
This is a summation of the line entries in the quote and is summed in the group footer for each USER_ID.
If I have QUOTE_Binary_to_notes in the report, it duplicates each line and repeats this formula for every note that has been entered in the quote. So, if a quote has had 4 quote notations entered, this formula is repeated 4 times and summed up which is very frustrating.
I need someway of either suppressing the extra line entries (which I have been unable to do so far)
If you can offer me any help on this I would be eternally grateful.
June 26, 2009 6:01 PM
July 15, 2009 1:00 AM