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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|