Microsoft Reporting Technologies

It seems there are several current reporting mechanisms related to .net and Visual Studio. There is Crystal Reports, an integrated reporting system in Visual Studio and a somewhat related reporting system in SQL Server. The last two seem to use similar .xml bases but it's unclear how or if they are related. This does not include (or maybe is does) the Sharepoint reporting system.

I have eliminated the Crystal Report for various reasons after trying it for awhile. Therefore is there some good introductions and/or comparisons between the Visual Studio reporting system and the SQL Server or BI reporting systems since they both seem to use .rdlc and .rdl type definitions. How or are they related?

Try this link where you can find the answers for your questions

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

sql

Microsoft CRM Picklist Fields in Reports

Hi,
I have experience with Crystal Report Designer and Microsoft CRM. I am now
writing reports in SQL Reporting Services. In Crystal when you add a
picklist field to a report you are able to pick a field called
CaseTypeCodeName and it automatically associates the IncidentBase table to
the StringMap table so that the values for the picklist field automatically
show up.
I do not see that feature in SQL Reporting Services. What I am wondering is
how did people get around this? Do I need a special SQL query to pull this
information?
Thanks!!Yeah, just create a UDF that pulls the appropriate StringMap value.
"Amy" <Amy@.discussions.microsoft.com> wrote in message
news:F6800BE4-2DA9-4803-88D6-4DBEEB170502@.microsoft.com...
> Hi,
> I have experience with Crystal Report Designer and Microsoft CRM. I am
now
> writing reports in SQL Reporting Services. In Crystal when you add a
> picklist field to a report you are able to pick a field called
> CaseTypeCodeName and it automatically associates the IncidentBase table to
> the StringMap table so that the values for the picklist field
automatically
> show up.
> I do not see that feature in SQL Reporting Services. What I am wondering
is
> how did people get around this? Do I need a special SQL query to pull
this
> information?
> Thanks!!