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 > november 2004 > threads for friday november 5

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

Reportmanager failed to load from internet as a webapplication
Posted by Henrik Juel at 11/5/2004 8:55:54 PM
I works fine when I run from our lan by a IIS virtual directory. But using reportmanager from a IIS application outside the lan as a true webapplication, the reportmanager produce wrong paths for controls. E.x. http://images/48folderopen.jpg There should have been a domain in front of /images. I...more >>

Table counting column
Posted by Cindy Lee at 11/5/2004 3:23:36 PM
Is there a way in a table to just have a counter in a column, of which row number. data1 data2 1 data1 data2 2 data1 data2 3 data1 data2 4 data1 data2 5 that will count like 1,2,3,4,5 ...more >>

Security configuration to allow remoting
Posted by Marc Lewandowski at 11/5/2004 2:43:04 PM
I have a custom remoted object that is used to implement single sign-on for our web applications; however, I am having difficulty getting it to work with Report Services. I began by using the Forms Authentication example, then modifying from there. It seems to work up to the point where th...more >>

Report parameters??
Posted by Kjell Brandes at 11/5/2004 2:06:58 PM
I have a report based on a PROC, this PROC takes a lot of arguments. The report it doesn't seem to send these arguments to SQL-server when executing query. When looking in SQL-Profiler I can see just a feew of the arguments. Is there anyone whom can see what I'm doing wrong??! regards Kjel...more >>

sort rdl in solution explorer
Posted by Ing. Branislav Gerzo at 11/5/2004 12:41:46 PM
Hi there, I already have around 50 rdls in my solution explorer in VS .NET, and I want sort them into groups. I don't know how to do that. Drag and drop doesn't work. When I add some report it will be at the end. How to move it to the middle for example ? Thanks. -- Ing. Branislav Gerz...more >>

Page break causing by a long text field
Posted by Eric at 11/5/2004 12:24:01 PM
I have a table with a couple of fields on a table row. One of these field contain a long text in it and a page break is do. What I want to do is displaying all fields in the same page and the rest of the long text field on the second page. Right now all my field is displayed on the first page ...more >>

Q: adding item to dropdwonlist
Posted by JIM.H. at 11/5/2004 11:56:02 AM
After I bind my table to the dropdownlist, I need to add one more item in it. How should I do this? Thanks, ...more >>

Logon Error for Reporting Services
Posted by BK3 at 11/5/2004 11:47:30 AM
I am using SQL Server Reporting Services for my implementation of MOM. I rarely go to the reporting site, so I'm not 100% sure when the error started occuring. Basically when I go to the Home Report site I see Microsoft Operations Manager. I click on that and it takes me to all the possible...more >>



Hard coded sorting
Posted by SAcanuck at 11/5/2004 11:24:01 AM
How does one "hard code" sorting. eg. I want the data set 1,2,3,4,5 to always sorts as 2,4,5,1,3...more >>

Can I render RTF data into a SQL Reports Textbox?
Posted by Rob Miller at 11/5/2004 11:10:28 AM
We've got some form letters that are stored as RTF encoded text fields in the database. We'd like to include this info into a SQL report. Any one know if this is do-able, while still maintaining the RTF formatting in the output? I think the answer is no, but I wanted to throw it out there ...more >>

Installing SQL Server Reporting Services
Posted by Guy G at 11/5/2004 11:08:03 AM
Current machine Windows XP Pro with sp2. Successfully installed all portions of Reporting Services with exception to Report Designer to SQL Server 2000. The message which appears at almost the conclusion of installation states "There is a problem with this Windows Installer package. A progr...more >>

Why preview and deployment are different?
Posted by fanh NO[at]SPAM tycoelectronics.com at 11/5/2004 10:49:24 AM
Hi there, I put 3 Matrix in one report, they are partially overlapped. They are in perfect positions as I preview the report, but when I deploy the report to the report server, They are gaps between 1st/2nd Matrix and 2nd/3rd Mareix,i.e 2nd and 3rd Matrix moved down little bit, Why this happe...more >>

