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 > december 2005 > threads for friday december 16

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

Format string
Posted by Techotsav at 12/16/2005 9:36:16 PM
Hii can somebody please tell me what format string i should use to bring 3 digits after decimal in any textbox. thanx in advance ...more >>


Book recommendations for an all encompassing SQL Server 2005 Reporting Services
Posted by Paul M via SQLMonster.com at 12/16/2005 3:52:57 PM
Out of all the books for SQL 2000 Reporting Services, I found Peter Blackburns book most helpful. Since he is not writing a Sql 2005 Reporting Services equivalent, can any make any recommendations for an RS 2005 book? -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums....more >>

impersonate="false" doesn't work for SRS 2005
Posted by Luke Plant at 12/16/2005 3:23:03 PM
We are using SRS 2005 via the web interface, and have found that if you set a datasource to use 'Windows Authentication (Integrated Security)' then SRS impersonates the user connecting. Changing the web.config for that VD to have 'impersonate="false"' doesn't change this. We need SQL Repor...more >>

Authentication hell report builder RS 2005
Posted by William N via SQLMonster.com at 12/16/2005 2:27:27 PM
I started playing with VS 2005 and SQL 2005 to try to get ready to migrate some of our apps. I ended up in authentication hell. I am trying to play with it on my XP machine before I do some real world stuff. I first tried the new report builder and was able to generate a data model and build...more >>

report builder... click-through to a standard report (not a report builder based report)?
Posted by Jéjé at 12/16/2005 10:49:13 AM
Hi, In the administration page of RS2005, I see that its possible to specify a target report for a click-through action. but, does this report can be a standard reporting services report? (not a report builder based report) if yes, how this report must be configured to allow this type of ...more >>

Passing Date as String
Posted by asnewbie+rs=argh at 12/16/2005 10:21:03 AM
I have a report that returns date in the format 'YYYY-MM-DD'. This report has no parameters, but I am drilling to another report that accepts date as a parameter. So, I select the textbox I want to drill from and select "Jump to Report". I select the report to be drilled to and define the p...more >>

Data Type - DateTime
Posted by Terry at 12/16/2005 10:09:02 AM
After adding four datetime related parameters, the following error is displayed when attempting to run the report. The first two datetime parameters causes no challenges until the third datetime parameter is added. An error occurred during local report processing. An error has occurred durin...more >>

SQL2005 report builder.... connect to a View?
Posted by Eric Pearson at 12/16/2005 9:07:03 AM
I created a view in my database and would like the report builder to work with it, but it doesn't give me the option. Is this possible? ...more >>



New Installation
Posted by FredG at 12/16/2005 8:31:03 AM
Windows 2003 Advanced Server SQL Server 2K sp3a There was an existing reporting services database on the SQL Server Instance. Tried to perform an new install of Reporting Services and point to this existing database, ReportServer DB. Installation was successful. However, RS would not activ...more >>

Formatting question
Posted by Chris Patten at 12/16/2005 8:10:02 AM
I want to show a parameter date minus 1 year, how can I do this? ="PERIOD MINUS 1 YEAR: " & Parameters!startdate.Value & " to " & Parameters!stopdate.Value...more >>

Report Builder
Posted by Paul at 12/16/2005 7:58:11 AM
How to create report with Matrix and Chart in a report using report builder? ...more >>

How can remove a row from my report if the results is empty or a n
Posted by victoras at 12/16/2005 7:38:03 AM
How can remove a row from my report if the results is empty or a null? If i have a null value , then i get a white space row in report - this is not looking good ! Can somebody help me, please !? Thank you!...more >>

using 2005 tools with older databases / views
Posted by Marzipan at 12/16/2005 6:15:03 AM
Can all 2005 tools be used against older (2000, 7) databases? If we don't have any SQL 2005 servers setup, can we still install the tools to our workstations? What CD would we use? Note: we have a select contract....more >>

Sybase OLEDB connection, stored procedure, does it work for anyone
Posted by LehrSJ at 12/16/2005 6:05:03 AM
Has anyone had any success using Sybase OLEDB drivers and stored procedures in reporting services? I am trying to use Reporting Services 2005 against a Sybase database using stored procedures. I've setup an OleDB connection. In the report developer on the data tab after I setup the datasou...more >>

Performance Issues
Posted by NO[at]SPAM at 12/16/2005 4:31:02 AM
We have a default install of sql 2005 with rs installed. When we try to do even the simplest reports they take an extraordinarily long time to render pages on fairly small sets of data. Whats steps do i need to go through to optimize a report to make it execute in a similar amount of time as ...more >>

SQL Report 2000 - Pagination ? - Urgent Please
Posted by Labhesh Shrimali - Bangalore at 12/16/2005 1:29:02 AM
Hi, I have one SQL 2000 Report. This is Audit Report. When this Report is rendered then whole data is rendered to the client. as one page. There are somewhere 500 Rows. I want this to be break in pages. How do I do Pagination over here. Please Help. waiting for this only.... Re...more >>

Not working after installing VS 2005
Posted by moondaddy at 12/16/2005 1:07:13 AM
I've been using SSRS in a .net wiforms 1.1 app for about 1 year now and all has been fine. Now I installed VS 2005 pro and I get an error when I try to deploy reports or try to call an existing report from the app. I didnt install sql server 2005 yet, only visual studio 2005. It seems that ...more >>


DevelopmentNow Blog