.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Sum function giving error in SSRS 2008

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :Windows Application


 Below expression is giving #Error in SSRS 2008, but working fine in SSRS 2005.


Note: When i export the report result to excel sheet sum value is showing correctly.

Let me know if any one know about this error.




View Complete Post

More Related Resource Links

ssrs 2008 R2 - report parameter with no default set throws java script error

We have recently upgraded from SQL Server 2008 to SQL Server 2008 R2....I am experiencing a problem with my report parameters on my SSRS reports. It seems that my report parameters that I do not have a specified 'default' value throws a java script error when I try and run/render the report under R2.  As soon as I put a 'default' value on the report param, everything is fine.  However, that is not the behavior we need for our reports...the user needs to pick their selection. Can anyone shed some light on this, it seems to be an AJAX problem...I need to be able to have report parameters with a list of values, but no 'default' value on the parameter.

[SSRS 2008 R2]Report Builder Access error-The remote server returned an error: (401) Unauthorized.

Hello,        I am able to login Web Service URL and report manager using computer name and report builder is also working fine.  http://RPTSRV/reportserver   (RPTSRV is report server name. web service url working fine. all accessible) http://RPTSRV/reports  (report manager working fine and all accessible ,report builder too) It means I am able to access everything locally right? http://rs.test.abc.com/reportserver  (web service url working fine. all accessible)  http://rs.test.abc.com/reports    (Report manager working fine and all accessible accept report builder)(I carefully checked the link and its taking rs.test.abc.com/reportserver.....)     when I click on reportbuilder button in report manager it shows me error dialog box with following error log!! I tried from local and remote computer too but gives the same error both side. I am not sure but I am just thinking is this double hop kerberos security issue? Please help me to solve this problem. I am finding solution from last 4 days. Reporting Service configuratin tool settings Web Serivice URL -  all set to default Report Manager URL - all set to default Environment - Distributed deployment Server1(report_srv) --Windows server 2003, Installed sql server 2008R2 reporting service,

"Service not available " Error in SSRS 2008

HI ALL, I Have created few reports in SSRS 2008 and deployed to report manager,though reports are working fine in it but sometime what happens when we click any reports its shows error "Service UnAvailable". after getting that report ,i simply close the window and open again after 10 or so ,again it work fine . Please suggest whether its a bug in report manager or i am commited some mistakes over it.   Regards Amit.

SSRS 2008 error - Sys.WebForms.PageRequestManagerServerErrorException: status code 12029



I am executing a huge report in SSRS 2008, after some time the report doesn't renders and there is an error icon at the left bottom of the web page. When I click open it to see the details, it gives following error;

Sys.WebForms.PageRequestManagerServerErrorException: An unknown error occurred while
processing the request on the server. The status code returned from the server was: 12029.

Any help on this will be appreciated.


SSRS 2008 R2 Email error


I'm attempting to ude the email notification through a subscription in SSRS 2008 R2 but am getting the following error:

An error has occurred during report processing.

The logs say:

library!WindowsService_19!720!09/24/2010-10:10:25:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: AuthzInitializeContextFromSid: Win32 error: 5; possible reason - service account doesn't have rights to check domain user SIDs., Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;
processing!WindowsService_19!720!09/24/2010-10:10:25:: e ERROR: An exception has occurred in data set 'ComponentList'. Details: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error.
processing!WindowsService_19!720!09/24/2010-10:10:25:: i INFO: DataPrefetch abort handler called for Report with ID=. Aborting data sources ...
processing!WindowsService_19!720!09/24/2010-10:10:25:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: , Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingS

Error SSRS 2008


I would like to save a Report as PDF.

It says an error; Invalide URI: The hostname couldnt be parsed.


What does that mean? It works on the others.



One who can read, have a clear advantage!

SSRS 2008 ERROR - rsProcessingAborted:System.ArgumentOutOfRangeException: Index was out of range. Mu



I am using SQL Server 2008 R2 Ent. Edition 64 bit reporting services. The source data for report is at remote server and it is SQL Server 2005 Ent. Edition (though I don't think this matters here.) I have set the <WorkingSetMaximum> to 5GB for SSRS

I am testing the performance of report server and running a report with 100K records with 20 concurrent users. All 20 reports gets executed successfully. When I try with 25 or 30 users only 21 reports execute successfully when I see the ExecutionLog table. I see this exception in the report service log file. Please help.

ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: , Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
   at System.ThrowHelper.ThrowArgumentOutOfRangeException()
   at System.Collections.Generic.List`1.get_Item(Int32 index)
   at Microsoft.ReportingServices.ReportIntermediateFormat.Persistence.IntermediateFormatReader.RemoveReadOnlyMembers(List`1 declarations)
   at Microsoft.ReportingServices.ReportIntermediateFormat.Persistence.IntermediateFormatReader..cto

SSRS 2008 R2 error


I wrote a custom function in a ssrs 2008 r2 report and tried to reference it in an experssion on a parameter, but I keep getting this error message "the defaultvalue exprsssion for thre report parameter "parm1" contains an error: Request for the permission of type 'Sytem.Security.Permissions.UIPermission, mscorlib, Version=, Culture=neutral, PublicKey Token=b77a5c561934e089' failed."

My expression looks like this:  =Code.functioname(value1, value2)

I there  a security setting I need to make to get this to work?


Thanks in advance.




ssrs 2008 reports Datasource error in Test server..


Hi ,

 i Have upgraded my Reports from Report server  VS 2005 to  VS 2008 .

My reports works fine in local, development & test server.

