Browse by Tags
Have you ever noted down the difference when you open a CSV file in Excel which is exported from REPORTING SERVICE 2005 and REPORTING SERVICE 2008? The one which is exported from REPORTING SERVICE 2005 shows all the values for each row in a single column
Read More...
I was working on an interesting case where the reporting service was moved back to Windows authentication from Forms based authentication (FBA). There were lot of subscriptions which were created using a forms based user account. Now when the reporting
Read More...
Recently I was looking for a sample that will help me with the concept of Passing parameters to sub reports in RDLC. I didn’t get one. So I thought of exploring more on to this and started off the journey. The tricky part with the RDLC is, even though
Read More...
1. How Duplicate SPN's in IIS can come in to picture? An SPN is a service principal name and usually uniquely identified in a domain with it's service name. for eg: If we have a machine name " test " in the domain " contoso.com " and we have a web site
Read More...
PROBLEM: When you try to run a report ( or) Generate a model from an existing Data Source (or) Open a Model using Report Builder from the Report Server, you get the following error, An attempt has been made to use a data extension 'SQL' that is not registered
Read More...
PROBLEM: 1. Consider a report (rptParent) with a multi value query based parameter and it has links (table cell action “Go to report”) to rptChild. 2. The report (rptChild) renders pased on the parameter value it receives from rptParent. 3. When viewed
Read More...
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
Read More...
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.
Read More...
ISSUE: As per definition, http://msdn.microsoft.com/en-us/library/ms251779.aspx Growing and Shrinking a Text Box By 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
Read More...
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
Read More...
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
Read More...
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
Read More...
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.
Read More...
When you browse the Report Manager, you're getting the above error message. To resolve this issue, Do the following, Search for the key ---- MaxActiveReqForOneUser in RSREPORTSERVER.config file under the ReportServer directory, And set the value to 400
Read More...
ActiveX Data Objects (ADO) Overview ActiveX Data Objects (ADO) Design Philosophy ActiveX Data Objects (ADO) was originally designed as a simple and relatively lightweight COM based database API for use with Active Server Pages (ASP) on Internet Information
Read More...
