I have problems with referensing assebly to my report. I copy my.dll to \MSSQL\Reporting Services\ReportManager\bin and \MSSQL\Reporting Services\ReportServer\bin. I have added the assembly to the report using the Referecnce tab poniting to \MSSQL\Reporting Services\ReportServer\bin but i still...more >>

Hello, How to set the fixed order of DataSets execution? For example, I need DataSet2 to be started only when DataSet1 is finished. Thanks, Lucy. ...more >>

Is it possible to bold a part of the text in the expression? For example, In Crystal, all I have to do is hightlight a word and format it anyway I like and leave the rest of the paragraph alone. So far, I can only use ucase("test"). I need something like bold("test") to work. Thanks...more >>

I try to initialize my object in OnInit, however, there is always an erroe saying "[BC30469] Reference to a non-shared member requires an object reference." My code is very simple and it is like this : Dim MyObj as MyClass Protected Overrides Sub OnInit() MyObj = New MyClass MyObj...more >>

I have the beta version of RS running fine on Windows 2000 Server (SP4), IIS 5, and SQL Server 2000 Enterprise (SP3a). No issues at all. However, when trying to install the RS release candidate, for some reason I am not presented with the server components option - I can only see the client tools...more >>

I have a long word with no spaces gets a line break and part of word ends up on next line even though I have CanGrow = true and CanShrink = false. Anyone know why? How do you make a textbox or table or anything that will span 100% of width when viewed as web page? thanks!...more >>

I have a fairly good handle on controlling reports programmatically, setting report parameters programmatically, etc., etc. For an upcoming report I am going to have several different DataSets on my report and some of these DataSets are going to require parameters to be set on them. I don't see ...more >>

In Report Designer, when trying to export the report to a pdf file we get the following error: "Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index " This error happens only for this report which references a custom assembly a number ...more >>

Hi, I have a custom assembly that is working just fine in the Preview tab in Report Designer. However, the popup preview is blowing up with the error: Execute permissions cannot be acquired. I've added a code group (at the top of the code group section) in the rsPreviewPolicy.config, which i...more >>

How do I repeat the group header at the top of each page?...more >>

I have inserted a linked subreport into a table. I have it formatted so that it lines up perfectly with my main report, so the user shouldn't even be able to tell that it is a subreport. When I render the report in the ..Net viewer, it's columns line up perfectly. When I export to .PDF, it li...more >>

After installing SP1 on all the servers I get "Keys lock row not found" on each one. And good luck w/ the logs because they're a lot of help. Any ideas? The servers were working fine before the service pack install....more >>

I have an action in my report: jump to report. It works great! However - I don't want to collapse the parameters... when I jump. How do I achieve that? I know with SP1, the parameters are collapsed, but available. I want to 'uncollapse' them. Thanks...more >>

Are there some guidlines on setting the page and body sizes as well as laying out objects such that PDF doesn't throw blank pages between or pages or on the first page. My page is standard A4 which in landscape means it is 29.7cm wide - and this is what I have set the report width to. I have ...more >>

I have a client with an eager IT manager who used Report Manager, saw the BUILTIN\Administrators group in the roles list and decided to remove it from the Report Server groups, or I think that is how he did it, he says he is not sure. Sadly that was the only RS group with Content Manager and Pub...more >>

Is it REALLY necessary to put VS .NET on the server on which I want to run SQL Server Reporting Services? That seems like a lot of "bloat" to be going on a server. I would like to run the report designer only on my client. Is this possible? Has someone got a minimal installation somewhere t...more >>

Hi everyone, I wanted to know when you export to a pdf if there is anyway to force the pdf to go from 2 pages to 1. Are there any parameter i might be able to pass? thanks to all who answers the question...more >>

Has anyone used this sample app and article yet? http://msdn.microsoft.com/library/en-us/dnsql2k/html/ufairs.asp?frame=true I have stepped through the paper twice now, verified each and every step but it still does not work. I get an error indicating that the Report Server cannot be contact...more >>

I checked the rsreportingserver.config file, the server name and from address are specified. Does reporting services need an outlook profile set up on the machine like SQL server does? I can't figure out why the subscriptions are not working. Thanks, Rick. ...more >>

I have two hyperlink-related questions: 1. How can I generate a URL from within a query or stored procedure such that it appears as a hyperlink within the report? On my first attempt, the text of the link shows but it does not appear as a "live" link within the generated report. 2. Once I've a...more >>

Hi There This might help someone else, so thought I'd post... I have a bar chart with details the age of clients gender as a series group. I've set the chart colours using the series style property. i.e. There are only 2 possible values (pulled from a table).. Male, Female To set the ...more >>

When the installation of the Enterprizd edition completed there was a message as follows Setup could not initialize the report server. You must manually initialize the report server beforeusing it for the first time. For more information , seethe Reporting Services setup documentaion. ...more >>

Hello, Is there any way I can list the groups that that user belongs to and display it in the header section? Thanks, Jim. ...more >>

I have a report with multiple graphs below each other (some bar, some line, some pie) To the left of each graph, I have a few text boxes and tables tables displaying information about each graph to the right. (fits on A4 portait page) For lack of being able to display a pic: Table Gr...more >>

Is it true thar RServices uses VB.NET syntax for functions (converting types,iif,CDate,..) apart from choosing C# IB project? Aleš...more >>

Hi I use Oracle data source. The report is in Polish. When I try display some text from database or use report parameters, this text is not written correctly. The environment on the machine, where is installed Reporting Services is rather correct, when I am using SQL*PLUS it is ok. I linked Oracl...more >>

Hi, Our live and test servers are enterprise edition, but development servers are developer edition, due to not needing to match the live spec exactly. What can we do about reporting services, since this product will not install on the developer edition of SQL Server?? Many thanks...more >>