Hi, i have a table with column for quarter and year (just like the sample Report - Company Sales). now, i'm trying to create a chart which shows the quarter as the series group /x-axis... how can i show the label of the quarter and the year. currently, it can only use either year or quarter. s...more >>

I have a requirement where I produce a number of rows in a table footer and each subsequent rows needs values calculated in the previous row. Fields in columns can be given a name and used in another column of the same row by using "=ReportItems!textbox1.Value". Is the same thing available betwee...more >>

i have a problem that alerts "The report server cannot process the report. The data source connection = information has been deleted. (rsInvalidDataSourceReference)" what must i do? in .NET, connection and data receving is correct. but in = my project, i couldn'r open the report....more >>

Hi, I am trying to use the images from database function. I used textcopy to load gif, bmp and wmf files to a table. In Reporting Services, the bmp and gif files renders ok, but not the WMF files. I also tried to use the embeded and it complains that the WMF files is not a valid MIME format. In...more >>

I have a table report with five groups and want to add grand totals to my report footer. But if I add a field to the footer: =Fields!Period_MonthToDate_Measures_B.Value The footer shows the total of only the first item in the highest level group. If I use a sum function: =Sum(Fields!Perio...more >>

Hello, Currently I have a database that contains data in RTF and HTML formats. I am creating a report that shows up that information. What can I do If want to lose the format when the information is printed or showed in the screen. Does Reporting Services support that feature? Thanks Hir...more >>

Alrighty... This has been a bugger of a pain all day. We have Enterprise RS on our test server - only the web part. The databases are located on the test sql server, and both servers are more than happy to talk to each other just fine. On the webserver where report manager is, we have tossed t...more >>

I have one dataset.. This dataset is affected by a parameter called @fromdate. The SQL statement is Date > @From I also need to know data that = Date < @From... How would I do this? Thanks. ...more >>

Whenever I render a report, about the first half of the first letter in a textbox will be cutoff. This does not happen on every column. I cannot determine what is causing it, but I can get around it by increasing the padding on the left hand side from 2 to 6 or 8, but when I reposition the tex...more >>

Hi, I've a report with 1 Dataset from a cube. I've a table where I display my cities and the % of customer (measure come from my cube) I want to sort by the % of customer column, but I receive an error. I can sort by the city name without problem. why? any solution ? Thanks. Jero...more >>

Yeah, I do have the same problem. Sam is talking about stacked bar chart. But I guess its a problem in both stacked bar chart and stacked column chart. I have the same problem in stacked column chart. I don't know how to post the dummy chart to explain the problem. As sam says my legend is sor...more >>

Good evening. I just renamed the server that hosts both SQL Server and Reporting Services. I am now unable to access the report manager website (http://localhost/reports). I receive an error stating "The underlying connection was closed: The remote name could not be resolved." As suggested by pr...more >>

I know this has been asked before but I'm still confused post SP1. I'd like to hide the parameters that show in the URL after running a report. The web application provides summary data and users drill down to reports of more detailed information via links. The web app (not mine it's PHP) gra...more >>

Hi, I have IIS5.0 running on w2k (SP3) for SQL reporting service(SP1). IIS has all the patches that I can find. While IIS running, this computer has been hijacked or turn to proxy server to deliver spam mails. How can I provent it (no smpt service running.)...more >>

Can anybody tell me if they have been successful having hidden and prompted parameters in the same report? I think there is a bug in MS SQL RS SP1 which raises a Runtime Error in that situation!! Try making a report with one hidden and one prompted parameter and you will see. I have detailed h...more >>

I need to print a footer only on the last page of my report ? how can i do that.... also in other report i have to print a part of footer(data is subset of the whole footer) and the whole footer on the last page.How can i do this Thanks ...more >>

Hello. The following article talks about a reporting component that will be released for Visual Studio 2005: http://www.microsoft.com/presspass/press/2004/mar04/03-26MicrosoftOLAPReportPR.asp Our company is very excited about this, as it may allow us to move our product away from Crystal Re...more >>

I have a sproc w/ 3 parameters. I'd like the schedule to kick in and run through a list that would contain the parametes, I'm guessing this won't work this way in Reporting services, but rather I'd have to schedule x number of reports... is that right? say for example Terretory 1 for S...more >>

I've created a report and it works fine in html, but when I export to PDF, I receive next error: Reporting Services Error Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Exception of type Microsoft.ReportingServices.Repor...more >>

In the SSRS BOL, under the heading "Installing Repoorting Services From the Command Line", the /i switch is said to accept the name of the Windows Installation package file to be used to install Reporting Services. But it doesn't identify which msi file to use, and there many msi files tha...more >>

Hi everybody I need to reinstall iis after using it for sometime as reports server. What is the easiest way to reinstall iis without redeveloping existing reports? Can I backup the reportsserver and reports sites and return them in to iis after it had been reinstalled? Will i need to reinstall...more >>

In the SSRS 2000 readme file, under the heading "1.6 Requirements for hosting the report server database on a remote SQL Server instance", it says that; "If the remote SQL SErver instance runs as a domain user, you must specify that same domain user account for the report server connectio...more >>

I need to write a VB program that will be run as a scheduled job using SQL Server 2000. It has to prepare up to about 2500 PDF files, and either store them in a folder or email them to users. I don't have a clue as to how to do this. I'm familiar with SSRS and we've been able to create repor...more >>

I have a report that needs to be able to show Chinese characters in a PDF, any idea how to make it recognize chinese instead of squares and gibberish? ...more >>

Just getting started in RS. I've got this dynamic query string: ="select * from v_teds_rpt_workorderlisting where teds_project_nbr=" & Parameters!teds_project_nbr.Value & iif(Parameters!status.Value="A", "", " and status='" & Parameters!status.Value &"'") & iif(Parameters!activity_id.Value=0,...more >>

Is there anyway to make an image or text be the drilldown activator instead of the dinky little + - symbols? thanks in advance, casey ...more >>

Is there any way to change the amount of padding around a pie chart other than resizing the whole chart area itself? It seems like no matter how big or small I make it, there is an incredibly large amount of whitespace around the chart and legend. thanks in advance, Casey ...more >>

It appears that this NG is out'a control I see a real disconnect between what we need to do in MSSQL and .Net, experts don't seem to exist in both HTH JeffP..... ...more >>

Rajeev, Thanks for your reply. What I am after is being able to join a dataset fron an SQL Server to one from a different data source, say Oracle. Would I be right in saying that OpenRowset wouldn't help in this instance? Paul ...more >>

My query returns something to the affect of: Company One Division A $100 Division B $200 Company Two Division C $300 The query is grouped on Division and Company, with the dolla...more >>

Is there a way to limit the available export formats within the toolbar in Report Manager? For example, I would like to only provide Excel and PDF from the drop-down list and remove the remaining export options. Is this controlled through a config file? Jason ...more >>

I know you can change the order of the parameters in the report, but is it possible to organize it more accurately? for example, I would like the following xxxx xxxx xxxx xxxx xxxxxxxx xxxx xxxx xxxx xxxx As you can see, I would like the 3rd line to have just 1 field in it, ...more >>