Software to create reports [modified]
-
Hello, I would like to find a cheap (free) software package that I can use to output data from SQL Server. It does not need to be too fancy as all I am doing is connecting two tables (header and detail). I do not do this often enough to purchase Crystal Reports. Thanks djj Note I originally posted this in the Lounge as a reporting question. I guess I should have thought to put it in the DB area.
modified on Monday, January 31, 2011 9:08 AM
If you've got Server SQL, why not use Reporting Services (SSRS)?
Sarchasm : The gulf between the author of sarcastic wit and the person who doesn't get it.
-
Hello, I would like to find a cheap (free) software package that I can use to output data from SQL Server. It does not need to be too fancy as all I am doing is connecting two tables (header and detail). I do not do this often enough to purchase Crystal Reports. Thanks djj Note I originally posted this in the Lounge as a reporting question. I guess I should have thought to put it in the DB area.
modified on Monday, January 31, 2011 9:08 AM
-
As a developer, can you not write your own? :)
Dave Find Me On: Web|Facebook|Twitter|LinkedIn
Latest Article:Data Historians! You Bought It, Use It! Real World Example Latest Tip/Trick:Google Charting API and Formula Imaging
I am not a developer! I do a little programming but am mainly a T-SQL person as a DBA. I did think about it though :)
-
I have a text column that is greater than 255 characters. :( Excel has a problem when I try to move the info around.
-
If you've got Server SQL, why not use Reporting Services (SSRS)?
Sarchasm : The gulf between the author of sarcastic wit and the person who doesn't get it.
Good question. Mainly I do not know how to. I guess I can get my book out and see what I come up with. -- I have a quick and dirt report but need to figure out formatting.
modified on Monday, January 31, 2011 9:43 AM
-
I am not a developer! I do a little programming but am mainly a T-SQL person as a DBA. I did think about it though :)
djj55 wrote:
I am not a developer
Your profile says you are..... If your not looking for anything fancy, then sometimes rolling your own can be the best option. Sometimes giving your brain that little challenge is enought to keep you ticking over nicely. :)
Dave Find Me On: Web|Facebook|Twitter|LinkedIn
Latest Article:Data Historians! You Bought It, Use It! Real World Example Latest Tip/Trick:Google Charting API and Formula Imaging
-
djj55 wrote:
I am not a developer
Your profile says you are..... If your not looking for anything fancy, then sometimes rolling your own can be the best option. Sometimes giving your brain that little challenge is enought to keep you ticking over nicely. :)
Dave Find Me On: Web|Facebook|Twitter|LinkedIn
Latest Article:Data Historians! You Bought It, Use It! Real World Example Latest Tip/Trick:Google Charting API and Formula Imaging
:) Actually my profile says I have been programming. That technically is not a developer as they generally (I hope) know what they are doing. The number of programs being used by people that I have developed is very small and the programs themselves are simple. Four years ago I could have knocked something out quickly but know I need to refresh my memory on how to do it which I like to do but the boss thinks I could use my time else where. :-D
-
Hello, I would like to find a cheap (free) software package that I can use to output data from SQL Server. It does not need to be too fancy as all I am doing is connecting two tables (header and detail). I do not do this often enough to purchase Crystal Reports. Thanks djj Note I originally posted this in the Lounge as a reporting question. I guess I should have thought to put it in the DB area.
modified on Monday, January 31, 2011 9:08 AM
I write XML and then use XSLT to transform the data (to HTML or CSV).
-
Excel as a reporting tool is a dog, integrating any office product to a database/c# application is always fraught with danger. Outputting the data to a csv file and manipulating it in excel on the other hand is reasonable.
Never underestimate the power of human stupidity RAH
-
Hello, I would like to find a cheap (free) software package that I can use to output data from SQL Server. It does not need to be too fancy as all I am doing is connecting two tables (header and detail). I do not do this often enough to purchase Crystal Reports. Thanks djj Note I originally posted this in the Lounge as a reporting question. I guess I should have thought to put it in the DB area.
modified on Monday, January 31, 2011 9:08 AM
Get to know SSRS, theoretically as a DBA it does (sort of) come under database. It's free and you can use embedded reports if your requirements are simple (if you do not need the full server capability).
Never underestimate the power of human stupidity RAH