Hey Guys,

I have been losing hair (what I have left) at a great rate trying to impliment a Report function in VB.Net Express.
I think I now have a workable solution, and figured I'd put my 2 cents in as others may benifit.


History:
Crystal Reports
I have toiled with CR just in a effort to frustate myself.
Had done the Repot, and couldn't get the code to access the 'logon' correctly - I gave up.

SQL Server Express
Loaded up Express with the Advanced Services - Then every other download in a effort to be able to build a Report. Poking my eyes out with a sharp stick would have been less painless.

Long story short - both methods above suck for anyone wanting to generate and view a (simple) Report!


Suggestion:
I stumbled accross 'fyiReporting RDL Project 3.0' - I'm loving life.

Using this tool, you can create Reports (with graphs too) and link your Apps DB (something CR was having a fit over).

There is also a set of dlls you can add to your App to view the Report.
(I'm in the process of testing the Report against ReportViewer)


So, for the low end, if you need to build a Report (SQL or Access etc) then this can do that, and provide a .Net Viewer too.
There are other features I haven't mentioned.


Posted in the interest so others dont have to feel the same pain


I would be interested if any else has had experience with the tool and would like to provide feedback.