Solved

SSRS Report Deployment

Posted on 2011-02-17
5
417 Views
Last Modified: 2012-05-11

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

0
Comment
Question by:mayajhon1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 40

Expert Comment

by:lcohan
ID: 34918253
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
0
 

Author Comment

by:mayajhon1
ID: 34919511
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
0
 
LVL 18

Accepted Solution

by:
chrismc earned 500 total points
ID: 34924133
I don't know how Reports integrate with CRM but there should be some way to pass parameters through.

Check out here to try and work out what method you are using in CRM to run the report (Embedded, Connector, IFrame or URL access).

You can get info on integrating a report into applications at;
http://msdn.microsoft.com/en-ca/library/ms155362.aspx

Hope that points you in the right direction.

Cheers
Chris
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 35163535
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.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
This code started out as a fix for a customer that had incoming data that was hunderds of numbers and words long that was to fit in one column. The problem was that the customer did not want to split words or numbers when wrapping in the column. …
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

695 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question