Browse by Tags
All Tags »
Reporting Services (RSS)
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...
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...
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...
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...
Recently wrote a new tool to assist in enabling / disabling verbose logging which supports Reporting Service 2000 / 2005 / 2008 including the HTTP logging. For more information please visit, http://verboselogger.codeplex.com/ It is freely downloadable
Read More...
Why can’t I install Reporting Services? *Remove any traces of previous installations *Add IWAM, IUSR, and ASPNET users to Admins group *Be sure all required software and service packs have been applied. *Make sure the account being used during installation
Read More...
RSSTP<xx>.LOG and RSMSI<xx>.LOG - During installation, the wizard logs all of its actions and checks into log files it maintains in a file called RSSTP_.CAB in the folder \microsoft sql server\80\rs setup bootstrap\log. RSSTP and RSMSI log
Read More...
Kerberos Checklist General Kerberos scenario Client logs in to the KDC using the domain account. The KDC responds with the TGT. (Provided by the TGS within the KDC). Now the client sends the TGT and a session request for the particular middle tier machine
Read More...
