Archived Months
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
all groups > sql server reporting services > december 2004 > threads for thursday december 16

Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

Filtering the dataset
Posted by Terry at 12/16/2004 7:11:02 PM
Hi All, I have reports which return employee information. I want the report to have an optional 3 parameters representing Entity, Business Unit and Cost Centre. If any of these parameters(or a combination is used) I want to filter the returned dataset to display only relevant rows. Before...more >>


Word rendering... WHEN?
Posted by Rodrigo Sánchez at 12/16/2004 6:49:38 PM
UIs it true thatr microsoft has no plans to create word rendering extension?, I cant believe they wont support their own propietary format, even when tehy support PDF, even rtf would do the trick, Is there some one who can tell me if we are to expect that feature in the final release of sql serv...more >>

Change report server database
Posted by May Liu at 12/16/2004 6:19:04 PM
I install reporting service on 2 machines. Each RS has it's own report server database. e.g. A_ReportServer for machine A and B_ReportServer for machine B. Can I dynamically change the report server database ??? i.e. Machine A point to B_ReportServer database. If yes, how can I do this ??...more >>

sort correctly by month name
Posted by aaron_kempf NO[at]SPAM hotmail.com at 12/16/2004 5:53:20 PM
so i have month name in a field for a rs report.. and i want to be able to sort it correctly. what are my options? I'm doing this in MDX: and i cant change the cube or a dimension aaron ...more >>

Reporting services initilization problem
Posted by Skeptical at 12/16/2004 4:06:24 PM
Hello, I installed RS on a Windows 2003 box with SQL Server 2000 sp3. Unfortunately setup reported that it could not initialize RS and it has to be initialized manually I have tried: rsconfig & rsactivate with tons of different combinations of users ranging from local system account ...more >>

Reporting-Server Grafik mit werten kleiner 0
Posted by Ralph Hüttenmoser at 12/16/2004 3:39:41 PM
Guten Nachmittag ich habe einer Grafik eine DataSet zugewiesen (Thema ist: Über oder Minusstunden) Auf der Grafik werden aber nur die postiven Zahlen angezeigt (der 0-Punkt ist immer der Ausgangspunkt). Es müssten z.B. aber noch -1, -2 oder noch tiefere Achsen angezeigt werden. Muss man d...more >>

Report Parameter Defaults not being used in deployed reports
Posted by Kelly Gross at 12/16/2004 2:51:12 PM
When I set the default properties under Report Parameters in some reports, it works perfectly, in other reports, the parameters specified in Visual Studio under Report Parameters seem to have no effect when the report is deployed to the ReportServer. The toolbar for the parameters displays, and ...more >>

One subscription; Multiple Reports
Posted by HBWAL at 12/16/2004 2:45:02 PM
I have a report with 4 parameters. Hierarchy:Dept, Team, Member Report: List based on Hierarchy Mgr: List based on Hierarchy Person:List based on Manager The managers want to send a "report card" to the team members letting them know how their metrics are meeting goal. To do this they wo...more >>



I need to know how to deploy reports without Visual Studio
Posted by Kelly Gross at 12/16/2004 1:52:50 PM
I have reviewed the available documentation and was unable to locate a method to deploy reports outside of Visual Studio without instantiating the web service. We have a package we would like to bundle with some reports. Does anyone know an easy way to deploy reports using an .rdl file? ...more >>

Operation Not Supported: LogonUser method in the Reporting Web Service
Posted by Dave at 12/16/2004 1:51:13 PM
I'm getting a SoapException stating "This operation is not supported in this edition of Reporting Services --> This operation is not supported in this edition of Reporting Services" when I try to call myReportService.LogonUser(myName, myPassword, myDomain) I have verified that I am running t...more >>

A couple newbie questions: page breaks & grouping
Posted by Paul Enfield at 12/16/2004 1:42:00 PM
Referals to documentation references appreciated if applicable... I've got a few questions regarding my task of creating a collection of fax reports. I'm gathering I might be attempting to use the wrong tool for this. Please indicate if this perception is correct. Specifically: I need to pr...more >>

DistinctCount
Posted by Myles at 12/16/2004 1:19:02 PM
I am running into a problem using DistinctCount - I have values in the report that can either be a valid value, an empty string or null - I believe the nulls are being discarded in the counts, but is there a way to make sure that the empty strings are not being counted?...more >>

