I am doing a report which shows rows from a table 'tblAccounts'. The tblAccounts table is related to the tblUsers table by the userid. The 2 datasets I built are dsAccounts and dsUsers The commandtext for dsUsers is select 0 as userid, '(All)' as username from tblemployeeprofile UNION select ...more >>

Hi, I want to remove display of total page number and Find textbox from my toolbar. Is it possible for me ? Thanks in Advance. ...more >>

A few work-mates attended a 2-day hands-on lab/workshop on Reporting Services, and according to them these were the issues presented by the trainer := 1) RS is still in its infancy, unstable , unsuitable and unreliable for enterprise deployments 2) Could turn into a long drawn-out developmen...more >>

Hi I have a dataset and there are 2 columns in the dataset : Name , ID In the report Design I need to have a text box in which I need to get the value of the Name where ID = 7. Please tell me if this is possible!!! and if Yes then how do I do it? Thanks a lot in advance ...more >>

I am just getting started using scheduled emails and after setting up the config file and setting up a schedule...I get the following error reported on the RS (and no email): "The delivery extension for this subscription could not be loaded." when the subscription fires. Can some one point me i...more >>

I've read that in SP1, it should be possible to hide a parameter without blanking the prompt and therefore making it read only. I have attempted to do this in the recommended way, i.e. by unticking the "prompt user" check box for the parameter within report manager and leaving the prompt with a ...more >>

I would like to make a field visible only if the data value assigned to it is not equal to something. I used to do this is Crystal using the suppression settings for a field. How do I do that here? I see that there are some settings for field visibility in the Advanced Field Properties, but t...more >>

Re my other post and hitting the 260 char limit on my params report, seems I need to use SetReportParameters to programmatically set the params in the report before I call it. I've searched all over Google for any examples of using this call & found nowt but others asking the same question and...more >>

When I toggle visibility for an item in a table I loose the borders for that cell. It is very annoying to have a solid line on down the column of the table and when I expand the group have the border go away in the top cell of the group. Any thoughts on how to keep a border, but not show cell...more >>

I can't seem to hit on the right combination of roles/persimssions to set against the Report Server in order to allow my localhost implementation to access/browse/upload reports. Is there some deFacto setting(s) that I should be using? After installation I was able to upload and browse. The tr...more >>

I would like to use e-mail delivery for the following scenario: new orders arrive in a table and i would like to send confirmation messages which contain the content of the order. The RS has an "every 5 minutes" schedule and should send e-mail just about the new orders to the customers. How...more >>

Using the visibility fucntion I can presently do the following: Start: Product A (+) Product B (+) Selecting the "(+)" next to Prodcut A produces the following results: Product A (-) Part 1 Part 2 Product B (+) Required Result: Product A (-) ...more >>

Is there a way to add text to the toolbar (that contains the export choices, refresh button, paging, etc)? I would just like to put a line that says "You must export before you can print". Thanks in advance, Melissa ...more >>

Hi, Got some reports with a lot of parameters to deal with, a custom web front end and using the ReportViewer component to render the reports. A typical URL generated by the app is: http://localhost/reportserver?/Reports/My%20Report&rs:Command=Render&rs:Format=HTML4.0&rc:Parameters=false&Dat...more >>

Could I set up Chart type in run-time. The attempt to set <Type> attribute inside RDL in the following way: <Chart Name="1"> ..... <Type> = Parameters!ReportChart.Value</Type> was failed "Deserialization failed: Requested value =Parameters!ChartType.Value was not found." Any sug...more >>

I have a subscription programmed to send the report by mail. I can create the report in interactive mode and I can create a subscription to deliver the report in a shared resource. <RSEmailDPConfiguration> it seems correctly configurated. i don't know whats going on... any idea... ...more >>

Hi Guys On one of my RS Servers the scheduling does not work. That is the "schedule" is created. It even exists as a job in SQL Server that runs however the actual report is not run. In the log file I have the following entries: ReportingServicesService!library!10ac!11/08/2004-18:04:22:: e E...more >>

Hello, Below I posted a big glob from the log file. I am attempting to run a data-driven subscription to produce 30 large reports (400+ pages). It works for 28 of the 30, but has problems with two and I'm trying to figure out why. <Header> <Product>Microsoft SQL Server Reporting Se...more >>

Hi, Reporting Services is installed on Windows 2003 Small Business Edition. When I run a report on client machine, It prompts a login screen (although I am already logged in to the domain) and shows the report when I renter my credentials. I tried storing credentials in the report but it didn'...more >>

Stupid newbie question of the day: is there a way to embed a button to close the opened report? ...more >>

Bruce: Sorry for the misposting. I don't understand what you mean by "you haven't setup your roles for the developers on other machines." Once a user role (developer or otherwise) is set up on the server, shouldn't it be in effect no matter where a user logs in from? Jody "Bruce Lo...more >>

Hi All, I have a report with only one parameter(Date field). It is set to allow null value. When I click the report it immediately starts rendering the report instead of waiting for user input. Is it anyway to make the report to wait for user input without removing the allow null value? ...more >>

I have a custom web application that includes URL access to Reports hosted by Reporting Services. It is accessible via the Internet Security is handled by impersonation in the web app, so I can provide a more graceful login than would be required by using Windows Authentication. This mean...more >>

Does anyone know of a good reference for Expression Syntax? I have years of experience in SQL using all kinds of tools, but this thing has got me really flustered. No If..Else, just endless nested Iif's in Expressions? No Case..When? No Count Distinct? Can I fake a Running Total? This thin...more >>

hi, I'm using the sample RS code for my cube. I just copied from the sample code and replaced the cube name with my cube name ....its working fine with the code given by them and for microsoft's reports. but when i run my reports its giving an error msg like ... The expression for the ...more >>

Hi all, I'm making a webcontrol to replace the MS ReportViewer. This new reportviewer get all the parameters of the specified report, and as the MS sample, it renders the report at design time (changing a property value make the report to be regenerated). It works well with the ReportManager ...more >>

I'm using a parameter for Superintendents. The parameter drives a filter is in the dataset; the parameter is not in the sql query. I want the user to be able to select a single Superintendent from a queried list, and have the report return filtered data. I also want the user to be able to s...more >>

Hi All, I'd like to pass the name or label of a textbox to a parameter but I am not sure of how to get it done. I have a table (the PK is on Language and Field) Language(PK) Field (PK) FieldName and a data set query: "SELECT * from table WHERE Language = @Language AND Field = @Fiel...more >>

Hi, I have a problem in that I have one server with IIS and another with SQL Server 2000. I would like to run SSRS from the SQL Server and then store all my pages on the IIS server. Is there a way of doing this. Only installing SSRS on the SQL Server and then everything else on the IIS serv...more >>

Oops! Sorry I don't know why I sent that without a question :-) Basically, I've implimented the Forms Authentication sample, and now the following code causes the error above. ReportingService rs = new ReportingService(); rs.LogonUser("UserWithBlankPassword",String.Empty, null); BatchHea...more >>

I know it sounds kind of dumb. Is there supposed to be a front-end portal for "Browser" level users? Where can I find them?...more >>

Server Error in '/' Application. -------------------------------------------------------------------------------- The request failed with the error message: -- <html><head><title>Object moved</title></head><body> <h2>Object moved to <a href='/ReportServer/logon.aspx?ReturnUrl=%2fReportServer%2...more >>

Good morning I’m trying to enable the scheduled report delivering. It is working fine without attachment (except the mail is in the SMTP-queue, but this is another issue… ). But I’m not able to send a mail including a rendered report. Here is my environment: - Windows 2003 Advanc...more >>