SQL Reporting services
MS SQL Reporting services sounds interesting.
It will publish to PDFs or DOCs for printing
>>It will publish to PDFs or DOCs for printing
Okay, if not PDFs or Excel, what would you recommend.
I was interested in this too, but read that it required Developer Studio. Is that true? Maybe when I'm more curious.
I just fired this up the other day and was really impressed with it. From what I saw, you need Visual Studio 2003 and .Net to get this working. I am sure you could do it on your own with only the compiler but I do not recommend it.
Our development group recently met with some MS pre-sales engineers about Reporting Services. They indicated that you can print directly to the printer (no PDF or Excel), but it requires a little work. They also indicated that there is a sample application available that show you how to do this.
Currently you do need developer studio, but the spec for the file format is available and supposedly several vendors are working on report editors. Cognos is the only one I know off the top of my head though.
>>Okay, if not PDFs or Excel, what would you recommend.
I am at a health organization and we are well on our way to being completely paperless, electronic billing, electronic medical records, digital imaging for radiology, etc.
You can print directly from a client application if you call the web service on the report server and have it return an EMF image. You can then use normal GDI+ printing in .NET to print it. The results are very good, however it's a little fiddly to implement at first and the docs on this particular subject are very poort.
I was very dissapointed to find that this tool doesn't recognise my regional currency setting. It uses $ regardless.
Fog Creek Home