Actions

Information

6 responses

19 06 2012
Kwesi Ofori-Quaah

Working with SSRS, just wondering if anyone has sent in their Reports.
I have not done anything cool but might be working on something over the next few weeks for the insurance industry. Not sure how much of it I can share online but will email the methodology once it’s done.

Just wanted to know if anyone else is using SSRS for reporting in the Insurance Industry (UK)

Thanks,
Kwesi

6 04 2012
Pete

Paul — has anyone submitted their reports? Just wondering if you’ll be sharing what other people have accomplished…

Thanks,
Pete

3 03 2012
SSRS or a Custom Web Form – Pros & Cons « Paul Turley's SQL Server BI Blog

[…] This is an interesting subject and one that I and many others have debated in the past.  The original thread is posted here but please reply to this topic in this thread.  Derek, I encourage you to post your previous […]

3 03 2012
Paul Turley

Derek,
One purpose of my blog is to promote an open discussion forum so I’ll start by saying that I respect your opinion. However, to duplicate the complexity of the reports I typically create for my clients in SSRS would be far more complicated and time-consuming in an ASP.NET web form. Your reply is not really related to my original post so I ask that any responses to this new topic by directed to a new post “SSRS or a Custom Web Form – Pros & Cons”, at: http://sqlserverbiblog.wordpress.com/2012/03/03/ssrs-or-a-custom-web-form-pros-cons/

2 03 2012
Derek Colley

I’m not really a fan of SSRS, preferring to use an ASP.NET and HTML interface with an OLEDB or ADODB connection string to a backend SQL database to present information. This way, I can use HTML/CSS to present the information in the way I want to, rather than the way SSRS wants me to. This has some obvious advantages – proper error catching, no grey parameter boxes, more comprehensive support for ‘against the flow’ INSERT/UPDATE traffic (you can use SSRS as a crude input tool), and more.

Plus, you get to use your favourite .NET language – mine’s VBScript. Yes, I’m of the old-skool ‘procedural programming’ class, not at home with OOP, and this has some disadvantages, admittedly (no event handling with VBScript!) but the possibilities are endless.

You can put a proper input form together, too, with method-based programming to sanitise inputs and perform server-side activities (like automatic e-mails, workflows) where SSRS is sadly deficient. SQL Server can handle all the sorting and even the formatting, returning ADODB.RecordSet objects in an intuitive grid form (queried using similar syntax to arrays – these are, in fact, all descended from System.Collections).

You probably get the idea by now – but just to emphasise – SSRS is the poor man’s tool for front-end web design. It’s best in my experience to do it the ‘hard way’ and get the results you want, rather than what you have to settle for.

27 02 2012
Link Resource # 42 : Feb 01 – Feb 24 « Dactylonomy of Web Resource

[…] Show Us Your Coolest SSRS Reports […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s




Follow

Get every new post delivered to your Inbox.

Join 272 other followers

%d bloggers like this: