I'm looking for a free (or open source) report writing tool to connect to SQLServer 2005.
I'm looking for the tool to help generate the SQL for the report - it doesnt need any fancy report generation features.
Can anyone advise?
I'm looking for a graphical tool which will help me construct the sql for reports. I saw a new opensource product recently called wasabi (or something) which generated reports but also had a tab which showed the SQL used for the report. In short, I'm after the sql which I can call/use from my app.
Management studio has something very like the query builder in Access - you can use that. Bear in mind it does create some crap. For graphical displays, there is Reporting Services which is included in the license.
A graphical tool for developing report queries?
How do you ever hope to earn the respect and admiration of your peers that way? Write your code in a text based query tool like a man.
You may see a jumble of joins and sub-tables, but I see a woman in a red dress....
If it's not practically useful, then it's practically useless.
There are no peers - this is a private project.
I have a large number of reports to produce and I want to knock them out quickly. If there's a tool out there that will make the process more efficient them I'm going to use it.
Anyway, back to my original question. Does anyone know of a good open source report writer that can also show you the sql it uses for the job? I'll take a look at the feature in management studio but its not quite what i'm looking for.