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 > january 2005 > threads for tuesday january 4

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

Book recommendation
Posted by collie at 1/4/2005 11:29:02 PM
Hi, I am not sure which book to buy: Hitchhiker's Guide to SQL Server 2000 Reporting Services or Professional SQL Server Reporting Services -- by Paul Turley I need a book that will also show me for example how to pass parameters from asp.net to rss. I want the user to select parameters...more >>

URL Parameter and Default Values
Posted by Michael McCallum at 1/4/2005 10:52:02 PM
I need to ability to pass a parameter (a session variable) on the URL that will drive the content of parameters used for lookups. An example is that a person may be limited to only two districts out of 10, so for that person I only want the two districts show in the drop down list in the para...more >>

Matrix row total
Posted by John Geddes at 1/4/2005 8:56:25 PM
I have a count(field!orderstamp.Value) in a field and I would like to show the percentage that number is of the whole row? I can add a column next to it, but how do I show a percentage of a row in a matrix? Thanks. ...more >>

Report Moving Script
Posted by Scott Meddows at 1/4/2005 4:54:14 PM
Does anyone have a script that they would like to share that would move some directory and it's tree from one server to another? Thanks! Scott ...more >>

Creating a group at run-time
Posted by Matt at 1/4/2005 4:05:07 PM
I have a request for a report to allow the user to render the output grouped by start of last name (A's, B's, C's, etc) and have each group print on its own page. This action would be controlled from a report parameter ideally and the user would be able to toggle from normal output to this gr...more >>

Report wont render
Posted by sfibich at 1/4/2005 2:49:22 PM
I am having an issue with a particular report not rendering when displaying in the web browser from reporting services web site. The report never displays and if you check under site settings the job is showing that it is in an Action of "Render". Has anyone else ever seen this? Is there...more >>

same data set, different parameters
Posted by Ben Sullins at 1/4/2005 2:23:02 PM
greetings... I have a stored proc that returns results based on startdate and enddate parameters. I have a report that has a matrix on it which needs to show totals for the previous day, month to date, and 3 previous months. To get the data all that is required is for me to run the same pro...more >>

file share subscription problem
Posted by dcp12345678 NO[at]SPAM yahoo.com at 1/4/2005 1:53:54 PM
I've setup a file share subscription to render a report to an AS/400 file system, but it is failing with Logon failure: unknown user name or bad password ---> System.Runtime.InteropServices.COMException (0x8007052E): I'm supplying the correct username and password to access the directory, and...more >>



If...Then Statement in Table
Posted by sbaker at 1/4/2005 12:55:07 PM
I am new to using Reporting services and was wondering if it is possible to use if...then statements within a table. Ultimatley, I would like to build a table that displays prior day sales, current month, current quarter, and current year sales. Any suggestions? Thanks, Scott...more >>

I can't get ANY query with Report Builder to work!!
Posted by trint at 1/4/2005 11:37:47 AM
I don't want to use a stored procedure, or do I have to? I can't get any of my querying (whether from a dropdown or not) to do anything other than display entire table...I'm creating report from report wizard. Help IS appreciated. Trint ...more >>

Average of average in SP2
Posted by Gavin Pollock at 1/4/2005 11:37:00 AM
Does anyone know if we are expecting this to be included in Service Pack 2 at all? Cheers Gavin ...more >>

Letter Templates query
Posted by Daniel Williams at 1/4/2005 11:29:18 AM
It seems that letter templates are based on a simple query to PROJ. Does anyone know if I can change that underlying query to get more data for a template? Thanks, Daniel Williams ...more >>

Linked reports in ReportManager
Posted by Christian Nordbakk at 1/4/2005 10:47:46 AM
Hi, I'm trying to link a number of reports that represents different drill levels (reporting off a AS cube), that I had to split up for performance reasons. My problem is that when clicking a link you are navigated out of Report Manager, and so loose a lot of navigational control, plus that...more >>

printing
Posted by Servé La at 1/4/2005 10:43:39 AM
It is my understanding that after installing SP1 you get a print button on the toolbar next to refresh and help. However, it doesnt show and I'm certain that SP1 is installed because javascript in hyperlinks does work now. What could be wrong there? ...more >>

Why does "Query Command Type" have to be "Stored Procedure"?
Posted by trint at 1/4/2005 10:04:26 AM
I have created a report that lists all contents of table but needs to do query on certain records...why can't Report Designer create the ability to do queries without stored procedures? Or can it? Help is appreciated. Thanks, Trint ...more >>

Server Behind SSL Firewall
Posted by beanmasher at 1/4/2005 9:35:02 AM
Have server with Standard Edition Reporting Services, SQL Server Standard Edition 2000, and portal application that uses ReportViewer. This is located behind a firewall and must be accessed via https://some.domain.com/app. SSL is not enable on the Server but on a content switch. How sho...more >>

Failure Parsing The Config File
Posted by Help Me Rhonda at 1/4/2005 8:41:05 AM
I am trying to execute the rsactivate file and I am recieving the following error: "Failure parsing the config file. Invalid URI: The hostname could not be parsed." What could be causing this and what is the solution? Thank you in advance. ...more >>

Repeating report
Posted by TheRSBeginner at 1/4/2005 8:11:11 AM
I want to do the following with RS: I have a invoice that I want to print three times and at the end of the report I want to print a letter refering the invoices. I could do that making 2 reports, calling the first with three copies for the invoices and the second report would be the letter. ...more >>

Format question of text concatenation
Posted by Sally at 1/4/2005 6:51:02 AM
I have a text like this '*'& Field!Item.Value. I would like to highlight the asterisk '*' as red color and bold in order to make the end user notice it easier. How can I do it? Thanks for your help. ...more >>

using url to query?
Posted by trint at 1/4/2005 4:47:46 AM
Ok, I have created a report that is very simple. SELECT DealerNumber, OrderNumber, ProdNum, QtyOrd, FromDealerNumber, OrderDate, Amount, Type, SalesManagerOrganization, DistributerOrganization FROM TravMasNew Here is the url that shows the report: http://localhost/ReportServer?...more >>


DevelopmentNow Blog