Editing RDL programatically using C#

Recently i was working on an issue. In Reporting Service 2005 you set FixedHeader property to a table control. When the dataset bound with the table returns no data in combination with Internet Explorer -> Tools -> Internet Options -> Advanced -> Uncheck Disable Script Debugging (Internet Explorer), you’ll receive a Javascript error. —————————Error—————————A Runtime Error has…

7

RepeatWith not working with Physical Paginations like Print, Image and PDF

PROBLEM: When we set the RepeatWith property of a TEXTBOX to the table / data region that holds the data, the textbox is not shown in other pages after rendering the report in PDF / Print Preview / Image. WHY? The behavior you are seeing is by design. The RepeatWith functionality is not supported in…

3

CanShrink does not work with RDLC when the textbox is within a data control like Table / Matrix

ISSUE:  As per definition, http://msdn.microsoft.com/en-us/library/ms251779.aspx Growing and Shrinking a Text BoxBy default, text boxes are a static size. If you want to expand a text box vertically based on its contents, change the CanGrow property for the text box. If you want to allow the text box to shrink based on its contents, change the…

6

System.Data.Odbc.OdbcDataReader.GetBytes() always returns 0 when you use with ExecuteReader(CommandBehavior.SequentialAccess)

Consider a sample which reads an image from the SQL Server table (Adventure Works database), whose column is VARBINARY(MAX). The code sample goes like this,   Odbc.CommandText = “select ProductPhotoID,LargePhoto from Production.ProductPhoto where ProductPhotoID = ’70′” Dim dr As Odbc.OdbcDataReader = cm.ExecuteReader(CommandBehavior.SequentialAccess) à Happens with the ODBC SQL Server driver and the SQL Native client driver…

0

Getting System.OutOfMemoryException when using ReportViewer contol in Local mode

PROBLEM: ========  Consider you’ve a ASP.NET application that contains Report Viewer control (2005 / 2008) in Local Mode.  You have an RDLC report file, that loads large amount of data / has lots of expressions. (Both are not recommended in Local mode)  Everytime you refresh the web page, the Report Viewer stores objects in the…

6

When you develop a report model project in SQL Server 2005 Business Intelligence Development Studio, the Isolation option in the Data Source Designer does not have any effect

Consider the following scenario in Microsoft SQL Server 2005 Reporting Services. You use SQL Server Business Intelligence Development Studio to create a report model project. In the report model project, you create a data source against a SQL Server 2005 database. The database has the ALLOW_SNAPSHOT_ISOLATION option enabled. You set the Isolation option to Snapshot…

0

ConnectionLifetime attribute in the SqlConnection connection string is not honored

Created a sample code.                 == It has the ConnectionLifetime attribute in the connection String set to 10 secs.                 == Now in the code, i’m having a loop which will open the connection, executes a statement.     == Waits for 15 secs and then closes the connection.                 == Then waits for 15 secs…

0