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 > march 2006 > threads for monday march 13

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

RS 2000 - Problem with percentage graphs
Posted by Simon Dingley at 3/13/2006 9:04:38 PM
I am using VS2003 .Net & RS2000 Just wondered if someone could help. I am relatively inexperienced with anything remotely complex in Reporting Services and need to generate a graph that displays my data as percentages. My simple query returns the following data collected from a questionnai...more >>


Reporting Services Install Error
Posted by Che J at 3/13/2006 6:40:39 PM
I am tyring to install SQL 2000 Reporting services on a 2003 Server. I have installed IIS, asp.net, VS .net 2003, etc. I installed service packs 3, and 4. I have not noticed the upgrade re: the versions. When I attempt to install Reporting Services, I keep getting the error the the server requir...more >>

SSL non-default website; non-default port
Posted by no.email NO[at]SPAM hotmail.com at 3/13/2006 5:20:17 PM
Hi everybody, Bit of a tricky question... I'm running RS2K on IIS 6.0 in a nondefault website which I've secured with a certificate. There is already one website with SSL on the server, hence, because of the limitation in the TLS stack, this website runs on port 563, which is also a well...more >>

Easy Newbie reporting services question
Posted by mzwilli at 3/13/2006 4:46:22 PM
I'd like to learn more about what I can put in expressions. For example: Fields!<FieldName>.Value.Length Is very useful. I found it on this user group but could not find it in the documentation (online books). The expression painter does not seem to be much help. Where can I find more i...more >>

One database item per page Reporting Services
Posted by randy1200 at 3/13/2006 2:41:12 PM
I'm creating Reporting Services reports in Visual Studio. I create a new report, and see the Data, Layout, and Preview tabs. In the data tab, I say: "select name from mytable". Four names are returned. I'd like to display one name per page. I posted this question a few days ago. The folks ...more >>

dynamic resizing of chart in IE window
Posted by mark.feferman NO[at]SPAM gmail.com at 3/13/2006 1:59:29 PM
I've got an ASPX page with four iFrames defined (soft of like a dashboard). Each one of the IFrames' source is set to another ASPX page that only contains a ReportViewer control. I am trying to make it so that when user dynamically sizes the main (encompassing) window, it resizes everything ...more >>

Unable to Connect to Remote Server
Posted by michelle at 3/13/2006 12:01:36 PM
This worked for quite some time but now it is not and we can't find anything that has changed. We can browse to /ReportServer and get to the folders and generate the reports but if we try to navigate to /Reports/Pages/Folder.aspx We get a red X Error and Unable to connect to the remote server. ...more >>

Repeating Footer on every page when printing
Posted by capricorn at 3/13/2006 11:00:29 AM
Using RS2005, but the same thing happened on RS2000. This report has 4 matrices and 4 charts which causes the report to print on 3 pages of 11in by 8.5in paper (landscape). I have a Footer that references a textbox in the body of the report, but when the report is printed, the footer only a...more >>



index out of range error
Posted by Zim at 3/13/2006 9:40:29 AM
I have two almost identical reports deployed to report manager, the only difference is sort order. They both are viewable but when I try to export to pdf, I get the following error on my new report. Anyone know why? ********************************************************* Exception of type ...more >>

Anybody knows the syntax? Thanks
Posted by Henry Chen at 3/13/2006 9:23:28 AM
declare @lastmonth char(7) select comment from tbldescription where themonth = code.getlastmonth() <----- syntax wrong getlastmonth() is a function returning last month in form like '2006.02' Anybody knows the right syntax, please email me back. Thanks! ...more >>

Performance of RS email delivery VS .NET code email with SMTP
Posted by Tony at 3/13/2006 8:25:21 AM
Hi, I have 2 options of implementing sending data drivent email to customers, one is coding .NET with SMTP, the other is using RS data driven subscription with email delivery. My question is, comparing to .NET code by building email body using StringBuilder, how is the performance of RS, by...more >>

Unable to generate a temporary class
Posted by DLS at 3/13/2006 7:47:27 AM
I am unable to browse reports and get this error: Unable to generate a temporary class (result=1). error CS2001: Source file 'C:\WINDOWS\TEMP\scjiuftj.0.cs' could not be found error CS2008: No inputs specified Any suggestions?...more >>

limit parameters
Posted by bevarg at 3/13/2006 6:45:28 AM
is there anyway to limit the date ranges that a user can enter? my reports have a start date and end date as parameters and I would like to limit the date range to 6 months so that a user cannot enter a huge date range or something and slow down the database. ...more >>

Assembly permissions for accessing db
Posted by Tur at 3/13/2006 2:33:12 AM
Hi there, I need to know how to set permissions for my assembly, since it has to access a db and without permissions I could not distribute it... Can somebody explain it in a breath, please? ...more >>

WebServiceAccount Error running RS 2005 on SQL Server 2000
Posted by RSRob at 3/13/2006 2:23:27 AM
I started with a fresh Win 2000 server, and installed SQL Server 2000. That is set up and running fine. I then installed RS 2005 from the CD and everything appeared to go fine. Once installed, i loaded up the Reporting Services Configuration Manager and proceded to set everything up. I managed...more >>

Export list in Reporting services
Posted by Peter Berglund at 3/13/2006 1:46:27 AM
Is it possíble (and in that case, how) to edit the Export list so some choices dont show (say for example, I only wanna let them convert to pdf and excel) and also, to have 1 of the choices (in this case, pdf) to be default in the list and not "Select a format" as it is today. this when ac...more >>


DevelopmentNow Blog