I'm trying to build what I would consider a very simple report, but I can't seem to figure out how Reporting Services wants me to do it. The "report" is really just a form letter. The data set contains basically a persons name and their ID. What I need to do is print a new page for each n...more >>

I need to make one column on a report to display as hyperlink. I am using TextDecoration underline property . How do I change the underline property to None dynamically based on the data. I am writing the following code in the Expression section of TextDecoration property of the text box. If ...more >>

Hi There, I have a question here. I'm using 2 subreports say subreport1 and subreport2 in a mainreport. Based on a parameter value i would like to show the subreport1/subreport2 or show both. Please let me know if this is posible. Thanks in advance. Rajesh ...more >>

i've noticed that others have gotten this same error, when trying to export to excel they get the following error, it seems it hasn't been something dealt with, maybe because microsoft cannot reproduce it Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException w...more >>

Hi, I am trying to create a data driven subscription. I have stored the credentials and custom data source in the report. My account has site administrator and content manager permissions, yet the "New Data Driven Subscription" button is not available. I have multiple reports like this. ...more >>

I am using a beta version of reporting services 2005. I have created my report parameters as multi-select. However, I'm having trouble having the query parameters accept the list that the report parameters passes. (below) I tried replacing the = with in and between and neither work. It do...more >>

I would like to be able to disable a Jump to Report link when the value of a particular field or parameter is a certain value. For example if parameter x = 1, enable the jump link, but if x = 2, do not allow the jump. Does anybody know how to do this? Chris Kennedy ...more >>

The following Extension Parameters are not being accepted -- CreateSubscription works and a record is created, but three values are not getting through to the database: extensionParams(3) = New rsSubscriptions.SVR03_ReportService.ParameterValue extensionParams(3).Name = "RE...more >>

Hello, Report.PageWidth - Report.LeftMargin - Report.Right Margin) >= Body.Width 8.5 – 1 -1 >= 6.37 I still see one blank page with page header only when I go to print preview in the Preview tab. What is problem? ...more >>

My report has images embedded in the report and when I render the report it shows everything but the images. Any ideas? ReportingService rs = new ReportingService(); rs.Credentials = System.Net.CredentialCache.DefaultCredentials; // Render arguments byte[] ResultStream = null; byte[...more >>

Hi, I'm having problems activating a second server that is participating in an NLB cluster. The common response I see here is to run rsactivate from the first node using the -m switch to activate the second node. The problem with this is that when in an NLB cluster you cannot even ping the sec...more >>

Hi, I'm just starting with RS. Can Datasets be shared or copy/pasted between reports. I have a number of reports that are all based on the same source query and would like to avoid coding in several places. THanks in advance. -- Doug...more >>

Hi, I need to calculate a percentage of population based on the number of rows returned on a dataset. Within a stored procedure, I could use @@ROWCOUNT but there is no way for SRS to receive multiple result sets in a single data set. I could execute the query twice, once for the count and...more >>

I have a Resource file that is a htm file in a sub-folder on reporting services. Using the web service I am getting the catalog items using ListChildren. I want to be able to extract out the contents of the htm file. It is stored as a text/html MIMEType. I don't know if this is the correct f...more >>

Hi all.. I have created 3 report parameters, named: NUMERO_POLIZA, CUATRIMESTRE, AÑO (in this order). When I preview the report, only NUMERO_POLIZA appears enabled. All others disabled. One strange thing is that when, in report parameters dialog, I move NUMERO_POLIZA parameter down, for...more >>

Does anyone know how to pass parameters through to the Sharepoint Report Viewer web part? Thanks, Paul. ...more >>

I have a table that has a "Problem" field with the following data Customer Service...Jam...Jam 5...Planned Technical Support...WinOnCD...WinOnCD6PowerEdition...Request...Reporting New Drive Sale Made I need to separate this "Problem" field into separate fields the issue1, issue...more >>

We currently use CVS as our versioning tool for .NET production. It has been suggested that we could also use CVS for SQLRS versioning in the same manner. Has anyone implemented this, with or without problems, or is there another 3rd party tool out there we could use. Thanks, Tony...more >>

I have lost the reports that I designed. They were deployed and are currently being used. Is there a way to get the RDL out of the ReportServer database ? Thanks, Craig ...more >>

Hi all... I have an Oracle Type connection whose connection string is only: data source=Pluton. I created a dataset with a query parameter, this way: SELECT NUMPOL FROM POLIZA WHERE NUMPOL = @NUMERO_POLIZA Here I have got some problems: 1.- The parameter wasn't created automaticall...more >>

Hi, can anyone tell me about the advantages of the techniq RS vs. crystal reports or any other tool. Thanx a lot. AJ...more >>

Hi, I have made a report, which seemed to work fine, but with some parameters it gives me the 'subject' error. The complete error description is: Processing Errors An unexpected error occurred in Report Processing. Index was out of range. Must be non-negative and less than the size of the ...more >>

How come I cannot make any reporting projects ... when choosing new from the menu it seems as the report designer isn't installed but when checking installation settings in add / remove everything is installed - do I need to apply servicepacks ? ...more >>

Hello, I would like to deploy report into folder named HOME3 located under the ReportServer directory. For example: http://[hostname]/ReportServer/HOME3 How do I type in the TargetServerURL so that report is deployed in HOME3? I appreciate the help. Thanks. Steve ...more >>

Hi all, I have a report that has 4 parameters but all of them can accept null values. Currently report defaults all of them to null and first time accessing the page, it will run the report. The problem is it will try to return the whole DB in that case. How do I prevent it from running unless...more >>

Hello All; I was wondering if there is a way to make decisions on a particular cell in a report (Tabular of Matrix) where the "CASE" effect can be achieved. I use IIF (SOMEHTING >0,"RED","Green") all over, but I wonder if the decision making can be expanded on Cell's content so as to get th...more >>

Hi I have a simple report I would like to run for 60 users. Is there a way to have one report cycle though a dataset and create 60 exported .mhtml files? I really don't want to create 60 reports and 60 subscriptions :( All the exported files would reside in the same folder. Any help wou...more >>

Is is possible to order the columns in a matrix? In this case, the number of columns is always the same. So, for example, if the columns were Car, Truck, SUV, and Bike, can you code MSRS to report them in the order Truck, Car, SUV, Bike? Thanks, Andy...more >>

I am extremely new to SQL Reporting Services. I have a report that is currently not using a stored procedure. I have 7 parameters, and I want to make the last two optional. So my query that runs would have a where clause that would have an AND at the end if the last two parameters were give...more >>

Hi All, My company has a legacy web application (VBScript/ASP) that includes a series of forms used to create various reports on SQL Server (or Oracle) data. Creation of these reports is extremely tedious due to fairly complicated calculations etc. My question for the group is: Is MS R...more >>

Hi All, I have installed VS.Net 2003, SQL Server 2000 with SQL Server 2000 sp3, enabled Internet Information services, Frontpage server extensions. However the Report Server database does not appear on my local server. Is there something I am missing? Thanks Sanjeev ...more >>

I understand that one must have certain rights in their role as publisher in reporting services. Does anyone know the minimum rights needed to allow a developer to publish reports? Must they have domain admin rights. Win 2000 Server running SQL server 2000 and RS on a domain. Thank you...more >>

I have a table about 3 rows. I want to see every other row highlighted gray so it easier for the eye to follow. any ideas? Thanks Fab. ...more >>

I have numbers along the side of my chart in MB's. The numbers a large so i want to format the number with "," ie I currently have 200000. I want to see 200,000 along the side fo the chart. along the y axis. Thanks ...more >>

I am using the Report Manager and I create a report and then create a new data-driven subscription. I give it a name and choose File Share. I specify a shared datasource, which I setup with my report, for my Subscriber info. Do Select * from UserInfo for my query. On the parameter page I suppl...more >>

I have a matrix report with 3 column groups. My main group is called "Location" and then I dump out a bunch of data related to that location. I want to insert a blank line before each new "Location" in my report but I can't figure out how to do this with my matrix report. Any ideas?...more >>

Hi all... Suppose the following case. A report that displays some data concerning the bank account of a customer. For performance reasons, one of those data need to be retrieved using a separate query. Such field is the mailing address of the customer that I have to query from other set of ...more >>

Hello, Thanks in advance. I am having a problem passing parms into a stored procedure and am hoping I am just doing something stupid. I have default values set for each of my parameters, but it doesn't appear to be sending the values. Could someone take a look at this and let me know what I am...more >>

Does anyone know how separable RS2005 will be from the 2005 DB Engine? We would like to use some of the new features expected in RS 2005 e.g. Multi-Select list boxes, but don’t want to upgrade either our Application or RS DBs (well not for a while anyhow). Is that in anyway feasible, and if...more >>

We have a report that links to another report. The A report is a posting on our intranet and we'd like to have it so when a user clicks on the link for the other report it will open another window for them. Any ideas on how this may be done?...more >>

have one dataset pulled from query that gives list of departments. The other dataset is a stored procedure 'usp_orders' that accepts three parameters, one is a non queried date for start date the other is a non queried date for end date. The third is a department from the first dataset 'dept_l...more >>

Hi all, I have a set of textbox controls stacked vertically. They display address information in the below format. How can I hide add2 if the field is empty or null? Can I also collapse the field so their is no gap between Add1 and City, St....? Name Add1 Add2 City, St, zip Than...more >>

Hello We are using SPSS and we combine many frequencies(table) in one report. SPSS frequencies can look like this: Ordinært avviklet 1 Poliklinikk 3 Innleggelse 1 Mann 50 11 61 2 Kvinne 100 15 115 Total 150 26 176 Nyhenviste 1 Poliklinikk 2 Dagbehandling 3 Innleggelse Tot...more >>

Is this possible in RS? I want to display $1000 as one thousand dollars and xx/100. Thanks for any help. ...more >>

Hi, all! What about making a russian version of RS 2000 ;)? Regards, Ailil...more >>

How can I define in designer a GUID query parameter for a stored procedure? If I give the guid as normal string, the designer display the error 'Can't convert string to guid'. Thanks Eric ...more >>

How to a format a date u appear as short month. I.e. i want to see it like this Apr/27/2005 Thanks ...more >>

I have made a report and now I need to sort on a calculated field where i subtract 2 database fields, and i only want the 20 higest. I'm new at this and appriciate any helt I can get, thank you ! Jack ...more >>

I have a subreport. In the subreport I have put all my elements in a retangle. The retangle has set PageBreakAtStart. This way the main report works fine, I get a page break when the subreport starts. Now I need to hide/show the subreport depending on a condition. I set the Hidden attrib...more >>

Hi all, have a Matrix-based report that tracks project's %complete by period id for a particular year, as follows: - 2005 -------------------------------------------------------- 01 02 03 04 05 06 07 08 09 10 11 12 project...more >>