I am trying to run reports on a custom object I created (called Securities) and Accounts and Contacts. I created a master-detail relationship between Accounts and Securities.
For example, an Account - Microsoft - would be linked to Security MSFT (and other securities that Microsoft might have).
I would like to run a report where based on a filter of a security (e.g. symbol starts with 'A'), I receive the accounts associated with that security and the contacts associated with that account.
I have contacted salesforce support and they say there is not way to do this in the salesforce reporting tool ( the create report tool will not allow the correct joins to be created).
This seems like a straight-forward enough report between 3 objects that are related.
Any ideas as to how to create such a report? I am open to any and all suggestions. Is there an app exchange app that will help me here?
I am the beginner. I am getting this following exception at
binding.login("username", "passwordxxxxxx");
nested exception is: java.net.ConnectException: Connection refused 16:45:08,771 ERROR [STDERR] AxisFault faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException faultSubcode: faultString: java.net.ConnectException: Connection refused faultActor: faultNode: faultDetail: {http://xml.apache.org/axis/}stackTrace:java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) at java.net.Socket.connect(Socket.java:516) at com.sun.net.ssl.internal.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:549) at com.sun.net.ssl.internal.ssl.SSLSocketImpl.<init>(SSLSocketImpl.java:351) at com.sun.net.ssl.internal.ssl.SSLSocketFactoryImpl.createSocket(SSLSocketFactoryImpl.java:69) at org.apache.axis.components.net.JSSESocketFactory.create(JSSESocketFactory.java:92) at org.apache.axis.transport.http.HTTPSender.getSocket(HTTPSender.java:191) at org.apache.axis.transport.http.HTTPSender.writeToSocket(HTTPSender.java:404) at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:138) at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32) at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) at org.apache.axis.client.AxisClient.invoke(AxisClient.java:165) at org.apache.axis.client.Call.invokeEngine(Call.java:2784) at org.apache.axis.client.Call.invoke(Call.java:2767) at org.apache.axis.client.Call.invoke(Call.java:2443) at org.apache.axis.client.Call.invoke(Call.java:2366) at org.apache.axis.client.Call.invoke(Call.java:1812) at com.sforce.soap.enterprise.SoapBindingStub.login(SoapBindingStub.java:2730)
I am trying to run reports on a custom object I created (called Securities) and Accounts and Contacts. I created a master-detail relationship between Accounts and Securities.
For example, an Account - Microsoft - would be linked to Security MSFT (and other securities that Microsoft might have).
I would like to run a report where based on a filter of a security (e.g. symbol starts with 'A'), I receive the accounts associated with that security and the contacts associated with that account.
I have contacted salesforce support and they say there is not way to do this in the salesforce reporting tool ( the create report tool will not allow the correct joins to be created).
This seems like a straight-forward enough report between 3 objects that are related.
Any ideas as to how to create such a report? I am open to any and all suggestions. Is there an app exchange app that will help me here?
