.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

wired issue while modifing Report Desgn tab?

Posted By:      Posted Date: September 15, 2010    Points: 0   Category :Sql Server
Hi Experts, When ever I modified anything on my rdl file through BIDS 2008, (SSRS 2008), any dam thing (like "rearrange the position of any report item" or "changing any report item property", etc) it is adding below code into the rdl (xml) file , which results into the below error message:- <ConnectionProperties> <ConnectString /> <IntegratedSecurity>true</IntegratedSecurity> </ConnectionProperties> Error Message:- An error occurred during local report processing. The definition of the report'/rdl_file_name' is invalid. The report definitio is not valid. Details: The report definition element 'ConnectionProperties' is empty at line 8, position 9. It is missing a mandatory child element of type 'DataProvider'. How to get rid of this wired issue? Any Help? Thanks Regards, Kumar

View Complete Post

More Related Resource Links

financial report issue

I am working on a project that is involved in financial reports. Here is what I want to accomplish I have a table (tbl_receivables) with id, accoundID, transDetails, debit, credit columns.  When I publish my receivables report I would like to see a balance field along with the table columns. Balance field value should be generated runtime and would give value of: current row credit - current row debit + previous row balance total. Should this calculation be handled in SQL server side or asp.net side? Is there any tutorial link that you can share with me?  

SSRS Report issue blank page is coming

I have a report with 2 pages, some time the second page doesnot contain the data at that time i want to get only 1 page report. but as of now if second page does not have data it is coming as blank, can anyone help on this. I am using ssrs 2008Jeeva Jacob

SSRS Issue with reloading Report

Dear all, I have developed a couple of reports and could deploy them to different servers. All reports are working fine at all servers and test computers, however I cannot reload any of the reports on my own PC. I tried with IE7 and IE8 but nothing. Scenario: 1. Go to the report 2. Run the report 3. Change any of the paramters 4. Press View Report Button 5. No reloading nothing changes.   It seems like the system could not pass the new parameter value.   Could you please help me out? Thanks in advanc, Zoltan

Access Services report issue

Good afternoon. We have an issue where the canned reports in a Web Assets Database site throw the following error: Report viewer failed to set the report parameter defaults for this report. Select new default parameter values from the tool pane. The report definition is not valid. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition' which cannot be upgraded. (rsInvalidReportDefinition) Actually all web databases (assets, projects, contacts) throw the same error for the canned reports however report services runs without issue on the server. The Web Assets database seems fine outside of the reports and when opened locally in access 2010 the reports run fine. We have one Sharepoint 2010 server with SQL 2008 r2 back end configured in sharepoint integration mode.  Thanks for any assistance you can offer. Cheers!   Cory  

Report Builder 3.0 issue - can view existing rdl files but cannot create new reports

I have Report Builder 3.0 deployed on my local machine pointing to a remote SQL Server 2008 R2 instance outside of my local domain.  Within this local Report Builder 3.0 instance I am able to open up previously created rdl files from the remote SQL Server 2008 R2 instance that I am connecting to.  However, if I try to create a new report on my local instance of Report Builder 3.0 and attempt to use the same data source as was used to create these existing rdl files, I receive the error: "Unable to connect to data source. The user credentials provided in the connection string do not have permission to connect to Reporting Services."  So why can I open existing rdl files from this remote SQL Server 2008 R2 instance, but not create new ones even though I'm using the same data source as the existing rdl files?  Thanks, Mark

SSRS Report rendering issue


Hi All,

i have a chart report and deployed in server and created a subscription for sending email with webarchive type. I can see the chart in out look and it is perfect. when i see the same report in blackberry the fonts are not showing properly(blured).

I have tested via attachement as a pdf file then i can see the clear report in both outlook and blackberry but when make a mode as webarchive i getting the font problem in blackberry.

I am looking for the solution.





- Thiru

Passing parameter to Sub report Issue ( pls help)


Hi I have main report and one sub report. I used on dataset for main report and one for sub report. I am using Vs2005 .

Store procedures



I have setup the report added sub report in main report. I have also setup parameter from main report to sub report.

It works fine on reporting server.


When I am calling from Asp.net. I am getting error sub report could not be found.

here is my code

Report.SubreportProcessing +=

new SubreportProcessingEventHandler(SubreportProcessingEventHandler);

void SubreportProcessingEventHandler(object sender, SubreportProcessingEventArgs e)



e.DataSources.Add(new ReportDataSource("DataSetSubReport", GetDatasoure("dbo.GetSubReport ", e)));


Facing issue in displaying the Matrix Report .


Iam using Matrix dataregion to display data.

I will be getting Columns dynamically and Matrix Control will be expanding horizontally.

I need the Columns to get below after reaching certain limit.

Lets say,If the matrix report contains 4 dynamic columns,after expanding to 2 dynamic columns,my report should display in the nextpage or below with 3rd,4th column .

How can I acheive this.

Suppose in case of page break,how can i acheive this.

let me know if it is possible


Issue - The report execution has expired or cannot be found. (rsExecutionNotFound)


Hello Experts,

I am running a huge SSRS 2008 report (that returns 2 million records) and it gets rendered sometimes and sometimes it gives me an error,

"The report execution <some string> has expired or cannot be found. (rsExecutionNotFound)”.

When I see SQL Server log after this issue comes I see following message there;

"A significant part of sql server memory has been paged out. This may result in performance degradation. Duration: 300 seconds. Working set(KB): 97672, memory utilization 42%"

IMPORTANT point to note here is when I am running reports with 1 million records or smaller than that, then I am able to execute them successfully without any issue.

I am using SSRS 2008 64 bit, Win Server 2003 64 bit. RAM is 8GB.

