SQL Server Reporting Services
Hi, all experts here,
Thank you very much for your kind attention.
As we know the limited features on SQL Server 2005 Reporting Services, but we can build advanced features for it with coding on it. Would please any experts shed me any light on it in a summary like what advanced features could be added with coding on SQL Server 2005 Reporting Services
Thanks a lot in advance for your kind help and advices. And I am looking forward to hearing from you.
With best regards,
Yours sincerely,
You can apply advanced features by building a custom front-end for Reporting Services, or building custom extensions for behind-the-scenes work.
Here is a link to the custom extensions available.
http://msdn2.microsoft.com/en-us/library/ms152934.aspx
In addition, you can add assemblies and write code for custom calculations & functionality within a report. You can also implement custom controls such as graphs within the report.
What specific functionality are you looking for Please have a look at the Reporting Services partner site for some further examples of custom coding.
http://www.microsoft.com/sql/technologies/reporting/partners.mspx
cheers,
Andrew
Hi, Andrew,
Thanks a lot for your help. Very useful.
Basically the functionalities I am looking for are : can we highlight any exceptions once some figures are out of normal values Can we drill down the reports to new page with different layout and columns from the page drill down happening Also, can we display series in different chart types (like I have 2 series, and I would like to display them in different chart formats within the same chart report), and also, can we have more than one scale displaying two different metrics in the same chart report (like if we display two different metrics, then they have very different value ranges, so it is better if we can have two different scales for these two metrics in the same chart report.
Thank you very much.
With best regards,
Yours sincerely,