Groups | Blog | Home


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 > april 2005 > threads for friday april 29

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

HTTP 500 Internal Error!!! PLEASE HELP ME!!!!
Posted by KMILO at 4/29/2005 3:45:22 PM
Hello, Somebody knows a way (different to the described in the troubleshooting guide of Reporting Services) to resolve this error???, I Installed Rs into a w2k3 machine with sharepoint portal server and Microsoft SQL Server 2000 - 8.00.818 (Intel X86) Thanks in advance KMILO ...more >>

SP2 Bug - Multi Column Reports
Posted by SAcanuck at 4/29/2005 3:26:07 PM
I have created a report with two columns. Using the preview for the new client printing: When the report I only contains enough data for a single column nothing is being displayed in page header and footer. When the report contains enough data for both columns the values in the page hea...more >>

SP2 and HTML Viewer Control
Posted by Darin at 4/29/2005 2:54:03 PM
I have installed SP2 on my workstation (client only, no server components) and I can't seem to find the new version of the HTML Viewer control anywhere. Also, the documentation doesn't seem to have been updated either. Is there updated documentation for SP2, and if so, does it contain inform...more >>

putting subscriptions and other SSRS things in SourceSafe?
Posted by FurmanGG at 4/29/2005 2:54:03 PM
There are things configured/setup in Report Manager that we would like to version in Visual SourceSafe... the setup of data-driven subscriptions, for instance. Has anyone done this? Does anyone know of a third-party product that assists with this? I'm currently thinking of writing some code...more >>

Preview bug with default params
Posted by DJM at 4/29/2005 1:10:08 PM
I have a bunch of reports with four parameters, two integers and two datetimes. They don't have defaults. I have gone through them and added another parameter, a string, nullable, with a default of =String.Empty (the purpose of this is to have a parameter in which I can pass a unique ID, to ...more >>

Failure sending mail: The transport lost its connection to the ser
Posted by Nate Dogg at 4/29/2005 11:36:06 AM
When I create e-mail subscriptions they have an error with the status: "Failure sending mail: The transport lost its connection to the server." Has someone run into this before? Thanks, Nathan...more >>

When is snapshot history created?
Posted by Bassist695 at 4/29/2005 10:45:37 AM
In the History section of a report (in Report Manager), assuming the report is run from a snapshot and the server is configured to store an unlimited number, at what point do these appear in the History? I have several reports that, even though they're run from a snapshot, they say "There are ...more >>

How to get email to show in subscriptions INSTEAD of UserID
Posted by David Bienstock at 4/29/2005 10:28:02 AM
I've looked at most of the emails from people that are confused regarding how to setup the email. But in the http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_configserver_v1_4bzl.asp from Microsoft, it indicates that in SendEmailToUserAlias "true=The e-mail ad...more >>



DataTime as parameters: Help Needed.
Posted by Ravi R at 4/29/2005 10:05:34 AM
Hello all, I need to generate a report based on dates(from and to). Is there anyway I can include a dropdown of datetime in the parameters of the RS interface. for example like from mm/dd/yyyy to mm/dd/yyyy. I have RS 2003 EE with SP1 and have no plans of installing SP2. Any help will ...more >>

NoRows Property: need to print table header.
Posted by Ravi R at 4/29/2005 10:02:54 AM
Is there way to print the Header column of a table along with the NoRows message ? Seems like it just prints the NoRows message and doesnt render any part of the table. Thanks Ravi ...more >>

changing datasource to SQL Server
Posted by donalmurtagh NO[at]SPAM yahoo.co.uk at 4/29/2005 9:57:00 AM
Greetings, I have a set of reports that were created using the report designer in Visual Studio. They were originally written to run against an Informix database, but I now need to change them to run against an SQL Server DB. I added a new datasource for the SQL Server DB, but couldn't find *...more >>

Email Subscription Problem
Posted by Benjamin Pierce at 4/29/2005 9:04:14 AM
Regards, When a non administrative person sets up an email subscription to a particular report, the "to" field defaults to their login name rather than their email address. So for jsmith@microsoft.com, the "to" field defaults to "jsmith" and is read only so it can't be changed. Once the ...more >>

Column Layout
Posted by AVG at 4/29/2005 8:30:07 AM
I am just getting started with reportingservices and have it installed (SP2) on my development machine (Win XP Pro SP2). I created a simple report and set the layout to be 2 columns across. It print previews as two columns in VS designer, but when viewing through the report web interface, it...more >>

ReportItem Nightmare
Posted by Andrew Stokes at 4/29/2005 7:56:03 AM
I have read all the threads on ReportItems and Sum within a group but still can't solve my problem. Really appreciate any help. I have a report with 3 groups and a report parameter called Recharge as follows Hours Hrly Cost/Rate Total Costs/Rates 8 67 ...more >>

SP2 Print Legal
Posted by muris at 4/29/2005 7:53:04 AM
I am trying to print a report in landscape with legal paper size. I can get my report printed just fine by clicking on the print icon and changing the paper size to legal in the printer properties. Since we have multiple reports it is hard for the users to memorize which reports have to be prin...more >>

