Reporting Services Question

Posted on 2005-03-17
Medium Priority
Last Modified: 2012-08-14
Right now I have a application that creates several xml files, each xml file is a report and is transformed with a certain xsl file when a person goes to a webpage for that report.

We just moved from access to sql server and I heard about sql server reporting services.  Though most of the reports we create aren't just sql, we have to go through and manipulate a lot of the date would sql server reporting services be a good solution or should we just stick with creating our xml and transforming it with xsl.
Question by:macros14
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
LVL 12

Expert Comment

ID: 13566307
I've used sql server reporting service a little bit and it's great.
You can create report in vs .net graphically with the designer add-on.
very easy to use.
What's more, it does not need license if you have one for sql server.
LVL 23

Expert Comment

ID: 13566345
It does a lot more than just churn out Xmls that are transformed by Xslts. Reporting Services is being used in my organisation for sending reports to printers to be printed. You can also get your output in PDF or Image formats as well. It is arguably a better option than Crystal Reports.

Author Comment

ID: 13566558
And you can manipulate dataset data before you add it to the report?
LVL 23

Accepted Solution

b1xml2 earned 1500 total points
ID: 13567246
Not entirely. There are limitations. The reports are created through rdl files loaded within Visual Studio and deployable within Visual Studio.

Reporting Services is something altogether different. I would suggest you download it and try it out.

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

IntroductionWhile developing web applications, a single page might contain many regions and each region might contain many number of controls with the capability to perform  postback. Many times you might need to perform some action on an ASP.NET po…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Suggested Courses
Course of the Month10 days, 11 hours left to enroll

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question