We have 6 Report Parameters (6 combos ). Each combo is attached to a Data Set. The default value for all the combos we mentioned it as NonQuery and set it with constant "All". When the report is launched for the first time, we see that 18 calls are made to populate the combos (3 calls for each...more >>

The domain\Administrator PW was changed a few days ago and ever since the ReportServer can no longer connect to its DB. When you first tried to reach the site in the browser you got the following error: ----------------------------------------------------------------------- The report server ca...more >>

Hi ! I am exporting a report to Excel. I have this issue where my labels that are to the left of my data columns are exported to different rows. Is there anyone out there can give me some tips or lessons learned when designing a report that will be exported to Excel? Thanks, Y ...more >>

I have installed SQL Reporting Services on my 2003 server and tested that all is aok using http://localhost/.... All seems fine and the default reports load no probs. My problem is when I try access the reports via WWW I can get as far as displaying the title of the report, but when I click on t...more >>

I have been having a problem with Reporting Services. It seems as though on Monday mornings, until an Admin logs on - and browses/ uses the report manager for anything... the users who have rights to browse get an error. As if - reporting services goes to sleep, until someone wakes it up......more >>

Is it possible to make a web service call from a report's custom code section? Or is it neccesary to wrtie a custom assembly to do it? Thanks....more >>

We have a customer in China that is interested in purchasing a solution we developed using RS and we are wondering if there are there any white-papers listing issues with running RS against SQL Server (Chinese)? Any info would be greatly appreciated! ...more >>

Hi Is there an easey way to set up report generation chaining (i.e. automatically start a second report once the first completes)? Many thanks, Dave Hughes ...more >>

I have a report that is returning several rows of data, but the report is only displaying the first row, how can I get the report to return all of the data...? TIA...more >>

Hi there, I have a table in my report and I need the heights of the first 3 rows needs to be: 1st row: 0.5cm 2nd row: 1cm 3rd row: 1cm So I set the height of each row by changing the height property on each row. But the height of the 3rd row keeps resetting itself automatically back t...more >>

This has happened several times. We set up a data driven subscription and it runs fine. We can edit it a few times and it works fine afterwards also. But at some point after perhaps editing it 5 or 6 times it jsut stops working. The job never fires off like it wasn't scheduled. You can de...more >>

Hello everybody, I have a web app where I need to render Reports using impersonation. I have looked at both the Forms authentication sample and the ReportViewer code, ideally, I guess a combination of the two is what I am looking for. I cant impersonate inside the ReportViewer control because ...more >>

Hi, This is what I am trying to achieve, but in vain. I have a report that has to be grouped by "Day" - I have hourly data for a day which can span for several days based on the report start and end time. For example if the report duration is 10/01/2004 to 10/05/2004, then I must see 10/0...more >>

I have a report with a graph on top and a table at the bottom. Sometimes the table becomes large enough to go to the second page. The problem is - the graph doesn't show up on the second page. Is there a way to fix the position of the graphs - so that it stays in one place as we scroll do...more >>

I'm trying to reference a report parameter in the code window: Dim CompId As Integer CompId = Parameters!CompanyId.Value It gives me the error: [BC30469] Reference to a non-shared member requires an object reference. Any ideas (or alternatives) on how to resolve this? Thank you. ...more >>

Hi, I have matrix report in MS SQL Reporting Services. And I need some information appear on every page (the same information for whole report) But when I tried to insert the field to page header or footer it gave me error: "The value expression for the textbox .... refers to a field. Fields...more >>

Friends, I must be missing something... I am trying to get a test example of an export with Office Web Components and am not having any success. The documentation is somewhat unclear, too. I know there are caveats to what can be exported to OWC. But have the following questions: 1) C...more >>

Hi, I have a parameter named County. County, can have multiple values in it - ex: 01, 02, 03. I need to somehow use a like statement with this parameter so that it will find all the counties in this field. I tried like%@County% but this doesn't work. Anybody have any suggestions?? Than...more >>

I am trying to convert a SRS report from using SQL to Informix. I have converted my stored procedure to Informix, but I am having a problem trying to get the data to display in the report. Informix stored procedures do not return field names/aliases with the resultset. I can view my dat...more >>

Hello, I wonder if it is possible to have better control over the colours than just selecting the palette? My problem is that I have several charts showing the same data series in different time periods. But for some reason the same series get different colours in the different charts. The...more >>

Hi there, Just started using Reporting Services instead of Crystal Reports and have a few questions: 1.) In Crystal, I can add a details section and hide it 'not onfirstrecord'...which essentially hides all instances of it except the first one. This allows me to add headers to details ...more >>

hi all, I have this strange problem with my parameters in a report. There are 4 parameters (2 date and 2 comboboxes) which need te be filled in in order to get the report. I've managed to get this to work on my test-machine,but once I deploy the code on another server,I get errors filling in...more >>

In the Body portion of a report I have a List. Within the List I have a textbox. Under the textbox I have a table with various columns. It's possible that the table spans more than one page, which is OK - it just depends on how much data I have. What I'm having trouble doing is the following...more >>

Hello, I need to pass field values to a URL when we click on a particular datavalue on the Report. Basically I am trying to put up a URL on a column of the report. And I would like to pass that corresponding column value dynamically. Please someone let me know how to do that. At present I ...more >>

hi, i need to pass the parameters to the report from a aspx page. im able to get the number of parameters required using the GetParameters webmethod.i want the user to enter the parameter and use it for generating the reports,How will i go it?? Thanks in advance,...more >>

Is there a sood reference for the syntax that is used in formulas? Here's the thing... If .NET there is no IIF Function...so I think, its SQL Syntax. Then there's the Bang notation (!) so I think its Access's syntax But I can say: =IIF(Fields!LAST_NAME.Value.indexOf("A") = 0, "Starts With 'A...more >>

Hi list! I have a set of report parameters and some are dropdowns (combo) from datasets. In adition to the values in a dropdown I want the value "(all)" as the first value in each dropdown. How do I do that?...more >>

Error attempt rendering extension that is not registered for this report server.... I would also want to use MHML and/or Excel as either csv or xls. Select Case LCase(OutPutType) Case "pdf" retVal = "pdf" Case "tif" ...more >>

I have Created an expression = Fields!Net_revenue.Value/ Fields!Gross_Revenue.Value Works fine but Net_Revenue.value is created from Sales Volume * Purchase Price and if no Sales Volume then the default will be zero. If the formula tries to divide by a zero I get an -infinity error on th...more >>

Hello all, Hope someone can help me with this problem. I wrote a report last week, connecting to a database we have and using the " allow saving password" option. This week I come to reopen the report and i am getting the following error message: " a connection connot be made to the dat...more >>