How can I do this?
Hi,
I want to make a report based on a bank account table. The user choose the
account number, initial date and the end date.
The report is grouped by account number.
So, the report will show the values between those dates. My problem is that
I must show at the top of the report the
total (sum of the value field) before the initial date (DATE_MOV <
initial_date), and at the end of the report, the total (sum of value field)
after the end date (DATE_MOV > end_date). (I don't know how to access the
parameters inside the report), and any variable that I create only works
within that range of dates.
How can I do this (with variables?)
Thanks in advanced.
I want to make a report based on a bank account table. The user choose the
account number, initial date and the end date.
The report is grouped by account number.
So, the report will show the values between those dates. My problem is that
I must show at the top of the report the
total (sum of the value field) before the initial date (DATE_MOV <
initial_date), and at the end of the report, the total (sum of value field)
after the end date (DATE_MOV > end_date). (I don't know how to access the
parameters inside the report), and any variable that I create only works
within that range of dates.
How can I do this (with variables?)
Thanks in advanced.
This discussion has been closed.
Comments
ReportBuilder will only traverse the data it needs to print the correct
output. If you need to make calculations on data not shown or printed in a
report, you will need to make them outside of RB either using Delphi code or
in an aggregate field in a new dataset.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com