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 > june 2005 > threads for thursday june 30

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

This can't be as hard as I'm making it, can it?
Posted by Greg at 6/30/2005 8:53:58 PM
I'm trying to build what I would consider a very simple report, but I can't seem to figure out how Reporting Services wants me to do it. The "report" is really just a form letter. The data set contains basically a persons name and their ID. What I need to do is print a new page for each n...more >>


dynamically changing TextDecoration property of a text box
Posted by Kiran at 6/30/2005 6:08:02 PM
I need to make one column on a report to display as hyperlink. I am using TextDecoration underline property . How do I change the underline property to None dynamically based on the data. I am writing the following code in the Expression section of TextDecoration property of the text box. If ...more >>

How to Make a sub report hidden using custom code(Sqs Reporting Services)
Posted by Rajesh Vasan at 6/30/2005 3:59:51 PM
Hi There, I have a question here. I'm using 2 subreports say subreport1 and subreport2 in a mainreport. Based on a parameter value i would like to show the subreport1/subreport2 or show both. Please let me know if this is posible. Thanks in advance. Rajesh ...more >>

Index out of range error exporting to Excel
Posted by klumsy NO[at]SPAM xtra.co.nz at 6/30/2005 3:01:22 PM
i've noticed that others have gotten this same error, when trying to export to excel they get the following error, it seems it hasn't been something dealt with, maybe because microsoft cannot reproduce it Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException w...more >>

data driven subscription not available
Posted by Marcus K at 6/30/2005 2:43:06 PM
Hi, I am trying to create a data driven subscription. I have stored the credentials and custom data source in the report. My account has site administrator and content manager permissions, yet the "New Data Driven Subscription" button is not available. I have multiple reports like this. ...more >>

Multi-select parameter in SQL Server Rptg Svcs 2005
Posted by Machelle at 6/30/2005 2:25:01 PM
I am using a beta version of reporting services 2005. I have created my report parameters as multi-select. However, I'm having trouble having the query parameters accept the list that the report parameters passes. (below) I tried replacing the = with in and between and neither work. It do...more >>

Selective Jump to Report?
Posted by Chris Kennedy at 6/30/2005 2:09:05 PM
I would like to be able to disable a Jump to Report link when the value of a particular field or parameter is a certain value. For example if parameter x = 1, enable the jump link, but if x = 2, do not allow the jump. Does anybody know how to do this? Chris Kennedy ...more >>

CreateSubscription Extension Parameters
Posted by AJ Cohen at 6/30/2005 2:03:03 PM
The following Extension Parameters are not being accepted -- CreateSubscription works and a record is created, but three values are not getting through to the database: extensionParams(3) = New rsSubscriptions.SVR03_ReportService.ParameterValue extensionParams(3).Name = "RE...more >>



Q: report blank page
Posted by JIM.H. at 6/30/2005 1:50:06 PM
Hello, Report.PageWidth - Report.LeftMargin - Report.Right Margin) >= Body.Width 8.5 – 1 -1 >= 6.37 I still see one blank page with page header only when I go to print preview in the Preview tab. What is problem? ...more >>

Using web services my images fail to display
Posted by jrlichina at 6/30/2005 11:36:21 AM
My report has images embedded in the report and when I render the report it shows everything but the images. Any ideas? ReportingService rs = new ReportingService(); rs.Credentials = System.Net.CredentialCache.DefaultCredentials; // Render arguments byte[] ResultStream = null; byte[...more >>

Activating a Second Server in an NLB Cluster
Posted by zinck74 at 6/30/2005 10:39:00 AM
Hi, I'm having problems activating a second server that is participating in an NLB cluster. The common response I see here is to run rsactivate from the first node using the -m switch to activate the second node. The problem with this is that when in an NLB cluster you cannot even ping the sec...more >>

Getting Started Q - Can Datasets be shared?
Posted by Doug Little at 6/30/2005 10:08:04 AM
Hi, I'm just starting with RS. Can Datasets be shared or copy/pasted between reports. I have a number of reports that are all based on the same source query and would like to avoid coding in several places. THanks in advance. -- Doug...more >>

Retrieving RowCount from a dataset
Posted by Bob at 6/30/2005 10:03:03 AM
Hi, I need to calculate a percentage of population based on the number of rows returned on a dataset. Within a stored procedure, I could use @@ROWCOUNT but there is no way for SRS to receive multiple result sets in a single data set. I could execute the query twice, once for the count and...more >>

ItemTypeEnum = Resource question
Posted by James Tow at 6/30/2005 9:51:07 AM
I have a Resource file that is a htm file in a sub-folder on reporting services. Using the web service I am getting the catalog items using ListChildren. I want to be able to extract out the contents of the htm file. It is stored as a text/html MIMEType. I don't know if this is the correct f...more >>

Report parameters appear disabled in Preview Mode
Posted by Jaime Stuardo at 6/30/2005 9:46:04 AM
Hi all.. I have created 3 report parameters, named: NUMERO_POLIZA, CUATRIMESTRE, AÑO (in this order). When I preview the report, only NUMERO_POLIZA appears enabled. All others disabled. One strange thing is that when, in report parameters dialog, I move NUMERO_POLIZA parameter down, for...more >>

Report Viewer web part (sp2)
Posted by Paul at 6/30/2005 9:28:05 AM
Does anyone know how to pass parameters through to the Sharepoint Report Viewer web part? Thanks, Paul. ...more >>

Parse the field
Posted by agenda9533 at 6/30/2005 8:22:02 AM
I have a table that has a "Problem" field with the following data Customer Service...Jam...Jam 5...Planned Technical Support...WinOnCD...WinOnCD6PowerEdition...Request...Reporting New Drive Sale Made I need to separate this "Problem" field into separate fields the issue1, issue...more >>

Versioning Tools
Posted by Logicalman at 6/30/2005 8:21:03 AM
We currently use CVS as our versioning tool for .NET production. It has been suggested that we could also use CVS for SQLRS versioning in the same manner. Has anyone implemented this, with or without problems, or is there another 3rd party tool out there we could use. Thanks, Tony...more >>

Retrieving the RDL from SQL Server
Posted by Craig HB at 6/30/2005 7:42:08 AM
I have lost the reports that I designed. They were deployed and are currently being used. Is there a way to get the RDL out of the ReportServer database ? Thanks, Craig ...more >>

Problem defining a query parameter in an Oracle connection
Posted by Jaime Stuardo at 6/30/2005 7:18:04 AM
Hi all... I have an Oracle Type connection whose connection string is only: data source=Pluton. I created a dataset with a query parameter, this way: SELECT NUMPOL FROM POLIZA WHERE NUMPOL = @NUMERO_POLIZA Here I have got some problems: 1.- The parameter wasn't created automaticall...more >>

Reporting Services vs. Crystal Reports
Posted by AJ at 6/30/2005 6:10:04 AM
Hi, can anyone tell me about the advantages of the techniq RS vs. crystal reports or any other tool. Thanx a lot. AJ...more >>

Index was out of range - depending on parameters.
Posted by pnp at 6/30/2005 5:31:05 AM
Hi, I have made a report, which seemed to work fine, but with some parameters it gives me the 'subject' error. The complete error description is: Processing Errors An unexpected error occurred in Report Processing. Index was out of range. Must be non-negative and less than the size of the ...more >>

Installation of Studio
Posted by Michael Vardinghus at 6/30/2005 12:00:00 AM
How come I cannot make any reporting projects ... when choosing new from the menu it seems as the report designer isn't installed but when checking installation settings in add / remove everything is installed - do I need to apply servicepacks ? ...more >>


DevelopmentNow Blog