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!!

Microsoft CRM and SRS

Hello,
I am trying to be an early adapter to SRS for Microsoft CRM reporting.
In particular, I am trying to get the activities that a lead has
associated with it. I am using a subreport and am trying to pass the
lead GUID to the subreport so I can run the activity report for the
lead. I get an invalid type error when I try to do this. Is there a
better way that I might do this? Does SRS have issues with CRM GUIDs?
Thanks in advance.answered in microsoft.public.crm.developer
--
John O'Donnell
Microsoft CRM MVP
http://www.mscrmfaq.us
"Jeffrey Jones" <jeffjones176@.kc.rr.com> wrote in message
news:usaxaU6lFHA.3144@.TK2MSFTNGP12.phx.gbl...
> Hello,
> I am trying to be an early adapter to SRS for Microsoft CRM reporting.
> In particular, I am trying to get the activities that a lead has
> associated with it. I am using a subreport and am trying to pass the
> lead GUID to the subreport so I can run the activity report for the
> lead. I get an invalid type error when I try to do this. Is there a
> better way that I might do this? Does SRS have issues with CRM GUIDs?
> Thanks in advance.sql