I am trying to call a subreport in master report, if i try to run the sub report individually by passing hardcoded nonqueried values in the parameters it runs fine, but when i use it as subreport in a master report, it shows the error: subreport could not be shown,
In my subreport i am using the table control to populate all fields is there something to do with table control or i am calling the subreport control in the detail pane of main report, and all main reports fields are in the group header.
Please help.
error info: from error list:
Warning 1 [rsErrorExecutingSubreport] An error occurred while executing the subreport €˜subreport1€™: One or more parameters required to run the report have not been specified. c:aspnetccsreports2005ccsreports2005
ptNewIssueHRT.rdl 0 0
I work for a Microsoft Gold Partner and I am having a problem with subreports in SSRS 2005 SP1.
Essentially, I have a report that contains subreports. The main report has a table that passes a parameter to a subreport in each row. The report renders properly when I preview it in Visual Studio, but once deployed to the server it only renders the first subreport for the first row, and every subreport thereafter displays the error, "Error: Subreport could not be shown."
I tested each subreport individually on the SSRS sever and each executes and displays fine. I turned on traces in the web.config file and found some additional information:
<Header> <Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product> <Locale>en-US</Locale> <TimeZone>Eastern Daylight Time</TimeZone> <Path>C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesReportServer__07_16_2006_18_17_54.log</Path> <SystemName>DEVBOX</SystemName> <OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName> <OSVersion>5.2.3790.65536</OSVersion> </Header> w3wp!webserver!5!7/16/2006-18:17:54:: i INFO: Reporting Web Server started w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file. w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file. w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file. w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file. w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file. w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file. w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file. w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file. w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file. w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file. w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file. w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file. w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file. w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file. w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file. w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file. w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file. w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file. w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file. w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file. w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file. w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file. w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file. w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file. w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file. w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file. w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file. w3wp!resourceutilities!5!7/16/2006-18:17:54:: i INFO: Reporting Services starting SKU: Enterprise w3wp!resourceutilities!5!7/16/2006-18:17:54:: i INFO: Evaluation copy: 0 days left w3wp!runningjobs!5!7/16/2006-18:17:54:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds w3wp!runningjobs!5!7/16/2006-18:17:54:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds w3wp!runningjobs!5!7/16/2006-18:17:54:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds w3wp!runningjobs!5!7/16/2006-18:17:54:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds w3wp!library!5!07/16/2006-18:17:56:: i INFO: Call to GetPermissions:/Reports/Project Scorecard - All Open by Team Member w3wp!library!5!07/16/2006-18:17:56:: i INFO: Catalog SQL Server Edition = Enterprise w3wp!library!5!07/16/2006-18:17:57:: i INFO: Call to GetSystemPermissions w3wp!library!1!07/16/2006-18:18:01:: i INFO: Call to RenderFirst( '/Reports/Project Scorecard - All Open by Team Member' ) w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: An exception has occurred in data source 'dsProjectScorecard'. Details: System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28' at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add) at System.Collections.Hashtable.Add(Object key, Object value) at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue) at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet) w3wp!processing!1!7/16/2006-18:18:13:: i INFO: Merge abort handler called for ID=325. Aborting data sources ... w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ; Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28' at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add) at System.Collections.Hashtable.Add(Object key, Object value) at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue) at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet) --- End of inner exception stack trace --- w3wp!processing!1!7/16/2006-18:18:13:: w WARN: Data source 'DataSourcePM': Report processing has been aborted. w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ; Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28' at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add) at System.Collections.Hashtable.Add(Object key, Object value) at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue) at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet) --- End of inner exception stack trace --- w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: An exception has occurred in data source 'dsProjectScorecard'. Details: System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28' at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add) at System.Collections.Hashtable.Add(Object key, Object value) at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue) at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet) w3wp!processing!1!7/16/2006-18:18:13:: i INFO: Merge abort handler called for ID=328. Aborting data sources ... w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ; Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28' at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add) at System.Collections.Hashtable.Add(Object key, Object value) at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue) at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet) --- End of inner exception stack trace --- w3wp!processing!1!7/16/2006-18:18:13:: w WARN: Data source 'DataSourcePM': Report processing has been aborted. w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ; Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28' at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add) at System.Collections.Hashtable.Add(Object key, Object value) at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue) at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet) --- End of inner exception stack trace --- w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: An exception has occurred in data source 'dsProjectScorecard'. Details: System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28' at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add) at System.Collections.Hashtable.Add(Object key, Object value) at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue) at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet) w3wp!processing!1!7/16/2006-18:18:13:: i INFO: Merge abort handler called for ID=336. Aborting data sources ... w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ; Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28' at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add) at System.Collections.Hashtable.Add(Object key, Object value) at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue) at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet) --- End of inner exception stack trace --- w3wp!processing!1!7/16/2006-18:18:13:: w WARN: Data source 'DataSourcePM': Report processing has been aborted. w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ; Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28' at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add) at System.Collections.Hashtable.Add(Object key, Object value) at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue) at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet) --- End of inner exception stack trace --- w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: An exception has occurred in data source 'dsProjectScorecard'. Details: System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28' at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add) at System.Collections.Hashtable.Add(Object key, Object value) at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue) at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet) w3wp!processing!1!7/16/2006-18:18:13:: i INFO: Merge abort handler called for ID=344. Aborting data sources ... w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ; Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28' at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add) at System.Collections.Hashtable.Add(Object key, Object value) at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue) at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet) --- End of inner exception stack trace --- w3wp!processing!1!7/16/2006-18:18:13:: w WARN: Data source 'DataSourcePM': Report processing has been aborted. w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ; Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28' at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add) at System.Collections.Hashtable.Add(Object key, Object value) at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue) at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet) --- End of inner exception stack trace --- w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: An exception has occurred in data source 'dsProjectScorecard'. Details: System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28' at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add) at System.Collections.Hashtable.Add(Object key, Object value) at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue) at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet) w3wp!processing!1!7/16/2006-18:18:13:: i INFO: Merge abort handler called for ID=352. Aborting data sources ... w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ; Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28' at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add) at System.Collections.Hashtable.Add(Object key, Object value) at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue) at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet) --- End of inner exception stack trace --- w3wp!processing!1!7/16/2006-18:18:13:: w WARN: Data source 'DataSourcePM': Report processing has been aborted. w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ; Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28' at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add) at System.Collections.Hashtable.Add(Object key, Object value) at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue) at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet) --- End of inner exception stack trace --- w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: An exception has occurred in data source 'dsProjectScorecard'. Details: System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28' at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add) at System.Collections.Hashtable.Add(Object key, Object value) at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue) at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet) w3wp!processing!1!7/16/2006-18:18:13:: i INFO: Merge abort handler called for ID=360. Aborting data sources ... w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ; Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28' at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add) at System.Collections.Hashtable.Add(Object key, Object value) at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue) at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet) --- End of inner exception stack trace --- w3wp!processing!1!7/16/2006-18:18:13:: w WARN: Data source 'DataSourcePM': Report processing has been aborted. w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ; Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28' at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add) at System.Collections.Hashtable.Add(Object key, Object value) at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue) at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet) --- End of inner exception stack trace --- w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: An exception has occurred in data source 'dsProjectScorecard'. Details: System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28' at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add) at System.Collections.Hashtable.Add(Object key, Object value) at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue) at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet) w3wp!processing!1!7/16/2006-18:18:13:: i INFO: Merge abort handler called for ID=368. Aborting data sources ... w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ; Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28' at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add) at System.Collections.Hashtable.Add(Object key, Object value) at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue) at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet) --- End of inner exception stack trace --- w3wp!processing!1!7/16/2006-18:18:13:: w WARN: Data source 'DataSourcePM': Report processing has been aborted. w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ; Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28' at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add) at System.Collections.Hashtable.Add(Object key, Object value) at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue) at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet) --- End of inner exception stack trace --- w3wp!library!1!07/16/2006-18:18:13:: Using folder C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesRSTempFiles for temporary files. w3wp!processing!1!7/16/2006-18:18:15:: w WARN: The grouping expression for a category grouping returned a null value. w3wp!processing!1!7/16/2006-18:18:15:: w WARN: The grouping expression for a category grouping returned a null value. w3wp!webserver!1!07/16/2006-18:18:15:: i INFO: Processed report. Report='/Reports/Project Scorecard - All Open by Team Member', Stream=''
Any insight or assistance would be greatly appreciated.
Eric Hausig Developer Lead Artemis Solutions Group eric.hausig@artemis-solutions.com
I have a problem with a report containing a number of subreports not running successfully when deployed to the Report Server.
The report runs successfully every time in the VS Development environment, so parameters are all setup correctly and the result is as expected accross the whole report.
No errors or warnings are listed when building or deploying.
All subreports are in the same project as the main report and deployed to the same folder in Report Manager. All the individual subreports run successfully both in VS Studio (Preview Tab) and in the Report Manager portal.
About 50% of the time, the main report runs but shows the error "Subreport could not be shown" for some or all of the subreports.
I have been battling with this for days now and I cannot get this to work. I would really appreciate it if someone could advise me of where I am going wrong:
Default.aspx.vb:
Imports Microsoft.Reporting.WebForms
Partial Class _Default
Inherits System.Web.UI.Page
Dim odsItems As New ObjectDataSource
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
My report is one main report with no Parameters and a subreport which is passed one parameter from the main report "questionid".
No matter what I do I get the same error: Error: Subreport could not be shown. I have tried setting the param to string, integer, hidden whatever and nothing works.
I seem to have run across the feared "Error: Subreport could not be shown" problem. I have very carefully checked everything I could find on the issue, but nothing seems to help--and I must admit, I'm at my wits' end here (though it's probably something absurdly simple).
I have a main report with one subreport. I am running ASP.NET, with a ReportViewer control on my ASPX page. The main report and subreport are both local reports, and pull data from SQL data sources.
Initially, I had the parent report pass a parameter to the subreport, but in the interest of keeping things simple I removed that--even though I verified that my handler for the subreport processing was valid and was obtaining valid values for the parameter.
Here's the applicable code from the CodeBehind's class:
Through debugging and other means, I have found the following:
1. The data being passed through vw in the ProcessSubReports is valid. 2. The subreport runs perfectly when placed into its own ReportViewer 3. The reports are all in the App_GlobalResources folder 4. The main report references a subreport by the name of SalesByProduct 5. App_GlobalResources/SalesByProduct.rdlc is the name of the report file
I should be able to provide more information on request.
I have a simple report which calls another subreport. I can run the report successfully in both the Report Designer and through the Reporting Manager. Security has been set for all users in the Report Manager for both the Main Report and the Sub Report.
When another user tries to run the report from Report Manager they get a one line error message in the Main Report which says "Subreport could not be shown".
I am a Systems Administrator, during testing I have added the other users to the System Administrator Group also, but this made no difference.
I have a base folder (Report Folder A) which has several reports. One of these is a report that is simply a subreport of one of the others in the folder (it uses different default parameters, which is why it's necessary).
I then created another folder (Report Folder B) for users who only have access to some of the data in the reports...so they have browser access to Folder B but not Folder A. All of the reports for the users work except for the one that contains the subreport. When I run the report with a subreport I get the message: "Error: Subreport could not be shown". I'm guessing this is because the users don't have access to the base report. Does anyone have an idea of how to work around this without giving the users access to the base report (in Folder A)?
I am trying to get a simple SSRS Report containing a subreport to work in Sharepoint SSRS Integrated mode but have been unable to do so. I get "Error: Subreport could not be shown" message
The main report does nothing but host the subreport (if I get working, eventually main report will host multiple subreports (graphs))
In Visual Studio online help for Subreports I find:
Subreport
Type or select the name of the subreport to include in the report.
For a report published to a report server configured in SharePoint integrated mode, use a fully qualified URL including the file extension. Relative paths are not supported. For example, http://<SharePointservername>/<site>/Documents/Report1.rdl.
I have tried entering in the FQ URL, but Visual Studio will not compile the report then as it errors saying:
[rsInvalidReportNameCharacters] The ReportName for the subreport €˜TestSubReport€™ is not valid. Item names cannot contain the following reserved characters ;?&=+$,*<>|".
I am trying to create a report with a sub report in Sql Server 2012 using Report Builder Version 3. Â I can run the subreport without any problems. Â I read where using a shared connection can cause this error so both the main report and the subreport use a connection that is embedded in my report. Â
For testing, I created the subreport without a parameter and added it to the main report. Â When I ran it that way, the report worked and sub report displayed the data. Â So I know it can read from the database.It seems to only give me this error when I am trying to tie the two reports together using a parameter. Â
How do I hide a subreport if the parent report row containing the subreport is a certain value? I am attempting to create a statement with ageing buckets. In the main body of the report I have to display payments and invoices. If the invoice row is blank, I need to hide the row containing the subreport.
I have a report which contains a subreport placed inside a list. when the subreport returns no data. it appears as a blank space in the main report. So i want to suppress the list when the subreport returns no data. Can somebody help me with this?
I have some issues regarding subreports placed in table within body of a report. I have a report Edit.rdl(functions as an Edit link) which is called in as a subreport in all Open Issues.rdl(Main Report)
When the same subreport is exported to excel then the following error message is displayed 'Subreports within table/matrix cells are ignored'.I tried to resolve this issue by first placing a list item in the table and then placing the subreport on top of List item but then the error mesage states that 'DataRegions within table/matrix cells are ignored'.
I have one report which has a list with subreports in it. If there is no data, I always got error " An internal error occurred on the report server. See the error log for more details". I tried the "NoRows" property, it didn't help either.
I noticed similar posts within this forum before, but haven't found the solution yet.
I have managed to pass a string parameter form the main report to the subreport with no problems, but when i try and use the same method to pass a datetime type, i am issued with the following error messase:
"[rsErrorExecutingSubreport] An error occurred while executing the subreport €˜SubReportName€™: The value provided for the report parameter 'MasterDate' is not valid for its type."
I cant see why it work for strings, but not for datetime. Any suggestions will be very much appreciated
Presently I have a main report and subreport, with the subreport having values for a carbon copy contact, which when it is displayed it shows these values:  Peter Piper    #Error    #Error   peterpiper@mycompany.com    #Error Donald Duck   #Error    #Error   donaldduck@mycompany.com   #Error etc.  When I run the subreport directly, it correctly returns all the values:  Peter Piper    123-345-6789    Calgary   peterpiper@mycompany.com    T Donald Duck   987-654-3210    Calgary  donaldduck@mycompany.com   F  Here are the details on SQL Server 2008:  Microsoft SQL Server 2008 (SP2) - 10.0.4064.0 (X64)  Feb 25 2011 13:56:11  Copyright (c) 1988-2008 Microsoft Corporation  Standard Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2)  why the #Error is showing up the the main report?
I am creating database with script sql file running in command prompt.The database files are created but database is not shown on SQl Server.. wat am I missing here?The databse script isCREATE DATABASE BudgetON ( NAME = Budget_data,FILENAME = 'c:mssql7dataBudgetdata.mdf',SIZE = 100, MAXSIZE = 500, FILEGROWTH = 25 )LOG ON ( NAME = 'Budget_log',FILENAME = 'c:mssql7dataudgetlog.ldf',SIZE = 5MB, MAXSIZE = 25MB, FILEGROWTH = 5MB )GO
I want to get a average value for one of the column in my report.But when I view the reports those calculated columns are shown as NaN. Does anybody know why this happen?
Here is my query. Also query results pane status indicates cell is read only. I can not figure it out why...
Code Block SELECT COUNT(Account.AccountId) AS NoOfAccounts, SUM(CertificateDeposit.Amount * CertificateDeposit.Csf / 12) AS TotalHelpAmount FROM Account INNER JOIN CertificateDeposit ON Account.Id = CertificateDeposit.AccountFK
Hi all - i'm trying to put together my first .Net web page (have switched from Dreamweaver to VWD - VWD keeps swapping my tab-indents for spaces, and none of the options stop it!).Here's a table that i'm trying to query: ItemID | ReviewRating | ReviewRatingOutOfAs i'm sure you've guessed, it's a reviews table, where there can be several records with the same ItemID and different (or the same) ReviewRating and ReviewRatingOutOf's. As the reviews are collected from lots of sources, the ReviewRatingOutOf will change (one review might be 3/5, while the next, for the same ItemID, could be 8/10, etc). Now, what i'm trying to do is return a list of ItemID's ordered by their RATIO (which is the sum of each ItemID's ReviewRating's divided by the sum of each ItemID's ReviewRatingsOutOf's - in other words, average score). My first guess was this:"SELECT DISTINCT ItemID FROM Reviews ORDER BY SUM(ReviewRating)/SUM(ReviewRatingOutOf)" - unfortunately that doesn't work (problems with the SUM aggregate functions, and overflow errors, whatever they are). Now, this string works: "SELECT ItemID FROM Reviews GROUP BY ItemID ORDER BY SUM(ReviewRating)" - right now, that just adds up the ReviewRatings, so an item with 10 reviews that only got awarded 1/5, 1/10, 1/8, etc (all 1's, therefore achieving a combined ReviewRating of 10 out of a very much higher ReviewRatingOutOf), would appear higher than an item with 1 review that got 5/5. Making the string into this: "SELECT ItemID FROM Reviews GROUP BY ItemID ORDER BY SUM(ReviewRating)/SUM(ReviewRatingOutOf)" (which is what I need), unfortunately gives me errors...Anyone have any ideas? Is there possibly a way to simply read all the distinct ItemID's with SQL, then get the two SUM's for each ItemID, then calculate the ratio of the two SUM's, and stick the ItemID's and the ratio into some sort of array, and have C# order the array for me, based on the ratio? I'd appreciate an example of that if possible, as i'm a complete C# beginner :-)Thanks in advance!
There is something I don't understand. When I use join
SELECT r.CHECK_NUMBER, i.orig_file from (AP_INVOICEDOCS i join AP_DETAIL_REG r on r.PAYABLE_ID= i.PAYABLE_ID)
I am getting 76 orig_file records
But when I do
SELECT r.CHECK_NUMBER, i.orig_file from (AP_INVOICEDOCS i right outer join AP_DETAIL_REG r on r.PAYABLE_ID= i.PAYABLE_ID)
I am showing only 8 records under i.orig_file column and I am not sure why. What I need is to get all the AP_INVOICEDOCS in the matching orig_file records.
i have a problem with a report. if i try it with vs2005 and the preview it works. if i call the report from my web-application i get no error-message, but i only get my headlines and no query-results.
i use reportingservices 2005, vs2005 and .net 1.1 my datasource is an olap-cube.
hi i have generated the rtf from html and this rtf contains an image and some text,the text is shown in reporting services but image is not shown.i am also using the code that is mentioned in this problem. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=738557&SiteID=1 can any body help me out that image is shown at their side in report server? kindly help me out. thanks in advance
I've built a report from a cube that I have had made. After selecting a few dimensions, the columns will be showing a drill down action related to different dates. Problem is, when you preview the report, the dates get alphabetized; they don't show up in an order like dates, days should.
ex: monday, friday, thursday, tuesday, wednesday
or april, august, july, june, may
How can this be changed, or is it related to the dimensions in the way they were made? Possibly something from the tables then? If more information is needed, please specify.
I have a matrix based report running, it shows a pivoted statistical value in the detail cells. Now I'd like 1 of 2 images to show instead, in those cells, based on the value of the statistic. Can this be done in a matrix?
I have data that is grouped by a code number. One of the code numbers have over 600 rows, while other code numbers have around 10 to 20 rows within it.
When I run the report the code number that has over 600 rows gets split over 2 pages while the other code numbers each get their own page.
How do I make it so that when I run the report the code number that has over 600 rows gets all displayed on the 1 page instead of being split over 2?
I am trying to cluster two sql node server on hyper-v both virtual and my situation is below :Â
two hyper-v host connected to vnxe storage two hyper-v are mapped to 3 LUN ( SQL Data , SQL logs , Quorurm) connectivity between hyper-v and storage direct fiber three LUN are mapped to the virtual SQL01 and SQL02  as VHDX and configure it on virtual machine as  IDE below is the pictureÂ
LUNs are presented to the guest SQL01 and SQL02 Â and visible through disk management
When create the fail over cluster i am not getting the disk to add them to clusterÂ
Getting the below error when validate the storage :Â
No Disks suitable for cluster disks were found, For diagnostic information about disks available run the Validate config wizard’..
Also , regarding this LUN how i can make them shared on the host side ?
I'm relatively new to AS2005, so you'll have to excuse me if there is a simple solution that has been overlooked.
Here is the situation - We have a fact table, linked to several dimensions - one of them being a generic date dimension used by a number of fact tables. The Date Dimension has all dates ranging from 1901 to 2100, but the fact table I am querying just has records from 2005 to present. Once the cube is processed and I open the cube in Excel (for example) it lists every date from the Date Dimension, is there any way to limit which dates are processed into the cube to those that just appear in the fact table (in essence - what would be an Inner Join in TSQL).
