Hi , I'm trying to make "word wrap" work when writing an e-mail=20 with Outlook Express, will appreciate any help, ever thing I have tried so far did not work. Thanks, Doc....more >>

Hi, I am wanting to alter the look of the Report Viewer Control. I was under the impression that the file: htmlviewer.css (located in: ReportServer\styles) was the file to alter to achieve this. Thing is that even when this css file is changed, there is no effect on the visuals of the re...more >>

Hi, I've been trying to get Reporting Services to activate but I keep getting an error. The error is The Report Server Web service has not generated a public key. I am trying to install RS on a W2K SP4 Advanced Server with SQL Server 2K SP3. I am using a named instance (TTBITEST2K\JAI). ...more >>

Greetings, i'm using ms ReportViewer which was provided. heres the deal, in my report parameters if i leave "prompt" empty and unchecked "allow null value" and click in preview, i do not see the parameters being shown at the header. WHICH IS WHAT I WANT. GOOD. but then, if i were to use the r...more >>

I have a report in which i don't know what I did but it has started displaying the document map, I know this might be silly but still i haven't been able to get rid of it, how do I do it? ...more >>

A Non-Admin user can't create a linked report in his My Reports folder. Reporting Services is set up with My Reports enabled with the default tasks assigned to the My Reports role (this includes Create linked reports). This same user can create sub-folders but not linked reports. -------------...more >>

Is the Report Manager vulnerable to the issue described here: http://support.microsoft.com/?kbid=887459 I'm not very experienced with ASP.NET - can I assume that any additional safeguards for the "canonicalization" issues would have to come from Microsoft in the case of Report Manager as i...more >>

Got past other issues.. now getting bad request... I have this working wonderfully on my local machine... can't get it to work on a Win2k3 server.. Anyone have any links? w3wp!ui!690!10/7/2004-15:49:04:: e ERROR: The request failed with HTTP status 400: Bad Request. w3wp!ui!690!10/...more >>

I have two datasets, the first one attached to a table, and I would like to display a field from the second dataset based on a criteria. Think as an analogy to joins, but for various reasons I cannot merge the queries to get a single dataset (data is coming from different databases). So, I...more >>

few useful articles on Reporting services.. http://www28.brinkster.com/avdotnet/articles.asp ...more >>

Peter Blackburn and I have been told by Addison Wesley that our book = should appear in bookstores anytime now. It's already receiving rave = reviews (see www.sqlreportingservices.net) so if you have a tough = question on Reporting Services, you might pick up a copy or venture to = our site for ...more >>

I have both a custom assembly and a data processing extension. The DPE I have successfully integrated into RS. But, I have written a custom assembly that I use for creating a barcode image. I run it fine in ReportDesigner and believe I have given it and the Barcode.dll (3rd party) "FullTrus...more >>

My company has spent the last few months developing a set of complex financial reports using RS. The goal has always been to package them into a single PDF, with different users receiving customized versions of each report (eg, everyone in NY gets #s for the NY office). We've just learned that...more >>

Does the scheduler for executing a snapshot just simply not work??? Is there a known issue with this? I've tried everything, daily, weekly, on and on....the only way i've ever gotten a snapshot to execute ever, is by checking the "execute a snapshot when the apply button is clicked". Anyon...more >>

Hi, I want to format an address field that is in a database as 123 Happy Street| |Montgomery|AL|36104 I want to break it out into address1, address2, etc without the pipes. I found some code that seems to fix my problem below pretty well, but about half the time it doesn't work. I get an e...more >>

I have a report that has two lists. One is embedded in the other list. The outter list has a filter on it to pull hourly employees. The inner list is a detail list to show the hourly employees and their hours, grouped by employee. The detail shows a sum of the different types of hours work...more >>

Hello, I need to force a string column to uppercase. In Powerbuilder there is a function upper(). Can you tell me the syntax to use in the expression editor for RS. I can't seem to find an example in theReporting Services Help. Thanks in advance! -- Jean...more >>

Is there a way to reference the results of a query by column number? i.e. select Name, City from tblEmployee so referencing field 1 from the query in a table will list all the employee names Thanks....more >>

On one of our development boxes, RS is installed and even pumped out a report last week. Now, even if we create a generic, 1-table report via the wizard, running SQL on the data pane returns results, but nothing shows in the preview pane. Even if we just put text in the page header area, not...more >>

I have a test server that is a domain controller. It is running Windows Server 2003 Enterprise. Running SQL Server 2000 Enterprise with SP3a and hotfix 859. I installed Reporting Services successfully. Due to machine configuration changes, I uninstalled reporting services. I have not been...more >>

Hi I'm a complete newbie to C# and Rep Services, however i have a report running on my localhost via a Web application created in C#. All fairly simple stuff so far. What I cannot get right is a simple task of setting, say, one of the Report params from within the C# code. In other words...more >>

We have a Win 2003 EE Server running SQL 2000 SP3a and the latest hot fixes. We are not running Sharepoint Services. Every time I install on the server I get a message at the end of the install it couldn't activate the product. So I read in the manual how to activate the product, and it says...more >>

Hello, I'm having some problems using the Report Manager, but I *really* need to make a role assignment now. Can't wait to have the problem with Report Manager solved. So, I would like to make this role assignment directly in the ReportServer database, using the SP SetPolicy or some other SP....more >>

I have a couple of textboxes on a report that are just where I want them. When I preview the report in the IDE, they are where they are supposed to be but when I deploy the report and view it from the report server they float down to the middle of the screen. How do I fix this ?...more >>

Hi, Can I setup reporting services to render a table to Xml without rendering two "list-elements"? Ex. a table with two rows with 2 columns renders like this: <table1> <rows> <row> <column1 ...> <column2 ...> </row> <row> ...more >>

A table in my report has 2 parent group rows & 2 subreports w/in the body. No matter what I try, I cannot prevent the right margin from bleeding past the page width and generating an extra blank page for every one of text - in pdf, print preview, print, whatever. The only tips I've seen po...more >>

I am trying to render a report directly to PDF from a windows application, I do not want to have to load IE to get to the PDF. Does anyone know how to do this? thanks! ...more >>

When I execute my report on my web server, I can see the data that requires a query to the custom assembly. I have got "#Error". When I execute my report in the Preview window my date is present. My Assembly is reference to the C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\...more >>

ok, I know this topic has been covered COUNTLESS times in this group, yet the solution is still very, very hard to come by. Has anybody successfully published their reports (through a custom .net web application using URL access to the report server) to an external network / internet? If so,...more >>

Greetings, I need to make a line graph that has running total data points for each month. In my table I am able to use the expression =RunningValue(Fields!Commitment.Value,sum,nothing) and it works fine and gives the desired result. However when I try to use this expression in the graph all...more >>

I have encountered a problem where repeated items are only rendered to the first page. Apparently this is a known issue, but the workaround of using the page header doesn't work for me, unless I'm missing some way to overlap the header and the body of the report. I am trying to display a ...more >>

I've installed Reporting Services on a server MSSQL. The installation created 2 virtual directories within IIS : Reportserver & Reports. The security on these virtual directories is the following Anonymous Access is disabled Integrated Windows Authentification is enabled While surfing to...more >>

Hi, Anyone know how can I export data to Excel 97/2000?, because in my company everybody has Excel 97/2000 and it's impossible change version. Thanks and sory for my English :)...more >>

Line Graph : My requirement is to create a chart that shows 2 employee-career lines. One is Titles and the other is Salary. This means there should be 2 lines , one is a line that shows how the titles of the employee changed. The other is the salary line that will show how the salary for the ...more >>

Is the runningValue function still not implemented for charts? ...more >>