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 > september 2004 > threads for monday september 27

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

Advise on Forms Authentication
Posted by JiaN at 9/27/2004 9:37:03 PM
ok i am doing a system in asp.net and also using reporting services to generate some reports for user to view. My system consists of two parts which is the Suggestor and the Evaluator. Firstly the suggestor will go to a aspx page whereby they can submit new suggestions by filling up the page...more >>


Could IIS and SQL Server in two machine
Posted by ad at 9/27/2004 8:52:18 PM
I install my Reporting in a server of Sql server and IIS together. I found the server is too busy. Could I install reporting service in another server that without Sql server. ...more >>

Standard headers across all reports
Posted by Stuart at 9/27/2004 7:35:04 PM
Is it possible to create a user control (or some such object) that is dropped onto all reports to provide standard consistent layout of elelments such as headers and footers? I would like the company logo, report title, current date etc to appear precisely the same on all reports. (Naturally ...more >>

getting data from another machine
Posted by Jasonymk at 9/27/2004 6:23:03 PM
hi all, my report server is installed in machine 1 , after i made a report which the source is from machine 2, the broswer hanged and report the following error: An error has occurred during report processing. (rsProcessingAborted) Get Online Help Query execution failed for data set '(myDB...more >>

Generate Executed Subscriptions Report.
Posted by Carlos E. Mosquera at 9/27/2004 4:47:03 PM
Hi Now i need a report of executed subscriptions in specific shared schedules, Someone have something to parse Subscriptions table or only way is consuming webservice??? Someone have an idea??? I program a module to get subscriptions (with lastexecution, emails, report name, etc.) b...more >>

Supress blank subscription reports
Posted by Noah Hart at 9/27/2004 4:28:13 PM
Is there a way of telling RSS to only mail reports which have data on them? Currently, reports are delivered even if there is nothing on them. This is causing many complaints. Thanks, Noah...more >>

Reporting Service ReportRendering Error
Posted by BrianDQ at 9/27/2004 4:25:03 PM
After running a report using reporting services, when trying to Export to a ..pdf format we are receiving the following error: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. Cannot find font '?'. Has anyone experienced this problem? ...more >>

Disappearing point labels
Posted by O8 at 9/27/2004 4:18:00 PM
I have deployed a number of reports with bar charts. Most of these bar charts have numeric point labels. On some charts the upper most and lowest bars do not display the point labels in preview or report manager. I have experimented with font size and style, point label position as well as char...more >>



impersonation / authentication
Posted by Marc Miller at 9/27/2004 4:02:29 PM
Hi, We moved our dev work to a staging server. On the staging server I am a Windows user and I am the Report Manager administrator. I have impersonated my userid and password for the staging server in a .NET web config. And have set my userid up to browse the report in the Report Manager....more >>

Browser Refresh
Posted by Sean Edwards at 9/27/2004 3:05:04 PM
The browser refreshes every 2 seconds when "Render this report with the most recent data"->"Cache a temporary *" is selected. It also refreshes around every 30 seconds when nothing is selected. Has anyone had an similar issue, I've done a little searching, is their a way to disable auto-b...more >>

plus/minus icon
Posted by Emmanuel at 9/27/2004 2:18:27 PM
hi, the plus/minus icon is showing the inverse of the current state of the group i.e. if the group is open (meaning that the sub rows are visible) the icon shows as plus instead of minus, and vice versa. my report is defaulting to the hidden=false option, and probably this is why. So how ca...more >>

user store for forms authen
Posted by jbmeeh at 9/27/2004 1:29:11 PM
I have my report server database deployed on a separate server from reporting services. Can I deploy the forms authentication user store on the same server as the report server database? I'm assuming that I would need to use sql authentication to connect to the user store....more >>

Setting Report Parameters
Posted by Lee at 9/27/2004 1:25:02 PM
I have a report parameter called "ReportDate" which is a date 1. How can I default the date to be today's date minus 1, i.e. yesterday? 2. How can I do the same with subscriptions?...more >>

The language of user interface become to English
Posted by ad at 9/27/2004 1:06:02 PM
I using a Tranditional Chinese version of Repporting Service. The user's interface was Chinese in the pass. But it become English today. How can I do? ...more >>

upgrading error
Posted by ad at 9/27/2004 11:40:15 AM
Hi, When I upgrading to sp1, it result in an error message "Can't stop W3C service." How can I do? ...more >>

Error clicking on My Subscriptions
Posted by Mike Kruchten at 9/27/2004 10:55:36 AM
I get the following error after clicking on My Subscriptions. There is plenty of space on the server where RS is installed. I'm stumped where to start looking. Server Error in '/Reports' Application. ---------------------------------------------------------------------------- ---- There ...more >>

Dynamic Parameter
Posted by SAcanuck at 9/27/2004 10:19:01 AM
I have created the following two parameters: DateRange Parameter with available values: 1. label = today, value = 1 2. label = yesterday, value = 2 StartDate with Default Value (Non Queried) = = iif(Parameters!PMDateRange.Value = "1", now(), iif(Parameters!PMDateRange.Value = "2", Tod...more >>

Forms authentication question
Posted by j_a5 at 9/27/2004 10:07:35 AM
Hi, The forms authentication works fine. However, after the prescribed timeout period specified in the report server web.conifg report server autmatically logs you off even when you are constantly using the report server. To reproduce: 1. Set the forms auth timeout to a small number say 5 min ...more >>

CAS
Posted by Jason MacKenzie at 9/27/2004 9:59:49 AM
I'm having a difficult time wrapping my head around Code Access Security. We have just installed Sharepoint Portal Server 2003. I have a web part that uses the obc.net dataprovider that is causing me a security error when I try to upload the web part. I'm just not understanding what I need...more >>

prompted for username and password
Posted by gearoid_healy NO[at]SPAM yahoo.com at 9/27/2004 8:59:37 AM
hi, I've a .net app written to view reports. The app is set up in iis with the anonymous access checked and integrated windows authentication checked for the default web site (my app - it's a dedicated web server) and the same with the Reports and ReportServer virtual directories within the ...more >>

Deault location for RSTempFiles
Posted by troark at 9/27/2004 8:55:48 AM
I currently have RS installed on my C: drive. Unfortunately, I did not realize how much free space I was going to need for temp files, so now I'm running out of space on my C: drive and RS restarts several times during a schedule. Is it possible for me to point RSTempFiles to another drive let...more >>

matrix problem!!!
Posted by Laura at 9/27/2004 8:47:04 AM
I created a matrix and everything looks good except that when I do a preview the first page is ok but the second to the last pages my matrix shifts a bit to the right. Anyone has an idea what's causing this? I can't seem to reproduce this in my other report so I'm wondering what's up with thi...more >>

Cumulating
Posted by jcredk at 9/27/2004 8:37:10 AM
hi, I have a table that gives me lets say : DateReachingPlace, PlaceCityName, MilesSincePreviousPlace How could I have a cumulative field for Mileage ? DataSet: 17:00 Paris 5 17:30 Clichy 7 17:45 LaDefense 11 Expected report: 17:00 Paris 5 5 //(assuming it...more >>

Subscription Owner
Posted by Greg - NEOS at 9/27/2004 8:29:01 AM
Hi, If i'm not wrong, there is no way to change a subscription's owner through the Report Manager website. I haven't found a way to do this programmaticaly too. I'm actually performing this operation by updating "SUBSCRIPTIONS" table... Is there any link to a website explaining how to easi...more >>

2nd request: group visibility issue
Posted by Stads at 9/27/2004 8:13:04 AM
Hi, I have a report with a SP datasource. The groups have drilldown capabilities. I have conditional expressions on groups 1 and group 2 that when a flag in the proc is one value then something like this is displayed: region 1 district 1 facility A data data data facility ...more >>

not seeing fields using stored procs
Posted by Lee Hopkins at 9/27/2004 8:04:25 AM
I do not see the fields to drag them to the table when using a stored procedure....more >>

Getting Top 20 of multiple groups(filter for top 20)
Posted by Lee Hopkins at 9/27/2004 7:51:34 AM
I have a query that is grouped by Site, bringing back 50+ lines per site, my mgr. wants to see only the top 20 for each is there a way to do this in the query or is there a way to filter the report for the top 20?...more >>

Add group or user name..Bug or not?
Posted by SteffoS at 9/27/2004 7:47:02 AM
Hi.. I just want to know if anybody else has experienced this problem. When i try to add group [xx\yyyYYYY Datakontakter] to a role on a folder the response is "The user or group name 'xxYYYY Datakontakter' is not recognized. (rsUnknownUserName) ". However, when it is [xx\xxxYYYY Filialchefer...more >>

Adding Values in a Text Box
Posted by TrussworksLeo at 9/27/2004 6:53:03 AM
I have multiple values in text boxes based on Summed values. I would like to add the values that are in the text boxes. What is the ref for Boxes? I know fields are Fields!. Here is an example of what I am running it the text boxes. They are in the group footer. I would like to add the...more >>

Cannot Delete or Overwrite reports
Posted by Hyper at 9/27/2004 6:23:06 AM
I cannot delete the first report I created. The Server CPU goes to 100% utlisation and practically cripples the server (simple sql queries take forever). Eventually the delete operation times out. I have managed to delete other reports with success. I see some other people are having the same ...more >>

Excel rendering crash with parameters. Ok as HTML.
Posted by colin_overton NO[at]SPAM hotmail.com at 9/27/2004 4:35:52 AM
Hi, I am trying to render report I have with a matrix on it using the web service. It works fine if I render to excel format with no parameters provided to the report. It also works fine if I use the exact same code and just change the render format to "HTML4.0" instead of "EXCEL". As...more >>

Export to PDF trims leading spaces
Posted by George Kousis at 9/27/2004 4:29:04 AM
Hi, I have a simple report that displays a table with text fields. The data source is a Stored Procedure that returns two nvarchar fields. These fields include in some cases leading spaces, i.e. the value of the field may be: " here is the value" The report works fine for other f...more >>

Cannot connect to the report server db.
Posted by Veronica at 9/27/2004 2:53:01 AM
After I reboot the server, the following error message show on: "Schedule and delivery process cannot connect to the report server database" Before I reboot the server, I try to set a new subscription. I think this is boot sequence problem. Anyone have any ideas....more >>

Error: Key not valid for use in specified state
Posted by Virginia at 9/27/2004 12:32:18 AM
Hi there, I got this error when I try to open report manager // {servername}/reports. An internal error occured on the report server. See the error log for more details. (rsInternalError) The server is win 2003 SP1, sql 2000 sp3 and report server SP1 Thanks, Virginia ...more >>


DevelopmentNow Blog