Filter by week: 1 2 3 4 5
SOAP Client Requests & Responses
Posted by Don Miller at 9/30/2007 12:29:34 PM
Although MS says over and over that RS can be used via SOAP web services
(not URL Access) with any SOAP-capable application to execute and return
rendered reports, I've searched for hours trying to find even one example
where a non-.NET application (like VB6 or Classic ASP) constructs a comple...more >>
Displaying data in Columns based on Criteria
Posted by Charles Allen at 9/30/2007 7:20:00 AM
I have data in rows that I want to display in columns based on a value in
Here's an example of the data:
Employee ID Type Code Amount
123 PAY BONUS 1,000
123 PAY SALARY 5,0...more >>
Stuck on Drill Downs, please help.
Posted by BLAW at 9/30/2007 12:00:00 AM
I have two reports that I created, one using the wizard which simply
has some Account Name, Parent Account and Opportunity Revenue. I'll
call this the Report #1. I want a user to be able to click one of the
Account Names and have it open a second report that lists details on
the opportunity. I'l...more >>
Table/Group Filter (by DateTime field) - Nothing works in the Filter tab?
Posted by Andrew Backer at 9/29/2007 9:13:34 PM
I am trying to create a filter on the data used in a table. This table has
NO other groups, is only one level, etc. Very simple. I get to the 'Filter'
tab by right clicking on the detail row and selecting 'Edit Group', and chosing
the 'Filter tab'.
I have a DateTime field that I...more >>
Posted by awakin at 9/28/2007 7:17:42 PM
I trying to build an SQL statement that includes the last twelve
months in the report. When I use the DATEADD function ie >=
DATEADD(MM, - 12, GETDATE())) the report brings back data 12 months
from the current date. I would like to include the whole month not
just the current ...more >>
Multiple Tables Inside a List
Posted by Chris Durkin at 9/28/2007 4:30:23 PM
I have 3 tables inside a list, all of which use the same dataset. The
layout is something like this:
The List has a group defined on it, lets assume the grouped column is
named Entity. What I want when the report renders is this:
Table1 for Entity...more >>
Access denied and no files...
Posted by Bradley Morris at 9/28/2007 2:10:02 PM
I performed an install of SSRS and SharePoint as noted in this document...
....with one exception I installed everything (SQL Se...more >>
referencing value in subreport in calculated field on parent
Posted by roy NO[at]SPAM mgk.com at 9/28/2007 12:51:09 PM
I wish to reference the value in a subreport in a calculated field
this subreport has one txtbox, no grid or any other objects.
is this possible?
what is the syntax...??
Don't see what you're looking for? Search DevelopmentNow.com.
ReportOnNewPage not working as expected.
Posted by AndyG at 9/28/2007 9:59:02 AM
I have a simple reporting services 2005 report with just a body section which
contains a table control with the following rows
table header (RepeatOnNewPage = false)
group header (RepeatOnNewPage = true)
group footer (RepeatOnNewPage = false)
table footer (RepeatOnNewPage = f...more >>
URL Access Security
Posted by Don Miller at 9/28/2007 7:18:18 AM
After suggestions from this newsgroup, I would like to use URL access to
render reports to PDF from my web application. My web application (classic
ASP 3.0) is secured by custom authentification (not Windows auth) so no
single page cannot be accessed without signing on first, and every single ...more >>
SSRS Events scheduling
Posted by Jan at 9/28/2007 1:48:01 AM
I noticed that Reporting Services is running every 20 sec a stored proc
GetMyRunningJobs, and every 10 sec queries and updates in the Event and
Notification tables in the ReportServer database. I suppose for subscriptions.
Is there any way to desactivate this if no subscriptions are us...more >>
input parameter in MS SQL 2005 report
Posted by -Hillary at 9/28/2007 12:00:00 AM
I am designing a report which need to take parameter input by user when the
report is open. Can anyone please tell me how to do this? Using MS SQL 2005
Best place for job posting?
Posted by Bob Murdoch at 9/27/2007 11:08:27 PM
We are looking to place a job posting for a developer experienced in SSIS
and SSRS. Are there any recommendations for the best place to post the job
Percentages of subtotals
Posted by Fresno Bob at 9/27/2007 10:00:25 PM
I have a matrix report with subtotals on the end of each row. I want to put
in brackets the percentage of the subtotal that each value is in the row. I
am not sure how to do this. Does anyone have any ideas?
ReportViewer control and multivalue parameter
Posted by Gilgamesh at 9/27/2007 7:00:57 PM
I'm using the control on an asp.net page. The first parameter is a multi
value field which is populated by a query. How can I programaicattly select
the first value as a default? I don't see anything in ReportParameter class
that can do that.
Reporting Services Configuration Initialization - Green or Gray
Posted by Rodo at 9/27/2007 3:55:43 PM
OS: WIN2K3, SQL: 2005 Standard. SP2 - All installs
On my production server, using the Reporting Services Configuration Manager
I'm able to get Reporting service to work OK. I check this by opening a
browser and going to http://<servername>/reports.
My problem is that although Initialization...more >>
Change Default Filename with Export?
Posted by Don Miller at 9/27/2007 12:10:55 PM
When I use URL Access to render a report with specified parameters and a
format (e.g. PDF), when I choose "Save" (instead of Open) the default
filename is listed as "ThisReportName.pdf". I need to have the "Save As"
name to be very specific (e.g. include the date and the customer ID, like
Multiple Database Parameter
Posted by Ryan Mcbee at 9/27/2007 10:46:02 AM
I have a report that works well, but would like to run it for other
databases. How would I go about this? Could I create some sort of parameter
in the report to call upon a different db?
Hiding SQL Server Reporting Services Header
Posted by nkg at 9/27/2007 10:35:39 AM
we published some reports and want to give user access to these via report
manager UI to Certain Folders.
Is it possible to hide the header which display SQL Server Reporting
Services, Home, My Subscriptions etc.?
data value split
Posted by aajay78 NO[at]SPAM hotmail.com at 9/27/2007 9:44:57 AM
I have data like
I would like to display
if data has | then display it in two text box
like Textbox1 Return
if data does not have | then displ...more >>
Trying to setup cluster - Report Server database format is not val
Posted by isabelle at 9/27/2007 9:26:04 AM
We have a 2 node cluster and realized when we were testing failover that
reporting services was not installed on our 2nd node. So I tried to run the
SQL 2005 install and got the message "Edition Change Check - Warning. To
change an existing instance of SQL 2005 to a different edition, y...more >>
No Fields in Page Header (and Footers)???
Posted by Don Miller at 9/27/2007 12:00:00 AM
I'm a newbie with SSRS and I'd like to place a customer's name in the Page
Header section so that the customer's name (and ID number, and addresss)
appear at the top of every page in the right upper corner. But when I try to
put a field in the Page Header I get "Fields cannot be used in page h...more >>
Problem with keeptogether
Posted by Lorenz Ingold at 9/27/2007 12:00:00 AM
In a report I have a table with 3 detail lines. The property 'keeptogether'
is set to true. However, if I call the report in IE and then export it to
pdf, the detail region can be splitted: The first detail line is at the end
of a page and the next 2 lines (of the same record) are on the next ...more >>
how to setting report viewer to view exactly as VS preview
Posted by gmi at 9/27/2007 12:00:00 AM
hi all..I'm new here and got a problem, and i hope you guys can help me.
I want to create one card , size : height =2.25, width =4.5 and it should be
on 2 page because I want to make it front and back.
i 'm using rectangle and textbox, and i set the page break after first
Reporting Services and ASP 3.0?
Posted by Don Miller at 9/26/2007 6:51:03 PM
I currently use Crystal Reports RDC that is called from an ASP 3.0 page
(actually, the ASP page calls my custom VB COM+ code which then calls then
RDC), supplies a CustomerID as a parameter to generate a report (e.g. on one
customer) that is then exported as a PDF file and saved to the filesys...more >>
Could not establish trust relationship with remote server.
Posted by vbchewie at 9/26/2007 4:48:00 PM
I am trying to setup SQL Server 2000 Reporting services with an SSL
connection. The SQL Server (Windows Server 2003 SP2 Standard) and Reporting
Server (Windows Server 2003 R2 SP2 Standard) are on separate machines. I
have tried setting up Certificates from both and Stand-Alone and Enterprise...more >>
Stupid SUM question
Posted by Carl Henthorn at 9/26/2007 3:16:01 PM
I have a table with one GROUP row in it. It is supposed to show results of
who is a preferred vendor vs non-preferred vendor, sales amounts for the
group, and their percentage of the whole. It shuld look like this:
Vendor Sales percentage
Preferred $9,000.00...more >>
NULL values - finding an alternative to the IIF statement
Posted by roy NO[at]SPAM mgk.com at 9/26/2007 12:10:05 PM
since the IIF statement evaluates both the true and false conditions
regardless... I need to find a replacement to it...
my code is:
=IIF(Fields!SOURCE_TRANSACTION_KEY.Value = nothing, "", Fields!
I get the #ERROR value in my report ...more >>
Posted by Davin at 9/26/2007 11:36:11 AM
Anyone have any suggestions on how I can go about getting Reporting Services
Reports(about 2000 pages) printed by a 3rd party printshop? PDF export etc...more >>
Posted by Gary L at 9/26/2007 8:54:04 AM
I'm new to reports so please bear with me. I'm attempting to embed a
subreport which uses a parameter that should be passed from the main report.
Both reports work fine individually, but when I attempt to run the one with
the subreport, my subreport is blank. I read somewhere on-line someth...more >>
Start and End Date Parameters - How To Implement?
Posted by zgall1 at 9/26/2007 7:45:39 AM
I have a dataset that is made up of timesheet entries. Each entry has an associated date. These timesheet entries form a project accounting report that shows how many hours were worked on the project and how many hours were billed. I would like to filter the report so that only the timesheet entries...more >>
datasource connection error
Posted by arkiboys2 at 9/26/2007 6:08:03 AM
have developed a report on a test windows server machine in SSRS 2005 which
I can access from i./e. http://localhost/reports
DataSourcce is accessed using a sql login
My colleague on his machine can not access. His error is:
An error has occurred during report processing. (rsProcessingAb...more >>
Enumerate/list data sources and their connection strings
Posted by J. Peter Kuck at 9/26/2007 3:32:02 AM
I was wondering ..
Is there an easy way to enumerate all data sources and their configuration
parameters (e.g. connection strings) in a reporting services database ?
Thanks a bunch....more >>
0x8007F303 Error Printing From ReportViewer Web Control
Posted by Andrew Hayes at 9/26/2007 12:38:02 AM
My C#.NET 2.0 web application uses the ReportViewer control on a popup ASPX
page for print previewing the user selected report.
If the user then clicks the Print icon, it prints the first page of the
report then pops up a dialog with "An error occured during printing.
Can't deploy from local machine
Posted by Fresno Bob at 9/25/2007 8:47:11 PM
Can anyone help me. I work in a workgroup environment as opposed to domain
controlled. The minute I do anything with reporting services or analysis
services that is between machines I get problems.
I can't deploy to SSAS or SSRS from my machine unless I log into my machine
with a username a...more >>
Show All ?
Posted by GGill at 9/25/2007 2:40:00 PM
In my first table properties i have expression in visibility tab is this
In my second table properties i have expression in visibility tab is this
So if i check in parameter 'A' then it will show me ...more >>
Proplem w/Default Value for Parameter
Posted by Dean at 9/25/2007 2:26:40 PM
I have a Parameter with 2 non-queried choices, Yes and No. I set the default
to No. When the report displays, instead of the default value displaying in
the dropdown, the users are being forced to choose. any ideas what would
cause this or how to fix?
Cannot Delete Report
Posted by davestub NO[at]SPAM gmail.com at 9/25/2007 2:13:27 PM
I have been using Reporting Services 2000 for a couple of years with
no issues. Now have verion 2005 installed and building some reports. I
created a report that no longer want and when I went to delete it by
"showing details", selecting the correct checkbox and clicking delete,
I am prompted to...more >>
Rich Textbox Value in Reporting Services Report
Posted by jkposey NO[at]SPAM gmail.com at 9/25/2007 12:49:51 PM
I am looking to create a a report that displays a value that has been
saved to a database using a rich text box (Infragistics
WebHtmlEditor). The database (SQL server) value is a string that
contains HTML markup (ex: <strong>test</strong>). Is it possible for
reporting services to parse this ...more >>
How to close the blank page which is opening when clicked on export !
Posted by appu at 9/25/2007 12:16:39 PM
I tried to export my report to Excel and PDF, it is exporting
But it leaves a page opened, which was opened when I clicked on Export
How to close that page?
Is there any setting available for it?
Or else how to close it using C#.Net code?
Any help is appriciated.
Project accounting report problems
Posted by Zack at 9/25/2007 11:56:02 AM
I've been trying to create a project accounting report whereby for each
project, I can see the project broken down into cost category classes and
then cost categories. For each class (rollup of the categories) and category,
the report should display the budgeted hours, budgeted fees, actual ho...more >>
Exporting to HTML
Posted by Katit at 9/25/2007 8:57:23 AM
My client wants to send reports as emails. They don't want' PDF
attachement. HTML seem to be the best way for that.
I'm using Microsoft.Reporting.WinForms
I can't seem to find any other formats then Excel or PDF. But
Microsoft reporting does reports for web as...more >>
Microsoft help!!! Trying to send reports via email using RS2000
Posted by OriginalStealth at 9/25/2007 8:24:00 AM
I keep getting these errorrs. I am using RS 2000. What does this mean and
how do I fix this issue?
2007-09-25 11:00:25 - +  Schedule 143 has already been cached by job
2007-09-25 11:01:02 - +  Internal request (from SetJobNextRunDate
[reason: ...more >>
hide a column in a matrix
Posted by Stephanie at 9/25/2007 8:12:04 AM
How can I hide a column in a matrix? I set the visibility of the column that
I want hidden to True but it still reserves that space in the report. I want
the hidden column to take up no space.
File share subscription
Posted by Herman K at 9/25/2007 6:12:03 AM
I have a report server in domain â€˜Aâ€™ that through a data driven subscription
tries to write to a UNC in domain â€˜Bâ€™. In â€˜Step 4â€™ of the â€˜Create a data
driven subscriptionâ€™ wizard, you are asked to provide a username and
password. If I supply domain credentials from domain A (A...more >>
Problem viewing report based on analysis services
Posted by Fresno Bob at 9/25/2007 12:57:18 AM
I am using using some code which Implements IReportServerCredentials (see
the object below) to pass credentials to a non local report server. This
works fine and my reportviewer can get it's report from a non local server.
When the report uses Analysis Services it displays the parameters part...more >>
drill down jumping problems?
Posted by Rohit Peyyeti at 9/25/2007 12:00:00 AM
I have asp.net code in which I am calling report using ReportViewer control
in VS2005. The problem is that when ever I click on the drill down in the
report, the report page jumps and aligns itself to top of the window and
because of this the tabs (in our application) disappear (hidde...more >>
4 days and still can't get my report to depoly (help)...
Posted by trint at 9/24/2007 9:08:26 PM
I have had a great deal of success in the past on other systems with
BUT now, to save my life, I haven't been able to get the first report
to deploy. I get these
A connection could not be made to the report server http://###.###.##.###/reportserver.
Additional i...more >>
Grey out Parameter
Posted by OogleGoogle at 9/24/2007 7:09:37 PM
Hi I have three parameters,
First is a string, called DateFilter, with On and Off available
Second and third are date, Start and End Date
I want to grey out the Start and End Date filter if the DateFilter is
OFF... Is this possible?
Thanks in advance for your help~
Posted by JTL at 9/24/2007 12:18:56 PM
does anyone know if it is possible to add a filter to a report that is
passed as a user-defined parameter? i know i can do this by modifying the
sql that generates the report, but i'd like to do this inside of the report
so as to not hit the database each time the user selects a different fil...more >>