Hi all, I would like to create a report in which I can dynamically define the dataset (i.e: the name of the database). How can I do it? Regards, Tamas Szaniszlo ...more >>

Hi I have a report with some parameters (some have default values, some no). When leave all parameters visible and execute the report interactively it works fine. If I hide some of them that have default functions it works fine too. But when I subscribe to that report with some hiden parameter...more >>

Is it possible to generate a line column chart in Reporting services. It is possible in Excel. But I haven't found a way in reporting services....more >>

Hi, Is it posible to overwwrite an existing report (in the same folder) with a newly modified one. I recently made some changes to an existing report, deployed it to the same report folder in the report manager but the new changes failed to overwrite the old one. May be I should delete th...more >>

Hi Guys, Is there any way, we can set the number of Bars on X-axis per Page (in a Column Chart) in Report Designer? All I want to do is set no of Bars per page so that a new page is created if the number of bars on the X-axis exceeds the given value.. Any help is appreciated.. Regards ...more >>

Hi, I would like to have the following, field 1 field 2 field 3 --------------------------------------------- empty row total 1000 1000 1000 empty row field 4 2000 2000 2000 field 5 8000 8000 8000 Any advice on how to do that? ...more >>

Hi, I've seen one or two postings on this, and in particular 2 approaches: 1) running rs.exe from a stored procedure in conjunction with xp_cmdshell. I have successfully managed to create and test a stored procedure that renders a report to a file share using this approach - but for some reaso...more >>

Can anybody shed some light on this for me? I have to deploy Reporting Services in what I think is a fairly typical 3-tier Internet environment. I have the following Firewall - 443 only IIS Server (x2) Firewall - 443 only App Server (IIS)(x2) Firewall - 1433 only SQL Server Questio...more >>

Hello.... Does anyone know why this expression is not working? =Reports![Sub Lay Out for Approval].Controls!TotalJobs + Reports!Backlog!Controls!TotalJobs Here is the error I am getting... It is asking me to declare an object which is part of the object model right? The value expre...more >>

when navigating to localhost/reports I get... The request failed with HTTP status 404: Not Found. This is on a 2003 OS. Any ideas? Thank you for the help! -- ...more >>

We have a licensed version of SQL server and have built reports in .net using the report designer. Our end product shippped to the customer will include some of these reports. Our client will need a stand alone SQL Services Report Designer so they may develop reports at there convenience...more >>

I copy a report by viewing the code and pasting into a new report. The problem is that the fields do not display for expressions etc. It gives the following error "report item not linked to a dataset". How do I link the report to a dataset so I can see the list of available dataset fields? ...more >>

I am trying to setup some subscriptions for delivery of reports, but I am not getting an "Email" option in the "Delivered by:" dropdown on the Report Delivery Options page. I did designate an SMTP server during RS setup, as is shown in this portion of my RSReportServer.config: <Delivery> ...more >>

Can anyone suggest a website where I can see reporting services in action? I'm trying to evaluate if this would be good tool to use, but I haven't been able to get the samples to work yet. Thanks, Scott ...more >>

Hi, I am trying to show the textbox depending on the page numbers in Page Footer. But, I get the following error in doing so Expression in Visibility section of Textbox: IIF(Globals!PageNumber>1,true,false) Error: The hidden expression for the textbox 'textbox400' has the value "IIF(Glob...more >>

hi all i have a large image in the header of the report but when i deploy a report to the report server the images and words in the header of the report are not lined up with the rest of the report i have smaller images in the footer of the report that line up fine any ideas on this? t...more >>

I attempt to run the Reporting Services installation and get and on the screen right after the license agreement, I get a message that says just "Error!" and I cannot continue. Is there a log file somewhere I can look at - nothing was installed so no directory exists on the hard disk. I ...more >>

Have an asp page where the user selects a button to display information to a new window in PDF format. Seeking a coding example.... Glass...more >>

I want to use a WebService (which returns a dataset) as the source for a report. I have worked out that a custom dataset cannot be used "out of the box" with reporting services and a data extension needs to be written to achieve this. I came across Christa Carpentiere's article on using an...more >>

Hi, I am trying to use a stored procedure to get data, but I can't get it right. So far I have done this: 1) In the "Edit selected dataset" dialogue in the query tab I have entered the name of the stored procedure. 2) In the Parameter tab I have entered the parameters for the stored proc...more >>

Hello NG! I want to import AccessXP reports with charts. Is there any possibility to do this? In the report designer error message callt object is not supportet. Michael Herrmanns...more >>

I hope you can understand what I mean ! my english is not very good , i live in taiwan! i have a problem table A :(income of year 2004) table B: (income of year 2003) ITEM NAME INCOME INCOME growth _______________________________________________ A ...more >>

Is it possible to add a calculated static column to a matrix, after the dynamic ones? I have the following matrix to create: Indicator Units 2001 2002 2003 2004 %Change --------------------------------------------------------- Volume M3 23 33 44 55 25% Energy ...more >>

Is it possible to define a matrix that has 2 static columns? I have the following matrix to create: Indicator Units 2001 2002 2003 2004 -------------------------------------------- Volume M3 23 33 44 55 Energy KJ 33 34 35 36 etc. The Indicator co...more >>

I have created quite a lot of reports with Reporting Services.Iam calling these reports from my web application through URL Links. All the reports have parameters that are called from the application through URL and some parameters that the end user will enter. Now I have decided to write a C#...more >>

I've written a number of reports that now need to be deployed to a production environment. The reports will be sitting on one IIS server that is completely hidden from SQL Server. The reports data is retrieved via a web service. Can the reports be deployed to IIS and SQL server independan...more >>