Hi, I have not seen any sample that generate an Matrix Report RDL file on the fly... Have any one tried doing that... Thanks, Vinodh Kumar...more >>

I've read in the BOL that you can render a report straight to a printer using render in your VB.Net code, but there are not any examples. I believe it has something to do with the deviceinfo parameter of the render method. Can anyone help please?...more >>

....but got an error at the end when it tried to start the report server - that was denyid - said something about rights and I could only choose to cancel which resulted in rolling back the entire upgrade. Does this have something to do with my operating system being danish ? http://support...more >>

Hi I have to disable report processing at certain times for some reports. It's like when you don't have selected a value in a combo parameter. I have a function that returns true if you can view the report or false if don't. Any ideas? Andrés ...more >>

When VS 2003 compiles my RDL and deploys it to the server, where exactly does the assembly (I assume it's an assembly) go?!?!?! Into the database? I found saw the ChunkData table that contains an image field names "Content". Is this where the assembly is stored? If this IS the place then whe...more >>

Is there a way to do alternating line shading in a matrix where not every cell contains data? RowNumber isn't consistent in this case because it only counts cells that contain data. Michael Carr ...more >>

I'm getting this all of a sudden on a report that previously worked for me. I uploaded a new RDL after putting in a new graphic and adding a couple of text boxes, but not much else that I can see. Any clues? ...more >>

I'm getting this error when I try to preview my report: The value expression for the textbox 'RepairOrderID' refers to a field. Fields cannot be used in page headers or footers. I searched through the news groups and a found suggestion to replace: Fields!RepairOrderID.Value with Report...more >>

I have periodic problems with subscriptions delivered via the local SMTP pickup directory. While some work reliably, any new subscriptions I've created recently are failing to be delivered. When I review the \Badmail *.bdr messages, they all say this: Unable to deliver this message because th...more >>

Is it possible to get the session id in Data Extension or Report Designer thanks ...more >>

I would like to use a top n query as the source for my report where n is a parameter. Can I use the sql embedded in the report for this or do I have to use a stored procedure? In general, can I use dynamic sql for my report? TIA, Dave...more >>

I'm kind of a newbie at all this and I'm wondering if I can do the following. Whithout having to use custom code is there a way to use the IN function in the expression editor? I'm currently using the following to accomplish something quite simple: =IIF((month(Fields!por_POSTING_DATE.Value) =...more >>

Hi! I would appreciate any thoughts on the best way to determine using Web Services what the references to a schedule are when ReferencesPresent is true. Thanks for any ideas, Bob ...more >>

I've read countless postings now but haven't yet found an answer to this frequently asked question: "When using the Jump to URL option in the Action property of a textbox, how do you make that URL open in a new window?" Is it possible?...more >>

Hi there, I have a report with 2 column groupings and 5 row groupings looks like this: +Unit +Time +Type +Sub_Type +Start +Result +Orig SUM(!Field1.Value) I want to add "Total" to every column and every row a...more >>

It is possible to change the sort property dynamically on the client side by clicking on column headings without making a round trip back to the data and refetching the entire dataset? I've got a clickable column sort working based off of a newsgroup post based off of the link below, but it appears...more >>

I need to conditionally set the font weight of my data when a calculation is equal to or less than 70. I am using the following expression in the font weight property: =iif(( Fields!Answer1.Value/ Fields!SumStudents.Value)*100 <=70, "Extra Bold", "Normal") I get no errors when I run my report,...more >>

Hi, We are developing a web-based reporting solution with Reporting Services, replacing Crystal Reports by integrating RS in with our existing web-application. We need to buy the Enterprise license(s) to enable us to do this, because only the Enterprise license comes with the custom authent...more >>

I can create an expression for the visibility property as follows: =iif(countDistinct(Fields!RefNbr.Value)=1,True,False) BUT when I try to do something similar for the fontweight property like =iif( Fields!Carryover.Value = 2 ,Heavy,Normal) I get the following error message Name Heavy is no...more >>

Is there any documentation or sample code to point me in the right direction on how to modify an existing rendering extension? I need to add some browser checking to the existing JavaScript that is generated for the toolbar. I was hoping to modify the existing HTML 4.0 rendering to include so...more >>

Can I insert a newline character within a reporting services format string? I guess \n doesn't work since it is interpreted as a VisualBasic format string...? Is there an alternative? Thanks, Michael Carr ...more >>

CreateReport throws an error saying that user IUSR_XXXXX doesn't have permisssions to run this method. So, 1) I went to ReportServices roles and anded a new group for IUSR_XXXXX user 2) Assigned ReportserverSysadmin role for the new group. 3) Also set db_owner permissions for the IUSR_XXXXX...more >>

I get this error right at the end of installing the server components. Product: Microsoft SQL Server 2000 Reporting Services Developer Edition -- Error 1920. Service 'ReportServer' (ReportServer) failed to start. Verify that you have sufficient privileges to start system services. I a...more >>

Hi, I have been using the evaluation edition of RS but it has expired. I have ordered the CD from MS but it shows as backordered. I'm not sure how long it take to receive and I couldn't find any option to download from MS web site. Does anyone know if there is a download available? I'm in a bind...more >>

Our local setup doesn't have the users Email address as their login. For example, my Email address is user@site.net, but my login is xxx1234. Unless I give users the authority to manage all subscriptions, reporting services does not allow them to change the "TO" block on their own subscriptions...more >>

How do we put a mailto hyperlink in the report. I used an expression in 'Jump to URL' as ="mailto:"+Fields!email.value and it gives me error that it is an invalid URI: host name could not be parsed. Any suggestions. VR...more >>

We are somewhat confused about the best installation configuration for Reporting Services. Should it be installed on its own IIS Server. Can we intall it to work by combining a current (non-IIS) SQL Server 2000 server and another (non SQL Svr) IIS Server? Should we add IIS to a current ...more >>

My Matrix presently shows results as follows. column 1 column 2 row 1 23 row 2 34 34 How would I make the default null value to display as zero. Eg. Row 1, Column 1 would have a value of 0...more >>

I think reporting services is a great product and would like to be using it right now but unfortunately, what I need it for is for desktop applcations. I would like to use the product but avoid using it with a web server. My understanding is that in Visual Studio 2005 the ability to create repo...more >>

Hello, I would like to expand the size of parameters bar, is it possible with SP1? I have too many parameters to deal with and I don't want users to scroll through. Thanks. Regards, Cem ...more >>

Hi, I have an MSRS report connected to SQL Server as the data source. In this report there is a main report and a subreport inside it. Both the main and subreport are procedure based reports. On execution of the main report, it creates a temporary table and stores data in it to be used by the subre...more >>

Hello, I need to run several reports using the information in couple of cells of a table as input parameters, and eventually create a report combining the result from sub queries into one report. In other words: ColA ColB ColC ColD 9898 001 145 8789 000 454 ...more >>

I have a textbox on a report containing a number I want formatted in scientific notation. When I bring up the properties of the textbox, there is a formatting option. I select number and am given a choice of 1.234123e+003. This works great, but I really don't want to show that many number in ...more >>

Hi, Two Things: 1a) I was wondering if there is the odd issue with redeploying a report in that some changes do not seem to be propagated. For instance, In one case I set default parameter values for a report - this would cause the report to automatically execute when browsing to it - I di...more >>

