sum the parameters for the entire year
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=15246
Printed Date: 29 Apr 2024 at 8:13am
Topic: sum the parameters for the entire year
Posted By: mini987
Subject: sum the parameters for the entire year
Date Posted: 27 Dec 2011 at 4:02am
hi everyone!!!
i am having problems with creating sum formula, the thing is that I need to put into report the total sum of the books, magazines..etc. printed till that day, separately...have any ideas?
can anyone help me?? :)
|
Replies:
Posted By: kostya1122
Date Posted: 27 Dec 2011 at 10:35am
something like this
magazines
if {table.type} = "magazines" and {table.date} <= date(yyyy,mm,dd) then
sum({table.field to summarize}
books
if {table.type} = "books" and {table.date} <= date(yyyy,mm,dd) then
sum({table.field to summarize}
|
Posted By: mini987
Date Posted: 28 Dec 2011 at 3:21am
not quite :( i tryed with your formula, but it doesn't work
for every job that we do we have new report, and depending of a job my class-ID changes, so report no. 3456 have class-ID 210, then next report no. 3457 have class-ID 125, and what I need is that every time on each report is the sum of quantity of earlier class-ID
for example: class-ID is 210, and the quantity is 10 000, and next time I have class-ID 210 that quantities sums
but thanks a lot for your response!!! :)
|
Posted By: kostya1122
Date Posted: 28 Dec 2011 at 5:17am
if {table.class-ID} = 210 and {table.date} <= date(yyyy,mm,dd) then
sum({table.quantity}
|
Posted By: mini987
Date Posted: 28 Dec 2011 at 7:45pm
|
i put it already yesterday like that, but it doesn't work, will try to put job-id in the range
|
|