vendredi 27 avril 2012 06:51
I am currently maintaining an application and have little experience in VSS 2010 or vb.net. I have years of experience in non-net-based applications and am not having issues understanding code. I also use SQL Server 2005 and have experience in SQL, though not in the SQL report writer. I have picked up this application for a friend company that has been left in the lurch by the developers and there is no-one for me to speak to. Please help.
I am assuming that the code below is calling the VSS report server but I cannot find any code with .rdlc/.rdl extensions anywhere. I have found a web reference URL within the properties of the webserver object in VSS2010 which indicates that the webserver is reportexecution2005.asmx and the url behavior is dynamic.
Dim rs As New ReportServer.ReportExecutionService
Dim myCredentialCache As New CredentialCache
myCredentialCache.Add(New Uri(WebSuburb.Utilities.GeneralUtilities.GetConfigValue("ReportServicesURL")), "Basic", New NetworkCredential(WebSuburb.Utilities.GeneralUtilities.GetConfigValue("ReportServicesUsername"), WebSuburb.Utilities.GeneralUtilities.GetConfigValue("ReportServicesPassword"), WebSuburb.Utilities.GeneralUtilities.GetConfigValue("ReportServicesDomain")))
Dim myCredential As NetworkCredential = myCredentialCache.GetCredential(New Uri(WebSuburb.Utilities.GeneralUtilities.GetConfigValue("ReportServicesURL")), "Basic")
rs.Credentials = myCredential
Dim parameters(0) As ReportServer.ParameterValue
parameters(0) = New ReportServer.ParameterValue
parameters(0).Name = "ledgerIDs"
parameters(0).Value = Ledgers
Dim ReportPath = WebSuburb.Utilities.GeneralUtilities.GetConfigValue(ddlReport.SelectedValue)
Dim deviceInfo As String = "<DeviceInfo><Encoding>ASCII</Encoding></DeviceInfo>"
Can you tell by any of these clues where the report code might be and/or whether these reports were written and maintained within MSVSS 2010 or Qry2005? I also cannot find anything in Qry2005 that remotely resembles a report or a report writer.
Any help you can give me would make me eternally grateful (as it would the client!). If you can answer this, please phrase your answer as if you are writing a book of "reportwriter for dummies".
Thanking you in advance
Toutes les réponses
samedi 28 avril 2012 20:27The key to what you are looking for is "ReportPath" in the last line. If you put a break point there, you should see to full path to the report that is running.
dimanche 29 avril 2012 18:48
This code was using server based reports, so the reports may not be stored in Visual studio. If you have access to the report server, you can see the reports there.
Brad Syputa, Microsoft Reporting Services This posting is provided "AS IS" with no warranties.