I'm consuming a web service with in a dll that has a public function that returns a dataset.
I'm trying to connect to it with Crystal Crystal reports. I'm pretty sure the "Double Hop" rule while passing my credentials is causing me grief even though I'm supplying a NetworkCredential. If I reference the dll in a test project it brings back the data, but when I try to connect to it with Crystal I get "logon failed Details:mscorlib : Exception has been thrown by the target of an invocation.
Any ideas on how to get a around this would be appreciated.
Here is my class from within the dll:
public class cEntry
private EntryWrapper.entry.Service1 t = new EntryWrapper.entry.Service1();
public DataSet tickets()
string u = ConfigurationManager.AppSettings["user"];
string p = ConfigurationManager.AppSettings["pass"];
string d = ConfigurationManager.AppSettings["domain"];
t.Credentials = new System.Net.NetworkCredential(u, p, d);//Send credentials
string strWeb = t.ReportTest("F241A905-89B1-416d-8DC2-8C2EA1A6B434", ""); //Get xml string from Entry
XmlDocument doc = new XmlDocument();
string inputXml = strWeb;
XslCompiledTransform xslTransform = new XslCompiledTransform(false);
xslTransform.Load(XmlReader.Create(new StringReader(Resource.ticket))); //Load xlst string to the transform object
StringBuilder result = new StringBuilder();
XmlWriter output = XmlWriter.Create(result);
xslTransform.Transform(doc, output); //Apply xlst to the xml file
XmlTextReader xml_reader = new XmlTextReader(new StringReader(result.ToString())); //read the file and convet to xml
relational_data = new DataSet();