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 > july 2006 > threads for tuesday july 25

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

Authentication issue with report called from VB.Net application
Posted by Kevin O'Donovan at 7/25/2006 5:07:23 PM
Hi, I've written an application in VB.Net 2005. One of its requirements is to display a report which is hosted on our report server, and to let people subscribe to this report (to get a copy once a week by email, for example). To do this I have created a windows form containing a web browser ...more >>


Subreports on the report server
Posted by Ben Watts at 7/25/2006 4:45:52 PM
I havent worked alot with subreports so I have this question pertaining to subreports showing up on the report server with the regular report. Do they have to be on there and if so can they be hidden. Anything that might help will be greatly appreciated. ...more >>

formatting issures using tables and mutiple matrixes
Posted by cr at 7/25/2006 12:25:02 PM
Hi. I have a report that pulls all info from a single dataset. However, one field "type" contains either "a" or "b". I have two matrixes, One for the description and count of type a and another for type b. I also have data from the dataset that needs to be both before and after each matrix. ...more >>

Prints extra pages
Posted by Candy at 7/25/2006 12:01:02 PM
I have a report that shows 1 page of 1 page in the browser, however when I print (or do a print preview), it shows page 1 of 6 pages and prints 5 pages at the end with only the header information. All of my objects are within my margins. Any help would be greatly appreciated. -- Thanks!...more >>

Error: [rsMissingDataSetName] The data set name is missing in the data region ‘DataSetName’
Posted by Kevin at 7/25/2006 11:49:22 AM
This error occured under the following circumstances: 1. Had an existing report that was working with 1 DataSet. 2. Added 1 new Dataset with the same data source as the existing Dataset. Query was very simple: Select * from TableA. 3. Tested Query. Returned correct results. 4. Selected Pre...more >>

Blank page at the end when printing
Posted by KC at 7/25/2006 10:21:01 AM
I am using RS2000 SP2, and I have created a simple report. Everything looks fine on the screen, but when I print it, it always prints out a blank page at the end. For example, on the screen the report has 10 pages. When I print the report, it has 11 pages (with the last page only containing th...more >>

Querying Active Directory in RS
Posted by Todd C at 7/25/2006 9:39:01 AM
I am looking for a way to use our Win 2003 Active Directory as a DataSource in RS2005. I set up the Connection properties (correctly, I think) using OLE DB Provider for Microsoft Directory Services, and supplied the Server and Location (<myDomain.com>). The "Test Connection" responds with "Tes...more >>

percent in diagramms
Posted by florian at 7/25/2006 8:45:00 AM
Hi, http://www.stammer.at/sql/sql.html under this email adress you'll find a picture of 2 reports containing bars. My diagramm shows a qustion with up to 5 possible answers. when I display just one question my diagramm works fine. I just like the diagramm to go up to 100% and not end w...more >>



datediff
Posted by florian at 7/25/2006 8:14:09 AM
Hi, I'd like to calculate the days between 2 dates (data type:datetime). unfortunately all I get in the preview report is #error and nothing else. the 2 used date fields work when used seperately. =DateDiff("day", Max(Fields!Date.Value), Min(Fields!Date.Value)) thanks! ...more >>

Parameters: How do you display the Label field, not the Value field?
Posted by Dave at 7/25/2006 8:00:02 AM
Report Parameter EmployeeId is based on a dataset Employees with Value field emp_id and Label field FullName. A user will choose one row from this listbox and the report is then generated. I figured out how to display the emp_id on the report using: =Parameters!EmployeeId.Value But how do I di...more >>

Add dynamically series in Dundas chart
Posted by vladsm NO[at]SPAM rambler.ru at 7/25/2006 7:57:51 AM
Hi! Does anybody know how to add dynamically at run-time a new series in Dundas chart and bind it to the data in dataset? For example, I have the following dataset: LineType PoinNo PointX PointY 1 1 10 20 1 2 15 ...more >>


DevelopmentNow Blog