HI, Is it possible to have row grouping for each row in a matrix?? Something like header1 header2 Task1 Section1 Row1 value1 value1 Section2 Row2 value2 val...more >>

Hi all, I have been working on Reporting Services for a while I build and deploy reports. Just today I tried to go on htt://myserver/reports >>> and I get the following error: <Error Message Starts Client found response content type of 'text/html', but expected 'text/xml'. The request faile...more >>

I currently have several formulas to change the background or text coloring based on values in a report. All format render correctly except excel on out put. If I have a column that changes to red when there is a negative value, all numbers end up red in that column when exported to excel. ...more >>

I have a report that every Monday at 1:00AM, should run a report for the previous week (Mon-Sun). If it only had to run for the previous week, I would just get the dates in the stored procedure using getdate() and dateadd(). However, when the report is viewed on-demand, I want the user to be a...more >>

HI, I tried to open the report manager from all prgrams-->MS Sql Server-->Reporting Services --> Report Manager But it gave me the error:: SQL Server Reporting Services Error Session state has been disabled for ASP.NET. Report Manager requires that session state be enabled. I have w...more >>

Ok ... now I have it somewhat narrowed but dont know how to fix it. When I test the report on my pc (preview) then I get the nice NoRows property I have set on the table. When I deploy the report to the report server and run it .... I get the unfriendly "Server Application Unavailable" messa...more >>

Linked Server oracle 0x80004005 error Has anyone gotten around the ...... OLE DB provider 'OraOLEDB.Oracle' reported an error. [OLE/DB provider returned message: Unspecified error] OLE DB error trace [OLE/DB Provider 'OraOLEDB.Oracle' IRowset::GetData returned 0x80004005: ]. .... error ...more >>

basically i only want a document map when rendering to PDF however if there are any labels, then the HTML will show the documentmap, SO i want to write expressions for hte grouping labels that show nothing unless it is rendering to PDF, but how do you detect the renderer from expression code? ...more >>

I am on my local machine. I have deployed my reports to the dev environment. The reports won't run and I keep getting this era. What does this mean, please help. An error has occurred during report processing. (rsProcessingAborted) Get Online Help Cannot create a connection to data sour...more >>

Hi, could anybody help to figure out what is the correct (recommended) way to write trace messages for custom data processing extension? I have written such an extension and I would like to enable trace for it to be able to see how it performs through the time. I tried to write trace m...more >>

I am currently creating a schedule on the server for deliverying report. After Site Setting -> Manage shared schedules -> new schedule steps, I could not go any further by clicking the "OK" button. Which means I could not save the schedule I just created. the ok button only does validation che...more >>

Does anybody know a third party control for SQLRS? Thanks...more >>

Has anyone recieved this error while navigating the Report Services Report Manager? "The underlying connection was closed: An unexpected error occurred on a send." Any ideas on why and how to resolve the issue? A refresh clears up the issue but this happens frequently enough to bother ...more >>

Hi! I am using the report service to generate all of my reports. The reports are generated as pdf and then printed. The following situaton: - The user fills out a windows form and previews the report. On the preview he recognised that there is a mistake in the text he filled out and close...more >>

I have a custom assembly that decrypts encrypted data that is stored in SQL. The assembly works, this I know. The references to this assembly work in the "Preview" mode when designing the report, but when I deploy it, it doesn't work any more. I have placed a copy of the dll in the locations st...more >>

I have a problem that seems related to others but I just want to make sure I am not doing something wrong. I have a table DateX | NumberY 1/2/05 1 1/2/05 2 1/2/05 3 1/3/05 8 1/6/05 9 Actually the dates go down to the second, but you get the ...more >>

The web server is very quick for all other sites and pages, but for some reason, bringing up the reports page is a dog. Can take anywere from 10 secs to a minute. Anyone else see this problem... Guessing it's a conf or install issue, but I have no clue. All comments appreciated....more >>

Is anyone experiencing the folder.aspx taking a really long time to render the list of reports? On our server, all other web sites a very quick, but: opening http://myserver/reports/Pages/Folder.aspx can take as long as 40 seconds to list a few reports! Thinking it must be an install or...more >>

I have two list containing matrix. Report Logic Hide either of the list based upon parameter. Export to excel works fine but when try to export to PDF getting following error: Reporting Services Erro -------------------------------------------------------------------------------- Excepti...more >>

All MSRS Mentors, I need to create a report with dynamic columns, my stored procedure will return columns based on the parameters I pass. I have three static columns and n dynamic columns. My Reports should look like this ColumnA ColumnB ColumnC DynamicColumnD DynamicColumnE ..........more >>

In _Microsoft Reporting Services In Action_, Teo Lachev shows how to set up report parameters that allow the user to sort a table on Dataset fields (pp.157-158). This technique works beautifully for "free standing" tables that are not contained within another data region. If however the tab...more >>

Hello I have string 6:10, 11:30, 23:10, …, in one of column. I need to convert these string to time with the same format (HH:MM) so that I can sort by time. How should I do this? Thanks, Jim. ...more >>

I followed the instructions in http://support.microsoft.com/kb/842440. After logging on to the Beta Site using the Guest ID it says "Sorry, you are not enrolled in any programs that are utilizing Microsoft Beta.". There is no link to take the survey. I even went to http://www.microsoft.com/sq...more >>

I've done a number of RS installs, this one is on a new 2003 server. I have VS.NET on the computer and can develop and deploy successfully. I can view the report from VS.NET preview or using IE, typing http://localhost/ReportServer?/yada/yada However if I want to run Reports Manager, typing http...more >>

Is there a way, using the system tables in the ReportServer or ReportServerTempDB to determine which Active Directory groups have access to which reports. I want to document what I would otherwise have to go report-by-report in the Report Manager screen to see. I've looked at several of t...more >>

I have 2 datasets. One is used to give the values to a parameter and the second one is used to populated the main table in my report. The first one has a code and a Name like: Code Name c cat d dog I would like to display “cat” in the main table, but I just have the code “c”. ...more >>

Hi, I'm actually in trouble with some of my reports. Those reports are randomly producing corrupted PDF files in subscriptions. The only way for me to avoid those errors is to remove report caching. Here is my original post which explains tests i have made and patches i have applied htt...more >>

Hi, Can a column be created dynamically in a table.... For example the user selects start date and enddate and i want to create columns from startdate to enddate.... Thanks, Chandra....more >>

Hello, In my existing report, I have BirthDate column in YYYYMMDD sting format, and I want to calculate Age as a new column, how should I do this? Thanks Jim. ...more >>

I am trying to move my reports (and data sources) from one server to another. I can move everything fine, but when I go to execute a report, it says invalid data source, even though the data source exists with the same name as it did on the original server. I can manually go through each rep...more >>

Hi all, I am using SQL Server 2003, but now I want to upgrade to SQL Server 2005. My system is running BizTalk Server 2004. How can I do it ? Thnx in advance, Haroon...more >>