No announcements
Found 182456 threads
-
3 Votes
Excel Report Creation (ODBC or SQL Connection Failed)
when the user tried to opent he excel the connection with the Windows Authentication will be made to the CRM database and data will be fetched from the ...Answered | 10 Replies | 13897 Views | Created by Pavan Kumar Reddy - Monday, January 10, 2011 2:37 PM | Last reply by Bharat Bambhaniya - Wednesday, July 6, 2011 10:07 AM -
0 Votes
SQL connection with security for reports - data not returned properly
Connection works.Answered | 4 Replies | 10605 Views | Created by GreenWasabi - Tuesday, September 18, 2007 2:15 PM | Last reply by GreenWasabi - Tuesday, September 18, 2007 6:28 PM -
0 Votes
SQL connection with security for reports - data not returned properly
The problem though now when it is set to integrated security, it gives a SQL connection error.Answered | 2 Replies | 10415 Views | Created by GreenWasabi - Tuesday, September 18, 2007 2:15 PM | Last reply by GreenWasabi - Tuesday, September 18, 2007 5:24 PM -
0 Votes
Secure Store Service and ProjectServerApplication connection
Correct, when you open the report in the Excel client, that user must have direct database access rights for the data to refresh.Answered | 7 Replies | 11199 Views | Created by Donald R. Landry - Friday, March 18, 2011 6:16 PM | Last reply by hastidav - Tuesday, April 25, 2017 9:44 PM -
0 Votes
Not able to use a Shared Data Source Connection in Report Builder 3.0
Hi, I'm using Project Server 2010, and the installation is on 2 servers, one of them is for application (CUESTOR) and the other one is for SQL Server 2008 R2 ...Answered | 1 Replies | 8157 Views | Created by José Espases - Friday, July 29, 2011 9:11 AM | Last reply by Erick POW - Monday, August 8, 2011 4:22 PM -
0 Votes
A SQL Server Divide by 0 error not returning properly
SQL Server was able to catch the error correctly.Answered | 3 Replies | 8597 Views | Created by wud5 - Monday, November 1, 2010 5:54 PM | Last reply by Andrew Morton - Tuesday, November 2, 2010 9:23 AM -
4 Votes
Data connection ODC file and Excel Reports Templates
I edited the SQL query directly in the "Connection Properties" dialog ((Command Text zone) : it worked (I got my Enterprise project custom field in the ...Answered | 8 Replies | 14787 Views | Created by WLID1966 - Saturday, April 9, 2011 11:27 AM | Last reply by WLID1966 - Sunday, April 10, 2011 1:24 PM -
2 Votes
Issues connection on samples Excel Reports
Make sure you have followed the step by step procedure to configure reporting: http://technet.microsoft.com/en-us/library/ee662106.aspx Typically Secure ...Answered | 2 Replies | 8529 Views | Created by WLID1966 - Monday, January 31, 2011 1:42 PM | Last reply by Christophe Fiessinger - Monday, January 31, 2011 7:10 PM -
2 Votes
CRM 2011 security for reporting from outside?
Hi Jamie, I tried to "Run as " SQL Server Management Studio with normal user and connect to CRM SQL server but receive error "Login Failed ...Answered | 11 Replies | 7007 Views | Created by KM IT - Tuesday, October 18, 2011 12:09 AM | Last reply by Jamie Miley - Wednesday, December 21, 2011 12:28 AM -
0 Votes
Dynamic connection in CRM 2011 sql reports
To clarify on that point when I create a new report via BIDS I need to name the data source as "CRMXXdatasource" .Answered | 6 Replies | 2042 Views | Created by SSQLL - Friday, June 28, 2013 10:55 AM | Last reply by SSQLL - Monday, July 1, 2013 7:04 AM -
0 Votes
Security Report
The reports at http://code.msdn.microsoft.com/CrmSecurityReports should help.Answered | 4 Replies | 5376 Views | Created by Boudewijn Snoeren - Tuesday, January 24, 2012 1:08 PM | Last reply by Boudewijn Snoeren - Saturday, February 4, 2012 7:45 AM -
0 Votes
Cannot refresh data from external data connection with excel services
As i mentioned, I can get to the external sql db from sql queries and with ODC data connections with the client BUT it will not ...Answered | 9 Replies | 7270 Views | Created by Portfoliodude - Thursday, May 2, 2013 10:44 PM | Last reply by Portfoliodude - Friday, May 3, 2013 9:20 PM -
0 Votes
Data security for 'Link to webpages' report type - CRM 2011 on premise
First, add a new field (column) to your table representing the owning security role in CRM.Answered | 1 Replies | 700 Views | Created by Samantha Lau - Thursday, February 13, 2014 6:18 PM | Last reply by Payman Biukaghazadeh - Friday, February 14, 2014 9:14 AM -
0 Votes
Can't refresh reports connected to the cube in Excel Services
connection -> properties and you can see the data connection your report is using is located on the local path.Answered | 5 Replies | 13794 Views | Created by DKLJoe - Tuesday, January 4, 2011 4:00 PM | Last reply by DKLJoe - Friday, January 7, 2011 8:31 PM -
0 Votes
Sample Reports - Data Refresh Issue
1 SharePoint Server Farm(2010 - 14.0.4763.1000) - WS2008R2 1 SQL Server(2008 R2) - WS2008R2 They VM's and meet the hardware requirements.Answered | 8 Replies | 17764 Views | Created by JasonLee2122 - Wednesday, September 15, 2010 1:45 PM | Last reply by Gary Chefetz, MCITP, MCT, MVP - Tuesday, September 28, 2010 9:53 PM -
0 Votes
Best way to develop SQL reports for CRM 2011
To develop reports using Fetch XML you need to download and install the BIDS adapter for SSRS report.Answered | 2 Replies | 2113 Views | Created by Dan Di Giandomenico - Wednesday, January 9, 2013 2:40 AM | Last reply by JLattimer - Wednesday, January 9, 2013 3:46 AM -
2 Votes
Where I would get the security in SQL table?
Hello Anuranjan What level of security details are you looking for ?Answered | 3 Replies | 4815 Views | Created by Anuranjan Prasad - Thursday, March 1, 2012 6:31 PM | Last reply by epmXperts - Friday, March 2, 2012 7:41 AM -
0 Votes
Scheduling Reports in CRM 4.0
The account that SQL Reporting Service is running as needs to be added to PrivUserGroupAnswered | 2 Replies | 8602 Views | Created by 365knowledge.com - Thursday, April 30, 2009 1:44 PM | Last reply by Bryce Godfrey - Tuesday, December 21, 2010 10:24 PM -
9 Votes
Invoke-RestMethod not disposing of connections properly?
I got to this, because I got a HTTP - 505 error while connecting with INVOKE-RestMethod from Win 2012 R2 powershell 4 to Apache Tomcat server on Cisco Identity Services Engine (ISE).Answered | 14 Replies | 14877 Views | Created by Nathan Stohlmann - Tuesday, August 6, 2013 5:59 PM | Last reply by Matt Snead - Tuesday, September 25, 2018 6:06 PM -
0 Votes
Filtered Views returning no values - MSCRM
Hi, Check the connection string for the report.Answered | 1 Replies | 7319 Views | Created by Abhs - Friday, May 28, 2010 2:29 PM | Last reply by Hassan Hussain - Sunday, May 30, 2010 7:37 AM - Items 1 to 20 of 182456 Next ›
No announcements