Comparing Reporting Programs

I am developing an ASP.Net 2.0 application that will make heavy use of reports. The VisualStudio.Net 2005 Professional edition contains two reporting programs -- Crystal Reports and SQL Server 2005 Reporting Services. Can anyone refer me to a white paper, technical article, book chapter, blog, etc. that compares the strengths and weaknesses of these two programs? Thanks for any suggestions.

Ken McLean

In my opinion SSRS, though far from perfect beats Crystal Reports. I will look up some references for you.

|||

Have a look at:

SQL Server Reporting Services 2005 XML extensions http://www.codeproject.com/KB/reporting-services/SSRS2005XML.aspx|||

Thanks a lot. That's exactly what I was looking for.

Ken McLean

compacting / to repair base of data sql, using the msde

I am developing a project of the access for a friend, more I am with the
following doubts:
Does some exist it sorts things out of compacting / to repair base of data
sql, using the msde or the adp.?
MSDE databases do not require compacting. When updates or other changes are
made, the space freed when a row is deleted is reused automatically. For the
most part, MSDE/SQL Server databases are not subject to the file corruption
problems that are associated (from time-to-time ) with JET databases. There
are utilities (DBCC for one) that can be used to perform maintenance on the
database, but it's unusual to have to resort to these for smaller databases
as typically implemented with MSDE.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Frank Dulk" <fdulk@.bol.com.br> wrote in message
news:%23ZUa0OKMEHA.2456@.TK2MSFTNGP12.phx.gbl...
> I am developing a project of the access for a friend, more I am with the
> following doubts:
> Does some exist it sorts things out of compacting / to repair base of data
> sql, using the msde or the adp.?
>

Commercial Application using MSDE or SQL Server 2005 Express

Hi,

I'm currently developing a commercial application in VS2005 that will catalogue hobbyist type data such as Music and Movies and I am considering using SQL Server 2005 Express for the client database.

My question is how popular is MSDE and/or SQL Server 2005 Express in commercial software products? I can't think of any application that I could buy off the shelf that uses the light-weight version of SQL Server whether that be MSDE or SQL Server 2005 Express.

I love what has been done with VS2005 and SQL2005 and I would love to roll this out but I would like to know that i'm not the only person that is going to implement SQL Server 2005 Express into a commercial product.

Other alternatives that I have looked at is VistaDB.NET, Microsoft Access of course and even looked at DB4O... these are all light-weight in comparision.

Geoff.Great question Geoff. Thousands of companies have signed the redistribution agreement allowing them to redistribute MSDE and/or SQL Server Express. MSDE is installed with many familiar applications, many times silently so users may not know they have it.

Ultimately SQL Server Express will replace MSDE, so building on SQL Server Express is the right thing to do.

The redistribution agreement is available at http://www.microsoft.com/sql/editions/express/redistregister.mspx.

Regards, MJ|||Hello, I am also using Sql express for a commercial application, so dont worry.|||Thanks Luis, This helps, Can you tell me which application it is?

Geoff.|||I know of one that uses MSDE (app was developed prior to SQL Express availability):
REA 9 Real Estate Contact Manager (www.gorea.com/about.html ). It is a client-server app intended to track contacts and properties in a commercial real estate venue.

Comments Table Help

Hi everyone. I've taken a while off of developing site in ASP.net but had a site that I wanted to upgrade a little, but needed a little help.

What I have currently is a website of a person with videos and images of that person. To view the videos, I have a "view_video.aspx?ID=" page that plays the video from YouTube by looking my database for the ID, YouTube URL, Name, and Description. What I want to do is create a "comments" table for visitors to add comments for each video and then display all comments on the page.

So far, my "comments" table looks like this. ID, otherID, name, email, comment, type, date.

The ID is the id of the comment, otherID is the foreign key to the "videos" table, the name is the name of the person leaving the comment, e-mail is for the person, comment is the text, type is the type of video (tutorial, sampler, random video), and date is a timestamp for when users leave the comment.

So hopefully I have a good start. I don't have any code to show right at the moment for I am at work, but if anyone has any ideas or critiques so far, I'd love to hear them. This is an interesting project for my friend and I'd love to implement this sometime.

Thanks,
TetrisSmalls

It sounds great. But some unknown issue is always be detected during the development. So it's too early for us to judge the project or even suggestions on the project.