Hi, I have problem with sending mail through smtp server which requires authorization. BOL says that I should fill fields ("sendusername" and "sendpassword") or ("postusername" and "postpassword") in RSReportServer.config file, but doesn't say where to put this fields. I've searched the w...more >>

How do I create a schedule to run at month end? I selected monthly, and tried to put 28,29,30,31 in calendar days, since months vary, but I get this error "To create a schedule that runs on multiple days, you must choose which days to use" Any Ideas? I run monthly reports that create snap...more >>

When changing the following in the UI section <UI> <ReportServerUrl>http://intranet-computer-name/ReportServer</ReportServerUrl > </UI> Change it to <UI> <ReportServerVirtualDirectory>/ReportServer</ReportServerVirtualDirectory> </UI> Does the server need to be rebooted or a...more >>

I am using an external smtp server. If I do a subscription with a link only it works. Including the report in any format (tried 4 different ones) and it fails with the following error: Failure sending mail: The Report Server has encountered a configuration error; more details in the log files ...more >>

error: "The type or namespace name 'RS' could not be found (are you missing a using directive or an assembly reference?)" I can't use any sample rs c# files or anything without getting this...i have added a web reference thanks, Trint ...more >>

I need to do this...if anyone knows how, I would very much appreciate your input... I need my c# app to be able to render and save image without any user input...just pre-set parameters. Thanks, Trint ...more >>

I setup a production server today I thought the same as a development server that I was working on. However, I can not see the Data-Driven Subscriptions button to create a new data-driven subscription. My account is a system administrator and also a content manager. On my development server I ...more >>

How can I escape the character " in the query designer? This is my MDX query: ="select {[Measures].[Fakturerte timer HT],[Measures].[Fakturert beløp HT],[Measures].[Gjsnitt fakturert timepris HT],[Measures].[Gjsnitt fakturert timepris HT Veil pris],[Measures].[Gjsnitt fakturert timepris HT S...more >>

Hi All We have an ASP.NET application that lists all the reports hosted in our SQL RS by using RS webservices. When user selects on a particular report from the list the corresponding parameters get shown again using web service calls. After the selection of parameters, the user gets to view ...more >>

I want to get a row count at the end of a report that I am running. Is there a way to do this, or do I have to write the code? If I have to write it, can anyone give me a how to guide on writing .net components for reporting services? -- www.duanelawrence.com ...more >>

Can Reporting Services create an ascii file? We are searchring for a tool that can handle with predefinied queries to generate week figures, month figures etc. These figures will be used in paper publications as well as in electronical publications. Is it better to use DTS? -- Message posted v...more >>

I reach the 'Report Delivery Option' webpage when I click 'New Subscription'. Here I can specify the email address, Priority, Comments etc... Under the Subscription Processing Options, Nothing happens which I click on the 'Select Schedule' Button. Looking under-the-hood it seems the Validatio...more >>

I have a problem I hope someone can help me with. I display some of my reports in a browser control in a Windows Form. I want to be able to add an email button to allow the current report to me mailed somewhere. The problem I have is I cannot find how to get the current parameters being used f...more >>

My project manager is all gun-ho on using reporting services to handle the reporting in our new project. I have been asked to research these services and see how they will fit in. We have always used Crystal Reports, so I am looking to see that Reporting Services can handle our needs the way...more >>

We recently installed the patch (released by Microsoft) that fixed the Export to Excel problem for SQL Reporting Services. Now, on just one particular report, when we export to excel, it doesn't export the very last row of the data. This particular report runs off of a parameter. For every par...more >>

Hi, I'm writing a custom delivery extension that saves the rendered report to the disk. My problem is that the output file only contains spaces (the file size is excatly what it should be but no text only black spaces). Does anyone know why spaces appear instead of chars ? this is the code...more >>

Most of my reports have parameters on them for the @start and @end dates. Some just have start dates. How can I set the @start date for the subscription to be today -1? The report in question has a 'team' parameter that I can set from the drop down....more >>

I have a report on the Reporting Server Manager where in the Data Sources link it shows two data sources. I have removed the report in question and redeployed the report. The two data sources reappear. Does anyone know where the second data source is coming from in the Report Manager. ...more >>

Is it possible for me to send from my c#.net file a url that will render the report as a .tiff image and save it all at once without displaying it on the screen? I need to creat a series of these kinds of reports. Thanks, Trint ...more >>

i know subreprts wont work in excel; i get a run time error saying index out of bounds. can you tell me the code which i can use in an expression so that sub reports are suppressed and the user doesnt see the run time error message when they export to excel. ...more >>

I have a report that can run 1 to x number of pages. I need to be able to put list at the bottom of the last page. This list will need to include disclaimer message in a text box plus several fields from my data source also in text boxes. I've tried several different ways to do this, my last b...more >>

I would like to use a function to truncate the time of day from the date, so that sorting will be only by date and not date/time of day. How is this done? ...more >>

Is there any way to add some sort of condition, or where clause to an aggregate function? I have a report with three nested lists - the detail is in the inner list, list3. In the second (middle) list, I want to count the number of rows for column x where column y is not equal (<>) "This". ...more >>

I can connect to a oracle database on the development PC using OLE DB, here is the connection string: Provider=OraOLEDB.Oracle.1;Data Source=cdbprod Yet when I Deploy to the test server, it fails. Other applications can connect to the oracle database on the same test server, but not reporti...more >>

After installing SP1, reports fails to render to PDF, with the following error from IE: "Internet Explorer cannot download Format=PDF from myserver. Internet Explorer was not able to open this Internet site. The requested site is either unavailable or cannot be found. Please try again later....more >>

Is it possible to transfer thesubscription settings forall reports from 1 server to another? ...more >>

Hi, I'm writing a custom delivery extension. i can't seem to find in the printer sample where the report parameters are used ? ...more >>

Hello, I created a custom assembly with some business logic and attachted it to a report. A class in the assemby has an indexer defined which should return a string. When I call the indexer from the code block I alway get an "Specified cast is not valid" error back. I created a test progr...more >>

I have various sql, sybase & access databases that i need to report from onto the 1 table. A number of joins link them all together. As you can only use 1 dataset, what would be the best way to report on my data into the one table. I have spent weeks trying to work this out. Thanks...more >>