Large reporting project in .Net

[werrockjiu]

I am developing a sophisticated search engine for my website which would aggregate complex data that is stored in various tables in a SQL Server database. OLAP is out of question due to budgeting constrains, so we consider developing our own stored procedures and implement reports with SSRS. I am unable to find on the Internet a code generator which would let us explore with our client various data retrieval scenarios. Has anyone come across a code generator that can serve my purpose? Thanks in advance!

[garethlewis2]

No-one is going to develop a free or OpenSource version of a product like this. These are like gold-dust, entire consultancy companies are based around shovelling commercial products that do what you want.

[eastcoastsurfer]

First of all this is OSX programming.

But since you asked...if you already have MSSQL (and I think reporting services only comes in the enterprise version) then that means you have the MS OLAP product. Build your cubes in it and use excel as your front end for a cheap, effective solution to pivot around lots of data.

[kilarforat]

Hello! I am also a web developer and I was looking for a code generator when I had to develop a database intensive project. I decided to use OxyGen Code (http://www.techinceptions.com/codegenerator.html) to generate our stored procedures and the data access layer. OxyGen Code gave us a much needed productivity boost so we were able to focus on the business rules and the UI rather than writing SQL and data retrieval logic. I would suggest downloading OxyGen Code and giving it a try! Happy holidays!

[Monkaaay]

When it comes to a data access layer, you should be checking out LINQ. It's a part of C# 3.0. It gives you a visual way to create your DAL and makes data access extremely simple.