I have been trying very hard for days now to build a report using VS 2003.net I just need to query an order table by a date range. ie) from date a to date b. The order table contains PO's and have recorded dates. I just need an example of how to report based upon date range. Seems sim...more >>

Does anyone know if Report Services 2005 work with Visual Studio 2003? Thanks, Jim...more >>

Hi all, I am currently doing some reports using reporting service for my company. Some of the report require SA to input commend after analyse the report data and their commend will be part of the report. ( Ex: commends on chart showed in report) Anyway I can accomplish this? Thanks!...more >>

I have a reporting services project that builds fine on my local machine but when I attempt to deploy the project to the server I get the following error for each report I am deploying. An unexpected error occurred while compiling expressions. Native compiler return value: '128'. Does anyon...more >>

RS List, Well, I managed to get all the mdx pieces of my problem resolved. Now I need to solve a tricky conditional formatting problem. Let me provide some info first and then I'll ask a few questions. The report I have generated is a very concise matrix. It basically assigns ranks to...more >>

Does anyone has any problem when updating (change either report definition or data source info by using the API) an report that is being rendered? Expecially when the report takes a while to be rendered, like half an hour....more >>

Hi, any way to code a linefeed/carriage return in a label? I need it for labels in a pie graph (description on line one, value on line 2 of pie graph series description). Any suggestions welcome! Thanks, John ...more >>

When I run this expression, percentage, I'm still getting infinity as my return when I have a zero in one of the columns =IIF(SUM(IIF(DATEPART("yyyy",Fields!APR_DT.Value) = DATEPART("yyyy",NOW()), Fields!APR_CNT.Value,0))-SUM(IIF(DATEPART("yyyy",Fields!APR_DT.Value) = DATEPART("yyyy",NOW())...more >>

Hi, We have noticed a problem with following: 1. creating a new report 2. adding a DataSet which pulls from a shared data source and displays information correctly 3. choosing 'Save' and not pulling the fields into the layout form When we open the report again the dataset is there but all r...more >>

hi, How to access a DB on a remote/seperate MS SQL machine? My Reporting Services is installed together with MS SQL & IIS on a Windows 2003 server. I am able to access my reports from the report manager just fine if my data source is from the local SQL. However, I get the following error wh...more >>

I am still having this problem (more info below), and I have tried pretty much everything: - Tried using NTservice account.. - Tried using SA sql user - Tried using Administrator account Please.. someone help me Im super stuck! /// Christian ---------------------- Hi gang, ...more >>

Hi, We have a web application that connects to Reporting Server programmatically via the Web Service by passing credentials (not URL access), impersonating a user who does have rights. It works fine in the development environment where the web server and report server are on different machin...more >>

I'm seeing an issue where, after changing the criteria in two date parameters and clicking the "View Report" button, the screen is blanked out. If I click the button again, the criteria is used, and the report is displayed. Anyone else seeing this? Is there any solution this?...more >>

Anyway to do a custom sort on a matrix control? Can't do it thru tsql as other data regions are using the same dataset for which the tsql is appropritately sorted. Thanks - g...more >>

I have a report that shows a string containing "wildcard" values. I would like to be able to change the formatting (Bold, Italicized, Red) for the wildcard values within the string. I've been examining the conditional formatting functionality, but it seems only to apply to the whole textbox valu...more >>

Hello, How can I got dynamic report? My question is: the report did not automatically show a refreshed version of report unless you manully clicke refresh button Thanks in advance! Sandra ...more >>

Is there any timeout setting for when you are executing a report through subscriptions? We are running into problems of reports timing out when running them through subscriptions. Thanks...more >>

I'm a total Reporting Services newbie and couldn't find any examples of this in the books I have. Is there a way to allow the user to select multiple values for a parameter I am providing? More specifically, I am providing a list of values (via a query) for a parameter. The user would l...more >>

Hi, Where would one install SQL Service 2000 Reporting Services? I though about installing them on a Web Server (with NO local SQL Server installed on) and connection remote to a SQL Server 2000. Does this approach make sense? I don’t have a good feeling installing the Web Services on a ...more >>

Hello, I created a report, where one of the fields is using an embedded code: strReturn = System.Web.HttpUtility.UrlDecode(strURL). I added a reference to System.Web.dll and it works fine in the RS designer. But when I deploy it to the report server it shows #Error in the field. >From the r...more >>

Hi, Since installed SP2, I get the following error message "Failure sending mail: Cannot access a closed Stream". The smtp server is well configured. Can someone help me ? Thanks...more >>

So if I create a folder off the root(home) /report I can not create a report or datasource of the same name or anything else now the word "report" is completed used up at that level? can never be used for anything else. That’s really a lame. fisher price must have designed reporting...more >>

I would like explore the way to prepare Adhoc reports with the help of SQL 2000 OLAP Cubes. Any Could help me or point me right direction? Thanks in Advance. Vijay ...more >>

I have a VB.NET script that is used by the rs.exe command line utility to batch a number of reports and save them in a file share. Before installing SP2 (installed to fix another problem) the script compiled and ran perfectly and produced pdf reports that were readable. After SP2, the script s...more >>

Does anyone know where spinning_wheel.gif is held as I would like to change it to our own brand. spinning_wheel.gif is the image used while the report is being generated ...more >>

In our project we are using reporting service web service calls to get report paramaeters and report data. We are passing an array of parameter values to webservice method GetReportData() as an input parameter to render the output bytes.This parameter values array consists of each controls'...more >>

Hello ! I'm using the subtotal in a matrix. Here is the situation: Jan Fev Evolution A 10 15 50% B 10 11 10% Subtotal 20 26 60% So the problem is that the % of the last column is also summed, w...more >>

I have an infuriating problem which I can't seem to overcome with my first report containing a sub-report. 1 simple parameter a GUID string is passed from the parent report to the subreport and all I seem to get in return is the message 'Error: Subreport could not be shown' with no indication as ...more >>

Hi All, our report server machine went belly up last night so we had to restart it. A shared schedule (scheduled for every hour) has not fired since the restart even though we have restarted the Reporting Service and the SQL Agent. does anyone have any suggestions as to what else we might tr...more >>

Hi I have a stored procedure that takes a windows username and domain and returns certain data depending on which user. In the Web application this can be retreived from System.Web.UI.Page.User.Identity.Name, is there a similar way of getting this information to the dataset in the reporting ...more >>

Hi, I have a table with group which populated on multiple pages. If the group ended with odd page then I need an extra page break (1 blank page). pls get me the details on that. Thanks & Regards Gopi R ...more >>

Hi all, I'm stuck ... in this concept: when a report opens we would like to call our ERP-system via COM to calculate and fill a certain table. That table is used as dataset for the report. So we would like to have the dataset of the report rebuilt every time the report is opened, dependi...more >>