Please help me to know what are these issue, are these two issues related and how to fix it?


SQL 2008 Reporting Services Report Parameter and Analysis Services issue after upgrade

I have upgraded my SQL 2000 database and analysis server and SQL 2005 reporting services server to a new instance of SQL 2008 running database engine, analysis services and reporting services.

The analysis services database migrated successfully and I have got the database into a state where it processes fine but I am having the following problems.

- My Reports show in reporting services but the drop down list parameters are all empty.
If I change the parameter in report builder to use the display name instead of the uniquename then the drop down list populates and works until I select a value that contains a space character and then it reports a problem with the dataset used by the report.

Query for the dataset used to populate my parameter.
with member [Measures].[GroupUniqueName] as '[Site].CurrentMember.UniqueName' member [Measures].[GroupDisplayName] as'[Site].CurrentMember.Name' select { [Measures].[GroupUniqueName], [Measures].[GroupDisplayName] } on columns, { [Site].[Group].members } on rows FROM [Invoice Reporting]

Query used by the report, filtering on the selected parameter value from the drop

Font/letter spacing issue when printing from SSRS 2008 report page


We are developing reports in SSRS 2008.  When printing from the SSRS report page, we are seeing that that some text is "clumping" together or spaced oddly. I have tried a variety of printers so it's not printer-specific. If you export from the SSRS page to PDF or to Word and then print, everything prints as expected.

Nothing is as good as real text/names/data, but to reproduce, simply create several text boxes with...

I used several common fonts...
Arial, 10 pt (SSRS 2008 default)
Times New Roman, 12 pt (Office 2003 default)
Calibri, 11 pt (Office 2007 default)
Verdana, 11 pt
Tahoma, 11 pt

In the example above, I used normal weight, nothing fancy... If you use bold and underline, which is common for a page/column header or footer, this issue is even more apparent.

It feels similar to the following issue: https://connect.microsoft.com/SQLServer/feedback/details/482312/ssrs-report-font-rendering-issue

A workaround would obviously be to export to PDF and then print, but these are steps that our end users shouldn't have to (and won't want to) put up with to produce reports/invoices/etc. that ultimately go

Strange issue with a huge SSRS 2008 report (supposed to return 3 million records)



NOTE: The strange part (as mentioned in title) will come in the end.

I am running a SSRS 2008 report which fetches 3 million records from a remote server. After around 1 hour the report processing stops and I see an error icon on the lft bottom of the browser window. When I click on that to see the error details it shows some PageRequestManagerSQLErrorException with an unknown error message with code 12029 (sometimes 12002).

When I see the reportserver logs there is an error message logged in it which says "Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.InvalidOperationException: Timeout expired.  The timeout period elapsed prior to obtaining a connection from the pool.  This may have occurred because all pooled connections were in use and max pool size was reached."

The <DatabaseQueryTimeOut> value in the report server configuration file is already having a value set to 7200 seconds(2 hours).<

SharePoint 2010 Security (Prompts for Login) Issue with SSRS report with Out of Box Web Part


Hi All,

I have a SSRS Customized Report (.RDL). I have a web part with association on one of the report. When I try visit the page I am prompted for credenatial.

My Data Source Properties are as per below

Use this user and Password

  user name: domain\myadminuser


Selected: use as win auth

Selected: Impersonate


How Can I get rid of prompt?






SharePoint 2010 Security (Prompts for Login) Issue with SSRS report with Out of Box Web Part


Hi All,

I have a SSRS Customized Report (.RDL). I have a web part with association on one of the report. When I try visit the page I am prompted for credenatial.

My Data Source Properties are as per below

Use this user and Password

  user name: domain\myadminuser


Selected: use as win auth

Selected: Impersonate


How Can I get rid of prompt?






Sum Issue in Group Footer and report Footer


In attached SSRS 2005 report i am grouping by date and within date i'm showing acconuts.
In group footer i'm trying to do sum depends on TYPE field.
For Receipt Column
=IIf((Fields!Type1.Value= "R"),Sum(Fields!Amount.Value),"")
For Disbursement Column
=IIf((Fields!Type1.Value= "D"),Sum(Fields!Amount.Value),"")

But report is putting sum either in RECEIPT or in DISBURSEMENT column depends on whatever record is 1st.

For Receipt Column in report footer
=IIf((Fields!Type1.Value="R"), Sum(Fields!Amount.Value), "$0.00")
For Disbursement Column in report footer
=IIf((Fields!Type1.Value="D"), Sum(Fields!Amount.Value), "$0.00")

Same way page footer is not showing the correct value.
Instead of $257673.61, it should have been 257673.61-9340-2875.98 = $245457.63
And Disbursement column in report footer instead of $0.00 it should be $12215.98
Any Suggestions what i'm doing wrong here.


SSRS Report Sorting issue in Dashboard created usign Performance point services in sharepoint 2010


I have created a report in SSRS and this report is integrated within a dashboard created using performance point services in sharepoint 2010.

The report is a simple tabular report with 5 coulmns and interactive sorting is enabled on each of them.

Sorting works when the report is viewed separately but gives "Report Server Error" when I try to sort (on any column) inside the dashboard.

I have user IP instead of host name in the report server url.

Please help.



Issue when report exporting to excel



I am having a report (using SSRS 2008). when I view in the Preview tab its renders great but when I am exporting to excel i have this problem, the row height for rows with multiple lines, does not expand . So the user has to manually increase the height of rows in excel.

This is one of the subreport in Master report as an individual report there are no issues when exporting to excel ( The cell height in excel increases dynamcially based on text) however the same report i'm using in Master report as a subreport the cell height doesn't increase and also i can see the only first line message, so i have to change cell height manually.

I really appreciate if some one has any work around to this issue.


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