bombplayer
Programmer
I have a four databases. Customer Info, Customer Purchase Orders, Customer Advertising Expenses, Customer Advertising Sources. All of these databases are indexed by a joint index called LeadSrcID. I am trying to create a report that lets a user defined data range report:
Customers retained in date range
Customers purchases in date range
Customer Purchase amount in date range
Customer Advertising Expenses in date range.
My problem with this report is that a date range could have advertising expenses without retaining any customers and vice versa throughtout the reporting mechanisms. Currently the not written report shows SQL data fields of any data field that matches the date range and causes the report to run very slowly since all of the computations are done on the report level. Any suggestions on how to pump up this report would be appreciated.
Customers retained in date range
Customers purchases in date range
Customer Purchase amount in date range
Customer Advertising Expenses in date range.
My problem with this report is that a date range could have advertising expenses without retaining any customers and vice versa throughtout the reporting mechanisms. Currently the not written report shows SQL data fields of any data field that matches the date range and causes the report to run very slowly since all of the computations are done on the report level. Any suggestions on how to pump up this report would be appreciated.