Hello,
I have a main report that illustrates opening and ending balance for an investor. Within the main report is a subreport indicating all contributions for that investor (linking field is the investor id). Also, within the main report is a subreport detailing all the withdrawals for that investor (again, linking field is investor id).
My situation is that the data in the main report is filtered based on a cutoff date. I need to make sure that contributions and withdrawals are shown only up to this date and not after that date.
I am printing one copy of this report per investor to PDF. I have that code done but need to know how to cutoff all the underlying transactions at the specified date within the subreports.
My link works fine but I want to further filter the withdrawals and contributions subreports by a cutoff date.
I am using vb 6.0 and access ole automation to generate these pdfs?
Any ideas?
Jim
I have a main report that illustrates opening and ending balance for an investor. Within the main report is a subreport indicating all contributions for that investor (linking field is the investor id). Also, within the main report is a subreport detailing all the withdrawals for that investor (again, linking field is investor id).
My situation is that the data in the main report is filtered based on a cutoff date. I need to make sure that contributions and withdrawals are shown only up to this date and not after that date.
I am printing one copy of this report per investor to PDF. I have that code done but need to know how to cutoff all the underlying transactions at the specified date within the subreports.
My link works fine but I want to further filter the withdrawals and contributions subreports by a cutoff date.
I am using vb 6.0 and access ole automation to generate these pdfs?
Any ideas?
Jim