Export Data to Excel

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Crm
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Security Model Design Question Poke a Hole in this Security Model! I think I have a pretty good security design, but wanted a second opinion :). The following Security model works â?? however, I have to lock the user out of Excel downloads and Mail merges so that the user canâ??t download the companyâ??s entire contact list. Am I overlooking something that would allow users to own individual Accounts and Contact, yet preclude others from seeing opportunities attached to contacts they own? Background Assumptions 1 â?? Some sales reps are organized Geographically â?? others are organized Functionally (by industry). 2 â?? Sales Reps from different divisions of the company will call on the same Account and Contact. 3 â?? All Accounts and Contacts will be owned at the corporate level so any sales rep can see and attach their opportunity to the contact 4 â?? Sales Reps can only view others Opportunities IF they are in the SAME business unit. If a rep is in a different business unit, the rep should NOT be able to see another business unitâ??s opportunities. 5 â?? If we were to allow individual sales repâ??s to own contacts, then, they could see ALL attached opportunities to that contact regardless of the opportunityâ??s ownerâ??s business unit (which would violate requirement #4 above). Security Role Setup 1 â?? Sales Rep can view/edit/append to all Accounts (accounts owned centrally by a single user) 2 - Sales Rep can view/edit/append to all Contacts (contacts owned centrally by a single user) 3 â?? Sales Rep can view all opportunities within Business Unit. Can only edit their own opportunities Any suggestions are appreciated. Thanks. Tag: Export Data to Excel Tag: 85684
  - 2
    - Update Rollup 2 - Server and Client timing Are we able to install the server side update rollup 2 without having to install the client side updates immedietly? In other words if we install the server side will the Outlook client users continue to work or do we have to upgrade them at the same time? Thanks! Tag: Export Data to Excel Tag: 85681
  - 3
    - Help with CRM integration with Project, Business Portal etc Hi, I'm trying to get my head around how we can use MS CRM with other technologies. Ideally I want one portal which contains CRM information and project related information, from MS CRM and MS Project Server. I see there's a Business Portal that comes with GP etc, but how can I realistically achieve what I want? Thanks in advance. Tag: Export Data to Excel Tag: 85676
  - 4
    - Microsoft CRM 3.0 Virtual PC image missing? Hello, According to several websites I've visited a Virtual PC image with Microsoft CRM 3.0 installed ought to be avaiable here: http://www.microsoft.com/downloads/details.aspx?FamilyID=a8edfc7b-01d8-4500-845b-01370d4eed21&DisplayLang=en However, it seems to have been taken offline for the moment. Does anyone know when it will be available again, or if it may be found at another location? Thanks, Rune Ibsen Tag: Export Data to Excel Tag: 85675
  - 5
    - Renaming "Advanced Find" button Hello All, I was asked the question the other day if it's possible to rename the "Advanced Find" button. I do not believe it's possible but wanted to confirm. Thanks! Tag: Export Data to Excel Tag: 85674
  - 6
    - To reduce your body weight & slim your body To reduce your body weight & slim your body For More Details Please Vist As At http://www.freewebs.com/loseweight207to121 And more to earn please Earn $3,500 Weekly With Google! I Will Show You Proof! Work At Home Only 1hr A Day and earn $3.500 weekly! Limited Time Offer! Act Now! http://sen123.123secrets.hop.clickbank.net/ We can do own without investment you are owner contact with buyer. This website helpful for your business. Please Visit and join to do the Project. http://www.freewebs.com/elancedataentry http://www.freewebs.com/clickbankprofit/ Tag: Export Data to Excel Tag: 85670
  - 7
    - Page Cannot Be Displayed.... I have 2 clients that have intermittent loss of access to CRM 3.0 via the web browser. One is running XP, the other Win 2000. I have applied all patches and updates to Windows, Office, CRM and CRM Client, everything. There are times it will work one minute and not the next, and sometimes it will work for a day or 2. The Browser says Page Cannot be Displayed. Trying to access CRM through Outlook give an error saying something about an Authentication error. (I don't have the exact error message at this time). All other clients on the network are having no issues with CRM via the web browser or Outlook. Any ideas?? I'm completely stumped on this one. Thanks. Tag: Export Data to Excel Tag: 85669
  - 8
    - Querry Builder: No Attributes We have recently deleted some attributes from within our Account screen and have added some additional ones. Now when we go to Relationships and click on Mappings between our Account and Lead Enities we get a "Querry Builder: No Attributes". Has anyone seen this and how do we work around this? I know that there is a Rollup 2 that is design to prevent this, but that doesn't help know. This is for CRM 3.0. Thanks, Brian Tag: Export Data to Excel Tag: 85667
  - 9
    - Attaching Office docs to CRM Is there an easy way to attach a word, excel or PP file to an account or contact in CRM 3.0? I am looking for somethng like the "send to" command in Office currently. It seems like there should be an easier way to do this than going out of the application, into CRM and manually attaching the file? Thanks for your help Tag: Export Data to Excel Tag: 85661
  - 10
    - All my Product CDF import records are being rejected - why? I have carefully followed the CDF documentation regarding the mandatory fields yet all my products in the CDF are being rejected. The listed mandatory fields are simply: Product ID (int) ProductName (char) ProductNumber (char) I am also setting the StatusCodeName and StateCodeName fields to 'Active' I wonder whether in fact other fields are required - eg. Unit Group? All suggestions gratefully received! BillB Tag: Export Data to Excel Tag: 85660
  - 11
    - Customizing CRM CRM experts, We need to create a list of tasks to be completed under a certain entity within a form. This is not a problem, I can create new fields in check box form: Take pictures [ ] Check Trailer Number [ ] Blah Blah [ ] ...not a problem. But what we need to do is have only the first one in the list enabled, and the rest of the list either grayed out or invisible until the first one is checked, and so on. Does anyone know how to accomplish this? Thanks in advance! ~Steve Tag: Export Data to Excel Tag: 85659
  - 12
    - CRMUG.com - Membership is OPEN, try a 90 day free trial! CRMUG MEMBERSHIP is OPEN! Link: http://crmug.com The CRMUG Board of Advisors has finalized the membership program and we are OPEN for business. Make sure to get in on the introductory membership rates only through November 1, 2007. All membership rates are 50% OFF and extend your renewal to November 1, 2008 regardless of when you signup. Want to find out what the user group is all about before committing? We've got a free trial membership! Just use the coupon code "90FREETRIAL" to receive 90 days of free membership! At the end of the complimentary period, one of our Business Development Staff will contact you to see if you enjoyed your free trial and sign you up for a full membership. The only limitation during your free membership is that you will not be able to register for any fee-based event at membership rates until you become a full member. When registering, choose "PAY BY CHECK" and enter "90FREETRIAL". The code will change the dollar amount due to $0 and automatically enable your account. Link: http://crmug.com Tag: Export Data to Excel Tag: 85656
  - 13
    - Adding Notes Is there a way to add the option to add an Associated Entities "Notes" to an exsisting Entity. This Entity was a custom Entity that i created, and i forgot to check the Notes checkbox, and now it grayed out. Even if i have to do it manually through SQL i cant delete the Entity and start over, it not an option. Please help Thanks Bill Tag: Export Data to Excel Tag: 85652
  - 14
    - Environment test before CRM 3.0 installation. Hi. Is is possible to run the environment test without running the CRM app server setup? I would like to know if everything is in place before I run the installation. (I'm waiting for the license key and CD kit, and would like to use the waiting time to prepare the server) Thanks Jacob Mondrup Vivant IT management Denmark. Tag: Export Data to Excel Tag: 85651
  - 15
    - CRM speed sometimes very slow Hi, were using CRM 3.0 in our company. Its installed on a Windows 2000 SP4 server with an Athlon XP 2000+ and 2 Gigs of Ram. We have only 2 people using CRM, so the server shouldnt be that busy ;) ... In most cases our CRM runs very smooth, page loading times don't exceed 1 second. But sometimes, it takes about 30 seconds or longer to open a page, no matter what page you click. I have done a lot of investigation myself. The caching tool is already installed, i have raised the maximum HTTP-connections to 10 and i have modified the stage.js so that HTTP headers exire immediately. What else can i do? Maybe its the SQL server causing those slowdowns? Thanks for your help! Philipp Ritter Tag: Export Data to Excel Tag: 85643
  - 16
    - Linking Accounts and Contacts during Import Can anyone tell me if it is possible to link accounts and contacts when they are being imported into CRM? My scenario is as follows: - I have a list of contacts who all work for Account ABC - Account ABC has one primary contact I wish to import the account details for Account ABC and all of the contact records. I then would like all of my contacts to have Account ABC displayed in the Parent Account field of their contact record. I would also like all of the contacts to be listed in the Contacts section of Account ABC and for the Primary contact field to be populated on the Account ABC record. I understand that this can't be completed using the Bulk Import, and I have used the GUID export method to bring in the primary contact on the account record, or to bring in the parent account field on the contact record. However, I can't see how to populate both the primary contact field and the parent customer field. Would the Data Migration Framework or a third party tool (Scribe?) be able to achieve this for me? Thanks in advance, new2CRM Tag: Export Data to Excel Tag: 85642
  - 17
    - Help! Setfocus problem i ave a dropdown field on the first tab. I use setfocus so that it selects a different field to stop users scrolling down and changing the selection on the load event. Problem When a user changes tab and come back to the origional tab the setfocus doesnt run as the form is already loaded. How do you get around this? This is driving me and users mad at minute...please help before i open another bottle of dark rum! Tag: Export Data to Excel Tag: 85636
  - 18
    - entity mapping to copy notes on leads to contacts and accounts Two of our customers complained that notes on leads do not get copied to the new contacts and accounts when the leads get promoted. As I have learned that Microsoft sees notes as part of the entity I would like to suggest the following. The customizer of a Microsoft CRM system should be able to define a mapping of the notes in the relationships between the originating lead and the newly created contact and company. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=b75c465f-54d0-47b5-aa78-9cd80f6c2f6a&dg=microsoft.public.crm Tag: Export Data to Excel Tag: 85635
  - 19
    - Problem installing CRM wiht SQL Reports SP2 SharePoint integrated Hi I'm having trouble installing MS CRM 3.0 with SQL Server SP2 in SharePoint integrated mode. I get the following error message and the install will go no further. Is there a patch or a way round this problem. Regards Andrew Error message ------- Setup failed to validate specified Reporting Services Report Server http://inex2.ncl.ac.uk/reportserver. Error: The operation is not supported on a report server that is configured to run in SharePoint integrated mode ------- Tag: Export Data to Excel Tag: 85633
  - 20
    - Product, Pricelist with Customer discount Hoi. Is it posible to create a pricelist with products and a customer discount for some special products? Thanks for any help Tag: Export Data to Excel Tag: 85632
  - 21
    - Managing Products Hi group, when I go to the Products in Microsoft CRM -> Sales area in Outlook, I can only see products, but can't manage them. I know I can go to http://crmserver:5555 and manage products from there, but for that I need my Outlook to be closed. Any way to make it working from Outlook client? The cleint is somehow "tired" of closing and launching Outlook again and again. Thanks for your help, Jevgenij Tag: Export Data to Excel Tag: 85630
  - 22
    - Migrate Access to CRM Custom entity Hello... everyone Got any software that can direct allow migrate access data to CRM custom entity.. Tag: Export Data to Excel Tag: 85628
  - 23
    - Lotus Notes and CRM Integration Hi, I am new to MSCRM and I would like to know is it possible to integrate Lotus notes with CRM. Since it is tightly integrated with MS Outlook. If it is possible, then can you provide some useful information regarding the integration. Thanks in advance Sreeju Tag: Export Data to Excel Tag: 85625
  - 24
    - Unable to start dicount list...in CRM 3.0 I am new to MSCRM. I am currently running the trial version and have frustrated in my inability to enter discount list. I followed the instruction in CRM help and the Dummies book to the letter. My problem is that the 'New' button is not available to me to click as stated in the instructions. This is what I did: [In the Navigation Pane], I Click Settings [In the Product Catalog window] I click Discount List. [In the Discount Lists window's toolbar] the New button is missing. Am I in the wrong place? Did I missed any step? Your help will be highly appreciated. Many thanks and regards in advance! Tag: Export Data to Excel Tag: 85615
  - 25
    - Contacts & Advanced Find Hey Everyone, Got a ? for ya...How can I run an advanced find by account criteria (relationship type,account status, etc.) but have it list ALL of the contacts under that account, not just the primary contact? Please help! Thanks Tiffany Tag: Export Data to Excel Tag: 85610
- Next
  - 1
    - Security Role setting for "Change Stage" and "Apply rule" Hello, I have following problem: I have a custom role, that differs in some positions from the standard "sales representative" role. The CRM users, that are in this custom role only, have not the menu entries "Change Stage" and "Apply rule" in their own opportunity, but t he administrator can see them. Does anybody knows, which settings in the security role definition enables the user access to the changing stage of the workflow process? Regards Tag: Export Data to Excel Tag: 85609
  - 2
    - Price List - Pricing methods Hi group, my question is about Pricing methods in Price List Item entity. I clearly understand the purpose of the field itself, but options "Precent Markup..." and "Percent Margin..." mislead me. I tried playing around with it and I perfectly understand what the "Percent Markup..." option does (please, correct me if I am wrong: resulting price = price + % of the price), but it's the "Percent Margin..." which I don't understand. Another not understandable thing is that I can use only values from 0,00 to 99,99 for the margin percentage. This could be more linguistic problem since English is not my mother-toungh, but translation I get from various dictionaries of words "margin" and "markup" mean exactly the same in my mother-toungh (Russian). Reading CRM Help doesn't really help here, cause the description of the options are totally equal to me. So... if you are in a mood to explain this to me I would be very much obliged :) Regards, Jevgenij Tag: Export Data to Excel Tag: 85608
  - 3
    - test test Tag: Export Data to Excel Tag: 85606
  - 4
    - Microsoft worflow keeps crashing Microsoft worflow keeps crashing and before it does I always get the following error in event viewer : The description for Event ID ( 1000 ) in Source ( C:\Microsoft CRM \Server\bin\CrmWorkflowService.exe ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: crmworkflowservice.exe, 3.0.5300.9, 45196ca0, kernel32.dll, 5.2.3790.4062, 46264680, 0, 0000bee7. Any ideas? Tag: Export Data to Excel Tag: 85601
  - 5
    - Workflow services keeps stopping Hi, I have CRM installed on different servers and on one of the server the MSCRMWorkflowService keeps crashing. Just before it crashed I get this error message in event viewer: Event Type: Error Event Source: C:\Microsoft CRM\Server\bin\CrmWorkflowService.exe Event Category: None Event ID: 1000 Date: 7/18/2007 Time: 6:45:43 PM User: N/A Computer: CTOR-PCCRSIIS01 Description: The description for Event ID ( 1000 ) in Source ( C:\Microsoft CRM \Server\bin\CrmWorkflowService.exe ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: crmworkflowservice.exe, 3.0.5300.9, 45196ca0, kernel32.dll, 5.2.3790.4062, 46264680, 0, 0000bee7. Any solution or leads? Tag: Export Data to Excel Tag: 85600
  - 6
    - Reporting Services Server Hello all I was wondering if it is possible to change the Reporting Services Server that I used during the CRM installation. When I installed it, I used http://localhost/reportserver and now I want to change it to http://localhost:93/reportserver, for example. If this is possible, how do I do it? Thanks much, S.R Tag: Export Data to Excel Tag: 85599
  - 7
    - Add-ons and verticals Hello CRM guru's, We publish a website on which we try to give an overview of all add- ons and verticals that are available for Microsoft CRM. We do have over 100 add-ons listed, but only a few verticals. Do you have any vertical that you want to share with the CRM community? Don't hesitate and post them on www.pimpmycrm.com via the comment form or via the emailadres that is listed there. This is a free website, so you have nothing to lose. Of course, if you are looking for extra functions, add-ons or verticals, you can also find them there. Tag: Export Data to Excel Tag: 85588
  - 8
    - formatting in nText field Does anyone know of an add on that allows for formatting such as bold/underline/bullet points etc in an n Text field? Thnx Tag: Export Data to Excel Tag: 85587
  - 9
    - New Computer Synchronization Good morning. I have a CRM client who had a desktop and I just gave her a new laptop. I loaded CRM on the laptop and received a message saying that I need to set the computer to be the synchronizing client for this user. However, when I go into her personalize workplace, there's no synchronization tab. Am I looking in the wrong place? Any advice on this is greatly appreciated! Thanks! Tina Tag: Export Data to Excel Tag: 85585
  - 10
    - Authentication Error When Working Offline With CRM We have a user that will receive an Authentication Error when working Offline with the CRM Client. It's the same error that appears when you try and access CRM with a disabled or non-existent account. When the users Goes Online with CRM everything works fine. It sounds like it happens when the user is browsing the CRM folders and starts switching between folders then it will appear. Hitting Try Again a few times eventually brings the page up but then the error comes back soon after. IE is setup ok, no kerberos errors nothing out of the ordinary. I had turned on tracing and it did report a SQLTimeout Error. The user is running SQLExpress with the CRM V3C client with all patches applied. Is it possible to increase the connection timeout period on the local client? Maybe this would solve the problem. Tag: Export Data to Excel Tag: 85584
  - 11
    - Changing a User's Business Unit From a user record I go to Actions - Change Business Unit and then select the BU that I want to move the user to. After clicking OK, I get a message saying: "You do not have enough privileges to access the Microsoft CRM object or perform the requested operation." I have been given full access to everything, so I don't know why I can't change it. I also tried moving another user who is no longer with the company. Their record is still active, but is never logged on as another user. This caused some problems as my system froze and no one in the organization was able to load the CRM. Tag: Export Data to Excel Tag: 85581
  - 12
    - Email router install SBS 2003 Hi All is it possible install CRM 3.0 Server and email router on different machines ? This is my network: Server A - SBS 2003 Premium Edition Server B - SQL Server 2005 I want to install CRM 3.0 Professional on Server B (and I think this is possible...) but Email Router must be installed on Exchange machine... My Exchange machine is a SBS...is it possible to install only email router as a separate component ? and on a SBS machine ? Thank you Tag: Export Data to Excel Tag: 85579
  - 13
    - Removing a quote, promoted to order I have a quote with was promoted/converted to an order. The order has been deleted, the quote still exists. Upon deleting the (greyed out) quote I get a crm error stating that either I have to access to the object or not enough privileges to perform the action. I'm CRM admin, what is wrong? Regards Tag: Export Data to Excel Tag: 85578
  - 14
    - URGENT!! Bulk Import - Account with Address (More Addresses) Hi, I am trying to do bulk import of a list of accounts which also have "shipping address" along with the Primary address. I used Bulk import tool in the CRM 3.0 and did mapping with "Primary address" with " Address 1" fields and Shipping Address" to "Address 2 fields". But after the import i find that Primary address available in the General screen of the Account but "Address 2" fields mapped should appear in "More Addresses" section which it didnt appear. I checked with the database table customerAddressbase to find both the address (Primary and Shipping) available in the table with all require information but shipping address not appearing. May I know which fields should I map with to display the address in "More Addresses" section?? Plz help as its quite urgent Thanks a lot Tag: Export Data to Excel Tag: 85576
  - 15
    - CRM Report: Problem with "Jump To URL" Hi, I use the report in a CRM Application. In a textbox I want an hyperlink and in the Texbox Properties --> Navigation --> Jump to URL option i include something like this: = "javascript:void(window.open('" & Fields!url.Value & "','_blank'))" but don't open a link in a new window. I click on the link and it doesn't work The identic HTML Code in a .html page work and open a new window but don't work into ReportViewer in the CRM solution. Steven Tag: Export Data to Excel Tag: 85572
  - 16
    - QuickCreateForm on System Entities Hi there, Is it possible to create QuickCreateForms for system enitites e.g. Products. I got the a sample code on the stunnware website but it does not work. Any ideas? thank you Lebo Tag: Export Data to Excel Tag: 85571
  - 17
    - QuickCreateForm on System Entities Hi there, Is it possible to create QuickCreateForms for system enitites e.g. Products. I got the a sample code on the stunnware website but it does not work. Any ideas? thank you Lebo Tag: Export Data to Excel Tag: 85570
  - 18
    - CRM Exchange Router Hi, We have setup 2007 Exchange Server in our office, and still have a 2003 Exchange server, I have downloaded the updated CRM Exchange router that supports 2007 exchange enviroment and kept the crm mailbox on the 2003 server. All other mailboxes are now on 2007. Since this upgrade we are now unable to get any emails into our CRM queues. We have also carried out the Rollup 2 Update on the CRM server. If i look into the crm mailbox through outlook, i can see the email arrive at the inbox, it then trys to deliver it to CRM Queue, but is unable to and bounces back into a folder within the crm mailbox called undeliverable. An event log is also recorded as failed. If anybody has any suggestions I would appreciate your help. I feel like I have tried everything possible. Cheers, Matthew +61 2 8879 6810 matthew@edv.net.au Tag: Export Data to Excel Tag: 85568
  - 19
    - Incoming Email Routing We have MSCRM 3.0 set up on one server and MS Exchange 2003 and CRM Router installed on a second server. Outgoing emails from CRM work fine nbut when a client responds to an email it goes into the agents personal Outlook inbox, is forwarded to the CRMMAil mailbox but does not appear in CRM. Can you confirm that it should appear in the Contacts History or if not where it should appear? Thanks Andy Tag: Export Data to Excel Tag: 85566
  - 20
    - Cannot choose the column in CRM view Hi, I face a strange problem. the crm i install. i can customize "form", but i can't customize the "view". the problem is i can't select the column header in the view. i want move the position of the column. but when i click the column header. it no have any response. any help will be highly appreciated thank you Tag: Export Data to Excel Tag: 85565
  - 21
    - Sharepoint on Outlook Client Hi All, Is it possible to view Sharepoint web pats on the Outlook Client. At the moment we using an IFrame to integrate the Sharepoint services and it works fine, is it possible that there would be problems to view the Sharepoint web parts on the Outlook Client? Thank you Lebo Tag: Export Data to Excel Tag: 85561
  - 22
    - Sharepoint on Outlook Client Hi All, Is it possible to view Sharepoint web pats on the Outlook Client. At the moment we using an IFrame to integrate the Sharepoint services and it works fine, is it possible that there would be problems to view the Sharepoint web parts on the Outlook Client? Thank you Lebo Tag: Export Data to Excel Tag: 85560
  - 23
    - Error - Reports Hi We are not being able to upload report from MS CRM3.0.While trying to upload report from reportmanager it worked!...Problem occurs while uploading the same from CRM. Error Displays like - Error in Server / Application.. Please Suggest?? Tag: Export Data to Excel Tag: 85555
  - 24
    - CRM Trial to Official License HI, I have installed MS CRM3.0 partner license at client side on the live server.Would like to know if i can upgrade the trial license to a license copy.As we are awaiting the paper license. Tag: Export Data to Excel Tag: 85554
  - 25
    - Problem with tracking CRM email Tracking email from Outlook into CRM is not working for some reason. - The Exchange server was moved from the CRM server to another server. - The Exchange connector was installed on the new Exchange server. CRM mailbox for forwarding it configured. - I have reconfigured the CRM SMTP settings and CRM is sending out email. - When a user clicks Track in CRM, the email does not go into CRM. Any help on this would be appreciated. Thanks, -Rick M. Tag: Export Data to Excel Tag: 85551

Hi All,

Please help me out in the following scenario.

1. We have problem in exporting Marketing List data to excel.Dynamic Pivot
table or Direct both the options are failed to export the data.

It throws an exception like "SQL Server Connection failed/access denied" and
when i try to use SQL Authentication , the same error continues.

Note: the Client Machine is in the same domain. Windows authentication works
perfectly when i test it in DSN Creation .

And If we need to work in the Machine which is in the workgroup
instead of Domain, Can we able to export the data?

Please tell me the steps to resolve this issue.

Thanx in advance.

Kind Regards,
Jothi krishnaN

Top