I am having trouble getting a report emailed for the first time. The timed subscription has been set. I have updated the ReportServer.config file to include the ip of the exchange server along with port number although im not sure where to enter a password. The IT guys are making sure that the ...more >>

I have downloaded up to SP3a, but the reports are not generated properly in Excel2000, although it works well in Excel97 already. Would it be allright if I re-install just SP1 which supposed to fix these Excel97/Excel2000 issues? Would I lose the extra enhancements from SP3a?...more >>

Any hint how to build a report that prompts user to select multiple values from a lookup table and uses the multiple values in WHRERE myfield IN (<user-selected-list>) to select the data? Thanks...more >>

Hey peeps, I am wondering to know if there is a way to change the color of the SQL Report parameter strip when the report is rendered. I tried changing a few classes in the Reportingservice.css file but those changes reflect only in the outer region(the container of the report, not the fram...more >>

I will be running reports on a shared database server. The database server supports one main application with many environments for different user groups. Each groups’ data is kept in a different database instance. I want to deploy my reports in a single location on the shared database s...more >>

I have Report Server setup and I want to add email delivery functionality. According to Books Online, to configure a Report Server for email delivery only the following is necessary in RSReportServer.config: 1) SMTPServer - Note I entered just the mail/smtp server host name, not fully quali...more >>

I continue to get this error on my new server install of reporting services. I cannot get the reportserver application extension on IIS6 to have a * to run it all thorugh isappi dll because I keep getting an extension not valid error about the *. I think this might be somehow linked since I...more >>

I'm not sure if someone's posted this already, but I came across why paging is working in some of my reports and not in others. If I had a visibility (hidden) expression on a table in a report, the report would render on one large page. I hope this helps someone out there! Melissa ...more >>

I need to put an asterisk before and after this expression: =Sum(Fields!InvoiceNumber.Value, "eqis") in a textbox so that it looks like this for code 3 of 9 barcode: *123456* Any help is appreciated. Thanks, Trint ...more >>

Hi All, I created a custom data processing extension wrapping calls to the .Net System.Data.OLEDB classes. I don't want to give the DPE FullTrust permissions in the rssrvpolicy.config file. I noticed that there is a SecurityClass entry for SQLClientPermission in rssrvpolicy.config file....more >>

I've built a fairly straight forward report in RS that looks normal in preview mode and in PDF format but when I export it to Excel the column header row is missing. Actually, it's present on the first sheet but missing on all other sheets within the document. The column headers are in t...more >>

I wrote aspx pages to index reports and show them in reportviewer control. The user needs to log in the aspx page, select a report on the index page, then log in to the reporting service form authentication log in page (for the first time). Everything works fine when I tested on the server lo...more >>

I'm having an issue with Page Breaks within a SQL Report. The report consisting of a single table with two groups. The report is setup to insert a page break after the first group. Grand totals are calculated in the footer of the main table. The report renders correctly in HTML. When t...more >>

I am getting #Error as the result of an expression and could use some help. This doe not make sense to me since the the data is on the "false" side of an if statement. expression 1 is: = iif ( isdate(Fields!RDD.Value) and Fields!STD.Value >0 , "true", "false") .... then I edited the "t...more >>

I have this magic eight ball on my desk. Today I asked it, "Will Service Pack 2 be released before the end of July, 2005?" It answered, "All signs point to NO." Just wanted to let everyone know. This is a very bad sign....more >>

With sqlsvr reporting services, I will have a separate W2k3 server, do have to use the default Inetpub/www directory, or will I be able to use a directory on different drive, for example E:\reporting.? Any input would be great. Thanks T ...more >>

Ok, Sometimes the shipping department puts in a "_____" instead of a value like this "23". The underbar should never show up on the report. The textbox should only display its contents if there is a real value. Here is the current expression for that textbox: = Fields!QtyShipped.Value How ca...more >>

Hello, My query returns numbers for months. Can I use conditional formatting to convert a 1 into Jan, 2 into Feb, ect? I know that there is a way to do this within the query itself, but am curious as to the conditional formatting way. Thanksabunch. ...more >>

I tried searching for this (since it's gotta be easy), but didn't find anything. I'm trying to add a date and an integer. The integer is a parameter that the user enters. So bascially, today is 3/28/2005. If I want to show the date 100 days from now, how do I do that? In Crystal,...more >>

Can I use SQL SRS with VS 2002? Does it involve downloading a service pack? -- jackwc...more >>

I am reporting off an oracle database that has a field with a number that is the date. ie 20041201 (yyyymmdd) What would be the best way to convert this into a date with the format dd/mm/yy. I regularly use this field with a parameter to allow my usres to generate their own reports. Th...more >>