×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Multiple Reports in one Spreadsheet

Multiple Reports in one Spreadsheet

Multiple Reports in one Spreadsheet

(OP)
Is there a way to take multiple reports and have them produced in one spreadsheet?  I have been able to get them to produce one after the other but is there a way to have it so it populates them next to each other?  So if I have 4 reports I would want it to be as below
 
Report 1         Report 2
Report 3         Report 4.

Any help would be appreciated.  These are all Excel output.

RE: Multiple Reports in one Spreadsheet

Output the reports as csv files and write an import macro into a master spreadsheet, this way you can format the output of the report as you wish.

RE: Multiple Reports in one Spreadsheet

(OP)
I am looking to have this distributed via Report Caster.  Is the above solution still possible and if so could you provide an example of what you are stating in simple terms?

RE: Multiple Reports in one Spreadsheet

We used to extract data from the databases and store the output in csv file.

e.g.
Year, Month, Day, YTD_Target, Actual_Amount, Branch
2010,10,05,5000,4500,124567
2010,05,05,4000,10,123456

Then you import the data into a spreadsheet such as excel and store each column as a separate column. Then format each worksheet as you want the user to see it and write a macro to grab the data from the imported column and do what ever you wish with it. As the raw data is stored you can either protect the worksheets with a password or if you have some power-users you can open it up to them in order to empower their division or branch.

Initially, this does take some time to set-up. But if your consistent with your data and the way you set-up your reports the whole thing can be automated. So, all you do is click a button in order for it to run. We used to run a similar process, providing data and spreadsheet report for about 200 groups and reporting down to about 2000 banking branches. Each branch reporting on about 100+ products. This was completed in about 4 hours from start to finish, including checking the financial side to make sure they all added back to what had been produced for each branch upwards.   

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close