Hi all, We are considering to start using one tool for creating reports on our company. Today we are using ASP(web) for some reports and PowerBuilder for som reports and som custombuilt system from IFS for finacial data. I've started to try out Reporting services a few weeks ago and I got very ...more >>

Hi All, It is possibile to create a dataset that is a join of two other datasets (the two datasets are of diverse origin: the first is OLAP the second is relational)? Example: I have dataset 1 and 2 I want to create the third that is a join of the 1 and the 2. Can anyone help me? Thank yo...more >>

I'd like to join string within a group, preferable with a separator, the same way I'd sum values. So, I'd like to write somethign like =Join( Fields!Email.Value, ";" ) to obtain a string of semicolon separated substrings, the same way I'd say =Sum( Fields!Number.Value) to get the sum of ...more >>

I created a very simple report just to see how Reporting Services works adn it shows all the data just fine in the preview inside Visual Studio but whe I run the report it shows me this error: Reporting Services Error ----------------------------------------------------------------------------...more >>

I built a report with Dataset to run a stored procedure, using parameter of @StartDate, @EndDate. I was able to run the stored procedure via Preview by supplying the necessary parameter. After the report was working for quite a while, suddenly, when i processed the report, the report came ba...more >>

I'm trying to show currency values rounded to the nearest thousand (i.e $797,100.12 would display as $798. I can't seem to figure out the custom format string. Can someone help me out?...more >>

I have a query on a table. This table has a datetime column. I have another table. This table also has a datetime column. It has only one row. It basically to store some simple configuration data. There is no relation between the tables. I want to be able to limit the entries returned by ...more >>

I'm trying to figure out the best way to print the report I have. printing in excell will sort of work for me, but my tables are to wide. Excell has a page options setup, which will fit to 1 page wide, and shrink my tables. But when I do this it fits it to 1/5 of the page, making it to small...more >>

Hi, Is anyway to set default setting in Reporting Service develop environment ..Net 2003? For example, I want default the Font Properties as "Time New Roman, 12pt, Bolder" in .Net, so that I don't need to modify all of the font property during report edit. Anyway or any idea can do this? ...more >>

I have a parameter that acted as optional before I changed it to a dropdown populated by a query. Now the report forces me to select something in spite of the fact that I have selected ALLOW BLANK and have tried to use blanks spaces or other things as a default values. It seems like it won't...more >>

Hi, We are having a problem with reports containing images (charts, etc). Our application uses the web service to render our reports, which on development machines works great(IIS5, win xp). However, I have just deployed the app for testing to and Win2k3 server running iis6 and all of the c...more >>

I'd like to build a dropdownlist in the texfield which describes the columns. This dropdownlist should show all distinct values of the column like the 'autofilter' in excel. This sholuld be done directly in the report not as a parameter in the head. Any ideas ? ***********************************...more >>

1. When a normal user attempts to subscribe to a report, the report manager displays their username (e.g. jdoe) in the To: field and the user cannot edit contents of the text box. However, the user's name does not contain the fully qualified domain name FQDN (e.g. jdoe@company.com). The SMT...more >>

I have a report that I want to set a global default in the date to only query the last 30 days worth of info: __________________________________________________________________ SELECT DISTINCT Company.Company_Name, Billing_Unit.Description AS [Practice Area], SR_Service...more >>

I know I must be missing something obvious but I cannot find it in the documentation. How do I allow the user to input multiple values for a report parameter. For example, the main query has this for test criteria: where CustID in(100, 200, 300) so I changed to: IN(@CustId) expecting to input...more >>

I have just changed the SMTP value in the RSReportServer.config values, does this value automatically effect the report server or is there something else that I need to do to make these changes take effect. Thanks ahead of time....more >>

In an attempt to initialize a class from an external assembly, I copied the example from BOL to my code window. <Code> Dim m_myClass As MyClass Protected Overrides Sub OnInit() m_myClass = new MyClass(User!Language, Parameters!Territory) End Sub </Code> My class has bee...more >>

Hello All, I'm struggling with trying to calculate a percentage based on grouped results. ie. =(Fields!TotalPrice.Value)/( Fields!TotalPrice.Value) How do I refer to the group column in the above expression? Already gone through BOL without much success. There's a lame looking visual below....more >>

Hey all- Anyone know of a way to limit export options for a report? Thanks, Doug ...more >>

Please.....help.....I've to go live with the production environment - next week... http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=a80ed727-334a-47c9-a6c8-2b76dfc141cd Many thanks.......more >>

Is a Data Connection to Excel possible? I have read that it can be done through an OLEDB connection, but have been unable to do so. Can anyone help?! Thanks!...more >>

Hi, I'm new to RS and want to know how to write an expression which will set visablility of a table group header to false if group1.value = "Account". Any ideas? Thanks Jon...more >>

I have a custom data extension I'm working on. I can debug this when the report using it is being designed by adding a line in the code for the extension like: System.Diagnostics.Debugger.Break(); When I then run the report in design mode I'll get a choice of debuggers and I can then open...more >>

Hello, I will be moving my RS to a production server in a week or so. I would like to ask if anyone has had experience with this, and if so could they share any pitfalls that they came across. Specifically I would like to know if you had to handle anything releated to the symmetric keys. ...more >>

I have a report that has so many parameters that the area fills the screen. When the report runs, I can't see the results because of this. I can't even see the double arrow to hide the parameter area. Any suggestions?...more >>

Hi, I would like to know if there's a way to deploy only the reports that i change instead of deploying them all?? With one or two reports this is not a problem, but with 20 or 30 reports... Thanks, Jorge...more >>

Hello, I want to import access report into sql reporting, but i dont have the option in the project menu "Import Reports "-->"Microsoft Access...". I'm working on windows 2000 and i have installed Sql reporting server SP1. Any Idea ? Thank you for your help ! ...more >>

Hello! I tryed the example from Reporting Services Books Online but it didn't work. I copied ="SELECT FirstName, LastName, Title FROM Employee" & IIf(Parameters!Department.Value = 0,""," WHERE (DepartmentID = " & Parameters!Department.Value & ")") & " ORDER BY LastName" in generic query d...more >>