I have a Pie chart which shows different sections. Is it possible to indicate the % figures in front of the sections? Thanks...more >>

I've set the pagesize to 11in, 8.5in and the body width to 10.5 to compensate for the margins. the preview views in landscape but when i try to export to pdf i get an "index out of range error." If I change the pagesize to 11in, 15in it works ok unless i drill down before the export, then i ...more >>

I'm displaying report in my webpage. I display it through report viewer's property. rptViewer.ServerUrl=http://www.myname.com/ReportServer // The Name of the Report rptViewer.ReportPath="/ReportName"; Now I want to catch exception if host name not found or Report server is not accessible or I...more >>

Hi there, I have a problem I have struggling with for ages and still can't get it to work. I have a server with Win2k Server OS, Sql Server 2k Standard and .NET SDK installed on it. I need to be able to install reporting services on this server so that it can be used as the central repository ...more >>

Hi Scott, Thanks for the input, but this user has been made a member of all of the roles defined within Reporting services. i.e "Browser", "Publisher","My Reports", "Content Manager". I've tried all combinations of these. No joy. The user has to be a member of the "Administrators Group" o...more >>

Hi there, I am trying to install reporting services on our server at work. It is a Win2k server OS, with SS2k on it. It does not have VS .NET installed. Is it possible for me to set up the server so that it is the central repository for all our reports and then develop and design the reports from...more >>