Solved

SSRS Report Deployment

Posted on 2011-02-17
5
413 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
5 Comments
 
LVL 39

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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SSRS Export data as csv file 2 115
SSRS set number of in tablix 5 56
SSRS Access Remotely 5 63
Report Builder 9 53
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…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

816 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now