all groups > sql server reporting services > november 2005 > threads for monday november 14
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
Subreport parameters
Posted by WayCool at 11/14/2005 11:59:30 PM
I am using a subreport that uses two GUID's (uniqueidentifier) as parameters.
The parameters are assigned in the parent report as "Fields!My_GUID.Value".
The subreport runs correctly outside the parent report with supplied
parameters. When I try to run the parent report, I get the error "The
exp... more >>
Add New Report Wizard fails
Posted by SAinCA at 11/14/2005 6:00:03 PM
I'm using the Developer version with SP1 and have had to reinstall because
the localhost Reports DBs were lost and there's no obvious way to get just
two empty DB's created...
So, after install, I can edit and deploy to local and Production. BUT: When
I use the "Add New Report" wizard i ge... more >>
Can I use 2 different stored procedure in a single report?
Posted by MissQti at 11/14/2005 3:31:03 PM
Can I use 2 different stored procedures in a single report with the same
dataset? How so?... more >>
Nested Lists and Printing
Posted by josef NO[at]SPAM wainz.net at 11/14/2005 2:14:23 PM
Is there something I need to do to get Nested Lists to print correctly?
When I preview the report, it displays correctly, grouped by Year,
Resource and Part. Yet when I print it or even print preview it,
instead of printing on one page:
Year 2005
Resource A
Part 1
Part 2
Part... more >>
Can't get reports to print
Posted by msmolarek NO[at]SPAM community.nospam at 11/14/2005 2:08:04 PM
Hello,
We have never been able to get the printing to work on any of our reports
using SQL Server Reporting Services SP2.
During the time we have been fighting to get this to work we had added on
the SP, so we totally rebuilt the machine from scratch, that didn't help. In
addition a cou... more >>
patindex that I can use in RS?
Posted by SharinDenver at 11/14/2005 1:09:03 PM
Basically, I am trying this in a table cell expression:
=iif(patindex('%-%', Fields!courseName.Value) <>
0,left(Fields!courseName.Value, patindex('%-%',
Fields!courseName.Value)-1),Fields!courseName.Value)
It errors because it says patindex is not declared. I tried doing this part
in m... more >>
Need help with report paramters.
Posted by Rob Edwards at 11/14/2005 1:01:20 PM
I have created a report that calls a stored procedure on Oracle using input
parameters. It runs fine with no problems. My client has asked that i
provide a list of available values for each parameter. For the first
parameter I query a second dataset to get a list of items. For the second
... more >>
Line graph on bar chart
Posted by bobfoc at 11/14/2005 11:34:02 AM
Does anyone know if it is possible to create a graph where a line is on top
of a bar chart?
I'm using reporting services 2000, cheers
bob
... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Ill try this again
Posted by Matt at 11/14/2005 11:33:58 AM
The 'when run' column of the report manager website is blank. the reports
have been run. i can also look in the ExecutionLog table of the reporting
database and it is properly reflecting the dates and times that a report is
run. it is not as important that i can see the times and dates run the... more >>
what this mean? First(Field!
Posted by Henry Chen at 11/14/2005 11:11:02 AM
and where can I find the reference. Please advise. Thanks!... more >>
Dataset Confusion in Reporting Services 2005
Posted by Amos Soma at 11/14/2005 11:05:18 AM
I'm creating a report that gets its data from a dataset returned from a
webservice call. I've supplied the URL for the webservice and in my Dataset
dialog (in Visual Studio), I've indicated the Comnand Type as 'Text' and my
Query String as follows:
<Query>
<SoapAction>Federation/GetAll<... more >>
HELP with Running value totals
Posted by Susan at 11/14/2005 10:44:08 AM
HI,
I have a table created. I need to have static fields.
The table has one group, where I use an IIF statement to point the values
into one of the three static fields. The reason I am using a table is that I
have to show months/loan programs with zero as well. The fixed static fields... more >>
RS Scripting utility does not work with Forms Authentication
Posted by Dawit T. at 11/14/2005 9:59:02 AM
We have successfully implemented Forms Authentication using Custom Security
Extension. It works fine except the RS Script Utility unable to deploy
reports either locally on the report server itself or remotely from
workstation.
I could not connect to the report server. The command I used: ... more >>
is VS2005 required for RS2005
Posted by chicagoclone at 11/14/2005 7:15:07 AM
Upgrading to Reporting Services 2005. Does Visual Studio also need to be
upgraded to 2005 or can I continue using VS20003?... more >>
Newbie Question accessing values in other data regions
Posted by cg at 11/14/2005 5:35:39 AM
Hi,
i have a simple report that has two data regions,
i want to use a calculated field in one data region that refers to a
field in the other region.
how do i achieve this?
sql server 2000 RS 2000
regards
... more >>
Integrating Analysis Services 2005 with Reporting Services 2005
Posted by Ralph Watermann at 11/14/2005 12:00:00 AM
Hi,
I found an article
"Integrating Analysis Services with Reporting Services"
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/RSDSetEx3.asp)
for SQL-Server 2000 saying:
"Reporting Services 2005 will also add support for server-side aggregates.
This featur... more >>
Use datasets from assemblies in reports
Posted by Ralph Watermann at 11/14/2005 12:00:00 AM
Hi,
is it possible to call a function inside an assembly that returns a dataset,
where normally a SQL or MDX statement is used to retrieve data for a report?
Ralph
... more >>
|