Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Alternative to SQL Reporting Services

Avatar of chshwong
chshwong asked on
Crystal ReportsMicrosoft DevelopmentSSRS
3 Comments1 Solution980 ViewsLast Modified:
At our company, we use SQL Reporting Services (2005/2008) to create our reports.
Our software are mostly composed of .Net and Java programming.

The reports normally contain dynamic tables, graphs, and all that you can think of.
We have done everything that we can such as massive denormalization in order to speed up database calls. Now 90% of the process time reside in rendering, and there's nothing much we can do about that right now.

We're at over 3 seconds per report, and we're hoping to achieve 10 reports per second instead. It'll be used for banks, so it can't take days to generate just a million. The final forms need to be in PDF format. They have awesome printers that can print that much in hours.

Please let us know what realistic alternatives we have here.
We can change database, way of programming and even hardware.
We need to achieve:
- 10 reports per second
- Average reports contain 10-20 pages, with dynamic tables and graphs.
- PDF as final form (other alternatives? pictures? with table formatting and graphs in mind)

As a side, what about, some other methods that directly brings report generation to printers?

Your help is greatly appreciated! :)