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
ADVERTISEMENT
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
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
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
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
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
Feb 21, 2008
Hi everybody,
I'm quite new in Reporting Services and have the following problem:
I created a report which is getting its data from 5 different databases. For every database I made a subreport to get the data. In the preview and on the Reporting Server all the data is displayed find. Now I want to export the report to an Excel sheet which does work. But where the data from the subreports is to be shown it just says that subreports in table-cells has been ignored.
Another problem is that the way the report looks in the preview is fine - on the reporting server the columns are far to wide. I allready marked that the width should be fixed.
Some more information: in the main report some cells are merged. In these merged cells is the data from the subreport to be shown. The subreport displays the data in a table which has exact the same amount of colums (and the same size) the cells in the main report had before merging.
Thanks in advance,
Steph
View 5 Replies
View Related
May 8, 2007
Is there any way in which i can carry or retain the tooltip value which is shown on my report into Excel sheet ....
i mean when i export the report into Excel sheet, tooltip value is gone?? how can i retain the tooltip value when i export into excel ??
is it possible if so ...any hints??? thanks a lot in advance
View 4 Replies
View Related
Jan 16, 2006
I am not aware of this if it exists in MS SQL server. But I need to return results in alphabetic order ignoring "The" if it's the first word of a title...
so for example title "The Cliffhanger" would be returned along with other titles that start with letter C, but "The" also must be returned as part of the title, but just ignored while alphabetizing.
I'm sure that I'm not the first one to ever need this and don't want to re-invent the wheel, so if you have any ideas as to the best way to accomplish this, help me out.
Thanks in advance.
View 8 Replies
View Related
Jan 23, 2008
Hi:
I made a report that is 10 pages long. I like to show all the data in one page (after deployment). Any idea if this is possible?
View 8 Replies
View Related
May 4, 2007
I'm trying to create a heading for my report.
I want
sales figures between 09/11/2006 to 09/04/2007.
The date comes from parameters
What I have done is created 4 text boxes
textbox 1 = sales figures between
textbox 2 = =datepart("D", Parameters!param_datef.Value) & "/" & datepart("M", Parameters!param_datef.Value) & "/" & datepart("YYYY", Parameters!param_datef.Value)
textbox 3 = To
textbox 4 = =datepart("D", Parameters!param_datet.Value) & "/" & datepart("M", Parameters!param_datet.Value) & "/" & datepart("YYYY", Parameters!param_datet.Value)
Ok the problem is the text boxes when previewed are all over the place.
In crystal reports you can add a formula into a text box after text
Is this sort of thing possible in Reporting services
Thanks for all your help
View 3 Replies
View Related
May 25, 2007
I need to display 12 months dynamically in columns of a matrix report, starting with the current MMM, yy - 3 in the first column, current MMM, yy and incrementing by 1 month in columns 2-12.
For example a report that would run on today's MM, yy (5/2007) would look something like this:
MAR-07, APR-07, MAY-07, JUN-07, JUL-07, AUG-07, AUG-07, SEP-07, OCT-07, NOV-07, DEC-07, JAN-08, FEB-08
(Col 1 - Col 12 separated by commas)
How do I do this in a matrix report column?
View 1 Replies
View Related
Jul 24, 2015
 I've a requirement per below business rule to change the Scheduled Delivery Date on the report. Below is the DDL:
