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 > august 2006 > threads for friday august 11

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

Suppress Paging (Page numbers)
Posted by Sudha Kashyap at 8/11/2006 10:31:05 PM
Hello, I want to suppress paging (page numbers) and have all the records display on a single page in a report. I am loading that report into a ReportViewer Control. Any ideas/suggestions would be appreciated. Thanks, SK ...more >>


RS2005 and SQL 2000
Posted by Tanmaya Kulkarni at 8/11/2006 6:39:24 PM
Hi, As per my reading, using RS2005 with backend database as SQL 2000 is possible. Can anyone tell me whether RS2005 connect to SQL 2000 database on same same machine. i.e. in short can RS2005 reside with SQL 2000? Which edition of RS 2005 support backend as SQL2000? TIA, Tanmaya ...more >>

"Can't execute code from a freed script" + double toolbar when AsynchRendering=True and toggle items on page
Posted by Pete D at 8/11/2006 5:38:19 PM
Hi, I have an ASP.NET web app which uses the ReportViewer control to render a table report, with toggle items to show/hide groups of rows within the table, each row allowing users to drill (via Jump to url) to a subreport. I have AsynchRendering=True, and drilling to the subreport works fi...more >>

how to bypass report size limitation
Posted by how to bypass report size limitation at 8/11/2006 1:52:02 PM
I want to build a super long report that is organized by a train of rectangles, and one rectangle follows another. Each rectangle has a page break at end, so the report can be rendered in many pages, one rectangle falls in one page. The problem is the size limit of a report is 160 inches. T...more >>

reportbuilder button not appearing
Posted by bharath at 8/11/2006 11:48:32 AM
Hi Everyone, I am not getting the reportbuilder button on the toolbar in report server portal. I have implemented forms security on the reporting services instance. Can anyone please help me solve this problem? Thanks in advance, Bharath ...more >>

SQL 2005 SP2 (Reporting Services)?
Posted by Tony at 8/11/2006 11:42:02 AM
Has anyone heard anything about a service pack 2 for SQL Server 2005? I have seen many places that state that Microsoft is going to include some frequently requested items on the Reporting Services wish list. I was just wondering what the time frame for this was. Thanks in advance....more >>

Dealing with Temp Tables from Access to SQL Reporting
Posted by bjkaledas at 8/11/2006 10:45:01 AM
Hi guys. I have a bunch of Access databases that we used multiple Append queries to create local tables in the Access database and then create a report within Access from this data. I am converting these Access databases to SQL 2005 and SQL Reporting Services. So far I have been importing t...more >>

Cannot Initialize Report Server
Posted by zinck74 at 8/11/2006 9:16:25 AM
Hi, Trying to initialize a new instance of Reporting Services on SQL Server 2005. I've setup every part of it up to the Initialization. When I click on initialization I get the below error. I've checked the services on the machine and the RPC service is certainly running as is the Report Ser...more >>



Report Builder field calculate problem
Posted by Guillermo at 8/11/2006 8:48:02 AM
Hi, I have a problems with the field calculations. NOT Work. When i tried calculate total sales for a specific store, this duplicate or 3, 4, 5 times the total sales....more >>

problem concatenating text to a field value
Posted by Dan D. at 8/11/2006 6:09:01 AM
Using SS2000, VS2003, RS2000. I want to put some text like "Totals for Enterprise " in front of the Enterprise number in a group row. I have one that works and one that I get an error ("#Error") on. The one that works is this: ="Total " + Fields!Item.Value. The one that doesn't work is th...more >>

is this possible in RS?
Posted by Dan D. at 8/11/2006 5:21:01 AM
Using SS2000, VS2003, RS2000. The report lists branches and the companies they have mailed to. The company mailed to could have received one of three offers. I need to get a count of how many companies were mailed to by each branch and how many of each offer was mailed for each branch. The cl...more >>

Business Inteligence Reports
Posted by Mark Stephenson at 8/11/2006 2:57:02 AM
Hi, I am writing a report in Studio .net 2003, and have created a prompt which contains regions, obviously the drop down only allows me to select 1 item at a time, or I can use a union to select all records. Is there any way that I can select more than one item from a drop down without t...more >>

Report parameter won't show values with stored procedure results
Posted by Winkles at 8/11/2006 12:00:00 AM
Hi, I wrote a stored procedure in C# to return results that I could use to populate a report parameter list. The problem occurs when I set up the parameter. Under "Report Parameters -> Available Values -> From Query", I can set the dataset fine but no entries appear under the Value field...more >>


DevelopmentNow Blog