jollyreaper
Technical User
Crystal Reports XI, topspeed database, SoftVelocity ODBC driver v4.0.
Our accounting system creates separate databases for each of the projects we run. That's as it should be since they are all separate corporate entities. As for reporting, though, that makes things a little more difficult. Those projects are all separate entities but operated in similar fashion. In fact, the databases are kept identical, even down to the numbers used in the chart of accounts. Theoretically, though I haven't done this yet, I could create a detailed report for one company, point the system DSN at a second company, and the report shouldn't have a single hiccup.
At this point in time, there is no need to run any comparisons between different companies. The reports right now are strictly internal to each company.
So. I'm trying to determine the smartest way to create these reports. The simplest solution I can think of would be separate reports for all companies. Simple, but time-consuming. I could imagine Accounting asking for either a report that prompts you for the company you want and pulls the data at that point or one master report that rips through everything in a single go.
So, is there a direction to be pointed in for this that might lead to a happy solution? Thanks!
Our accounting system creates separate databases for each of the projects we run. That's as it should be since they are all separate corporate entities. As for reporting, though, that makes things a little more difficult. Those projects are all separate entities but operated in similar fashion. In fact, the databases are kept identical, even down to the numbers used in the chart of accounts. Theoretically, though I haven't done this yet, I could create a detailed report for one company, point the system DSN at a second company, and the report shouldn't have a single hiccup.
At this point in time, there is no need to run any comparisons between different companies. The reports right now are strictly internal to each company.
So. I'm trying to determine the smartest way to create these reports. The simplest solution I can think of would be separate reports for all companies. Simple, but time-consuming. I could imagine Accounting asking for either a report that prompts you for the company you want and pulls the data at that point or one master report that rips through everything in a single go.
So, is there a direction to be pointed in for this that might lead to a happy solution? Thanks!