Port80 Forums Fast Hit Web Hosting

Our Platinum Sponsors:


Go Back   Port80 Forums > Development & Code > dotNet & ASP

Reply
 
Thread Tools Display Modes
  #1  
Old 02-12-2007, 02:30 PM
ashul's Avatar
ashul ashul is offline
Moderator
AWIA Member Committee
 
Join Date: Jan 2005
Location: Perth
Posts: 2,124
ashul is on a distinguished road
Default charting / reporting in ASP.NET

After being totally frustrated with the inbuilt cut-down version of crystal and vowing to never use crystal reports again for any project. I have done a Google and came up with lots of different products, don't mind paying for a good one, but really do not have time to test/trail solutions so the questions:

1. What do people use out there
2. Any recommendations
3. Would like something that does not bloat the user experience and at least tries to be standards compliant - in that vein do not bother to suggest Component-art we will not be renewing our subscription for that one next year..

anything?
__________________
I work at eduka : We do web design and development : Our amazing CMS and My CV
Reply With Quote
  #2  
Old 03-12-2007, 03:35 PM
deprecated-cruelty deprecated-cruelty is offline
Senior Member
 
Join Date: Feb 2003
Location: Huntingdale, Perth
Age: 38
Posts: 2,084
deprecated-cruelty is on a distinguished road
Default

Hey Ashul,

For charting with ASP.Net i've used a couple of different components, all depending on budget for the projects/companies..

for easy chart implementation Dundas has some very nice (and easy) charts..www.dundas.com

some other to look at that i've also used is:

www.dotnetcharting.com
www.infragistic.com

the last two are far more versatile but takes longer to implement in that you have more control..

control == more code generally.

i've also used ComponentArt, but as you say, it bloats a bit for the user.

The all-time favorite is Infragistic...it's widely used and i've had no problems with the components themselves, not to mention from their support if something's gone pearshaped.

All charts, because of the extra overhead, will bloat a bit, Infragistic has by far been my favorite to use.

good luck, and let us know which you end up choosing.
__________________
www.sqlserver.org.au - SQL UG Australia www.msmvps.com/blogs/brianmadsen - blog
Microsoft MVP Visual Developer - ASP/ASP.Net
Reply With Quote
  #3  
Old 03-12-2007, 03:36 PM
deprecated-cruelty deprecated-cruelty is offline
Senior Member
 
Join Date: Feb 2003
Location: Huntingdale, Perth
Age: 38
Posts: 2,084
deprecated-cruelty is on a distinguished road
Default

Should quickly mention that Telerik also makes a reporting tool - it's fairly cheep and royalty free..that's for reporting only though..

haven't used it as extensively as the others, but it's worth a look if Crystal is being smart via .Net
__________________
www.sqlserver.org.au - SQL UG Australia www.msmvps.com/blogs/brianmadsen - blog
Microsoft MVP Visual Developer - ASP/ASP.Net
Reply With Quote
  #4  
Old 11-12-2007, 02:24 PM
RedHawk RedHawk is offline
Member
AWIA Member
 
Join Date: Sep 2007
Location: Perth
Posts: 38
RedHawk is on a distinguished road
Red face Google Chart API

I've just come across the Google Chart API which seems pretty interesting...

It's not exactly "ASP.NET" specific but it lets you pass a URL with data into the img tag

http://code.google.com/apis/chart/
Reply With Quote
  #5  
Old 01-02-2008, 11:57 PM
Cybernetix Cybernetix is offline
Junior Member
 
Join Date: Nov 2007
Location: Willetton
Age: 29
Posts: 28
Cybernetix is on a distinguished road
Default

I've played with SQL Server Reporting Services and I have serious reservations against using it. Integration with applications feels a bit "nailed on". It's in the same vain as cut down Crystal Reports. It has some good points but the cons outweight them.

