During the last 2 weeks I Been working in a Report that have a great amount of calculations of different accounting GL accounts, the thing is that during the query and view creation with SQL Management Studio everything works nice with response from large query’s in 80 Sec (acceptable).
The Problem arrives when I began to use that query’s in the report construction in Visual Studio Business Intelligence Development Studio , I get error Time Execution Error – Timeout after 30 Sec of running.
This reference help me to identify a 4hr problem Ref:http://www.windows-tech.info/15/b4e1f506fe9c6f41.php
The actual solution to the problem was:
In Visual Studio under Tools – Options.
That resolve the TimeOut problem in the Report development with Visual Studio – Business Intelligence Development Studio.
I hope save some time to others