Again, seeking confirmation that I'm on the right track: Say I have a stored procedure that I want to re-use in several different reports. For some, I want to hard-wire the parameters without modifying the procedure code. What options do I have? Am I correct in thinking that if I use command ...more >>

Hello , all While I am still stumped on my Netscape issue I think (THOUGHT) I had possibly found an avenue I could explore to repair/augment that functionality. UNFORTUNATLEY the files I need are not there...... I am looking for these files C:\Program Files\Microsoft SQL Server\MSSQL\Rep...more >>

Does anybody have any idea if there is certification exam yet? -- Sincerely ...more >>

I created a small program using XMLHTTP to test the performance of pdf reports rendering. The program basically sends 20-30 XMLHTTP async requests with callback function in the format of: XMLHttpRequest.open "POST", <RS url access>, True This statement was executed 20-30 times in less than ...more >>

Hi, When first creating my report, I used the wizard to set up drill down on my first group. I know want to remove that so that all the groups are expanded by default. How can I change the group to remove the drill down? Second... I have the following in my report Group 1 Group 2-...more >>

I've looked for the answer to this question, but can't find it. How do you limit the number of report requests that execute at a given time? For example, if I schedule 100 jobs to execute via a shared schedule at the same time. How can I tell RS to only run 5 at a time until all 100 have comp...more >>

Has anyone had issues with deploying large reports to a report server? I am trying to deploy a 4061 Kb ".rdl" file. I get the error "Maximum request length exceeded." Is there any way to increase the acceptable file size or is this a limitation of the product? Any advice would be most...more >>

I am using the BOL walkthrough and have come to the Dynamic Query section. I type in the following into the generic query builder... ="SELECT FirstName, LastName, Title FROM Employee" & IIf(Parameters!Department.Value = 0,""," WHERE (DepartmentID = " & Parameters!Department.Value & ")") ...more >>

Hello, We're in the process of putting the final polish on our new Delivery = Extension and were hoping someone would know how to remove the hardcoded = path in the below snippet of our CodeGroup. Surely there's an $AppPath$ = variable or something like that? <CodeGroup=20 class=3D"...more >>

I get the following error when i try to add a new field being returned in a dataset: "Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope". I have no idea what this means, and i can reference just fine ev...more >>

Hello, I've created a report (with default parameters) and uploaded it to Report Manager. When I later change the default parameters in the RDL and "Update" the report definition, the default parameters do not update in Report Manager. When I remove the report definition and re-upload it, t...more >>

Hi, I am trying to deploy my reports to a new server running reporting services w/ SQL Server 2000 on the local machine. The ReportServer web site has anonymous access NOT checked and Windows Integration selected. I'm logged onto my machine with my domain account and when I try to deploy m...more >>

I have a problem within the Report Designer in Visual Studio .NET. I a new report, I define a dataset that returns data via a SQL query fine. I design the report without issues, but when I try to preview the report, no data is displayed. This error seems to have occured after applying repor...more >>

How do I change the login/password Reporting Services uses to connect to SQL Server? How do I reconfigure the options I chose when I installed SQL Server Reporting Services in the first place? Help!?!?...more >>

Hi I have a customer that aks me to build using Reporting services an application that will run everynight. The application should create near 10000 reports in pdf format. Some are report1, some are report2, etc... depending of the data. Do you have any tip or suggestion about how to do tha...more >>

I am having a problem trying to set permissions based on an Active Directory security group account. I go to the permissions of the Home page and add DOMAIN\Group with the Browser role. I then go to the specific folders under Home and add the same Group to it with the Browser role. When the user...more >>

I am creating several different versions of essentialy the same report, each version customized to suit the country for which it's being desgned (i.e US English, Australian English, German, French, Hebrew, etc.). How do get a German date format to show up in the German report, and an Australin...more >>

I need help creating a formula which calculates the average sum of unexpired products sold in a period. Its would work something like this. If the expiry strart date <= parameter start date and expiry end date >= parameter start date Count (product) Then increment the parameter start ...more >>

Is it possible to change the margins of a report so that the left and right margins are 0.1... thus utilizing more of the page? Thanks. ...more >>

I want anonymous users to be able to see my reports. But it says here it has to be disabled. http://www.microsoft.com/products/ee/transform.aspx?EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsAccessDenied&ProdName=Microsoft+SQL+Server+Reporting+Ser...more >>

Random question...does anyone know what edition of Reporting Services is included in the 120-day trial copy? Standard or Enterprise? jb ...more >>

Hi, I'm trying to build a report displaying a matrix that looks like the following but have some trouble composing it: Required output : Code, Name, Target, Batch 1, Batch 2, Batch 3 1, One, 12, 10, 11, 12 2, Two, 9, 10, 9, 11 ...more >>

I'm doing an eval of RS against their current report sw for a customer, and they are on VS 2002. I know that all literature mentions VS 2003, but I just want a final confirmation whether RS work with VS 2002 or not. That will be a part of the customers decision parameters.... :-) -- Tibor Kar...more >>

I've been trying to install the MSDN Developers edition of SQL Server Reporting Services for serveral hours. My environment is as follows: XP Pro, SQL Server 2000, SQL Server SP3a, .Net Framework, VS.Net (Enterprise). I have uninstalled/reinstalled SQL Server (and SP3a) - several times. The...more >>

I need to format a char(9) field as ###-##-####. What format string do I use in the Format property of the Text Box? ...more >>

I'm running into a problem here. If I generate a schedule from the Microsoft Admin tool for subscriptions I get one schema. If I create a schedule using the inherit Serialize and Deserialize I get a different schema. Apparently the one from MS won't serialize and the one I create by serializi...more >>

Hi! First issue: I want to print reports after the load of the data of the day have been made. How could i do this, nowing that i have a job that runs every day at the same time but end time depends on the size of data to load. Is there any way of doing this with reporting services? workflo...more >>

I have a report which is scheduled to be sent out by email every Tuesday at 4pm. It used to run and be sent out on time. Then I changed the report a little adding a couple more subreports, the report being sent out that week was a few minutes delayed but it was ok. Then I installed Reporting S...more >>

Hi everyone, I would like to know if it's possible to have a pivot table (with all the features of pivot tables: drill-down, drill-up. slice, pivot dimensions,...) in a report created using Reporting Services. I'm not sure if office web components could be a solution. Thank you! ...more >>

I have table with two group headers. I want my data to look something like this: -Group1_master data - header1 -Group1_master data - some description - header2 -Details of group1...... Now, i want to display this header2 only if descrpition contains data, that is not null, and i w...more >>

Hello I have an MDX statement that looks like this: SELECT { Measures.members } on Columns , { CrossJoin( [Time].[Calendar].[2004].[May]:[Time]. [Calendar].[2004].[July],[Business].[User].[Business Entity Id].[212].Children ) } on Rows FROM UsageStats And it returns this via a ma...more >>

Hi, I wonder if anyone can help me? This is what I'm trying to do: I want to get a parameter from a user (number of days) and subtract it from the current date, then use the resulting date in a query. In Transact-SQL, one should be able to subtract a number of days from a date as simply a...more >>