Why nobody answer my question "Preview a report"?
Posted by Jerry at 11/5/2004 9:35:38 AM
Hi, I want to preview a report in my program. Does MSRS provide relative interface to implement it? Where can I found some helpful information? Thank you. ...more >>

Format Currency Problem
Posted by Joe at 11/5/2004 9:26:01 AM
Hello, I'm running SQL Server & Reporting Services locally on my development PC. My regional settings are UK English (ie. currency format uses "£"). I create a new report containing a MONEY field and set the Format property to "C". This does not work - the values are formatted with "$" ...more >>

Repeat data horizontally, instead of vertically
Posted by Johnny Fugazzi at 11/5/2004 9:21:14 AM
I am writing a report and i would like some data to repeat in a horizontal direction, rather than a vertical direction. Actually, I would prefer it most if it could repeat horizontally until the end of the page and then move down to the next row. Is there any way to do this? ...more >>

Grouping with subtotals and totaling all levels
Posted by cmcdavid at 11/5/2004 8:51:28 AM
I have the following situation concerning grouping with subtotals: ColumnName ColumnName ColumnName ColumnName (Grouped on Undergraduates) Freshmen Sophomores Juniors Seniors Subtotal #,### #,### ...more >>

Report Server Email Question
Posted by Ed Willis at 11/5/2004 8:33:14 AM
Is there anyway to use exchange groups for the email addresses? I have about 25 email addresses and it is very difficult to paste that many in the To: email address list. Thanks. ...more >>

Drillthrough parameters
Posted by Chris Ashworth at 11/5/2004 8:31:07 AM
I've set a report that drills through to another report. There is a parameter on the second report (sales orders) called 'order_no'. I can set up the drill through so clicking on an order number on the first report links to the sales order report, with the appropriate order number selecte...more >>

ASP.NET 1.1 & Authz
Posted by Claudio at 11/5/2004 8:24:03 AM
Hi, At the begining of SQL Reporting Services Installation, windows let me know that it left have ASP.NET 1.1 and Authz installed. Can somebody tell me please the links to downloads them, as i can´t find them in the microsoft web. Regards & Thank you ...more >>

SOAP calls with anonymous turned on
Posted by Josh Hensley at 11/5/2004 8:01:01 AM
I have read many, many posts on this newsgroup and now have a pretty good understanding of the security model employed by RS. I therefore know that turning on anonymous access to the RS virtual directory is not recommended. But I also know that if you want to deploy over the internet you nee...more >>

Export to PDF Page Settings
Posted by richard.grover NO[at]SPAM imagefast.co.uk at 11/5/2004 7:22:09 AM
Hi all I have made a report that is massively to wide to fix into an A4 PDF when it is exported from the report server. Is there a way I can make the layout of the PDF landscape and/or tell the report server to shrink everything to fit the page? An example of what to do would really help if...more >>

ReportingServicesCompression.dll error
Posted by Bruce Parker at 11/5/2004 6:03:03 AM
I have a report that will not initially run if the user running the report is not a local administrator on the machine running reporting services. If the user is a local administrator, the report will run. The user that is not a local administrator is able to run the report after the local a...more >>

Report looking at wrong (old) data source
Posted by gearoid_healy NO[at]SPAM yahoo.com at 11/5/2004 4:13:54 AM
Hi, I've changed some reports to use a different data source. To do so I created a new shared data souce called ReportsTest, and changed the data source for some reports to now point to ReportsTest instead of the original Reports data source. However I am getting the following error. A...more >>

Retrieve ONLY the Report Items that a user has permissions for
Posted by DaveH at 11/5/2004 2:52:02 AM
Using ListChildren(@"\",true) returns all items in the report server that a user has access to, however if the user does not have access to view the home folder, the call fails. How do I retrieve ALL the folders/reports that a user has permission for from an application running with the user...more >>

Button OK not responding
Posted by Nicky at 11/5/2004 12:59:04 AM
Hi I am having problems with Report Manager. I am unable to submit any report under Report Manager because the OK button is not responding. This works fine on my production server. I have performed the same installation on my development server and have encountered these problems. I am u...more >>


DevelopmentNow Blog