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 > march 2005 > threads for wednesday march 9

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

multiple resultset in the report
Posted by ALI-R at 3/9/2005 11:30:49 PM
I have a stored procedure which returns multiplr resultsets ,and I'd like to show it in different tabls in my report.Is it doable??? Thanks for your help. Ray ...more >>


Is Legal convert Crystal RPT to RDL?
Posted by Jerry at 3/9/2005 8:27:02 PM
From Crystal [Licence.pdf] 4.6.5 (Excerpt) "End User agrees not to alter, disassemnle, decompile, translate, adapt or reverse-engineer the Runtime Software or the report file (.RPT) format" "End user agrees not to use the runtime software to creato for distribution a product that convert...more >>

Landscape printing setup
Posted by Sachi at 3/9/2005 8:19:03 PM
Hi, Anybody able to workout a solution to set report to landscape settings and export it to PDF successfully with that same settings? No Idea when SP2 is going to release. Had to workout a roundabout soultion. Please any one repond.... Thanks in advance, Sachi...more >>

Re: Exporting to Excel Error : (rrRenderingError)
Posted by Constantine at 3/9/2005 8:11:02 PM
When exporting some reports to excel. This error appears ----------------------------------------------------------------------------------------- Exception of type microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Get Online Help Exception ...more >>

VB.Net 2003 Render Method
Posted by Kevin at 3/9/2005 8:05:07 PM
The Reporting Services Render Method can be used as part of a Web Project. Can the Render Method also be used in a Windows Form Project?...more >>

Pull an Image from a Database onto a Report Problems
Posted by Jeremy Wright at 3/9/2005 6:47:51 PM
Does anyone know if the following is possible? If so, any pointers on how to accomplish it? I have a table in SQL 2000 containing two fields "StoredDoc" and "StoredDocExtension". The StoredDoc field is a ntext field. the StoredDocExtension is a char field. When uploading an image to th...more >>

Default Value for Parameters
Posted by Dario Concilio [MCP] at 3/9/2005 5:57:05 PM
Hi, Can I set a Default Value for Parameters? Thanks Dario Concilio ...more >>

nothing happens when selecting "new folder" ?
Posted by scott at 3/9/2005 5:42:37 PM
When i connect as local admin to http://server/Reports/Pages/Folder.aspx and select NEW FOLDER , nothing happens (also when selecting anything else on this bar nothing happens, like data source etc..) When moving the cursor over the option it does change. I can select properties. is this no...more >>



Summing matrix rows & columns
Posted by Bill Youngman at 3/9/2005 4:47:05 PM
I have the following matrix in my report - * Fields!GroupItemName.Value is a matrix row and Fields!UserName.Value = is a matrix column. * Documents Processed (=3DFields!DocCount.Value)/Avg Time = (=3DFields!AvgTime.Value)/Total Time (=3DFields!TotalTime.Value) are = static rows What ...more >>

Reporting Services installation:Authz is not installed on this mac
Posted by Omar Vera at 3/9/2005 3:43:04 PM
Hi all, I am installing Reporting services in the following machine: Win2K + SP4, both of them including in the same installer SQL Server 2000 + SP3, installed separately But when I am installing Reporting Services I receive the following warning in the result of the system prerequisites che...more >>

Reporting Services with Oracle 8i
Posted by Harold at 3/9/2005 3:33:03 PM
I want to know if Reporting Services has problems connecting with Oracle 8i functions (no procedures), also if it has problems with output parameters in Oracle procedures and functions. Thanks....more >>

Cant PREVIEW SAMPLE REPORTS
Posted by pmud at 3/9/2005 3:29:02 PM
Hi, I tried to view the sample reports provided by microsoft, but I cant even preview them....I get the error:: AN ERROR HAS OCCURED DURING REPORT PROCESSING. CANNOY CREATE CONNCTION TO THE DATA SOURCE 'ADVENTURE WORKS'. SQL SERVER DOESNT EXIST or ACCESS DENIED.... But the wierd thin...more >>

cant load rep mgr without user + pass prompt ?
Posted by scott at 3/9/2005 3:10:55 PM
When loading Report Manager on the hosting Rep Service machine i cant access any options without a password + user. I cant get any to work. When setting up Rep Services in every option possible i defiend a local service account at first. I then uninstalled the software and installed again u...more >>

The underlying connection was closed: Could not establish trust relationship with remote server.
Posted by Jake Smythe at 3/9/2005 3:04:57 PM
Hello, I have a couple of problems trying to setup a production box. Pre Installation...Created our own ssl cert and attached to default web(unfortunetly have no budget to purchase outside certs) Installation: Selected option to redirect homepage to reports page. Se...more >>

