I need to create report with a detail region containing some rows related a worker. I want to skip a new page maintaning joined these rows, not skipping after each row group but when it is arised the bottom limit of the page. So, I could have one, two or three etc. information worker on the sa...more >>

Hi, I am new to MSRS,Please tell me how to do the below mention things Can we change the custom.dll to use an account from a config file instead of the account from the app pool? Microsoft does not support installing MSRS using a domain account. MSRS corruption of the domain account ha...more >>

Hi, Env: Win2003 SP1 + SQL 2005 + SQL 2005 reporting service (named instance). I have local admin privilege. I tried to follow the example described in http://msdn2.microsoft.com/en-us/library/ms345334.aspx to set up web service as data source in SQL reporting service 2005. My data source...more >>

Hi: Can someone show me a link where I can get the Advantages/Disadvantages of SQL 2005 Reporting Vs Crystal Report 10 ? Thanks in advance. -- Thanks, SDRoy...more >>

Hi: Does anyone know if it's possible to set a property in the .rdl file or somewhere which will print the report in Portrait or Landscape ? Basically, pre-setting the print option to a choice of Portrait or Landscape when the print-icon is clicked for a rendered report. Thanks in advanc...more >>

I have two servers, one being the SQL server with RS db, one being the webserver with reporting services on it. I want to replace this webserver slowly by installing reporting services on a new server but at the same time being able to access the reports on the old server until we take it offlin...more >>

I have a report with three different charts. I would like to provide a link to each chart at the top of the report - so when a user clicks the link, they are taken to the relevant chart. Can anyone tell me how to create a bookmark on a chart (or a textbox, or anything!) - and link to it. ...more >>

Hi, I have a report when saved in PDF file, the text was overlapped. Has anyone encountered this problem before? ...more >>

We are planning on passing in an XML document as a report parameter but have not been able to determine if there is a maximum parameter length. Does SQL Reporting Services 2000 have a maximum parameter length? Thanks....more >>

Is there a way to collapse blank lines in Reporting Services? I have a report where I stack contact information -- address, phone, email -- and some records don't have one or another of these items. Rather than leaving blank lines in between data, makin the report difficult to read, I would ...more >>

I have SQL Server 2005 + Reporting Services 2005 installed on a machine. I've implemented Custom Forms Security Extension. When I run the code below I get a WMI Exception "Not Found"? I think maybe I have the namespace or class name wrong... The documentation has both "MSReportManager_Configur...more >>

hi, Im using an ODBC datasource linked to a Sybase database. In the dataset designer, I can access data in a table using the following syntax : SELECT * FROM "exp"."PROJ" However I can't seem to find the proper syntax to call a stored procedure. I select Stored Procedure as the Comman...more >>

I'm using the following SQL and receiving: "The expression for the query 'NOL' contains an error: [BC30201] Expression expected." ="SELECT C.CardholderLastName, C.CardholderFirstName, C.CardNumberLast4Digits, C.CUDiscoveryDate, C.EstimatedLossAmount_Quantity LossAmount, C.CUSTOMERREFERENCE, (...more >>

Is there a work around for trying this in my footer table field in my SSRS 2005 report? =SUM((Max(Fields!FeeGoal_AZ.Value) / (Fields!FeeSchedule.Value) * 100) doesn't allow aggregate functions inside SUM...but I need to do this! ...more >>

Hi, i need to know if in RS2000 i can: 1 - Change the text of the exportar link to an image or another text. 2 - Chage de arrangement of the parameters to vertical (one below another) 3 - If there is not results for the query, show a message like "There is not results for your query, try anothe...more >>

I have seen that what I want to do can be accomplished by using =ceiling(RowNumber(Nothing)/7) And (Check the page break at end) But I am unsure HOW to use it.... My table has a header and 2 detail groups....do I use this expression in the properties...and where, exactly. I wan...more >>

I have 2 reports and when i veiwed one is displayed with paging and one without. The PageWidth and PageHeight are (11, 8.5) on both. Any ideas why one is displayed with paging and the other isn't? Thanks....more >>

We have two areas for our RDL files in Report Manager. The Main repository is where the solution for Visual Studio is. we also have other directories that contain the production reports. When we make a change to a report, we deploy to the main area, then copy over the report to the producti...more >>

Hi there Has anyone used the new report model in Reporting Service 2005 and notice d the glaring bugs that are very obvious and make the Report Model itself a non starter for using. I just wonder if MS are aware of the bugs which make the product look unfinished. Thanks Gregor Suttie ...more >>

I have a report and a subreport. I have a toggle on the report that I want to show/hide based on whether or not the subreport has data. Does anyone know how to do this??? Thanks in advance! Shane ...more >>

The error I get is "Logon failed. (rsLogonFailed) For more information about this error navigate to the report server on the local server machine, or enable remote errors " The reports all work when in VS 2005 in the preview mode. When I deploy, the reports on the server point to the corren...more >>

Is there a way in reporting services to get a master record total along with detail record totals? For instance. If I have an Invoice record with sales tax and invoice items with item costs. Is there a way to get the sales tax total as well as the detail record totals (while still displayin...more >>

I embedded ReportViewer into my ASP.Net application and since we can manually export report to xls file, is there any way I can export it programmatically? Thanks, ...more >>

Hello Everyone, Im currently developing a report for a clinical system which requires patient information to be displayed at the top of each page. This seems to work fine when viewing in a web-browser and via VS but once I export the report to pdf it seems to put whitespace where the heade...more >>

Hello I'm using SQL Server Reporting Services 2000. I have a report with the following details:- Subtopic Question Answer Total %age Details %age The query behind the report groups results on subtopic and question. What I would like to do is put in a dividing line every tim...more >>

How can I pass a null parameter to a report through the URL? I hide the toolbar, so I don't want to see the null checks, and I want to pass the null value instead. -- Regards, Diego F. ...more >>