Sharepoint SubReport Could Not Be Shown

Oct 24, 2007



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 ;?&=+$,*<>|".



Any ideas??

Thanks

View 7 Replies


ADVERTISEMENT

Error: Subreport Could Not Be Shown.

Jul 16, 2006

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

View 13 Replies View Related

Error: Subreport Could Not Be Shown.

Jan 9, 2007



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.

Running SQL 2005 SP1

Please advise.

View 4 Replies View Related

I Am Getting Error Subreport Could Not Be Shown

Jan 30, 2007

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


Thank you all very much for the info.

View 6 Replies View Related

Error: Subreport Could Not Be Shown.

Jul 18, 2006

Hi,

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

AddHandler ReportViewer1.LocalReport.SubreportProcessing, AddressOf ItemsSubreportProcessingEventHandler

ReportViewer1.LocalReport.Refresh()

End Sub

Private Sub ItemsSubreportProcessingEventHandler(ByVal sender As Object, ByVal e As SubreportProcessingEventArgs)

If odsItems Is Nothing Then

odsItems = LoadItemsData()

If (e.Parameters.Count > 0) Then

If (odsItems.SelectParameters.Count > 0) Then

odsItems.SelectParameters.RemoveAt(0)

odsItems.SelectParameters.Add(New Parameter("questionid", TypeCode.Int32, CInt(e.Parameters(0).Values(0).ToString)))

End If

End If

e.DataSources.Add(New Microsoft.Reporting.WebForms.ReportDataSource("DataSet2_templBPQues", odsItems))

End If

End Sub

Private Function LoadItemsData()

Dim ods As New ObjectDataSource

ods.TypeName = "DataSet2TableAdapters.templBPQuesTableAdapter"

ods.SelectMethod = "GetSubQuestions"

Return ods

End Function

End Class

Default.aspx:

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>

<%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"

Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >

<head runat="server">

<title>Untitled Page</title>

</head>

<body>

<form id="form1" runat="server">

<div>

<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt"

Height="400px" Width="400px">

<LocalReport ReportPath="c:inetpubwwwrootsrstestReport.rdlc">

<DataSources>

<rsweb:ReportDataSource DataSourceId="ObjectDataSource1" Name="DataSet1_templBPQues" />

</DataSources>

</LocalReport>

</rsweb:ReportViewer>

<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" SelectMethod="GetQuestions"

TypeName="DataSet1TableAdapters.templBPQuesTableAdapter"></asp:ObjectDataSource>

<asp:ObjectDataSource ID="ObjectDataSource2" runat="server" SelectMethod="GetSubQuestions"

TypeName="DataSet2TableAdapters.templBPQuesTableAdapter" OldValuesParameterFormatString="original_{0}">

<SelectParameters>

<asp:Parameter Name="questionid" Type="Int32" />

</SelectParameters>

</asp:ObjectDataSource>

&nbsp;



</div>

</form>

</body>

</html>

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.

Any help would be awesome. Thanks.

View 1 Replies View Related

The Dreaded Subreport Could Not Be Shown Error

Aug 10, 2007

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:




Code Snippet



DataView vw;

protected void Page_Load(object sender, EventArgs e)
{
vw = (DataView)SqlDataSource2.Select(DataSourceSelectArguments.None);
rptAllCustomers.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(ProcessSubReports);
}

protected void ProcessSubReports(object sender, SubreportProcessingEventArgs e)
{
//vw.RowFilter = "SALES_INDEX = " + e.Parameters["SaleIndex"].Values[0];
e.DataSources.Add(new ReportDataSource("SALESConnectionString", vw));
}



And the applicable ASPX code:





Code Snippet

<rsweb:ReportViewer ID="rptAllCustomers" runat="server" Font-Names="Verdana"
Font-Size="8pt" Height="400px" Width="100%">
<!%--<localreport reportpath="App_GlobalResourcesSalesByProduct.rdlc">
</localreport>--%>
<localreport reportpath="App_GlobalResourcesBySale.rdlc"><datasources>
<rsweb:ReportDataSource DataSourceId="SqlDataSource1" Name="SalesData_SALES"></rsweb:ReportDataSource>
</datasources>
</localreport>
</rsweb:ReportViewer>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:sales %>"
SelectCommand="SELECT * FROM SALES WHERE SALE_DELETED = 'false'">
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:sales %>"
SelectCommand="SELECT * FROM CUSTOMER_PRODUCTS">
</asp:SqlDataSource>

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.

Anyone have any clues?

View 2 Replies View Related

