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 2005 > threads for wednesday december 21

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

Report Timeout
Posted by AdamB at 12/21/2005 10:41:02 PM
I have a report I execute from an Asp.Net front-end. The report is rendered directly to PDF via a web services call to the Reporting Services web service. For this particular report, at exactly 3 minutes, the report always aborts processing and redirects to a "Page Cannot Be Displayed". The...more >>

Name of report in head dynamically
Posted by Michael Bender at 12/21/2005 6:30:01 PM
Hi everybody, does anybody knows if it is possible to create a report where the name changes. I want to dynamically add a subtitle with data from a database. E.g. (Static: Adress List, Dynamic: of Town XY). Apparently it is not possible to insert fields from a dataset in the head of a repor...more >>

Cannot create a connection to data source 'dsInvent'
Posted by Steve Wofford at 12/21/2005 5:05:27 PM
I get this error message when connecting through IE to a report. We have a sepererate Report Server and the database to which we are reporting from. When I go to the report server logged on using the same account as my workstation I can access the report. I have tried making it a shared data ...more >>

Shared Data Source - access from custom code
Posted by John A at 12/21/2005 5:05:02 PM
Hi all I have a need to get at the connection object of my Shared Data Source from custom code that I have written. This custom code is in a library that I have as part of my Reporting Services Business Intelligence VS2003 solution. Is it possible to access the Shared Data Source from my cus...more >>

carraige return
Posted by superQ at 12/21/2005 3:51:02 PM
This is an easy question, I have two address fields and I have combine them together but I want address_2 to show up on the next line instead of have a sapce between address1 and address2 Any Idea Thank in Advance =Fields!BILLING_ADDRESS.Value & " " Fields!BILLING_ADDRESS_2.Value...more >>

Group sums wrong in Matrix
Posted by Jsarna at 12/21/2005 2:38:39 PM
Banging my head against the wall on this one. Running a matrix report in RS 2000. I have 2 groupings, Department and Company. I want to get a sum of total hours for each job code and Department and Company. The job code hours show up in the detail, as =Iif (Len(sum(Fields!HoursTotal.Valu...more >>

Report rendered via webservice not executing from cache
Posted by Hella at 12/21/2005 1:33:07 PM
I set a report to 'Cache a temporary copy of the report. Expire copy of the report on a Shared schedule' I generate the report using the webservice function Render. All the settings seem to be set properly, the cache options setting (using GetCacheOptions) returns True, and the ExpirationDate...more >>

Finding End of Month
Posted by Mike Harbinger at 12/21/2005 1:26:06 PM
Does anyone have a VB function they could pass along for converting a date to the end of the last month? I have a report that will be run for the period ending the prior month and want the parameter date to default as follows: Assum they are running it on 12/21, date should default to 11/30/20...more >>



Reporting Services 2005
Posted by Colin Halliday at 12/21/2005 11:19:58 AM
I am building a report based on an SQL Server 2005 Analysis Services = Cube of staff members' hours worked for a month, broken down into = chargeable and non-chargeable time. I can create the dataset that I require fine and add 2 columns to the = filter panel and tick the PARAMETERS check boxe...more >>

change sender for subscription.
Posted by ken lee at 12/21/2005 9:42:31 AM
I need change the sender for the reports under certain folder. I guess that I need to change RSreportServer.config. However it made effects on all reports subscripted. the problem is that I need to change some reports under certatin folder. is there someone could answer this question? thank...more >>

We would like to Proto MSRS. Can it run with CE9?
Posted by Jeff McAhren at 12/21/2005 8:22:04 AM
Our app platform consists of a MSSQL2k sp3 database server, and a Domino web server with CE9 installed. We currently run only unmanaged reports that are called via URL's from the client. We don't use the CE report manager console or anything like that. 1) Is this possible with MSRS?.. ...more >>

URL Access - Not Working
Posted by Terry at 12/21/2005 7:04:02 AM
I am unable to hide the report parameter with the following URL. Please help! http://reportserv/Reports/Pages/Report.aspx?ItemPath=%2fChina%2fReports%2fList_Codes&rc:Parameters=false ...more >>


DevelopmentNow Blog