I am not sure I am on the right place, but let's try.
I need a report tool which will allow me to enter SQL statement and as a product to get result that I can save as XLS, CSV, etc... I would like to be able to choose field delimiter if possible.
At work, on daily base I have to create little reports for various things. I usually spend 5 minutes writing SQL statement and 35 minutes copying and pasting and trying to give decent look to the report.
In SQL Query Analyzer (short QA) I can save result in RPT format which is, at least from my point of view, waste of time. Usually I would copy columns from QA and paste it to Excel and there I would start chasing my columns. The most anoying thing is I have to retype all the column/field names since they can't be copied and pasted, and sometime there are a lot of them.
Is there some tool that can help me with this?
I tried Crystal (ver. 9) and gave up. Is there anything else? Thanks.
I need a report tool which will allow me to enter SQL statement and as a product to get result that I can save as XLS, CSV, etc... I would like to be able to choose field delimiter if possible.
At work, on daily base I have to create little reports for various things. I usually spend 5 minutes writing SQL statement and 35 minutes copying and pasting and trying to give decent look to the report.
In SQL Query Analyzer (short QA) I can save result in RPT format which is, at least from my point of view, waste of time. Usually I would copy columns from QA and paste it to Excel and there I would start chasing my columns. The most anoying thing is I have to retype all the column/field names since they can't be copied and pasted, and sometime there are a lot of them.
Is there some tool that can help me with this?
I tried Crystal (ver. 9) and gave up. Is there anything else? Thanks.