Need suggestion for reports software

Hi,

We have Visual Studio 2005 , Crystal Reports, SQL Server 2005 Express Edition.

our Manager asked about the best and easiest reporting software other than Crystal Reports.

I didn't work with reports. Please assist me, if any one have idea.

Thanks in advance

Regards

Jyothi

I have worked with crystal reports and Sql Server Reporting Services and SSRS for all its problems, beats crystal and not just on price. The points with SSRS to watch are:

Choose the right style at the outset as difficult to change afterwards.|||

I tried Crystal it is expensive but has a lot of predefined functions that SSRS doesn't. But I elected to you SSRS I like it better it is easy to use and very flexible. I just wish it would conform to the same formats as excel. I found out you can not have over 160 in in viewable colum space width. Excel allows 256...

|||

Hello,

I'm currently working on SQL Reports and found out that they are better than Crystal and DEV express reports. I'm implementing a localisation functionality with ASP.net and they are very flexible.

Here are the key features.

1- Easy to integrate with ASP.net site

2- Build custom assembly and use it in your report or use VB for embeded coding.

3- Free of cost with SQL Express.

4- Plenty of support/samples and knowledge base.

5- Free of cost report designer (Business IntelligenceProject)

Thanks,

Farooq

|||

Check these links to see the features of reporting services

http://msdn2.microsoft.com/en-us/library/ms159273.aspx

http://www.microsoft.com/technet/prodtechnol/sql/2005/2005ssrs.mspx

Check this post for a good discussion on Crystal Reports .NEt vs. SSRS :

http://asp.net/Forums/ShowPost.aspx?tabindex=1&PostID=720164

Need some help with MSDE 2000

I have to create an application using MSDE, I install the software on my pc
and it is working fine but my problem is that I have to store the database
on the J drive of my LAN and must be able to access if from my local PC or
any other pc connected to the Lan. When I put the database on my pc I can
access the the tables, but when I put the database on the J drive of the LAN
the MSDE client on my PC does not find the databases. Is there a way to tell
the MSDE client on my PC to go to the J drive on the lan and find the
databases? The data must be store on the J drive of the Lan. I would really
appreciate some help here as I am very new to MSDE. In ms access I just had
to set the path to the database and that was it.
thanks in advance.
On Sat, 12 Jun 2004 01:37:34 -0400, Patrick Blackman
<caribsoft@.videotron.ca> wrote:

> the MSDE client on my PC does not find the databases. Is there a way to
> tell the MSDE client on my PC to go to the J drive on the lan and find
> the
> databases?
You should install MSDE on the machine where it runs, not on another PC
into a mapped drive. That's just what my feeling tells me. There might ne
network installation guides on msdn.microsoft.com.
Furthermore, if you need to access MSDE over the net, make sure
authentication (hint: SECURITYMODE=SQL, for instance) is set up properly
as well as "firewalls" are disabled or at least let the appropriate ports
through (I can't recall the MSDE listening port).
HTH,
Stefan
Give a man fire and he is warm for a day.
Set him on fire and he is warm for the rest of his life.

Need some assistance linking an Oracle database

I'm trying to set up an Oracle database as a linked server in SQL server 7 but having some problems.

The client software is installed and seems to be working fine (Used access to link some tables). I set the product name to Oracle 8.1 and the Datasource to the system dns name. I left provider string, location and catalog blank. Under the security tab I had it set to map to the oracle account and also tried the impersonate option, but always got the same error.

Error: 7399 OLE DB provider 'MSDASQL' reported an error. Driver's SQLSetConnectAttr failed]
ORA-12640: Authentication Adapter initialization failed]

This is my first time trying to set up and Oracle database as a linked server, any help is appreciated.Made a few changes and now getting the following error.

"Error 7399: OLE DB provider 'MSDAORA' reported an error"

I get this error when trying to view the list of tables under the linked server in enterprise manager. When i run a basic query through query analyzer, i get this expanded error message.

"OLE/DB provider returned message: ORA-12154: TNS:could not resolve service name"

Using Oracle ODBC Test utility in the Oracle client I am able to connect to the database and run queries.|||The most common problem in using Linked Server and other distributed services is SQL Server Agent did not have Network permissions which means your SQL Server is installed with the Microsoft provided local systems account, I maybe wrong but I think in 7.0 you may have to reinstall SQL Server with a Service account. You may not find the info about service account in SQL Server 7.0 BOL(books Online) because it took a while to get Microsoft to require the Service account. Hope This helps.

Kind regards,
Gift Peddie|||The error I would get is the following. "OLE/DB provider returned message: ORA-12154: TNS:could not resolve service name".

I haven't been able to find a good step by step guide to follow to link to an Oracle database. Trying to reinstall the server might not be an option. If I could find something that did say it was the problem you mentioned, then it would probably be worth it.

Can anyone shed some light on this problem. Or managed to link to an oracle databse from SQL?|||Try these two urls, the first has most known SQL Server Errors and the solutions complined over the years by Neil Pikes and the second is one of the best Oracle info site on the Web including Oracle BOL(Books online). Hope this helps.
http://www.mssqlserver.com/faq
http://www.dbasupport.com

kind regards,
Gift Peddie

Need Project Tracking software

SourceGear's Dragnet is cheap and it ties in really well with their most
awesome source control provider (vault)
http://sourcegear.com/
FogBugz is popular and also cheap
[url]http://www.fogcr.com/FogBugz/[/url]
There's the Issue Tracker Starter Kit which is free:
http://www.asp.net/starterkits/down...index=0&tabid=1
Karl
--
MY ASP.Net tutorials
http://www.openmymind.net/
http://openmymind.net/redirector.aspx?documentId=51 - Learn about AJAX!
"Antonio" <blarfoc@.yahoo.com> wrote in message
news:1135094223.837753.13100@.z14g2000cwz.googlegroups.com...
> Hi, sorry for the OT question but the readers opinions will matter more
> to me.
> I team lead a small development team of .net and sql programmers.
> There is another team in our group like ours. We are tracking our
> project requests and statuses in Excel as it is shared with people
> ourside our teams who also need update abilities.
> We're looking for a good project tracking software for teams like ours.
> It can be web based preferrably.
> PLEASE PLEASE do not tell me to have us write it ourselves. :-) We
> can but need to focus on our dev projects.
> can you readers suggest some of the 3rd party project tracking and
> request applications that you use today that you would recommend?
> Thanks!
>"Karl Seguin" <karl REMOVE @. REMOVE openmymind REMOVEMETOO . ANDME net>
wrote in news:enNTu$XBGHA.3408@.TK2MSFTNGP12.phx.gbl:

> SourceGear's Dragnet is cheap and it ties in really well with their most
> awesome source control provider (vault)
> http://sourcegear.com/
We use Vault + Dragnet. Vault works wonderfully... but I find that DragNet
needs additional refinement.
Stan Kee (spamhoneypot@.rogers.com)