1) If the Job has a batch number, the Scheduled Ship Date will be next monday to Requested Delivery Date. Say for example if the job has Requested Delivery Date as 2015-07-29 and it also has a batch number then Scheduled Ship Date will be 2015-08-03.
2) If the Job does not have a batch number then the Scheduled Ship Date will be the Monday before the REquested Delivery Date. Say for example if the Job J012347 has Requested Delivery date as 2015-08-04 and it does not have batch number then the Scheduled
Ship Date will be the Monday before i.e. 2015-08-04.Â
Similarly if the Requested Delivery date is 2015-08-07 and it does not have a batch number then Scheduled Delivery Date will be 2015-08-03.
DECLARE @Date datetime;
SET @Date = GETDATE();
DECLARE @TEST_DATA TABLE
(
DT_ID INT IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED
,JobNumberVARCHAR(10) NOT NULL
,JobStatus CHAR(1) NOT NULL
[code]....
View 6 Replies
View Related
Jul 23, 2005
I have a table containing typed log entries. One log entry is supposedto be created every twelve hours, but sometimes there are gaps. I needto create a report showing the time of entry, and the actual log entry.I can't just list the contents of the log table, because if I do thatthere will be dates missing. Instead, when there isn't a log entry fora date, I need to print the date, and then just leave the log entryblank.The SQL bellows shows what the output should look like. HOWEVER, thecode below makes use of a temp table containing all possible dates. Myquestion is, is there a better way to do this - one that doesn'tinvolve the temp table? Thanks in advance.create table StationLog (LogDate datetime, LogText char(11))insert StationLog values ('1/1/2005 00:00:00','entry one')insert StationLog values ('1/1/2005 12:00:00','entry two')insert StationLog values ('1/2/2005 00:00:00','entry three')insert StationLog values ('1/3/2005 00:00:00','entry four')create table Date_List (TempDate datetime)insert Date_List values ('1/1/2005 00:00:00')insert Date_List values ('1/1/2005 12:00:00')insert Date_List values ('1/2/2005 00:00:00')insert Date_List values ('1/2/2005 12:00:00')insert Date_List values ('1/3/2005 00:00:00')insert Date_List values ('1/3/2005 12:00:00')select TempDate, LogTextfrom Date_Listleft outer join StationLog on Date_List.TempDate = StationLog.LogDatedrop table StationLogdrop table Date_List
View 6 Replies
View Related
Dec 12, 2007
hai, iam new to ssrs pease help me below calculations.iam taking the parameters as
begin date,Enddate,region,year,site,
My report having outstanding bills information, i need to calculate, here resters are nothing but students, you take any relavent input data.
1)Rosters Outstanding 6-10 Days (Rosters expected, but not received for up to 10 days in the rears),
2)Rosters Outstanding > 30 Days
3)Rosters Current (Rosters expected as of the report end date)
4)Total # Rosters Outstanding (Total rosters expected, but not received)
5)Rosters Queued For Entry Into 3rd Party Systems (Total rosters entered into the SIS System and expected to be entered into, but not already in 3rd party systems)
6)Rosters Entered Into 3rd Party Systems (Total rosters entered into 3rd party systems)
7)Display Total Billable Dollar Amounts Associated With All Outstanding Rosters For All Aging Columns At Bottom Of Report By Daily, Weekly, Monthly, SYTD
thanks
View 1 Replies
View Related
Oct 26, 2015
I have a report that uses several filters including a from and to date filter, I have a field named TimeLastMod which is a Timestamp. I am extracting the From and To dates from this field using Select format(TimeLastMod,'MMM') as FromMonth,format(TimeLastMod,'MMM') as ToMonth From Eventlogs syntax.
These I pass on to a parameter and eventually to a tablix filter in an between opeartion. When I run the report, the records returned by the report is not what is expected as it sometimes returns an extra months data e.g., using between Aug and Sept will return october data as well.
View 5 Replies
View Related
Mar 29, 2007
Hi all,
I am trying to use the custom code in the report but I don't think I am understanding how this is being used.
I have a function to get starting months for a report parameter.
The function is below:-
--------------------------------------------------------------
Shared Function GetStartingMonths() as String
dim strDefault as string
dim CurrentMonth as String
Dim SqlString as String
'strDefault = Month(Now) & "/1/" & Year(Now)
CurrentMonth = "5/1/2002"
Do While CDate(CurrentMonth) <= Now
SqlString = SqlString + "Select " & CurrentMonth & " as value, " & MonthName(Month(CurrentMonth)) & " " & Year(CurrentMonth) & " as MonthYear"
CurrentMonth = dateadd("m",1,CDate(CurrentMonth))
if Cdate(CurrentMonth) = Now then
Exit Do
else
sqlString = SqlString & " Union "
end if
Loop
return SqlString
End Function
---------------------------------------------------------------
what i am trying to do here, and hopefully produce a sql string that would fill my dataset of dates and their representation.
In the dataset, I had put the following expression
=Code.GetStartingMonths()
However, I can't seem to get the parameter to display the dates. shows up as disabled in my report.
Am I doing something wrong here or is there a better way to doing this ?
Additionally, I was wondering whether there is a better SQL code that would achieve the same thing I am doing ?
thanks !
Bernard Ong
View 15 Replies
View Related
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
Mar 2, 2006
SQL 2005 Dev
How can I do this with Parameters? I can get a single parameter to filter for a single date (or even a combo list of the dates in DB). But I want my parameters to interact so that they specify a range. Is this possible?
View 3 Replies
View Related
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
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
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
View Related
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
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>
</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
Jul 18, 2014
Today I have got one scenario to calculate the (sum of days difference minus(-) the dates if the same date is appearing both in assgn_dtm and complet_dtm)/* Here goes the table schema and sample data */
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[temp_tbl]') AND type in (N'U'))
DROP TABLE [dbo].[temp_tbl]
GO
CREATE TABLE [dbo].[temp_tbl](
[tbl_id] [bigint] NULL,
[cs_id] [int] NOT NULL,
[USERID] [int] NOT NULL,
[code]....
View 9 Replies
View Related
Jul 21, 2014
I'm trying to create a report which will give me a break down of how many unique vehicles have been seen between two dates via a 15 minute interval and what Lane they were seen. My current script looks like this
SELECT l.Name [Name], count(l.Name) Total, p.Created
FROM PlateReads p
inner join Lanes l on p.Lane_ID = l.ID
where LicencePlate in (Select Plate from LPRnet_MelAir_C.dbo.TempVehiclePlates)
group by Name
Name being the Lane they were in and the Total being the amount of times a unique vehicle has been seen and p.Created being the date they were seen (thats what I need the interval powered off)
Ideally the output would look like this
16/03/201408:00 to 08:15Bus Lane 15
16/03/201408:00 to 08:15Elevated Road150
16/03/201408:00 to 08:15Public Pickup75
16/03/201408:15 to 08:30Bus Lane 13
16/03/201408:15 to 08:30Elevated Road120
16/03/201408:15 to 08:30Public Pickup55
All the way to 12/04/2014
I’ve got it so it says Lane and Count just can’t get the interval part
View 5 Replies
View Related
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
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
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
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
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
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
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
