Dear All, I would like to ask, I am going to use the RS to generate PDF reports, those reports will be sent out, as attachment in the email. How can i put the PDF generated in RS as the email attachment? Thank you. Regards, Angus ...more >>

Dear All, how can i save the pdf to the server instead of export the the client? Thank you Regards, Angus ...more >>

Hey All, I setup a log shipped server so we could have a warm backup but the only way I could make the business case to spend the money was to use it as a reporting server as well. Needless to say, people are not that happy about getting kicked out all the time when the data is loading...more >>

URL : http://<Servername>/reports/ Error : The underlying connection was closed: Unable to connect to the remote server. OS Windows 2000 Server, ..Net 1.1 ASP.Net (not sure how to find version) I have VS 2000 and 2003 installed on this box I have tried reintalling RS twice.Searched this discu...more >>

Hello, I have a stored procedure that asks for 2 parameters: ProductID or Class. I want it set up so if the user does not enter either one then the query selects and returns all records. In RS Report Designer=> Data View, I executed this stored procedure however it gives me an error: {An e...more >>

I populated a parameter list with dataset. The parameter @type_year has items look like "plan_2000" or "Actual_2000". Now my question is, if we can use some string function targeting @type_year in the query. something like "select ...... from ... where year=getyear(@type_year) and typ...more >>

Hello... I have a server used for testing....and it also acts as a backup/mirror for one of our production servers. This server has two instances of Sql Server (one used for testing and the other as the production mirror). Currently, I have set up SQL RS to point to the testing sql server datab...more >>

I am writting a custom web app that I need to get all available reports from the report server into an arraylist and then populate a drop down with that arraylist. I am getting back "myAppName.MyArrayName+ReportItem". I get this line for each available report in the dropdownlist but not the name or ...more >>

Hi, I'm trying to use Reporting Services, I have installed the client component on my computer (Win 2K pro sp4) and I try to start to design a new report. The data source is a SQL Server developer edition Sp3 installed on the same computer. All works fine until I try to preview the report usin...more >>

hi, can any one can send the differences between Microsoft Reporting Services and Crystal Reports. regards, chakri ...more >>

What would be the easiest way to make all the reports in a RS folder available to everybody who can access the Report Server website, whether or not they have NT accounts? Joe...more >>

If we own two standard edition SQL Server licenses that we can use for Report Services and a SQL Server running on another server, how does the report server recognize I have a valid license? The setup doesn't ask for any sort of license key... we don't want to install SQL server on our actual rep...more >>

I am using Matrix in my report. I have One Row Group (ProductID) and 7 Static rows. Expression for my ProductID Group is =Fields!ProductID.Value How can I set the Page break so I can accomodate 4 Row Groups (i.e) 28 lines on one page and then goto next page. Any Suggestions. ...more >>

is it possible to create one RDL file that consists of main report and subreport? ...more >>

Can i add any new type of Output format in the export report select box other than PDF,Excel etc which r give in dropdown.If yes please help me. Regs Vijay ...more >>

In a network load balance architecture - Scenario 4–Multiple Report Server Computers Connect to a Remote Report Server Database in a Web Farm Configuration I have gone through several white papers and newsgroups - and they all say - "for reliability and scalability"... What's the real be...more >>

I have a main report which includes 4 sub-reports. One of the sub-report shows the details based on selected parameter values and at that time all other sub-reports are hidden. When I run the sub-report as a seperate report, it shows page breaks correctly but when I display it from the main report, ...more >>

I am trying to use the one-time schedule option in Schedule Detail section and the subscription never appears to run. I can get the Hour option to work. Does anybody have any ideas? Thanks Tim...more >>

If anyone has a e-mail subscription that works, please tell me what you did, security-wise, because I get logon failures regardless of what I try, and I am convinced that SQL security accounts do not work with subscriptions. What is going on here? Regards Richard ...more >>

Im trying to set up my report for a landscape view. I have changed the PageSize in the report properties to 11in, 8.5in. I made sure the size of the body is less that the pagewidth - the left margin - the right margin. When I do a print priview i get the error "index was out of range." If i chan...more >>

I saw this posting below, and I just want to be clear. I have a data set with one Column, but many rows. I would like the data to display horizontaly, then wrap to the next line. My data is actually displayed in through Image controls. Im pulling the images from an external path, on the web (htt...more >>

I'm using RS sp1 and have a report that's 50 pages long and has 1000 thumbnail images in it (it serves as a products catalog). When I export as a PDF or tif, only half the data is exported so in the case of the PDF it cant open because it says its corrupt, and in the case of a tif, it will open...more >>

I have a subscription to a report that delivers an Excel attachment. When delivered to my outlook mailbox, no problems. Same report attachment delivered to my hotmail account is corrupted. Results are the same with the CSV option. Is this related to the problem with lotus mail servers?...more >>

Hello, I seem to have done something terrible. I had a long running data-driven subscription processing and had at least two hours of remaining processing left, so I attempted to find a way to stop the process. Is there a way? What I did was delete the row out of RunningJobs, but that seems to...more >>

GOOD MORNING, I HAVE INSTALLED THE MSSQL RPT SVC ON A SQL SERVER BUT HOW CAN I DESIGN A REPORT? I DON'T HAVE VISUAL STUDIO .NET ON THE SERVER ,IS A PROBLEM? ...more >>

I am attempting to install Reporting Services on a Windows 2000 (SP4) Primary Domain Controller. The initial issues I was experiencing were permission related. The TBP\IWAM_XXX account required changes to the Domain Security Policy. We made the changes as instructed in the Knowledge base article....more >>

My application collects some information using the FreeTextBox web control, which allows the user to paste HTML, word documents, etc... The user has requested custom SQL Reports to display the data, instead of the html reports that I created. Problem is that the data stored as an HTML string d...more >>

I want to use the RS object model to pass parameters to two reports, then render them in the same pdf. My users don't want to receive 20 separate PDFs each day. Is there a way to do this? Any help is greatly appreciated. Burt...more >>

I created a Windows report viewer and use the RS HTML viewer to view a report. In order to print the report, I added two buttons in to the viewer, one button is for Print-Preview and the other is for Print. For various reasons I decide to use Acrobat Reader as the print/preview tool. I know...more >>

Hello, If I have a text box with the following value : =Sum(Fields!Sales.Value) Can I then in another text box write something like: =textbox30.Value + textbox50.Value Is this possible? ...more >>

I have added the Sample Printer Delivery Extension to my report server, and am able to print most of my report, but not all. When the report is printed, data is 'chopped' off (not printed). Currently, if the report spans 3 pages, the 1st and 3rd page are printed (the second page is skipped). If ...more >>

I am attempting to install SQL RS and I am getting the error "Instaliing WMI registration Error -2147221164" I had just upgraded my PC from Windows XP Home to Windows XP Pro. I suspect this is not a SQL RS issue, but maybe someone knows something about a solution. ...more >>

I'd like to format a textfield with newline. In Preview everything looks ok. After exporting to pdf all newlines are gone. I use the following text inside the textbox: +++ =controlchars.Newline & controlchars.Newline & controlchars.Newline & controlchars.Newline & First(Fields!NameKunde.Value,...more >>

I have the following script where the select parameters is dependent on the "component" parameter list being send via the stored proc. Therefore the number of parameters returned by the proc is dynamic. These fields therefore do not show in the .Net design to be added to the report. Need some adv...more >>

Hello! How must I change the config files that my assemblie will work on the Reportserver? Lokal in VisualStudio.net all works fine. But on the server nothing happens. Please one tipp for me. Michael Herrmanns...more >>

Hello everyone, I am newbie to SQL RS and just got it installed on my laptop. I wanted to know if the following is possible with SQL RS or do I need to use a thrid party tool. Here is what I want to do: I have a search website where users can query certain (SQL) databases and genera...more >>

I try to install report server in my computer. The problem is I want to install it not in my default web site (my default web site is stopped). I want to install it in another web site in my computer but the installer doesn't recognize my web site. If default web site is turned on, the installation ...more >>

When I configure Mail Delivery in RS sending mails with links works fine, but when I want that also report is attached in mail I get corupted files. There is no difference if it's PDF, Excel or TIFF. Delivery to File Share is working fine and all files are readable. I use LotusNotes SMTP servic...more >>

Other than Document Map, is there any built in searching function within the generated report ??? e.g. The generated report contain more than 100 records. Then I would like to locate a particular record by inputing search values in textbox....more >>

I have a report that serves as a product catalog and the main content are thumbnail images of the products with a SKU number on top of each one. All of the table columns are 1 inch wide, but the images vary in width and often are .5 inches wide or even less. By default all the images are aligne...more >>

Hi to all I need to use a set of stored procedures as source of my report datasets, my problem is that I have several reports already created some of them using StoredProcedure as command type, and others using Text and using "EXEC MyStoreProcedure @Param1,@Param2" as the Query String , it see...more >>

Can anyone confirm what's happening when a user click the drill down (+) button to expand or collapse data. It appears to be doing a round trip, but does not appear to be re-querying the data. The round trip process is too fast. I am using OnDemand reports (no cache or snapshot), and the th...more >>

I am a newbie to SQL reporting services, and have a security question. I have a web application that users come in as IUSR. I have a web login page, which asks for a name and password. I query a database to see If a match occurs, then I set a session variable which controls access to the other we...more >>

Does anyone know how to handle assigning permission to user folder without using the report manager interface? Through a command line or programmatically?? ...more >>

Hi, I want to print a field in the page header. Since there is no option in RS to include a database field in Page Header, I placed the Field in a Table header and set the the Repeat Header on Each Page Property. But it prints the first value of the record on all page. Is it anyway to print th...more >>

Is there a clever way to display an alternate image or message if the image control cannot find the image as specified in the External URL? In other words.... we supply the image name via a field.... But if the image does not exist, we get the red X. I want to display something other than the ...more >>

CreateReport throws an error saying that user IUSR_XXXXX doesn't have permisssions to run this method. So, 1) I went to ReportServices roles and anded a new group for IUSR_XXXXX user 2) Assigned ReportserverSysadmin role for the new group. 3) Also set db_owner permissions for the IUSR_XXXXX...more >>

Is there a way to add percentages pointing to the pie pieces? ...more >>

Hi all, I want to include a character in a TextBox which represents a new line feeder. The problem is: I need to pass a string through a parameter, and that should be divided in multiple lines in one textbox. I know it is possible to get a new line in a textbox by pressing Shift + Enter, only...more >>

Hi there, SQL Reporting service sample "Foodmart Sales", the dataset is from below: SELECT { [Measures].[Store Sales], [Measures].[Store Cost] } ON COLUMNS, {Descendants([Product].[All Products],[Product].[Brand Name],LEAVES)} ON ROWS, {Time.[1997].[Q1],Time.[1997].[Q2],Time.[1997].[Q3],Ti...more >>