Solved

SSRS Report Deployment

Posted on 2011-02-17
5
416 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 100

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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error With the introduction of SQL Server 2008 R2 and Vista (Windows 7 as well) came new enhanced security features. One of the features included was User Access Control (UAC) t…
Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
Suggested Courses

740 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