Hi~
I am creating a database for our Client Services department. Currently all calculations are done manually and updated into excel - the reports were then emailed to the client in excel. Each client is assigned a "CSA" number and each tab in the spreadsheet would be titled according to the CSA number. I was asked to create a better/easier process, due to the fact that this department runs this data monthly for at least 50 specific clients. I have created all queries for the report and am almost home- so I thought until I started creating the report.
Problem:
The excel spreadsheet has the column headings by month and the row headings as the statistics. There are 41 pieces of information that need to be reported by month --- so eventually this report will have a rough total of 492 fields. In the end the data is separated into four separate queries (due to the fact that queries can only hold so many fields) and the report is composed of three sub-reports. When I do that, I get random blank pages. I have not inserted any page breaks or groupings in the report. The grow and shrink properties in the sub-report are set to Yes.
Are there any other options?
CC
I am creating a database for our Client Services department. Currently all calculations are done manually and updated into excel - the reports were then emailed to the client in excel. Each client is assigned a "CSA" number and each tab in the spreadsheet would be titled according to the CSA number. I was asked to create a better/easier process, due to the fact that this department runs this data monthly for at least 50 specific clients. I have created all queries for the report and am almost home- so I thought until I started creating the report.
Problem:
The excel spreadsheet has the column headings by month and the row headings as the statistics. There are 41 pieces of information that need to be reported by month --- so eventually this report will have a rough total of 492 fields. In the end the data is separated into four separate queries (due to the fact that queries can only hold so many fields) and the report is composed of three sub-reports. When I do that, I get random blank pages. I have not inserted any page breaks or groupings in the report. The grow and shrink properties in the sub-report are set to Yes.
Are there any other options?
CC