Hello experts, I'm doing a report. - I have a dataset which summarize transaction grouped by companyID. - Now i need to display the company's name for each row.. So how do i go about if i do not want to use custom assembly? I tried creating another new dataset which takes companyID from r...more >>

Hi all, Just installed the software on Monday and I already have 2 reports in the production. This software is so amazing, I did a little demo today at work and everyone was shocked to see that it took me only 15 minutes to author one simple report with no line of code! It's very easy to us...more >>

Hello All, I have my Reportservices installed at a windows 2000 box (RSBox) and a reportserver Database at a windows 2000 box (DBbox). I am using Windows authentication. I have been successully Deploying and viewing MS enterprise Reports .. but suddenly i got a issue... When ever...more >>

I have configured the config files so that my custom code and data extension work fine internally. I am having problems getting them to work over the internet. Are there any special considerations for this? Thanks ...more >>

I have two databases on the same SQL server which have identical data structures. I want to be able to use one set of reports on my report server to run against either database. How can I achieve this? Whenever I run the report it always runs against whatever the datasource points at. Nick...more >>

I'm doing probably 10 -15 MDX queries for each report. I got a big difference in speed when the database cube were put on the same machine as reporting services and IIS. With the Database and Reporting services on the same machine the report takes 10 seconds. When they are on different machin...more >>

does the server need to be on the outside of the firewall or can it be still assigned an internal IP with the firewall configured to allow port access for reporting only? Thanks ...more >>

A little background... I've got data in a database in which users have a serviceplan of sorts... and basically changes are journaled. So in order to determine which serviceplan they are on, you just about have to loop through all the records for that user up until x date, and that'll be t...more >>

Hi All... What I would like to achieve: Calculate the amount of time spent on a job (JDEID) per day. For eg: Assigned id 110 has worked 9 Hrs, 35 minutes on 02/01/2005, 8hrs on 03/01/2005 etc. This is how my query started: SELECT Tbl_JMS_Manhours.JDEID, Tbl_MS_Employees.Name, T...more >>

Trying to get e-mail subscriptions working. Suspect problem due to User being "Network Service" and not having sufficient rights. Not sure how to change. Both the ReportServer -service-, and the Application Pool I have setup in IIS (6.0) are running under "Network Service". If I change c...more >>

If I print the report from the IExplorer, it prints it as it appears on the screen with the scroll bar, the area above the report (where I choose the parameters) and so on. Is there a friendly way to have a clean print? I know I can export it to the excel, but this is not a good solution..:-) ...more >>

Has anyone successfully created a report that has a main Table and 2 Group Levels and correctly shows aggregates (SUM) in both Group footers and the Table footer? Like this: _______________________________________________________________ Table Group #1 Group #2 Detail Row #1 (this ...more >>

Hi everybody. I have one dataset with parameter 'UserID' and second Dataset which fill UserID parameter. When i run my report i can choose value from second Dataset, but i wont that in my Parameter will be present value as 'All' which mean all records from query. It is possible? if yes how?...more >>

Table region will not activate the "Double Lines" property. Does anyone know how to fix this problem?...more >>

Apologies right away if this is a dumb question - I've cast about t'internet looking for any references and, not finding them, wound up here looking for assistance. Working in RS Manager, having uploaded report files, when trying to set a shared data source, clicking the Browse button resul...more >>

Do user need to be administrators to create Data Driven Subscriptions? If i log into my machine as one of my users the create data driven subscription button is not there, but if i log in as myself or administrator(both in the admin group) I can see it. also noticed that non-admin users ca...more >>

I'm trying to get around a problem where my client wants to have totals from each grouping in the report table displayed at the top of the report body above the report table. It's easy to see why you can't just grab values from the grouping footers and place them elsewhere. I had an idea to c...more >>