I decided to write my own boilerplate report in ASP.NET using inline C# to render the report. Probably not the most elegant way but I felt I had the power over how the reports were integrated into my web apps - especially in a UI sense.
__________________
-cybernetix
mcts: .net 3.5 asp.net | mcts: .net 3.5 winforms
e: [email protected]
Reply With Quote
  #6  
Old 02-02-2008, 11:18 AM
ashul's Avatar
ashul ashul is offline
Moderator
AWIA Member Committee
 
Join Date: Jan 2005
Location: Perth
Posts: 2,124
ashul is on a distinguished road
Default

I have always had an issue with integrating SQL reporting services in an app - main thing is the security model, too hard to handle and understand.

To write your own is a brave move, but if your needs are simple think it is the best way to go!

A
__________________
I work at eduka : We do web design and development : Our amazing CMS and My CV
Reply With Quote
  #7  
Old 02-02-2008, 04:20 PM
Cybernetix Cybernetix is offline
Junior Member
 
Join Date: Nov 2007
Location: Willetton
Age: 29
Posts: 28
Cybernetix is on a distinguished road
Default

You'd be surprised how quick you can knock up a dynamic report with inline C# and ASP.NET. Our standard report reads from a view, functionally we provide sort by, group by, search by and filtering funtions to the data and it gets rendered. Pretty simple concept, works really well and saves having to write heaps of reports. I can knock them up pretty quickly within a day or so of development.
__________________
-cybernetix
mcts: .net 3.5 asp.net | mcts: .net 3.5 winforms
e: [email protected]
Reply With Quote
  #8  
Old 02-02-2008, 05:14 PM
deprecated-cruelty deprecated-cruelty is offline
Senior Member
 
Join Date: Feb 2003
Location: Huntingdale, Perth
Age: 38
Posts: 2,084
deprecated-cruelty is on a distinguished road
Default

if i you don't want to use SSRS (and it can be a beast) then using .Net is the next best thing..

what i've done in the past is to create a custom data object (can't go into too much detail on how ours was structured) but it allowed for all of the "normal" features such as sorting, grouping, filtering, linking, master-detail etc to be used on the object, rather than on the database.

next obvious step is of course LINQ To SQL
__________________
www.sqlserver.org.au - SQL UG Australia www.msmvps.com/blogs/brianmadsen - blog
Microsoft MVP Visual Developer - ASP/ASP.Net
Reply With Quote
  #9  
Old 25-06-2008, 01:12 AM
Cybernetix Cybernetix is offline
Junior Member
 
Join Date: Nov 2007
Location: Willetton
Age: 29
Posts: 28
Cybernetix is on a distinguished road
Default

definitely looking forward to implementing LINQ to SQL in my web applications. unfortunately my manager isn't too phased about rewriting our data tier, which is understandable. hopefully there will be another project i can sink my teeth into and use LINQ with my reporting and data.
__________________
-cybernetix
mcts: .net 3.5 asp.net | mcts: .net 3.5 winforms
e: [email protected]
Reply With Quote
  #10  
Old 14-08-2008, 02:49 PM
RedHawk RedHawk is offline
Member
AWIA Member
 
Join Date: Sep 2007
Location: Perth
Posts: 38
RedHawk is on a distinguished road
Default

If you're talking straight reporting (not charting) then you can knock up one within a couple of hours - and most of that time would be spent doing the SQL for it.
Bind the query datatable to a GridView, chuck in the columns you want to represent (or let it dynamically add them if you are binding to an SQL view and just want to show them all), and then chuck in some pre-built paging and sorting handlers (I have standard ones I bolt in to all my gridviews).
If you want to make it extra fast (i.e. no full-page postback) then chuck in an AJAX ScriptManager and throw the GridView in an UpdatePanel.
That's it, nothing else to do! You now have a report with rapid paging and column sorting for under 2 hours work (okay, the first one you ever build might take longer).
I usually have dropdown list filtering and sometimes keyword searching but these just tap into the SQL query directly, so it only adds another 30 mins work.

If you're talking charting... then good luck!
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +8. The time now is 02:58 AM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.