Reportes ok desde /reportserver pero no ok en /reports
Posted by Jfrc at 3/9/2005 2:29:05 PM
En blanco Hola! por favor alguien me podria dar un luz con este tema los reportes en la = lan funcionan siempre ok y en internet desde el portal /reports = simplemente no fucionan y no saca ningun tipo de error, simplemente no = funciona y si el mismo reporte lo busco en web via /rep...more >>

HOWTO: Get a table to display that has a Null DataSet
Posted by Jeff at 3/9/2005 1:41:12 PM
HOWTO: Get a table to display that has a Null DataSet I have a table that is designed with static text that I what to be displayed every time regardsless of the tables dataset contents, with rows or a NULL dataset. I have multiply datasets in my RDL. How can I do this?...more >>

Report Caching
Posted by PD at 3/9/2005 1:25:13 PM
If a report (report A) is set-up for caching and is then used in another report (report B) as a sub-report, will report A be rendered from cache when report B is executed?...more >>

Web Service activation error
Posted by poul0004 at 3/9/2005 12:41:07 PM
Hello all- I have read and attempted to follow all of the doc I could find on the Microsoft site and this newsgroup regarding the following error. I have just completed an install of RS on Windows Server 2003 with IIS 6. This is the Report Server. The Report Server database is hosted on ...more >>

main page blank after new install ?
Posted by scott at 3/9/2005 12:06:45 PM
Hi, I installed reporting services on 2003 (IIS6, front page ext, asp.net, no vb.net). When connecting to http://server im directed to http://server/Reports/Pages/Folder.aspx . The main form header shows HOME / MY SUBSCRIPTIONS / HELP but the main page is blank. Anyone know why and how t...more >>

No attachments in subscription mail messages
Posted by Stefan Cremers at 3/9/2005 11:45:08 AM
We have reportingservices installed on the sql box. It's a W2K SP4 server with sql2000 SP3a. We have deployed several reports. All reports we have deployed after installing SP1 do not contain an attached report (PDF, TIFF, Excel, CSV) but when the report is rendered in the body of the messa...more >>

crashing excel when printing exported RS report
Posted by David at 3/9/2005 10:03:03 AM
We are having a problem with some reports that get exported to excel and then trying to print. we don't get this with all reports just some. Here is what happens: The report generates fine in RS. We then export to excel. We tell excel to print and then get a 'Memory can't be read' error and ...more >>

Reference to a non-shared member requires an object reference
Posted by JL at 3/9/2005 8:49:05 AM
Hi, I tried to use a custom assembly, written in C#. I received the following error: "[BC30469] Reference to a non-shared member requires an object reference..." Here's the detail info for the custom assembly: *I have 2 C# files. I did not write the code. So my C# knowledge is lim...more >>

Processing Time Perfomance
Posted by David Swanson at 3/9/2005 8:45:05 AM
First, a general question. What is a "reasonable" time to expect the ProcessingTime to take. Now I know that is pretty vague and largely depends on the grouping/filtering defined in the RDL. Our problem. We have a several main reports that each embed 7-10 subreports from a pool of 15 or ...more >>

System.Net.WebPermission and Data Processing Extension?
Posted by letuce dance at 3/9/2005 8:39:01 AM
I have created a Data Processing Extension Inside the extension I’m trying to do this: XmlDocument xml_document = new XmlDocument(); xml_document.Load("http://localhost/information.xml"); sounds pretty simple. Ya right nothing that has to do with rs is simple. It throws a <IPermis...more >>

move project to another developer
Posted by Jason Wang at 3/9/2005 8:37:03 AM
When another developer open my report project in his machine, he could not look at the report on design view. The user id on data source is a SQL user id, not Windows ID. How do I fix the problem?...more >>

Report to show current year revenue only if last year has no reven
Posted by DCount17 at 3/9/2005 6:31:05 AM
I need to create a report that correctly displays ONLY accounts that have revenue for the current year and no revenue at all for the previous year (calendar year). The sql below does not do it. SELECT DISTINCT a.ACCTNBR, a.ACCTNAME, SUM(f.REVENUE) AS REVENUE FROM FORD.dbo.DATA...more >>

user permissions
Posted by jcrodri NO[at]SPAM gmail.com at 3/9/2005 5:47:50 AM
Hi, anyone know how can I asigment a user permision for an expecific report, but programatically, in a .NET Web Aplication??? Thanks ...more >>

connecting Lotus Notes data in VS .NET Report Designer
Posted by Charles Chung at 3/9/2005 4:41:01 AM
my company is requesting that I convert notes db views into a report using MSVisualStudio.Net. I downloaded the LotusSQL driver and created a datasource. The driver was also downloaded to the appropriate Reporting Services server.When I am in VS I can preview the report. However, when I am i...more >>


DevelopmentNow Blog