Crystal or MS Reporting Services

Hi
We are currently contemplating a Crystal Systems, but I came across MS
Reporting Services.
Any ideas on which is more superior or MIS and CRM data?
Kind Regards
RikeshI found a document at the following location, but have not yet read it...
http://www.ramblainf.com/certia04/docs/RSvsBO_En_v1.pdf
Also be sure to figure in the cost of purchase, maintenance costs, etc...
Many of our customers are moving from Crystal to RS for the money reason.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"rikesh" <rikesh_patel@.website.com> wrote in message
news:ucN%23hwIeEHA.384@.TK2MSFTNGP10.phx.gbl...
> Hi
> We are currently contemplating a Crystal Systems, but I came across MS
> Reporting Services.
> Any ideas on which is more superior or MIS and CRM data?
> Kind Regards
> Rikesh
>|||Cool, thanks for that Wayne, I shall have a look at that...
Initial quotes from CR are anywhere in the region of 30K-100K!!!!
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:O7o8T3IeEHA.644@.tk2msftngp13.phx.gbl...
> I found a document at the following location, but have not yet read it...
> http://www.ramblainf.com/certia04/docs/RSvsBO_En_v1.pdf
> Also be sure to figure in the cost of purchase, maintenance costs, etc...
> Many of our customers are moving from Crystal to RS for the money reason.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "rikesh" <rikesh_patel@.website.com> wrote in message
> news:ucN%23hwIeEHA.384@.TK2MSFTNGP10.phx.gbl...
> > Hi
> >
> > We are currently contemplating a Crystal Systems, but I came across MS
> > Reporting Services.
> >
> > Any ideas on which is more superior or MIS and CRM data?
> >
> > Kind Regards
> >
> > Rikesh
> >
> >
>|||Rikesh,
In my experience, RS has provided a better reporting solution, especially if you already have a SQL server running. I've been in charge of moving my company's Crystal reports to RS, and coming in new to both, I've found RS to be smoother and easier to handle. It has its quirks, espeically being a younger product. I've found it has been exceptional for our purposes, which include a lot of large, number comparison reports.
Were I in your shoes, I would definately lean toward RS, but granted, that's just my opinion. Good luck with it all,
- T|||Hi Teros
Thank you for your reply....Just one question, is there any reason why CE
and RS could be installed on the one machine, I have limited resources at
hand, and I wish to prove my case for RS, however, I worried of corrupting
my test installation of CE. Would there be any conflict errors?
Kind Regards
Rikesh
"Teros" <Teros@.discussions.microsoft.com> wrote in message
news:A0B633AB-9729-4537-AB9D-154461F12601@.microsoft.com...
> Rikesh,
> In my experience, RS has provided a better reporting solution, especially
if you already have a SQL server running. I've been in charge of moving my
company's Crystal reports to RS, and coming in new to both, I've found RS to
be smoother and easier to handle. It has its quirks, espeically being a
younger product. I've found it has been exceptional for our purposes, which
include a lot of large, number comparison reports.
> Were I in your shoes, I would definately lean toward RS, but granted,
that's just my opinion. Good luck with it all,
> - T

CRM side-by-side install

