Reporting options for a web based software
What's your backend tech?
SQL Server 2000.
And Philo, you are up pretty late for a Sunday night :)
Depending on your timeline, MS has a reporting engine for SQL Server coming out soon. (Well, "real soon now" in MSese - YMMV).
Crystal Reports.... *shudders* ... *shudders again*
Jack of all
I liked Crystal Reports before they offered Enterprise Solutions.
About the format of reports.
What's wrong with Crystal Reports? That's what we're using at work, and I'm supposed to go to training in a couple weeks for Crystal Reports 9.0... Is there something I should be aware of?
I don't have control over the client machines and won't be good to restrict them. So HTML looks like a good option. But users do print out these reports a lot. So I probably have to support all the formats.
Deliver the report data as XML. Give the client options to display as HTML or PDF (Use XSL to get there). If you require the ability to drill into the report deliver as HTML with a link to a printable PDF view on every display page. Lastly allow users to take the XML directly so they can import into Excel or OpenOfiice or whatever their heart desires.
XML??? I can just see Joe Marketing having a field day with XML. If they want the data for doing their own massaging, why not comma separated values?
Thanks for all your suggestions so far. XML sounds good but we haven't used it with our application so far and I don't know if I want to get into one more technology. However my main concern is about the UI design of the report. Like what way the data should be presented? tabular? graphical? both? How the drill down should be handled etc. We have extesive set of reports now. But I want to explore some new ways to do them. I would like to see some examples on how others with ASP model do. If you have some links, please do post them. Thank you.
Because you can't XSL CSV into PDF, HTML, Excel, Word, etc...
Philo, but end users would not know how to do this anyway. I thought we were talking about delivery methods.
Check out MicroStrategy Web at http://www.microstrategy.com/Software/Products/Web/
"Like what way the data should be presented? tabular? graphical? both?"
Yes, we have asked the users and we will be asking them more. I have a good idea what needs to be done. I just wanted to see some online samples on how different systems have implemented this. Thanks for all your inputs so far.
Uh, Anon - you're *really* losing out by not putting an email address in. I suspect there may be some people willing to help you, but they don't want to put links to their site on an open forum.
Oops...sorry about that people. Was just using default handle.
What's the matter with Crystal Reports? I'm planning on using Visual Studio .NET and since it comes with Crystal Reports, I'm considering taking a look at it.
Fog Creek Home