Good afternoon, This is actually quite urgent and I'd really appreciate any helpful responses. Is it possible to join two datasets into a single report based on a specific column in each dataset? That is, if I have dataset 'dspatient' and dataset 'dsvisits', I'd like to join the two sep...more >>

I have 2 reports. When you view one, its breaks the data into page size pieces. I have another report that will just create 1 big page. Its probably about 4 pages long. Anyone know how to toggle this feature. I don't think I did anything explicitly, but I might have. Thanks John ...more >>

I've got some Reporting Services reports that I'd like to be able to link to from other dynamic web pages, passing parameters in through the HTTP GET query string. Everything I've read seems to indicate that if I append "&name=value" to the URL, it will load the report with the parameter set ...more >>

I see how I can sort data in a table or list, but how do I make it so users can simply click the column header to sort? Is this functionality not available? I have tried exporting to excel and find that my columns are merged together for the table and I get an error when I try to sort in ...more >>

We have a development machine, and a web server, both running SQL Reporting Services. My problem is that when I move reports from the development machine to the server, they lose properties, like font and can grow setttings. Please help me identify the problem. -- Thanks, CGW...more >>

Hi, I have created a line chart with 3 different datafields. I want them to have the colors yellow for the first, red for the second and blue for the third. Is there anyway we can manipulate the colors on the chart? If there is, can you kindly tell me how or point me in the direction of...more >>

I have a field which in the db is is char, and I want to sort in the report numerically. Tried changing it in many areas but it still sorts as if alpha. Is there an expression I can use on the report field to convert it to numeric? Will cast or convert work in a field level experssion? ...more >>

Hi, Just installed Windows 2003 server SP 1. Everything works fine except for Report Server which fails with this error from the web browser. The request failed with HTTP status 401: Unauthorized When I try to log into the http://oasis020/Reports/Pages/Folder.aspx site it asks me fo...more >>

It appears that I have come across a very weird but bad bug in the SUM() function in the Report Designer. I have a series of financial numbers, broken down into various expense categories, in a rolling 12 month format. For each month, a value is retrieved from the dataset and displayed. At ...more >>

Hi all, I am new to reporting services. What I am trying to do is display some of our accounting data in a debit and credit fields. I am using this expression to display the correct data in the fields: =Iif(Fields!credit.value,0,Fields!Amount.Value), however at the bottom I want to sum o...more >>

I am trying to Install Reporting Services on a Production IIS 5.0 server and I am getting the following error message: Internet Information Services 5.0 (IIS) or later is either not installed, or it is configured in a way that is incompatible with a Reporting Services installation. To inst...more >>

I have a number of occassions to place a database field inside a bunch of hardcoded text. But, it seems I can't do this if I want to format the number (or field). Below is an example. Your score this <DB Field1> is <DB Field2>%. For DB Field1, the database stores a date/time format (6/...more >>

I have a report that uses a matrix control to display the data. After spending hours on the report getting it to look right in Report Manager, I went to export to PDF and could not. I got the error "Internet Explorer cannot download format=PDF". So I proceeded to recreate the report step by...more >>

I've noticed that reports which use dynamic parameters ('Parameter B' is populated based on the value of 'Parameter A') can cause the Report Designer to go haywire. The problem occurs when I try to preview the report. When make a selection from the 'parameter A' drop down list, the Report De...more >>

In trying to find information about Reporting Services SP's I noticed in the instructions for Reporting Services SP1 there are instructions to install SQL Server SP4. Does an SP 4 (SQL Server) exist? http://support.microsoft.com/kb/842857 Reporting Services SP1 is independent of the SQL Se...more >>

Hi all, I have a report in which I use some embedded code. The assemblies I use are standard .NET assemblies. In my PC the rendering of the report goes fine, but when i try to render this report on another machine, the fields that call the embedded code (code!some_function) do not render co...more >>

I've been playing with Reporting Services for a week now, and it is great, but for some reason this morning I am getting a Connection problem, on all my samples, even if I enter a good SQL User Name and password it still fails. Here is the error messgae I am getting. Reporting Services Erro...more >>

I've tried various settings installing SQL Server 7.0, different modes of authentication (local system, domain user). Nomatter how I install SQL Server, then Reporting Services, I always get ... ' The report server cannot open a connection to the report server database. A connection t...more >>

There will be a SQL Server 2000 Reporting Services webcast early next month. See http://support.microsoft.com/?scid=http://www.support.microsoft.com%2Fdefault.aspx%3Fkbid%3D895617 for further information. As far as I can see there is no way to book ahead. Andrew Watt MVP - InfoPath...more >>

Hi, I am rendering a report in PDF Format using web services API using a click of a button which its doing perfectly. As soon as this report is rendered in PDF format, Is there a way to send him a particular user this report by Email thru C# FrontEnd. An Email has to be sent when a report...more >>

Hello, we use the Report Services to generate bills from our orders. Therefor a url with all the report parameters is created and send to the internet explorer which displays the report with the pdf plugin (standard). Our problem is that all reports have the same name (for example bill.p...more >>

Hi All, How do I link subreport with a mainreport. Thanks in advance Balaji -- Message posted via http://www.sqlmonster.com...more >>

Hi, Could you please enlighten me on the pros and cons of the two different standards XMLA or RDL? One thing I see missing in XMLA is CustomReportItems rather available in RDL. How can XMLA be extended to add my own tags in it? Thanks in advance, Shafia ...more >>