Hello all, This is probably not related entirely with RS but wanted to post anyway. I have a P4 3gig northwood chip with 512 mb ram. win2003 server. Running RS, an SQL Server instance and of course the VS.NET for developing reports. The VS.NET is slow right from the start and gets quickly ...more >>

Forgive me for asking, but I've looked around and couldnt quite find the best method of achieving the following. I've got a report that aggregates all sortsa data with group by and sums and counts etc. What I'd like to do, is if a parameter is set, use same columns etc, but bring up deta...more >>

Since there was no answer on my first post and I'm in a hurry and I have no clue on what to do I'm gonna post again. I have code in a report like the following: Function Translate(key as String, language as String) as String Dim mgr as System.Resources.ResourceManager Dim asm as System....more >>

I am trying to access the datasource parameters (connection string etc) through the report with the intention of using them to fire off a stored procedure at the end of the report. The parameters will be passed to a custom assembly will execute the sp to update several status flags in the data...more >>

I am trying to access the datasource's parameters (connection string etc) via the report, and passing these parameters to a custom assembly at the end of the report, with the intention of firing off a stored procedure from this assembly. The assembly is done, but the connection string is hard...more >>

I am trying to access the datasource connection properties (connection string etc) from a report -I will be accessing the information via a custom assembly, or passing it to a custom assembly with a view to firing a stored procedure at the end of the report in order to update a number of statu...more >>

Hello All, I have my Reportservices installed at a windows 2000 box (RSBox) and a reportserver Database at a windows 2000 box (DBbox). I am using Windows authentication. I have been successully Deploying and viewing MS enterprise Reports .. but suddenly i got a issue... When ever I ...more >>

I have a huge report (approx. 120MB) needs to be returned from reporting services. However, most of the time the request die before the report is returned. While I am debugging this problem, I realize that an exception is thrown between the BeginRender() and EndRender() methods of Reportin...more >>

Can I use a SQL udf as a datasource for a report? E.G. ISQL query Declare @MyID VARCHAR(5) SET @MyID = 'AC001' Select * from dbo.udf_ReturnData(@MyID) data is returned okay in ISQL when I use the select stmt. However in my data source I get an error message telling me to declare the va...more >>

How do I deploy are report that is not on my network? I need to deploy my report to the production server. I have FTP access, and I usually Remote Desktop to the machine, but its not on my network. When I try to deploy to the remote server, I get an error saying that that server can't b...more >>

I have images on my report which are URLs pointing to another server. The images appear fine in the preview enviroment but when running the report from the WEB they turn to red X's and the SRC=''. I tried configuring an account for unattended report processing using rsconfig but it doesn't seem...more >>

I have a custom Data Processing Extension that implements the IDataReader, using a .net DataSet as the backend datasource. The dataset obtains its data from an Oracle db and the IDataReader successfully reads through the data when the dataset contains at least one row. My issue is that if ...more >>

Hello, i create a matrix with this layout A Students B Students C Students (...) Total Teacher A 2 6 4 12 Teacher B 4 3 5 12 Teacher C 1 3 ...more >>

Hi, I am trying to link to reports together, I want to be able to pass a ID number returned from a query in this link. THe link currently looks like this: http://offsite/ReportServer?/LondonResults/Detailed Report by LEA&LEA=(Fields!IDNumber.Value)&rs:Parameters=true But in my parameter ...more >>

Hi there I'm pulling out my hair with what I suspect is actually something silly. I have a report with the following structure. --[TABLE]---- --[table1_group1]---- --[table1_group2]---- --[detail]---- My data source has a field, "minutes", which is displayed in table1_group2. ...more >>

Hi cant seem to find any info on when SP2 or the next release is due? I know SP1 was June 2004 Thanks Paul...more >>

Hi, I have a Dataset width the following data : Category Sub-Cat1 Sub-Cat2 Date1 Date 2 ------------------------------------------------------------------- AAA AAA1 AAA11 <NULL> 01-01-2005 AAA AAA1 AAA12 01-01-...more >>