We have duplicate detection rules on contact on First Name-same first 3 characters, Last Name-same first 5 characters and Account-Exact Match.
When a first and last name match an existing contact, even though the Account does not match, and is being converted from a lead to a contact, the user...
I have done this a hundred times with other databases but something is not working with MS Access linking to an MS CRM view. Access 2003 and SQL 2008. I can link to tables and see data but linking to a view doesn't return any rows. Can someone help? Thank you.
I have an excel pivot table (v2003) that I started with an advanced find in CRM. I want to add a view to the pivot table and the view is accessing data in a different database. I can refresh the data but other users are getting "cannot access [database the view is looking at] under the current...
I see where you can remove the email tracking token and on personal options you can set how your emails and contacts are tracked. How can you turn off automatic tracking at the network level? Thanks.
I have been given a report that uses a stored procedure. I'd like to add fields to the report without modifying the stored procedure (which is not mine). If I create a dataset using a select query, how do I relate this data to the st proc data? All from the same database.
Thanks.
A report that I had been updating and deploying during the edits suddenly would not deploy. (Other reports can be deployed to same server, same data source.) In VS, the error is "An internal error occurred on the report server. See the error log for more details." Trying to upload in Report...
Somehow the power failure we had last night screwed up the physical folder permissions for the virtual directories. It was fixed by removing then re-adding the required SQL groups to the folder permissions, then restarted the reporting services service and IIS.
After a power outage I cannot get Reporting Services to start. SQL is running fine on the same server but I get this error in RS:
Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
I have found many people with this problem but it is with new...
Is there a tutorial for borders? Click on a cell in a table and look at the properties. There is only a bottom style, and a default style and a default width. Yet a border displays all the way around the cell. What does the default do and what's the difference between that and specifying border...
I have a page header that is hidden on the first page. However, the report is still leaving space for this hidden header so there is too much top margin. I have set the text box to can grow and can shrink and made the header very small. I guess growing doesn't apply to the header section because...
Opening SQL 2005 Database tuning advisor, This error comes up:R6031- Attempt to initialize the CRT more than once. This indicates a bug in your application.
Microsoft KB article 913395 gives these instructions
2. Locate the following registry subkey...
Thank you, thank you. The textbox was in the body above the table and it did use First. I put the invoice number in the table details (hidden) and not it prints as it should.[smile]
I want to display the invoice number in the page header where there is more than one page. I created a text box in the page header (not report header) that refers to a textbox in the body. =ReportItems!INVOICENUMBER.Value
I set the property of the header to Print on first page=False. The field...
This doesn't work. I finally used this formula
=iif(Fields!MEMO.Value="",true, false)
which I couldn't get to work yesterday. Maybe my true's and false's were backwards.
Thank you.
I have been trying to hide a row in RS when one field is blank. I cannot find the syntax for this after two hours of searching. Can someone tell me if I want to use IsNothing, Is null, ="", or what? Cannot figure out how to test for null in RS which seems to use different sytax than any other...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.