Changing Scale Minimum value on a Graph
Posted by Bryan Avery at 4/29/2005 7:12:05 AM
How can we change in code the Scale Minimum value via code, depending on the data in a dataset? What I would like to beable to do is find the min. value in the dataset and then set Scale Minimum value ...more >>

Parameter by POST max length
Posted by Rachel at 4/29/2005 5:30:05 AM
Hi all, I'm trying pass parameters by Post. Woks fine but when the length of parameter is over 1845 chars the report is not displayed. There are limit in the post method in RS. Rachel...more >>

Installation Adventure Works after update to sp1
Posted by hickmann NO[at]SPAM strama.info at 4/29/2005 5:17:39 AM
Hello, i wonder if it is possible to install the adventure works sample db after updating to ms sql reporting svcs sp1. I got a new book and want to do the trainings on it and would like to know if there are problems or issues that have to be cared about. Thanks a lot in advance. Kind re...more >>

=?ISO-8859-1?Q?Wo_sind_die_ganzen_alten_Beitr=E4ge_hin=3F?=
Posted by hickmann NO[at]SPAM strama.info at 4/29/2005 5:14:22 AM
Hallo Zusammen, wo sind denn die ganzen Beiträge hin, sehe hier im Moment nur noch 13 Stück, erinnere mich an Zeiten, wo es weit mehr an einem Tag gab? Viele Grüße Jens...more >>

RS wishlist
Posted by kamel at 4/29/2005 4:49:50 AM
Hi, I would like to add one more item to RS wishlist: - ability to dynamically switching parameter prompts Example: when userid = Person1 then Parameter1 prompt is ON when userid = Person2 then Parameter1 prompt is OFF TIA, Kamel ...more >>

3-tier deployment
Posted by Web Mayfield at 4/29/2005 4:24:03 AM
I'm looking into deploying Reporting Services on a new project. The reports in question would be accessed from the Internet. We have a requirement to separate the HTTP server from the application logic, but all of the RS deployment examples I have seen show the RS server on the same box as t...more >>

Page Breaks
Posted by nic at 4/29/2005 4:02:16 AM
Hi Got a problem... Have a report of about 30 pages but in print preview it has 60 pages. How do I control the page breaks, because after every 1 page there is a blank. Thanks! ...more >>

Having trouble with the DeviceInfo XML element and showing the toolbar
Posted by moondaddy at 4/29/2005 2:50:59 AM
I'm trying to call a report from an aspx page and so far the whole process works good. However, in the <DeviceInfo> XML element the <Toolbar> element was set to false like this: <Toolbar>False</Toolbar> Now I want to see the toolbar in the report so I changed the Toolbar element to True, ...more >>

Need code examples of how to call SSRS reports from winforms app
Posted by moondaddy at 4/29/2005 12:29:02 AM
I'm writing a vb.net winforms app and need to call up reports from SSRS. I also need to pass in secure parameters into the report and I don't want to pass the credentials if I don't have to. I was hoping I could call my own web service where I can pass encrypted data to my web service which ...more >>

WishList : Datepicker
Posted by anandsagar NO[at]SPAM gmail.com at 4/29/2005 12:18:06 AM
I have developed more than 100 reports in SSRS for my company. I see the usage of SSRS growing in the developer community. The one basic thing that Microsoft forgot to give priority is the datepicker for date parameters in the parameters toolbar. I WANT A DATEPICKER FOR DATE PARAMETER SELECT...more >>

PDF Rendering: What about metadata and security?
Posted by David Lightman Robles at 4/29/2005 12:00:00 AM
Is there any way when rendering reports into PDF, to specify metadata such as Title, Author, Subject and Keywords? And... what about security properties? Allow/Prevent document printing / changing document / extract contents / etc. Regards. ...more >>

Duplicate emails being sent for subscription
Posted by mabster at 4/29/2005 12:00:00 AM
Hi folks, We have a report that is emailed to three users (one "To" and two "Cc") at 6:45am every weekday. As of applying SP2 earlier this week, each user is receiving two copies (generated about 2 seconds apart) in their inbox. There's one curious difference between the two emails: One...more >>

Novell Server
Posted by Jason at 4/29/2005 12:00:00 AM
Hi, We are using Novell as NOS. However, we would like to implement Reporting Services. At the present moment, we are using mixed mode for our SQL Servers. For RS, should we create two accounts: 1) Payoffice 2) Enquiry on the Report Server and let user to use Browser to view the report ...more >>

E-mail delivery
Posted by Geek 007 at 4/29/2005 12:00:00 AM
Hi All, I need to programatically create a report, and deliver it. I managed to create the report and a schedule. When I call CreateSubcription, it fails (InvalidDataSourceCredentialSettingException is thrown) the message is: "The current action cannot be completed because the user data source...more >>

help! - line numbers
Posted by Armands Brants at 4/29/2005 12:00:00 AM
Please help me! Is there some possibility to add line numbers to a table in Reporting Services??? Can't find it anywhere... Thanks! Armands ...more >>


DevelopmentNow Blog