am trying to install report server and db of reporting services on separate servers. this servers is not on the same domain. Command line : setup.exe RSDATABASESERVER=<IP address of DB Server> RSSETUPACCOUNT=sa RSSETUPPASSWORD=db RSSQLACCOUNT=sa RSSQLPASSWORD=db RSDATABASESECURITYMODE=SQL B...more >>

When i set up an odbc connection to a access database on a network path. I get an error saying the path is invalid. I am running SP2 . I can use the same odbc datasource to connect using excel on the report server but not using any reports....more >>

I am trying to add report designer to a new development machine (XP professional sp2) that has VS 2003 installed. The machine does not have IIS installed. I am using the MSDN August 2005 DVD 2432.10 that has SQL & Reporting Services. I keep getting the dialog box indicating a missing IIS ...more >>

How do we ensure that the exported PDF file has always same number of pages as that of the HTML report. We are having an issue with number of pages in the exported PDF file, as they are almost double that of HTML number of pages. I would like to know, if any one has encountered the similar i...more >>

I need to put in parameter always return the first day of the current Month. Example: if today is 08/25/2005, I need to have a default value: 08/01/2005. Any help would greatly appreciate....more >>

I know there are a lot of functionality that perform using the RS APIs. I found a few APIs in a book, but what I want to know is where can I find the entire list of RS APIs. I would like to instruct the RS Scheduler to run a report once programmatically. Is there an API to do this?...more >>

I am trying to number a group and I am using the following to do so: =RunningValue(Fields!DBPROJECTID.Value, CountDistinct, Nothing) However, I have one little problem. How do I clear out the value and start over? This is what I want my report to look like: Group 1 Header 1. Group 2 He...more >>

I am new to Reporting Services. I set up the infrastruicture with two computers to learn the Reporting Service, a stand alone server (No DNS and AD and not a domain server) and a workstation, and both computers are in the same workgroup. On the server computer I have a SQL 2000 SP4, mixed mode...more >>

I have the following sproc that has been in production for severa months. When attempting to set this sproc as my data source I get the following error. There is an error in the query. Implicit conversion from data type sql_variant to int is not allowed. Use the CONVERT function to run this...more >>

Hello! I'm not sure if it's available or possible, but in future versions of Reporting services would it be possible to create a dataset from two or more existing datasets? This question is due to the fact that if you have two data sources and you take a dataset from each of the sources, it ...more >>

Hi, I have accidentally removed myself from the Home folder of my local installation of reporting services. My security group was using an old domain group and RS warned me that it was invalid. I deleted the entry which was Content Manager, thinking that I was in the BuiltIn/Administrators g...more >>

Hi All, Can anyone explain this weirdness? If I have an Image set to External with a URL of http://localhost/myimagepage.asp?MediaID=82 I can see the image in the designer and also at run time. This is without an equals sign at the front as well, so just the plain string starting with http. ...more >>

All, I am having an issue with a fairly standard implementation of the ReportViewer control in an Asp.net application. I have several fairly strait forward reports, but am having problems with one that contains several tightly aligned textboxes. I am using a grid spacing of '0.0625in'. ...more >>

Hi, I need to create a report with barcodes. Currently I have a method in asp.net that generates the barcodes by selecting different graphics based on the characters passed into the method. Is this possible to do in SRS, or do I need to use a third-party tool to create the barcode with...more >>

I'd like to make a substractions between result of year 1 and result of year 2. I've made a matrix with year in colums? Can I make his operation easily or have you got an other solution? Please, help me. Thanks in advance Nicolas...more >>

Hi, Is it possible to filter a dataset on current network user, something like the global USER!UserID when editing report expressions. select * from MyUserTable where UserIdCol = ???? USER!UserID ???? ...more >>