Error: Subreport Could Not Be Shown. Works For Me But Not Other Users

Sep 20, 2007

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.


Can anyone give me any hints?
Thanks
Rae

View 2 Replies View Related

Linked Report Error: Subreport Could Not Be Shown

Mar 25, 2008

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)?

Thanks,
Richard

View 8 Replies View Related

Error: Subreport Cannot Be Shown - Show The Error?

Jan 4, 2008



Ive seen a few posts with the same title but none of them asked this question. At least what I found.

I am trying to get my subreports to show up. However, all I can get them to say is Error: Subreport could not be shown.

How can I get the error that the subreport is throwing? My environment is VS 2005

Thanks.

View 7 Replies View Related

SQL 2012 :: SharePoint 2013 Hosted SSRS - Subreport Consolidate To A Single Folder

Jan 13, 2015

I am in the process of migrating 300+ reports and 200ish subreports to SharePoint 2013 hosted. I wanted to avoid the duplication of creating copies of all the subreports across 9 different folders.

View 0 Replies View Related

Reporting Services :: Report Builder V3 Subreport Data Retrieval Failed For Subreport

Nov 3, 2015

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.  

View 2 Replies View Related

Reporting Services :: Hiding Subreport If Parent Report Row Containing Subreport Is A Certain Value

Jul 14, 2015

Using SSRS 2014 and VS2013 rc5.

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.

First, Is this even possible?
Second, How?

View 10 Replies View Related

How To Suppress A List Containing A Subreport, When The Subreport Returns No Data

Dec 16, 2006

Hi,

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?

thanks
shri

View 1 Replies View Related

A Subreport Which Aslo Has Another Subreport In A Master Report

Mar 17, 2008



Can we include a subreport which aslo has another subreport in a master report? (assuming all three reports have parameters too)

Thanks

View 4 Replies View Related

Reporting Services And Sharepoint Integration - Sharepoint Alternate Access Mappings (Zones)

Mar 2, 2007

I get the following error when I try to navigate to a report/model/data source, stored in a Sharepoint Document Library using a Sharepoint URL based on an Extranet or Intranet zone - but it works OK using the url for the Default zone:

System.Web.Services.Protocols.SoapException: The specified path refers to a SharePoint zone that is not supported. The default zone path must be used. ---> Microsoft.ReportingServices.Diagnostics.Utilities.SecurityZoneNotSupportedException: The specified path refers to a SharePoint zone that is not supported. The default zone path must be used.


Is this a limitation of the SQLRS-WSS3 integration or is there a workaround?

Many thanks to anyone who can help!





View 22 Replies View Related

Sharepoint Integration Microsoft.ReportingServices.SharePoint.UI.WebParts.dll

Feb 2, 2007

Does anyone know the location of Microsoft.ReportingServices.SharePoint.UI.WebParts.dll after you install the web part? I am wondering if I can inherit from this web part to wrap some other functionality into it. I know that i see it in the GAC buyt can't seem to find it so I can look at the assembly using reflector.

Also, how easy is it to pass in parameters to the Report Viewer?

Thanks!

Erik



View 6 Replies View Related

Problems With SharePoint Integration And Reporting On SharePoint With SSRS

Jan 17, 2008

Since I wasn't getting any replies with answers or suggestions to my initial posting, I figured I would continue to list the problems and solutions I've encountered while trying to setup and utilize SharePoint integration mode, and read data from SharePoint with SSRS reports (developed in VS2005). Hopefully this is helpful to anyone that is also trying to learn all this stuff and figure it out.

(Single server - W2K3R2_SP2 as: DC / SQL2005 Standard / MOSS2007 Enterprise - see the bottom of this posting for the steps I took to set that up)

Note: After I get this to work, I intend to post my experiences for setting up SharePoint Integration with SQL and SP on separate boxes.

1. In the new reporting section under SharePoint application management in the Central Admin Console, the Grant database AND Set Server Defaults work when using the domain admin account, but not when using the SQLSPS service account I used to setup both SQL and SharePoint. Why can't I use the service account? Is the domain admin account now going to be used as a service account for accessing the sharepoint database?


This question remains unanswered as of yet.

2. Reporting Services configuration tool shows Sharepoint integration as red x when I create a new database in integration mode. (the service account SQLSPS and the Server object are members of the group WSS_WPG). If I switch back to native mode (the original reportserver database), the red x goes to a blue exclamation instead. Using Service Credentials or Windows credentials (as either the service account SQLSPS or as domain admin) doesn't change anything.