Why does adding a new static row to a matrix add a new column?
Posted by Stefan Wrobel at 12/16/2004 12:59:03 PM
In a matrix, when I add a static row it adds another column. I don't understand this behavior. For example, take a Matrix, define a column group and a row group (just the initial columns and rows groups, just give them each a grouping expression), then right-click on the data area and do "ad...more >>

Formatting spoils when export to HTML Format
Posted by Jignesh Nakrani at 12/16/2004 12:45:01 PM
I have problem here. when I overlap two or more tables one on other and export to PDF, it works fine. But when exported to HTML, it doesn't hold the absolute position and renders tables sequentially. Thanks, Jignesh...more >>

Table Cell Formatting
Posted by Rory McCaw at 12/16/2004 12:24:27 PM
The cell formatting doesn't appear to be working in my report. In the Textbox properties: Name: Value Value: =Fields!Value.Value Format: Standard | Number | 1234 The output however in the cell is consistently 1234.123456789. How can I round off to the nearest whole number (no decimals)? T...more >>

Reporting Services
Posted by sai at 12/16/2004 12:03:01 PM
hi, I trying to display list of values in the table footer. Here i am using multivalued datafield and it is displaying only one value. How can I make the footer to display all of the values of that field? Is there any other solution?...more >>

Carriage returns
Posted by Microsoft at 12/16/2004 11:03:30 AM
I'm migrating from Crystal. When I inserted address fields which contained carriage returns, Crystal seemed to recognise them automatically, putting the second line beneath the first line, etc. RS doesn't do this - obviously I have to do something more explicit. Cam anybody help? Thanks ...more >>

Changing password
Posted by Patrick at 12/16/2004 11:02:31 AM
Hi Freinds, SQL 2000 REPORTING SERVER I changed my SA account password and Reporting service stop working. Where should I modify the account crudentails in RSReportServer.config Thanks, Pat ...more >>

Change quality rendering to PDF
Posted by TiJei at 12/16/2004 10:47:07 AM
PDF - rendering of reports that contain images, makes very large pdf-files. Is there any option that I can set the export quality of the images? I have seen in this forum that there have been many questions about rendering images, but very few good answers .... can anyone tell me if there ...more >>

Moving SQL Server/Report Server off public IP
Posted by DJM at 12/16/2004 10:28:50 AM
We are planning on moving our SQL Server off of the same machine as our web server and securing it behind a firewall, removing all accessibility by public IP. However, our web app uses the report viewer control to render reports, and it points to <default IP of the web server>/ReportServer, w...more >>

Linking Reports in different projects
Posted by sfibich at 12/16/2004 9:59:26 AM
Is there a way to link reports from one project to reports in a second project?...more >>

format Now()...
Posted by clutch at 12/16/2004 9:33:03 AM
How do I format Now() to look like dd/MM/yyyy (without time part) as a default value for a report parameter?...more >>

Permission problems - Access Denied
Posted by CTSawyer at 12/16/2004 8:45:02 AM
When ever I attempt to access the Report Manager (<rooturl>/Reports/Pages/Folder.aspx) page of RS I get: The request failed with HTTP status 403: Access Forbidden. If I try <rooturl>/ReportServer/ I get: Directory Listing Denied This Virtual Directory does not allow contents to be listed Ou...more >>

How can I detect the user name and show only the Rows with his information?
Posted by Luis Esteban Valencia at 12/16/2004 8:26:14 AM
I have a table or view with a column name with the DOMAIN USER NAME. I want to detect it and show only the information that they need to see. -- LUIS ESTEBAN VALENCIA MICROSOFT DCE 3. MIEMBRO ACTIVO DE ALIANZADEV ...more >>

hidden parameters are not hidden
Posted by Pascal Simler at 12/16/2004 7:35:01 AM
Hello, I've created a report with a parameter with no prompt ( hidden ) and a second one with a prompt. When I switch to preview in Visual Studio only the second parameter appears. This is OK. When I launch the report in IE : http://servername/ReportServer?/ReportFolder/Myreport&Param1=1&P...more >>


DevelopmentNow Blog