Hi, i created a report like this: Q1 Q2 Q3 Q4 subTotal sales1 customer1 10 20 30 40 100 10% 20% 30% 40% 100% i wana show the percentage, so i need to get the row subTotal value, can anyone help me? -- ...more >>

We are trying to deploy a report server project from an XP Dev box to a Server2003 production environment. Both computers are running SQL Server 2005 with SP1 installed. We have tried to deploy by (1) a deploy over the network and (2) a database backup of the ReportServer database and then a r...more >>

I have a report that uses the table control, the last column has id's for dealcompanies in it. When the user clicks on any of the other Columns in a row I would like to be able to grab the id from the last column in the row and insert it into the expression for the Jump to url feature. This...more >>

Does SSRS have a tool/method or some way to snake text i.e. 1 5 9 2 6 10 3 7 11 4 8 12 Thanks, Gary ...more >>

HI there, I have a problem viewing a report on the report server that uses a Visual FoxPro dbf file as the data source. The database is on a network share, not on the same server as the report server. This is the error I am getting trying to run the report: The current action cannot be...more >>

Hi I have wrote a set of report for a large company, this company has up to 20 different divisions, all with a seperate sql server and seperate instances of reporting services. My single report project needs deployed to all 20 different instances on a regular basis (as their is a lot of cha...more >>

Hi, the following problem has just started happening: When you click the back button in IE to jump back from a drill down report, first you get a blank pg and then if you click back again you get back to the previous data. Apparently, the cause is a hot fix that was released in June. We w...more >>

I'm using SQL Server 2000 Reporting Services. I want to create a curve using chart for a series of data. If the number of points (x axis) is small (less than 800), the curve is displayed correctly. But if the number of points is more than 800, the curve cannot come out, after about 1 minu...more >>

Hi All i wanted to implement foms authentication to RS2005.i am using the MSDN article to implement the forms authentication.when build the project i am getting this error. 'Microsoft.Samples.ReportingServices.CustomSecurity.Authorization' does not implement interface member 'M...more >>

Hello, I have created a report which use MS SQL Server 2000 Analysis Services. I am using MS Reporting Services 2000. I have 7 parameters, 3 Of them are also linked to olap data source. The other 4 parameters are non queried. Every parameter has non-queried defaults and some defaults use e...more >>

I have a report that uses the table control, the last column has id's for dealcompanies in it(Fields!res_dealCompanyid.Value). When the user clicks on any of the other Columns in a row I would like to be able to grab the id from the last column in the row and insert it into the expression for ...more >>

What's the best way to display "approved" when a status field is "A", "pending" when a status field is "P", etc? Would the SWITCH statement be best? If so, what is the syntax for this and where do I put it in my report? Any suggestions are welcomed. -- K. Thomas...more >>

using ssrs 2005 I have a report that looks fine in the preview and in mhtml. But in Tiff and PDF it page ejects and takes another blank page and an eject prior to printing a textbox. The textbox is as wide as the page width (I have made it narrower and played around with the height in the lay...more >>

Has anyone had any luck getting an Avg on Date Diff? Here's what I'm trying to do: Figure out the average time it takes from ringtime (datetime) to starttime(datetime). Any ideas? ...more >>

I am having some issues trying to uninstall SQL Server Reporting Services 2005. We are running: Win 2k OS Sql Server 2000 NO reporting services Sql Server 2005 w/reporting services When I try and uninstall my previous version of SQL 2005, everything uninstalls with the exception of report...more >>

Sometimes my subreport renders fine in the preview environment. An then sometimes I simply get the message Error: Subreport Could Not be Shown. There is no clue given as to why it cannot be shown. I just have to do random things with the layout and hope it shows. Is there a more scientif...more >>

Hi all, We've started having problems with our SSRS 2005 reports in the last few weeks, whereby users get the following error when they try to access reports: "The selected report is not ready for viewing. The report is still being rendered or a report snapshot is not available. (rsReportNotR...more >>

Textboxes with lots of data force page breaks when exported to PDF if they do not fit onto the remainder of the page. This leaves a lot of whitespace on the previous page which looks odd. Does anyone have a workaround that will split textboxes across multiple pages when rendering to a page bas...more >>

I am getting the following message when trying to export a report to PDF format --------------------------- Export Error --------------------------- Index was outside the bounds of the array. --------------------------- OK --------------------------- The report works fine in all other f...more >>

this is about two related issues... We tried to deploy by backing up the ReportServer DB on my XP dev box and restoring over an existing ReportServer DB on a Server 2003 box. After the restore, when trying to go to /localhost/reports we got "login failed for 'NT AUTHORITY\NETWORK SERVICE'. ...more >>

I have created a report which uses an external .bmp accessed through a URL as the background image of the header (i.e. to brand the report with the company logo). this works fine until I use the interactive sort function which causes the image to disappear. refreshing the report brings back...more >>

I have a report that uses the table control, the last column has id's for dealcompanies in it. When the user clicks on any of the other Columns in a row I would like to be able to grab the id from the last column in the row and insert it into the expression for the Jump to url feature. http...more >>

I'm building a winform application and I've managed to use the Reporting Services webservice to render a report after passing it a parameter, but I can't figure out how launch it in Acrobat after rendering. I've done it in a web app using Response like this: Response.ContentType = "applicatio...more >>

We have an ASP.NET application using Forms authentication which launches the Report Builder via an HTML link with the href set to: ReportServer/ReportBuilder/ReportBuilder.application This will launch Report Builder and allow users to create, modify, and save reports. But when the user trie...more >>

We are on SQL server 2000 (sp4). We have upgraded to Visual Studio 2005 (from .NET 2003) We installed SQL server 2005 reporting services, on a separate machine (separate from the machine that has sql server 2000. But when we open our Visual Studio 2005 IDE, on a client machine, we can't ...more >>

Here's my question. I have store procedure sp_whatever it has @login varchar(50) @beginDate varchar(10) @endDate varchar(10) select .... from... where somDate between @beginDate and @endDate AND logged_by=@login. In RS I have: 2 parameters, both are string @start and @end (for date...more >>

We have a SQL reportserver Version 2000 setup on a Windows 2003 Server that is part of a Active Directory Domain. We are able to see the reports using the url http:\\Localhost\Reports but when we try to open a report we get the credentials Popup. We try to enter a User {DomainName}\{UserNam...more >>

Hello, I'm trying to create 2 reports. I have SQL Server 2000 and Access 2003. Report should be done in Access. There are 4 different databases on same SQL Server. I need report showing: CustomerID AgencyName State TotalDVI TotalDRI TotalVI ...... Totals are cou...more >>

Is there a way to search all of the RDL's that have been deployed out to a Reporting Services site? I am looking for what stored procedures are being used on our production reporting site. Any help would be appreciated....more >>

Hi there, I have one report which has a table with a subreport in it, I put something in the NoRows property of the Table and subreport. If there is no data, I always got error " An internal error occurred on the report server. See the error log for more details". Is NoRows property for subre...more >>

What is the best way to lookup a value in a column from another data set? I am trying to locate and display the employee name based on the employee id found in another data set. I.E. 13 = Terry Ward 14 = Peter Jackson Thank you....more >>

I have a report with user sorting enabled. Each row of the report contains a hyperlink (Jump to Url) of the form: ="javascript:window.open('"+Globals!ReportServerUrl +"?/myreport&rs:Command=Render&rc:toolbar=false&rc:LinkTarget=_self" +"&Action="+Fields!Action_ID.Value +"','_self')" ...more >>

Hello, I have a main report that calls a subreport. In report manager, when I drill from the main report to the subreport, everything is fine. However, when I hit the IE back button I get a blank page. If I hit back again the main report displays. This problem just started happening within...more >>

In trying to incorporate business rules into my SSRS report, I need to be able to conditionally load drop downs based upon what the selects for other drop downs. Can anyone tell me how? Example: DropDown1 = Country DropDown2 = State/Region How Can i leave DropDown2 empty until they sele...more >>

Someone told me I could replace the parameter toolbar with my own custom toolbar. How do you create/use a custom toolbar? ...more >>

We would like to take advantage of the Report Builder tool to provide end-user ad-hoc reporting. The database for the application can be different depending on how the client configures it (they can add various fields and data collection forms). At TechEd, I attended a session on Microsoft...more >>

Is it possible to build a report that displays a chart and if a particular bar or slice of the chart is clicked we can present the details for the data associated with the Bar or SLice of the chart? ...more >>

I'm working with a report which is being generated dynamically through an XML and XSLT transform which generates the .rdl file which is then pasted in to the code view of a report file in Visual Studio. This process has worked so far for various reports until we came to this latest report. Th...more >>

Hi, I'm using navigation functionality to pop-up another report. The syntax is javascript:void(window.open(http://balabalaalabal)). This code works with a development server (IIS 5.1, database in the same server), and doesn't work with a production server (IIS 6.0, database in another server,...more >>

This morning, after booting up my dev box SSRS says it cannot connect to the local machine when I click on it in Management Studio. Also can't deploy reports. Reboot then it works. This has happened before. Is there a reason for this erratic behavior? -- Regards, Gary Blakely ...more >>

Hi Can anybody help with this? Using RS2005. Question 1: What's the proper syntax for the expression to pass a parameter and a field (.value) to my Function. Question 2: I get an error caused by business_source that says, report item expressions can only refer to fields within the current...more >>

Is it possible that a rendered report can be saved with rendered data in a file or stream or/ the xml format ?...more >>

Can subfolders be added to a project? i want a few folder like : dashboards, full reports , management reports etc. in each folder i would like to store only the relevanr .rdl files and images used in the reports. but i dont see an option to add a folder when i right click on the project name....more >>

Hi, I am upgrading a few sql 200 dts packages to ssis. In one old package, an activex Script task creates a global variable for a file name. The file name is something like: "abcd_062606.csv". This file is then downloaded via ftp and then imported into a table. My question is whats the best...more >>

I want to enable history for my report but on the property page there is a red warning saying that I have not registered credentials for the report. (I think it means the datasource). So in the docs it says that credentials are required for datasources that have subscriptions enabled. But ...more >>

Hi, I have couple of reports deployed on my dev server and my User is unable to see any of those reports unless he is an ADMIN on the box. I have added the user to ReportManager and ReportServer, also added him to the Content Manager role in the concerned folder. But still all he can see is...more >>

I created a chart report and then created a second report which has a table in it. The second report has a report parameter called DealStatus. I went to the Chart report and edited the action tab on the edit chart values and select the Jump to report and selected my report and clicked on the ...more >>

Looking for some good examples of how folks used ASP.Net to pass in parameters to SQL2005 Reporting Services - not liking how the parameters have to be coded within the designer itself. ...more >>

Hello, I have a French and English user base and I would like to display reports in the language of preference of the user. However, I am not certain as to a best practice for this within VStudio. In addition, how can I make the reportserver display a french GUI? Any help would be appr...more >>

I have some bullet-pointed text I need to add to a text box such as * Line 1 * Line 2 * Line 3 I see the formatting toolbar has a bullet point icon, but it is always disabled for me. How can I format text in a textbox so that it is bullet pointed? Thanks, Chris ...more >>