RESOLVED by using a domain user account for the ReportServer WebApp. Even though everything is installed on the same machine, it seems using the default of NETWORK SERVICE wasn't acceptable. Possibly because SharePoint is configured to allow additional machines in the farm?

3. http://servername:8080/reportserver will display Report Server information as it did before the integration on port 80, but http://servername/reportserver doesn't display anything through SharePoint.


Resolved. I needed to define a repository before I could view it (go figure). When I created a sharepoint site based on a report center template, created a data connection library and report library, and then referenced that by http://servername/sites/myReportCenterSite/myReportLibrary, I was able to see the equivalent of http://servername/reports (which is now disabled due to integration mode).

4. Unable to deploy to new report center sharepoint site I mention above using Visual Studio. I kept getting "A connection could not be made to the report server http://servername/sites/ReportCenter. Server was unable to process request. The request failed with HTTP status 503: Service unavailable (System.Web.Services). In Visual Studio, the project properties were: TargetDataSourceFolder = http://servername/sites/myReportCenterSite/myDataConnectionLibrary, TargetReportFolder = http://servername/sites/myReportCenterSite/myReportLibrary, TargetServerURL = http://servername/sites/myReportCenterSite/


Found these errors in the event logs on the server.

Event Type: Warning
Event Source: W3SVC
Event ID: 1021
Description:
The identity of application pool, 'ReportServer' is invalid. If it remains invalid when the first request for the application pool is processed, the application pool will be disabled. The data field contains the error number.

Event Type: Warning
Event Source: W3SVC
Event ID: 1057
Description:
The identity of application pool 'ReportServer' is invalid, so the World Wide Web Publishing Service can not create a worker process to serve the application pool. Therefore, the application pool has been disabled.

Event Type: Error
Event Source: W3SVC
Event ID: 1059
Description:
A failure was encountered while launching the process serving application pool 'ReportServer'. The application pool has been disabled.

RESOLVED the issue by changing the Application Pool used by reporting services from ReportServer to DefaultAppPool and changing the account DefaultAppPool used from NETWORK SERVICE to my service account SQLSPS. I have no idea why ReportServer is invalid, it was set to use the service account SQLSPS the same as DefaultAppPool is. Perhaps the reporting services add-on makes a change to invalidate this?

5. Attempting to read a SharePoint list using a SSRS report. This should be fun.

First, created a new custom list in the ReportCenter SharePoint sites I've been using and called it myCustomList. I added one item with a title of myCustomListItem1. I don't know if I need to do more than that for a simple test of reporting or not yet.

Second, configured new shared data source. Name = myCustomList1DataSource, type=XML, Connection String = http://servername/_vti_bin/lists.asmx (this URL is viewable in IE), Using Windows authenticaion.

Third, in VS2005 on a workstation in the domain, create new report item (report1.rdl). New dataset for report; Name=Report1DataSet, Data Source=myCustomList1DataSource (Shared), Command type = text, Query String = [See Queries and associated errors below]:

Initial query obtained from: Connecting SQL Reporting Services to a SharePoint List (David Wise)
http://www.sharepointblogs.com/dwise/archive/2007/11/28/connecting-sql-reporting-services-to-a-sharepoint-list-redux.aspx

Note: Queries when executing the dataset (which errors out) and when executing a query in CAML Viewer for the same information (which does work just fine) both initially return 401.1 and 401.2 errors (as viewed in Fiddler). Since the CAML query works, I have not tracked this down yet.


A. Original format from posting



<Query>
<Method Namespace=http://schemas.microsoft.com/sharepoint/soap/ Name="GetListItems"/>
<SoapAction>
http://schemas.microsoft.com/sharepoint/soap/GetListItems
</SoapAction>
</Query>


Parameter; Name => listName, Value => =myCustomList

Was NOT prompted to define the query parameters


- Gets this error: "An error occurred while setting the command text property of the data extension command. The XmlDP query is invalid. (Microsoft.ReportingServices.DataExtensions)."