After Ugrading to 2008 it works fine in local server & devlopement serverr.

 When i deployed to Test server i am trying to access my reports i am getting below errors,

 An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection) For more information about this error navigate to the report server on the local server machine, or enable remote errors ..

i checked the Datasource conncetion properties..its pointing to correct Test database only..

My reports are windows integrated...

Now it works in srs 2005 developement & test server. For same properties it works in dev server,  it  doesn't works in srs 2008 test server.


Why? Can anyone give me some idea...?


Word Export error when orientation is Landscape in SSRS 2008


Hi there,

        I have created a report in SSRS 2008, In the report properties I have selected Orientation as Landscape but when i Export the report to Word it prints the report on middle of the page and cuts the rest of the report.

Urgent help is needed!!!

Giving syntax error for CASE statement using VS (SSAS) 2008 designer


Hi All,

I am writing following CASE statement in Data Source View-> Righ click measure table "xyz" -> and select "Edit Named Query"








SSRS 2008 Data Driven Subscription Timeout Error



I have a report that pulls data from an SSAS 2008 cube.  The report does take a few minutes to run, as it is grabbing a lot of data.  The report is published to our sharepoint website, with stored credentials.  When I run this report manually on the sharepoint site, it works fine.  However, when I try to create a data driven subscription, it gives me the following error: Error: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.  I've looked through the SSRS log file, and it basically just repeats this error.  I've also run SQL Server profiler, and I can see that all of the queries that populate the parameters run successfully, but then there are no more queries sent.  So, it seems that the connection is fine, but the data driven subscription has another timeout value that is causing the problem.  All of the datasets have a timeout = 0, so that is not the issue. 

I've also run a different data driven subscription using a smaller report (based on the same cube though), and it works fine.  Any thoughts on what I need to do to fix this?


Problem Analysing SSRS 2008 R2 Error Logs



I have a very simple SSRS 2008 R2 report in Sharepoint 2010 with embedded data source and data set connections. When I edited the deployed report within Report Builder 3.0 launched within Sharepoint 2010.
2.4.2) The query executed fine within the data set component of this report returning data.
2.4.3) On clicking on the run button I get the following error; -
"For more information about this error navigate to the report server on the local server machine, or enable remote errors
Log on failed. Ensure the user name and password are correct. (rsLogonFailed)
The report server has encountered a configuration error. Logon failed for the unattended execution account. (rsServerConfigurationError)"

I have been viewing the Execution log as follows; -

SELECT * FROM ReportServer.Dbo.ExecutionLogStorage ORDER BY LogEntryID DESC

I understand that I should get more information from; -

C:\Program Files\Microsoft SQL Server\MSRS10_50.<my instance name>\Reporting Services\logFiles\<today's log file>

But I don't know what my search criteria within this log file is. Can any body help?

I am currently looking at; - http://technet.micros

Error upgrading SQL Server 2008


i was normally using VS2005 and SQL server 2005...

i upgraded to SQL Server 2008... and then...

i could not build my project anymore... because of this error:

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 
Exception Details: System.IO.FileNotFoundException: The specified module could not be found. (Exception from HRESULT: 0x8007007E)
Source Error: 

Json Deserialization is giving error in IronPython



Have anyone tried json deserialization. When I tried:

>>> import json

>>> json.loads('["foo", {"bar":["baz", '"Test", 1.0, 2]}]')

I got following error:

Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "C:\Program Files\IronPython 2.6 for .NET 4.0\Lib\json\__init__.py", line
 307, in loads
  File "C:\Program Files\IronPython 2.6 for .NET 4.0\Lib\json\scanner.py", line
42, in iterscan

ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Function name is missing ).


I Am Continiously Getting Error For Following Line Of Code, It Work  Fine In Other Database

Am I Doing Any Mistake

if (sh3itno != "" && dpsh3no != "")
                string queryy = "SELECT [CHEQNO] FROM [SH3MAST] WHERE (([CHEQDATE] = " + chqdate + ") AND ([FAVOUR] = " + favour + ") AND ([CHQTYPE] = " + ctype + ") AND ([TRSTN] = " + trstn + ") AND ([TRBANK] = " + trbank + ") AND ([SH3ITNO] = " + sh3itno + ") AND ([DPSH3NO] = " + dpsh3no + "))";
                OdbcCommand cmd3 = new OdbcCommand(queryy, connen1);
                string chqno =cmd3.ExecuteScalar().ToString(); (Here Iam Getting Error)
                tbl.Rows[i]["cheque no"] = chqno;
Stack Trace: 

[OdbcException (0x80131937): ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Function name is missing ).]
   System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) +39
   System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, Strin

SSRS 2008 R2 and sharepoint 2007 report builder problems


I upgraded our enterprise sql server 2008 to sql server 2008 r2 last weekend.  Along with this i installed the report builder 3.0 on the servers as well and the updated ssrs add in for sharepoint.  The upgrade went fine, no errors that i could find.  The problem is now when i go to a library that has the report builder content type enabled and click report builder report under new it does not load report builder 3.0.

I updated the custom report builder url in central administration from /_vti_bin/ReportBuilder/ReportBuilder_2_0_0_0.application to /_vti_bin/ReportBuilder/ReportBuilder_3_0_0_0.application

however when i do click the new report builder report it kicks me over to http://company.com/ReportServer_MossEnt  which itemizes out each individual sharepoint site in the farm.

Is the integration of ssrs 2008 r2, sharepoint 2007 and report builder 3.0 work?  did i install the wrong version of the report builder add in?  The above is the only problem i am having now.

all servers are server 2008, 64 bit and moss 2007 enterprise with sp2 & april 2010 cu

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend