Attempting to use parameters for report pulling from Teradata. Appears TD does not like parameters. Thinking of custom code for generate dataset query dynamically.. Is there function/method to generate / replace sql string? Other ideas? Thx...more >>

Hello, Can I install reporting services in a XP Pro, or windows 2000. We have SQL Server 2000 installed on XP Pro, I was trying to install RS2000 and I got a message it sais OS should be a server. Does that mean RS2000 can only be installed on a server? Can I install RS2000 on a windows 2000 ...more >>

Hello, I have a report with multiple data sets. I would like to take the subset of the results from one data set and use it in another but I am wondering about timing issues. Are the data sets all executed simultaniously or are they done in a specific order (ie. the order the data sets were...more >>

I have created a report with a boolean parameter. The radio buttons for T and F show up as I expect, but I can't get my labels to display. The buttons are simply labeled "True" and "False", even though I have assigned them more descriptive labels. I would much prefer for my own labels to ap...more >>

Hello, I have 3 tables in my datasource and I am trying to Join them with the following { oj TABLE2 RIGHT OUTER JOIN TABLE3 TABLE1 ON TABLE2.ACCTNO = TABLE1.ACCTNO } At least this is what the designer translates it to. I basically want Table1 as the primary table (al...more >>

When I preview a report using a matrix, I get the following warning: "The value expression for the textbox ‘Measures_Act_Amt’ references a field outside an aggregate function. Value expressions in matrix cells should be aggregates, to allow for subtotaling." The report data looks fine...more >>

hi, I am using IsMissing in below expression strStateName = iif(Fields!StateName.IsMissing, "Mahesh", Fields!StateName.Value) the problem is when Fields!StateName.IsMissing is true, strStateName is not getting any value assigned where as it should get "Mahesh" assigned. Please let me ...more >>

One of my reports uses a subreport. I use a script that runs under RS.EXE to publish the reports, with the result that the subreport appears in the list view where the user may be tempted to go in and try to run it, even though it's not intended for stand-alone use. I can hide it by going t...more >>

Can SQL Server 2005 Reporting Service be purchased seperately or need to buy SQL Server 2005 license also. In other way, SSRS 2005 database required to be on the SQL Server 2005 or it can even be on SQL Server 2000 ? Thanks, ...more >>

How could I add a percentage of total column to a matrix that looks like this: Employment Status Owned Rented Total Full-Time 10 10 20 Part Time 20 20 40 Totals 30 30 60 I want it to look like: Em...more >>

I am using the WS interface and returning reports for rendering will our UI. I am successfully getting back the parameters. I would like to create a drop down list box where appropriate for the parameters. So i iterate through the ValidValues[]. This works fine for the exception of when tho...more >>

Hi! We have changed the userid that Reporting Services uses. The process of backing up the key, changing the userid, and restoring the key seemed to work well. Everything is working fine, but we notice that SQL Server Agent jobs for schedules are still being created with the old userid as...more >>

I have been working for 2 days on getting rid of those anoying unwanted blank pages. I figured mine out hopes this helps you. Mine was a matrix and the fit on 1 page seems to screw things up. I played with font row sizes and page size and unchecked fit on 1 page, and my report looks great now....more >>

My IS Support installed Reporting Services (Client) on my box. MSDN says that I should be able to find the RS extention library DLLs under "...\ReportingServices\Report Manager\" . I am not finding the "Report Manager" folder at all. Do I need to install some other additional component for ...more >>

Hi, I'm new on Reporting Services 2005 and would apreciate your help. I'm trying to format a textbox in a matrix report to present an ABS value. I've tried several formulas but I'm getting this warning : "The Format expression used in textbox ‘SALDO_PERIODO’ returned a data type that ...more >>

Is there a way to prevent VS from collapsing the formatting that I do to keep an SQL statement readable. I go through all the trouble of writing the statement keeping it nice and neat, then VS combines it all into one lump of code. This makes editing it later difficult....more >>

We would like to upgrade to Reporting Services to 2005 as soon as it is released this fall. However, we don't plan to go to SQL Server 2005 for at least another year. I'm a bit worried about this configuration (RS 2005 on SQL 2000). Does anyone have any experience running RS 2005 beta on SQL 2...more >>

This is shutting down my employer... Went to change somebody elses report this morning with a new/different report parameter (after deleting the original). I CANNOT add a report parameter now w/o approximately 1/3 of the summary page textboxes (~100 out of 300) throwing errors now about ha...more >>

simply added a report parameter for a working report (which went fine and w/o issue..) next thing, went to build the report in VS.NET and got 100 Build Errors telling me that every TextBox on my summary page has the error: 'The value expression for the textbox '...' uses an aggregate expre...more >>

There is a problem when I include correlated query in the SELECT clause in the SQL statement like the following: SELECT a.column1, ( SELECT b.column2 FROM b WHERE b.a_id = a.a_id ) as dummy FROM a; (just replace a and b with any related table names from your database) This quer...more >>

I have to wait forever on this report and I know the end users are always going to have an issue with the lag. How can I make this report render faster using this query? SELECT t1.MemberId, t1.PeriodID, SUM(CASE WHEN t2.amountTypeId = 7 THEN t2.amount WHEN t2.amountTypeId = 23 TH...more >>

Hello All I am working on a report that will use a metrix to display locations on rows and time on columns. I have enabled the drilldown feature on the rows (Locations). The Problem is in the locations structure: some members don't have a child to drill into, and also a location may have a ...more >>

I am unable install ActiveX plug-in (RSClientPrint) for RS Printing in my client's machine who do have the administrative rights to download plug-in from the browser. Can anyone suggest me how can do this?...more >>

Hello all. Right now I'm trying to get a report based on OLAP data to work on a server which is only running Reporting Services. No Analysis Services have ever touched this server. So when I try to run my report, I get the following error: An error has occurred during report processing. (r...more >>

Hi, When you have more than one sub groups in a report, table keeptogether is not functioning properly. It is always breaking into multiple pages. I would appreciate if anybody give a fix for this problelm Thanks, vamsi....more >>