- Advanced information from the error => 'http' is an unexpected token. The expected token is '"' or '''. Line 2, position 19. (System.Xml)

B. Changed: Placed the namespace URL in quotes (also tried with and without / in namespace after /soap)

<Query>
<Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems"/>
<SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems
</SoapAction>
</Query>

Parameter; Name => listName, Value => =myCustomList (also tried Value => myCustomList) (no equal sign)

Clicked "!" to execute, and got prompted to define the query parameters
Entered Name => listName, Value => myCustomList

- Gets this error: "failed to execute web request for the specified URL (Microsoft.ReportingServices.DataExtensions)."

- Advanced information: <faultstring>Server did not recognize the value of HTTP Header SOAPAction: http://schemas.microsoft.com/sharepoint/soap/GetListItems/.</faultstring>


C. Try the query string that seems to work for Stramit CAML Viewer to read myCustomList

Stramit CAML query:
<Query xmlns="http://schemas.microsoft.com/sharepoint/soap/">
<OrderBy>
<FieldRef Name="ID" />
</OrderBy>
</Query>

Also tried
<Query xmlns="http://schemas.microsoft.com/sharepoint/soap/">
</Query>

And tried entering no query...

Parameter; Name => listName, Value => =myCustomList (also tried Value => myCustomList) (no equal sign)

Clicked "!" to execute, and got prompted to define the query parameters
Entered Name => listName, Value => myCustomList

- Gets this error: "failed to execute web request for the specified URL (Microsoft.ReportingServices.DataExtensions)."



- Advanced information: <soap:Fault><soap:Code><soap:Value>soap:Receiver</soap:Value></soap:Code><soap:Reason><soap:Text xml:lang="en">Server was unable to process request. ---&gt; Data at the root level is invalid. Line 1, position 1.</soap:Text></soap:Reason><soap: Detail /></soap:Fault>

RESOLVED. Went back to the query used in B above, and mysteriously it works now. This could be the "funny things happen" symptom I've been reading about. We'll see if it continues to function.

Here's what I've learned so far on Issue #5:

1. XML is confusing. XmlDP is even more confusing...whatever that is. Apparently it's new to/with Reporting Services in SharePoint integration mode?
2. There is far too little documentation regarding XmlDP and querying SharePoint lists from SQL Reporting Services.
3. According to http://msdn2.microsoft.com/en-us/library/ms159741.aspx: You must use the generic query designer to create the query. The query is not analyzed to identify parameters; therefore you must create parameters through the Parameter tab on the Dataset dialog box.

Tried this query:

<Query>
<SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction>
<Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems" />
<Parameters>
<Parameter Name="listName">
<DefaultValue>myCustomReport2</DefaultValue>
</Parameter>
<OrderBy>
<FieldRef name="ows_Date" />
</OrderBy>
</Parameters>
</Query>
I was still prompted for the listName and the list returned with ows_Date still out of order. So maybe that proves this statement is true?
<translation: why make it convenient when it's already [somewhat] functional?>
4. When building the dataset, anything I place in the "Query string" box has to be enclosed in <query></query> tags or it errors out. I am trying to understand how to translate the CAML viewer query (which does work but isn't wrapped in query tags) into something that fits between query tags, and it hasn't gone well so far.
<translation: To be at one with your reports Grasshopper, you must understand xml>
5. According to http://srv1/sites/ReportCenter/_vti_bin/lists.asmx, "GetListItems" operation is supported
<translation: you're getting warmer...>
6. According to the soap output of my site http://srv1/sites/ReportCenter/_vti_bin/lists.asmx?op=GetListItems, I am only allowed to specify the following parameters: listName, viewName, query, viewFields, rowLimit, queryOptions and webID.
<translation: that and $3.00 will get you a cup of coffee>
7. According to http://www.sharepointblogs.com/dwise/archive/2007/11/28/connecting-sql-reporting-services-to-a-sharepoint-list-redux.aspx, only listName, viewName and rowLimit parameters are usable(?) (query and queryOptions may not be working properly with SSRS).
<translation: that kind of sucks>
8. When this started mysteriously working again, I tested using the "/" at the end of the namespace (wouldn't work without) and the "=" sign in front of the parameter value as defined on the parameter tab of the dataset (turns out to be optional).

As long as I can query SharePoint and get my list information back, I'm going to consider this issue closed and move on to actually using this information in a report. I'm sure that won't work right either, but why stop now?!

6. Ok, now that I can read SharePoint list data with SSRS, I need to try and actually do something with it.


A. Begin by setting up new data to report on


1. Create a new custom list (myCustomList2) and add a test record. This list will simulate the data we intend to submit to SharePoint using InfoPath, so it has a number of custom/created columns in it


2. Modify the working information from #5 above; add a new shared data source (myCustomList2DataSource), tell the dataset to use the new shared data source, change the information set in the parameter tab (Name => listName, Value => =myCustomList2) and test the dataset. Lucky me, it actually returned the record I entered on the first try.

B. Begin to build the report with the dataset returned

1. So, as I'm feeling good that it's actually reading the list in Step A without me threatening to destroy the machine, I look to the left in the Dataset results navigation pane in VS2005 and realize there are NO fields for me to choose to report on.
2. At this point, I have no clue what to do about getting this XML data into a report. Not that I have a large clue about SSRS otherwise, but I have at least been able to build SSRS reports when using a SQL database as the datasource. Fyi, http://msdn2.microsoft.com/en-us/library/ms159741.aspx states: "Reports can use data from XML documents and Web services, or embed XML in the query. There is no built-in support for retrieving XML documents from a SQL Server database.", in case anyone is trying to do that....

RESOLVED. Since the fields were not appearing automatically, I had started to add new fields to the dataset manually (if it doesn't work, beat it with a hammer, right?). I entered half a dozen or so fields, each one with the exact name as displayed in the query results, and then decided it would be fun to hit the refresh fields icon. As soon as I did that, all the fields shown in the query immediately appeared in the dataset and I was able to add them to a report. I don't know if I hit the refresh fields when working in issue #5, so I can't say if they are there now because of that, or because of adding some fields manually first, a combination of the two, or if it's just one of those mystery items I'm reading about with sharepoint reporting.

7. Rows are being returned even though they have NULL values (so far anyway), and most data is returning nicely for the bulk of the columns I created in the list I'm reporting on. Here are the current issues:


A. I have one column in my SharePoint list that is multi-lined text. If the text type is either rich text or enhanced rich text, the value returned in the query is formatted like this: "<div class=ExternalClassyadayada<div>My notes display here". If I set the column to be plain text, this doesn't happen. I will need to figure out how to filter that for my report.


RESOLVED. David Wise had some code listed at http://www.sharepointblogs.com/dwise/archive/2007/11/28/connecting-sql-reporting-services-to-a-sharepoint-list-redux.aspx that addressed this issue somewhat. I modified it to match my circumstances. Disclaimer: I'm not a programmer, so use this at your own risk.


function ExtractMultiLineText(myField as string) as string
dim strBegin as string
dim strEnd as string
dim myBegin as integer
dim myEnd as integer
dim myTextLength as integer
strBegin = "<div>"
strEnd = "</div>"
if myField = nothing then return ""
if myField = "" then return ""
myBegin = Instr(myField, strBegin) + Len(strBegin)
myEnd = Instr(myField, strEnd)
myTextLength = myEnd - myBegin

if myBegin < 1 then return myField
return mid(myField, myBegin, myTextLength)
end function

B. I have two columns in the SharePoint list that are set as number values with 0 decimal places. When I query those however in SSRS, they return with the number plus like 12 zeroes behind the decimal. Not a major issue, but I'll put it on the list anyway.


RESOLVED. Used the Int() function; =Int(Fields!ows_myProblemNumber)

C. If I go to "/_vti_bin/lists.asmx?op=GetListItems", it appears from the sample soap output that I am allowed to ask GetListItems for is: listName, viewName, query, viewFields, rowLimit, queryOptions and webID. As I mentioned in issue #5, according to http://www.sharepointblogs.com/dwise/archive/2007/11/28/connecting-sql-reporting-services-to-a-sharepoint-list-redux.aspx, only listName, viewName and rowLimit parameters are usable(?) and query and queryOptions may not be working properly with SSRS.

So, if I can't put anything other than this in my query string;

<Query>
<Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems"/>
<SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction>
</Query>
and I only have a couple parameters to pass on top of that, then it appears to me that my options for filtering the amount of data returned from the SharePoint list is to figure out a way to do it with expressions in the parameters or in the report itself. Am I missing something? Is this really all I get to work with out-of-the-box?


More to come...


==================================
Installation steps taken to build the server VM:
==================================

(Using VirtualPC 2007)
1. Build OS (2003R2SP2) and promote to DC

1a. Create domain user service account SQLSPS
2. Prep for SQL

2a. Install ASP.NET, IIS (www) and .NET 2.0
3. Install SQL/SSRS 2005 Std

3a. Verify SSRS works
3b. RS config tool shows SP integration as blue exclamation
3c. Use service account SQLSPS for anything requiring Windows credentials
4. Install SQL2005 SP2

4a. Verify SSRS works
4b. RS config tool shows SP integration as blue exclamation
5. Prep for SharePoint

5a. Install .NET 3.0
6. Install MOSS2007 Enterprise and configure

6a. Webapps, SSP and anything else use svc acct SQLSPS
6b. Move Default website to port 8080 and re-activate (SharePoint stopped the site)
6c. Verify SSRS works on 8080
7. Install Reporting Services Add-in
8. Create new RS database in integration mode (with service credentials)

8a. RS config tool shows SP integration as red x
9. SP central admin /application management / manage integration settings

9a. reports server = http://srv1:8080/reportserver (since default port has been moved to 8080)
10. SP central admin /application management/grant database access

10a. using the FQDN, confirm servername and default instance - click OK
10b. Prompted for an account to use to retrieve information; svc acct SQLSPS did not work, domain admin did though
11. SP central admin / application management/set server defaults

11a. Accepted all defaults
12. Verify reportserver answers at http://srv1:8080/reportserver (via reportserver AppPool and DefaultAppPool)
13. Changed the application pool identity for the ReportServer AppPool from Network Service to the domain user service account I used for all SQL and SharePoint configurations (SQLSPS) and rebooted. The red x for sharepoint integration in the RS configuration tool is now a green checkmark.

View 7 Replies View Related

Database Not Shown

Jul 23, 2005

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

View 2 Replies View Related

NaN Is Shown In My Report

Oct 23, 2007

Hi All,


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



Please can anyone help me?

View 3 Replies View Related

Help With SQL Group By Please (results Returned Into / Shown In C#.Net)!

Oct 16, 2006

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!

View 7 Replies View Related

Number Of Records Shown Are Not Matching

Sep 12, 2013

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.

View 3 Replies View Related

Only Last CRI Output Image In Subreports Is Shown

Dec 2, 2006

I've implemented quite a number of CRI ( Custom Report Item ).

If I dropped it on a matrix so that I can have multiple CRI output images rendered it works well.

However, I'm trying it out on a table in which I've included a subreport. The subreport is a report that uses the CRI for one record.

I'm seeing only the last output image, the rest of the CRI output image are not shown, instead a red x image is show.

Anyone have any idea why this happens and how I can resolve the problem?

Using the matrix is not an acceptable workaround for me.

View 3 Replies View Related

No Query-results Shown In My Report

Oct 17, 2007

hi,

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.

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

ReportExecution.ExecutionInfo ei = repExecution.LoadReport(ReportPath, historyID);



repExecution.SetExecutionParameters(convertToReportExecutionParameter(Parameters), "de-AT");

result = repExecution.Render(Format, devInfo, out extension, out mimeType, out encoding, out warnings, out streamIDs);

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

do you have any idea?
thank you

harald

View 1 Replies View Related

RTF Image In A SQL Server Report Not Shown

Jan 25, 2008


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

View 1 Replies View Related

Dates Get Alphabetized When Report Is Shown

Mar 28, 2007

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.



Im running Sql 2005 Developer Edition, with BIDS.

View 5 Replies View Related

Can An Image Be Shown In Matrix Detail?

Dec 31, 2007

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?

View 1 Replies View Related

Need All Rows Within Each Group To Be Shown On 1 Page

Jan 2, 2007

Hi,

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?

Thanks

Ben.

View 10 Replies View Related

Recovery :: Disk Not Shown By Cluster

Nov 5, 2015

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 ?

View 3 Replies View Related

Only Max Date Record Should Be Shown For Every Student

May 25, 2015

I have a table which shows data in below format

Now I need that only the max date record should be shown for every student as shown below...

View 8 Replies View Related

Reduce Records Shown From Dimension

May 22, 2007

Hi There,



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).



Hope this makes sense,



Regards,



Tobias

View 7 Replies View Related

Convert Datetime To Integer Value As Shown Within Brackets

Dec 23, 2014

Iwant to convert the datetime to the integer value as shown within the brackets.

----2014-12-21 0:00:00 (1419091200000)

View 1 Replies View Related

Report Builder Cannot Be Shown On Other User Login

Jan 16, 2007

Dear all specialists,

I am encountering a situation that the report buider feature cannot be shown on other user login. Would you guide me to solve this issue ?

Thanks for your help

Gary Ho

View 2 Replies View Related

Delete Rows While Table Is Shown On DataGrid

Oct 2, 2007

Hi All,
I have a program which shows some manipulate data from 2 tables on a datagrid.
I'm using another program to delete rows from both tables. (The second program activate from the PC using the RAPI dll).
I have sometimes a problem deleting records.
Actually the Datagrid is not suppose to be shown when the user use the second program, but since I'm not able to determine whether my first program is still running or not, is there an option to force the delete even if other program is using it?
If not, is there a way to stop the first program?

Thanks in advance

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved