urgent help - cash flow report
Featured Partner
Top Posters
Zine Eddine
2 posts
Alex Lyaschenko
27 posts
mxsiegel
0 posts
Mattvtek
0 posts
Gareth Evans
3 posts
PP Admin
3, 129 posts
Rajkamal Tangirala
5 posts
Rahul Kumar
1 posts
blake333_
0 posts
Jeamiell Ostrovsky
2 posts
Our Partners
Great, just keep hanging around PP, seems like you are a lot of steps ahead of me, the sharing of your knwledge will be welcomed.
Best regards,
Rafael
thank you rafeel for your help..
however, the solution was just a tilt!! i moved the subtasks to outer level and then back to place, and the pivot gave the correct wbs structure this time..
So, be careful when you have many activities.. you may have to tilt your program
suha
What if you use Save as CSV or even as MS Excel Workbook instead of a MS Excel Pivot Table throug your visual reports wizards. By doing so maybe you will be in better control of your Pivot Tables than if using a Pivot Table Wizard from the start of data transfer.
Never had such a schedule but understand MS Excel is RAM hungry. Save as CVS should be the less RAM demanding route. Follow the link for an article on the limits of Pivot Tables.
http://support.microsoft.com/kb/211517
If you cannot overcome the limits in any way then save as CVS and use of a Database software as MS Access/ Lotus Approach could be an option.
Primavera SureTrak have a Pivot Table Wizard but it is very slow and wonder if can handle the 10,000 activities, SureTrak limit.
Hope this helps,
Rafael