Search results for query: *

This is how the running total is set up. for the running totals, i just want to do a summary of the {table.structure} and in the evaluate I have inserted the {table.structure} in the "change of field" and left the reset to "never". When I put this running total in the detail section, the...

Thank you lbass and Ian. I forgot to mention that I am also using a crosstab report and want to see the totals there but it seems like the last total values add up to a very high number. There is a field {table.area} that range from 1-8, so I put that in the row and summarized by...

Hi, I have a report that is summing duplicates. The formula I am using is: @sum whileprintingrecords; numbervar SUM; SUM := SUM + {table.field} SUM; This is summing but is also summing duplicates. Does anyone know of a formula that would sum only distinct values? Your help will be appreciated...

Thanks for the reply. It actually worked. Only thing is the user has to enter the date in the right format. I tried changing the date parameters in the sp but nothing worked, so i am taking the current option.

I have a stored procedure that has an start date and end date paramters as nvarchar data types and I believe it is going to create a problem when I run it in crystal reports. The date parameter is under the create stored Proc (@A nvarchar(10), @B nvarchar(10), @startdate nvarchar(10), @enddate...