I've installed SQL Reporting Services on the same server
as CRM1.2 install. There were a couple minor issues that
were fixed (none of which involved any of the CRM .config
files or IIS permissions for the CRM site). Now when i
try to open CRM i get an error stating a problem with a
config file.
Line 5: <assemblies>
Line 6: <add
assembly="Microsoft.Crm.Platform.ComProxy,
Version=1.0.0000.0, Culture=neutral,
PublicKeyToken=xxxxxxxxxxxxxxxxx"/>
Line 7: <add
assembly="Microsoft.Crm.Platform.Types,
Version=1.2.3297.0, Culture=neutral,
PublicKeyToken=xxxxxxxxxxxxxxxxx"/>
Line 8: </assemblies>
Line 9: </compilation>
Source File: C:\inetpub\wwwroot\web.config Line:7
The server is a dual processor Windows 2000 server with 1
GB ram. All the latest patches are applied.
I have restarted all the CRM services and am able to get
to the point where it asks for login information. It's
upon loading the initial CRM page that i get this error.
There isn't anything in the event log that correlates
with this error.
Any ideas?Jason-
Did you ever find a fix for this problem? I'm getting the same error on our
server and on our client's server as well. On our server we get the error
when we try to access CRM, but the Report Manager runs fine. On our client's
server CRM runs fine, but the error occurs when I try to access Report
Manager.
I did notice that there was already a "Reports" folder from CRM when I was
installing Reporting Services, so I changed the name of the install folder at
the time, so that's not the issue.
Joel
"Chancetribe" wrote:
> Notice that CRM installs a "reports" folder in the root directory. Also
> notice that SQL reporting default virtual folder for the SQL Reporting Folder
> is named "reports". I had a similar problem and just reinstalled Reporting
> Services to a virtual folder with a name other than "reports".
> Hope this can help you.
> Jeremy
> "Jason" wrote:
> > I've installed SQL Reporting Services on the same server
> > as CRM1.2 install. There were a couple minor issues that
> > were fixed (none of which involved any of the CRM .config
> > files or IIS permissions for the CRM site). Now when i
> > try to open CRM i get an error stating a problem with a
> > config file.
> >
> > Line 5: <assemblies>
> > Line 6: <add
> > assembly="Microsoft.Crm.Platform.ComProxy,
> > Version=1.0.0000.0, Culture=neutral,
> > PublicKeyToken=xxxxxxxxxxxxxxxxx"/>
> > Line 7: <add
> > assembly="Microsoft.Crm.Platform.Types,
> > Version=1.2.3297.0, Culture=neutral,
> > PublicKeyToken=xxxxxxxxxxxxxxxxx"/>
> > Line 8: </assemblies>
> > Line 9: </compilation>
> >
> > Source File: C:\inetpub\wwwroot\web.config Line:7
> >
> >
> > The server is a dual processor Windows 2000 server with 1
> > GB ram. All the latest patches are applied.
> > I have restarted all the CRM services and am able to get
> > to the point where it asks for login information. It's
> > upon loading the initial CRM page that i get this error.
> > There isn't anything in the event log that correlates
> > with this error.
> >
> > Any ideas?
> >

CRM mdf ldf files

Hi.

I wasn't sure where to post this, sorry if it belongs elsewhere.

To help you with the bigger picture, I'm an MCDBA and I am currently working in tech support for a Progress database.

I use MS Dynamic CRM 3 at work and it is really slow. I read through a Microsoft CRM performance paper and started checking. I have what seems to be an admin password and finding the SQL and CRM servers was easy.

In the registry of the CRM server in LM>software>Microsoft>MSCRM , there are two values, metabase and database, with the server name and the initial catalog, so I have the database paths. Let's forget about the metabase.

The mdf is 2.5 GB and the log 500MB. Here's my question. the modified date of the log file updates every now and then although it can be off by hours, even if I create a case in CRM! The mdf file is dated Aplir 11, 2007. This is what is being backed up everyday and all the system clocks are correct to the day and minute.

I plan to show the sys admin where the problems with CRM are coming from after I complete my investigation and help him, but this phenomenon with the modified date has thown me for a loop.

Incase the keys I looked at in the registry weren't the right ones, I searched the computer for .mdf files. All but the one in the value database's data are very very small and all have older modified dates. the metabase mdf and ldf update regularly. SQL is installed on the CRM server for the Reporting Services only.

If you need more info, hopefully I can get it.

Thanks,

Jeff

The time stamps on the physical files will update at random. The date/time stamp which is shown doesn't update when ever data is added to the files.

Have you rebuilt the indexes, updated stats, checked profiler for long running queries, etc?