Personal computing discussed

Moderators: SecretSquirrel, just brew it!

Grand Gerbil Poohbah
Topic Author
Posts: 3644
Joined: Mon Sep 23, 2002 7:24 pm
Location: Oz

MSSQL Reporting Server

Thu Jul 16, 2009 5:20 pm

Does anyone have experience with MSSQL Reporting Server?

One of our larger clients has an order from on high that MSRS is now the only reporting tool to be used. So our bespoke ASP.NET application has to shift from Crystal Report to MSRS. Converting the reports is fine, but the lack of functionality seems to be glaring.

It seems that MS figured that the developer would never want to print directly in the application (i.e. they only support going to screen and the user printing). The App has an End of Day process that prints ~40 reports all of which must legally be printed as a hard copy. I've seen the hack that exports the EMF and then stream it to the printer and we could also export to PDF and then print, but it all seems so clunky. Is there a better way?

What about version control? Now that the reports are hosted inside MSSQL instead of our application whats the best method to ensure that updated have been correctly applied? We used to ship an MSI to the 30+ sites that the user could run. It would update the database and website and everything is done. Any ideas on how to automate the update of reports on MSSQL. The users aren't trained and don't have sufficient security to access the servers anyway. We the OEM can't do it since for security reasons we aren't granted access and don't really know what their setup is. Also the sites go silent for periods of time days, weeks, sometimes months with no communication depending on the mission.
SZ87R6/i5 4560 stock/24GB 2333mhz/840 Evo 250GB/Seagate 2TB/ASUS 760GTX/Dell 2711
Rainbows lie in corded knots
While thunder wakes the sleeping crocs.

Who is online

Users browsing this forum: No registered users and 5 guests