Skip to Content
0
Former Member
Oct 13, 2006 at 04:08 PM

XL Report or CrystalReport Balance consolidate

22 Views

Hi all,

I'm trying to make a balance report consolidate with XL Report.

I want to consolidate 4 companies. The estructure and the accounts are similars. Only the ammounts are diferents.

I have seen that i can consolidate reports with XL changing the table views that uses the XL Report.

I have seen a yahoo forum only about the XL but i cant see how can do this report.

Anybody knows how can I change this table views or how can I connect XL Report to more than one database?

Other way than i am trying is ussing the Crystal Report. I get the ammount of the all accounts of the 4 diferent companies but I can't organize the accounts as i want like in the correct balance.

I see that XL uses differents views to organize the levels of the accounts to create the balance but i dont know if I can combine this views with the other tables necessaries to show the ammount.

Anybody have consolidate diferent companies with this methods? Can anybody help me?

Thanks a lot.

Regards,

Alfredo Temprano