StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
20425937
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2013-12-06T14:10:36.293
FavoriteCount
0
LastActivityDate
2013-12-06T14:10:36.293
LastEditDate
LastEditorUserId
0
OwnerUserId
638869
ParentId
20218281
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
<blockquote> Here is a sample it is working for me Web config ... </blockquote> <pre><code> <add key="ReportingUserName" value="xxxxx\xxxx" /> <add key="ReportingPassword" value="xxxxxxxxx" /> <add key="ReportingDomain" value="xxxxxxx" /> <endpoint address="http://xxxxxx/ReportServer/ReportExecution2005.asmx" binding="basicHttpBinding" bindingConfiguration="basicHttpBindingConfig" contract="SSRS.ReportExecutionServiceSoap" name="ReportExecutionServiceSoap" />  <binding name="basicHttpBindingConfig" allowCookies="true" maxReceivedMessageSize="52428800" sendTimeout="00:10:00"> <security mode="TransportCredentialOnly"> <transport clientCredentialType="Ntlm" proxyCredentialType="None" realm="" /> <message clientCredentialType="UserName" algorithmSuite="Default" /> </security> </binding> </code></pre> <blockquote> outputType ReportFormat i.e, Pdf,Image,Excel,Ffd deviceInfo contains the XML string for reporting services based on the ReportFormat reportPath contains report path on SSRS server "/xxx/datarecord-Table" </blockquote> <pre><code> private SsrsResponse ExecuteSsrsReport(string reportPath, IEnumerable<KeyValuePair<string, string>> parameters, string outputType, string deviceInfo) { using (var rs = new ReportExecutionServiceSoapClient()) { if (rs.ClientCredentials != null) { rs.ClientCredentials.Windows.ClientCredential = GetReportingCredentials(); rs.ClientCredentials.Windows.AllowedImpersonationLevel = System.Security.Principal.TokenImpersonationLevel.Impersonation; } byte[] result; Warning[] warnings; string[] streamIds; ParameterValue[] parameterValues = parameters.Select(p => new ParameterValue { Name = p.Key, Value = p.Value }).ToArray(); ExecutionInfo execInfo; ServerInfoHeader serverInfoHeader; ExecutionHeader execHeader = rs.LoadReport(null, reportPath, null, out serverInfoHeader, out execInfo); rs.SetExecutionParameters(execHeader, null, parameterValues, "en-us", out execInfo); string extension, mimeType, encoding; rs.Render(execHeader, null, outputType, deviceInfo, out result, out extension, out mimeType, out encoding, out warnings, out streamIds); return new SsrsResponse(result, extension, mimeType, encoding); } } private NetworkCredential GetReportingCredentials() { return new NetworkCredential( ConfigurationManager.AppSettings["ReportingUserName"], ConfigurationManager.AppSettings["ReportingPassword"], ConfigurationManager.AppSettings["ReportingDomain"] ); } </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POEmbed SSRS report into web page without Report Viewer
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USMuhammad Mansoor
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. COOn the "using" line, the IDE highlights ReportExecutionServiceSoapClient as type or namespace not found. Same with SsrsResponse in the return line. Not sure why.
 singulars
 PostPostId
 PO
 UserUserId
 USBlaze
2. COI fixed the ReportExecutionServiceSoapClient, I was using a Web Reference and not a Service Reference. Still can't figure out what's wrong with "SsrsResponse" in the return line. Anyone??
 singulars
 PostPostId
 PO
 UserUserId
 USBlaze

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.