Link to home
Start Free TrialLog in
Avatar of active8it
active8itFlag for United Kingdom of Great Britain and Northern Ireland

asked on

setup reporting functionality in Microsoft Dynamics CRM 2013

we have an on premise install of crm 2013 but haven't got reporting services setup with this at present. does anyone know the process to set this up and configure.

we are looking to be able to do things similar to below
Run reports to see the amount of activity, i.e. phone calls and tasks done by each user in certain time periods. We need it to be able to interrogate the activities under each record so that we can see how many activities were done by a specific user (not by the owner of the record) This would mean we could see how many phone calls or tasks have been added by each user in the telemarketing team. They currently are not the owner of any leads but are adding phone calls to the leads which are owned by the sales people they are calling on behalf of.
Avatar of Feridun Kadir
Feridun Kadir
Flag of United Kingdom of Great Britain and Northern Ireland image

Can you clarify your question please? Do you mean that you need help to enable reporting in CRM 2013 or help writing specific reports?
Avatar of active8it

ASKER

well initially just getting it up and running as i believe it doesnt work straght out the box
Right, there should be very little to set it up. You must have installed and configure or already had SQL Reporting Services because CRM 2013 won't install without it.

After the server installation the only remaining step is to install reporting extensions on the SQL Server that runs Reporting Services. You can find reporting extensions in the server download file.

If you have CRM and SQL on the same computer the server setup program offers to run reporting extensions after CRM is installed.
i have gone into sql extensions installer and under the reporting server dropdown it does not show the local sql reporting database, even though it found the crm database fine on the previous step?
I believe you can type in the name of the sql server if it does not show in the dropdown.
no it allows you to specify the sql server in the first step but on the reporting services page it doesnt allow you to type anything
This suggests that there might be a problem with reporting services. Can you confirm that reporting services is up and running on the server where you tried to install reporting extensions?

Try browsing to
http:// <reportservername>/reports

Open in new window

Replace<reportservername> with then name of the computer
yes this loads fine. the report server is on the local machine also so rules out network or firewall issues
I can only think of two more things to check:

1, Is reporting services a 32-bit or 64-bit installation?
2. What account is used for SQL Server Reporting Services? I think it needs to be a domain account or Network Service.
1. how would i check if its 32 or 64 bit, although i installed at the same time as sql so presume it will match?
2. irs running a domain admin as i thought lack of permissions could be the issue
If you see a folder for reporting services in Program Files\Microsoft SQL Server then it is 64-bit. If you installed it at the same time as SQL then it is almost certainly 64-bit.

And running as Domain Admin means that is not the problem (though it isn't really necessary).

Perhaps a daft question, but you are installing the 2013 version of reporting extensions?  

Otherwise I'm out of ideas :(
it appears it might be 32bit see attached screenshot for x86 program files looks to be msrs11 in that folder
Well that could be the reason.

I don't the screenshot.
User generated image
ASKER CERTIFIED SOLUTION
Avatar of Feridun Kadir
Feridun Kadir
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial