Productive reports are always welcome. Management always appreciates you to build up a good informative report. In SharePoint, you can found a large area where organization can play with their business data and transformed the raw data to a informative and intelligent report.
From the ancient stage, we are following the process to transformed business data to generate report. Latter stage we have got many tools like SQL DTS and then we have got another feature, cubical concept. There are many product available in the market for generate business intelligent report and one of them from SQL Server Analysis Service suite from Microsoft.
In Microsoft SQL Analysis service, you can build up cube by executing the raw SQL and you can buildup cube. Next phase is to build up report using VS.NET report server project template and using those cube and build up the .rdl compiled file. I’m not going to drill down that much of detailed describing how to build up the .rdl file, instead of, I’m assuming those files already has been deployed in the SharePoint Document Library and we just need to configure properly those files into SharePoint.
