INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

ASP.Net with SSRS vs Crystal Reports

ASP.Net with SSRS vs Crystal Reports

(OP)
I am beginning a new project and, against my better judgement, we are using SSRS rather than Crystal Reports. I have never been impressed with SSRS but I have use it in a couple of situations where it was just easier to install and let users run reports from the server. But now I am developing an application with Visual Studio and I can't seem to find one critical piece of development information.

Can I build an SSRS report and call it without integrating it into my ASP.net project? With Crystal Reports, it is easy enough to build a report and either read the files in the directory or add the new CR to a database table and have it dynamically added to a menu or listbox then open it with the OpenReport command.

Can a RDL / RDLC file be executed the same way or does the project need to be recompiled every time a new report is added.

If there is some documentation I've missed, PLEASE point me there!

Thanks for the help!

RE: ASP.Net with SSRS vs Crystal Reports

I faced the same decision for our projects and I came to the conclusion that there is pros and cons to SSRS and CR. In some cases I found that one is better and vice versa depending on the customer and the type of report. So I came up with this solution that is pretty simple and lets the customer do what they want and redesign reports as needed.

I created a table that contains the reports listed by a number reference and the list of parameters associated with each one.

In the same table there is a "Type" column that indicates the type of reports to call : either CR, SSRS or an external dll call by name.

And columns to set the URL for SSRS, call name if a dll or report file for CR.

In the code I have a "Helper" that reads the corresponding row when I give it the number and executes whatever is needed to generate the report.

This way you have the flexibility you need and the decision you take now for a specific report can be changed later without having to recompile anything. It's a bit of work but worth it on the long run

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close