<div>
Please have a look at the link below to see how to create a SSRS with parameters instead. That's where you could put the values instead of hardcoding them into your query.<br />
<br />
<a href="http://msdn.microsoft.com/en-us/library/ms155917.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms155917.aspx</a><br />

</div>


Please have a look at the link below to see how to create a SSRS with parameters instead. That's where you could put the values instead of hardcoding them into your query.

http://msdn.microsoft.com/en-us/library/ms155917.aspx [http://msdn.microsoft.com/en-us/library/ms155917.aspx]


<div>
okay I added the parameter now what I should do next so when I'm in CRM the report will show to any contact I'm in<br />
Thanks,<br />
Maya
</div>


okay I added the parameter now what I should do next so when I'm in CRM the report will show to any contact I'm in
Thanks,
Maya

<div>
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
</div>


This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.

<div>
<div class="content wysiwyg-content">
<br />
Hi,<br />
I created a report in ssrs and I have a query to select some policies <br />
where &nbsp;Ownerid=123 or Insuredid=123<br />
<br />
I didn’t create a variable I just put some id’s as a test.<br />
<br />
since It’s the first time I’m working with SSRS reports I don’t know how to deploy it to MS CRM 4. should I create a variable and then the crm will pick it up?<br />
<br />
My goal is then when I’m in CRM and I’m in certain Contact name I can run the above report and it will run for the contact and will fill automatically the<br />
Where Ownerid=(current contact) or InsuredId=(current contact)<br />
<br />
I hope I’m clear in explaining the issue.<br />
Thanks,<br />
Maya<br />
<br />

</div>
</div>



Hi,
I created a report in ssrs and I have a query to select some policies 
where  Ownerid=123 or Insuredid=123

I didn’t create a variable I just put some id’s as a test.

since It’s the first time I’m working with SSRS reports I don’t know how to deploy it to MS CRM 4. should I create a variable and then the crm will pick it up?

My goal is then when I’m in CRM and I’m in certain Contact name I can run the above report and it will run for the contact and will fill automatically the
Where Ownerid=(current contact) or InsuredId=(current contact)

I hope I’m clear in explaining the issue.
Thanks,
Maya



SSRS Report Deployment

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.