I want to add an export option for the report dropdown menus that will allow users to export reports to tab delimited files. This will allow them to open up the data of a report directly in excel. Does anyone know if this can be done?...more >>

Hi, I tried to use report parameter with a stoed procedure that its parameter type is UNIQUEIDENTIFER. When I execute the data set, I got ivalid data type converting error (Syste.String -> String.Guid). Is ther a way to pass GUID as parmeter value to stored procedure? Thanks...more >>

Hi, Is it possible to get reporting services to create a report with a repeating grouping structure with a total at the bottom of each group? I would want to start with a report header that is only output once. Then for each repeating group, I need a header, the body, and a footer with the ...more >>

Is it possible to dynamicly change the background color of the row(s) in the destination report when using Jump To. I have a report that users click a value and it jumps to another report. Whatever value the user clicks on in the source report I would like to highlight in the destination rep...more >>

Hello, In the footer of my report I use “Page of Pages”, now I need to reset this number each time I need to go to next page through page navigation button in the ReportViewer. Right now it shows total number of pages in the report. Thanks, ...more >>

I have 2 dates one a parameter and one from a field, I need to calculate the number of days inside a reporting services expression window. The Datediff function does not seem to work, I cannot do it on the SQL Query because one of the dates is from a parameter (ie. @date)...more >>

I am trying to use and expression in the parameters tab on the dataset. I have a parameter called END_DATE and I want it to be equal to the expression =DATEADD(DateInterval.Day, 1, Parameters!END_DATE.Value) The expression comes out fine on the report. I tested it there to see if it would ...more >>

Using RS Standard, SP2, I am prevented from creating a subscription on reports that I am able to schedule for snapshots. The error message says "Subscriptions cannot be created because the credentials used to run the report are not stored, the report is using user-defined parameter values, or...more >>

Hi There, We are having a problem in listing subscriptions in Report manager and getting "OutOfMemory" exception. Our Application has an event-based subscription management system, and every-time an event gets fired on the Application-side, it creates an one-off subscription on the Reportin...more >>

Hi all.. How can I use a value of a returning dataset to be the default value for a parameter? I tried using =Fields!THE_FIELD.value in Non-queried textbox of the parameter, but this doesn't seem to work. When I press the fx button, the text "Report item not linked to database" is sho...more >>

I have some rows with finance periods, there is different periods per account per year. I then need to have top 10 accounts based on the sum of all periods for an account. When I select top 10 i get 2 accounts because there is 10 postings, is it possible to get top 10 based on distinct account...more >>

I have some troubles installing reporting services on a Windows 2000 server with IIS 5.0 the error number is 1603 this happend because the ASPNET local user does not exist, but i already check my local users and ASPNET user exist. The other thing that I try was install reporting services by com...more >>

Hello, How can I put a page number such as “page of pages” to my report. Thanks, ...more >>

Hi, Is the rdl schema based on a standard? For example will the "<ReportItems>" element ever be renamed? Thanks, Shawn ...more >>

ie i want to know whether sp2 is installed or not please help...more >>

i have parameter for pagebreak required or not ie true or false now <pagebreakatend>true</pagebreakatend> how can i change this on basic of user selection of, parameter iif() is not supported in <pagebreakatend>iif</pagebreakatend> ie cant we set expression for <pagebreakate...more >>

My report has an int column representing minutes. I can show the group's sum total minutes as =Sum(Fields!myMinutes.Value) ... however ... the users want the sum total shown as "0,000hrs:59mins" How can I convert a groups sum total to format "0,000hrs:59mins" Thanks -- Frederick Volking...more >>

Hello, I need to take one of my date column and compare it with the current date and see how many day difference? How can I do this? Thanks, ...more >>

Hello, I need to create a MyPar parameter dropdown list, that is why I created a new dataset that gets data through a stored procedure. I also add @MyPar into the query string of MyMainDataSet . I defined this parameter in Parameter screen for both available and default values. When I run...more >>

Hi, I have one main report that has 5 subreports in it. The main report is a form for contacts in the database. When the main report runs it runs each of the 5 subreports for each contact in the database (so lots of executions of the subreports). The subreports are the same for each contact...more >>

Hi. I am pulling dates from an AS400 where the date is formatted as 1050701 for todays date. CYYMMDD. I have tried to use the date format for the field (d), but the date does not change. Any ideas how I can format this type of date to display as MM/DD/YY. Thanks...more >>

Hi, those things I can't find out: 1. What means "Export" to "HTML with Office web components"? It looks just like the orginal report viewer to me, ie confusing as the first export format. 2. Is it possible to re-sort a report table on "any" report column in the report viewer or do I hav...more >>

We are developing an application that must work in two different languages, and we have the following doubt: Is it possible to design a localizable report ?, that is, that the report appears in different languages depending on a parameter or the browser configuration? We are interested i...more >>

Hi, I checked with msdn for help in sql Reporting Services. Where can i find help for the same. -- SushiL...more >>

Hi, I have a field with time in minutes. I have converted it to hh:mm:ss -> = String.Format("{0:HH:mm:ss}",CDate("0:0:0").AddMinutes(Fields!SETUP_TIME.Value)) and set format properties to hh:mm:ss It looks just like it should, but when exporting to excel, the format type is General. I n...more >>

Hi, We are getting a 401 unauthorized error when trying to create subscriptions via a web service from our .Net. The server is Windows Server 2003 with SP1 and Reporting Services with SP2. The frustration is that one of our servers is fine with this setup and the other one is giving the ...more >>

I am using a Visual Studio created Rendering object to stream Excel reports to the browser. My client wants the ASP.Net application to be able to tell when a report is empty and display a message and not stream a blank report. Some reports have headers and the like. So far, the only time ...more >>