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 > may 2006 > threads for tuesday may 30

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

OLEdb Issue
Posted by john doe at 5/30/2006 2:01:38 PM
I am getting the following error: Error 2 An attempt has been made to use a data extension 'OLEDB' that is not registered for this report server. C:\Documents and Settings\Administrator.WILLCARE\My Documents\Visual Studio 2005\Projects\Willcare\Willcare\Report2.rdl 0 0 I am trying to des...more >>

&rs:Parameters=false not working if redering reports in a iframe;
Posted by TomKang2000 at 5/30/2006 12:11:01 PM
Hi, I have problem with &rs:Parameters=false it's not working if reports in a iframe; same url working well on a normal page; any trick? here is my url: http://localhost/ReportServer?/BASE/Opened Incidents By Severity - Chart and Graph&rs%3aCommand=Render&rs%3aformat=HTML4.0&rc%3aParameters=...more >>

Customizing Report Parameter control; handling "available values" collection.
Posted by Benjamin Chan at 5/30/2006 10:43:25 AM
I have a report that I show a bill of material based on a selected parent. I have about 17,000 parents to select from. When I use "available values from query" the current behavior on the report is a drop down box where I can choose between all 17,000 where at least for large collections I'd...more >>

Bottom half of Page Not Found
Posted by Phillip at 5/30/2006 10:05:02 AM
I have RS2k on SQL2k for several months with no issues, all users can access reports for which they have been granted access. I have one new user lately that has not been able to access a report that he has been granted access to. He clicks the link to the report server http://servername.d...more >>

2 Tables and 2 Datasets in a report
Posted by vamsi at 5/30/2006 9:20:26 AM
Hi I am having 2 Tables and 2 Datasets in the report and depending up on the Report parameter value either of the dataset should execute and the data should be displayed in the related tables and other table should not be seen. Is it possible to do in this way??? Thanks ...more >>

SQL reporting best pratice
Posted by Jean-Philippe Breton at 5/30/2006 7:08:42 AM
We are starting to have a lot of reporting services servers : MOM, CRM, Project Server. I was wondering if I could use a single Reporting Server to host all my product instead of having 3 reporting server. Thanks for any help. Jean-Philippe ...more >>

Render method - the operation has timed-out
Posted by frog314 at 5/30/2006 7:07:02 AM
Hello, I use render() method to generate and write reports to MHTML rendering extension. When report generating time is more than ~100 seconds the exception appears ( I write this exception to the event log) try { result = rs.Render(…..); } catch (Exception e) { e...more >>

DPE and Report Models
Posted by Tobi at 5/30/2006 4:27:50 AM
To my horror I have discovered that you can not specify a provdier that is anything other than SQL Data Provider in a report model project. Here's my problem. I'd like to provide one set of models for my schema and be able to dynamically change the connection string using a DPE that we have de...more >>



How to uutofit text when rendered in Excel
Posted by Omnibuzz at 5/30/2006 2:52:01 AM
Hi We are facing following issue in SQL Server Reporting Service 2000. We are generating report in excel format using reporting service. We are unable to format the column width and height based on the content. We tried couple of option like CanDraw and CanShrink, but it did not work. We ...more >>

VS2003 SSRS Project build fails
Posted by moondaddy at 5/30/2006 2:01:16 AM
I just setup a new dev machine and am running sql 2k + ssrs, VS2003, sql 05+ ssrs and VS 2005. I hae a VS2003 SSRS Project and it builds fine on the old PC. SSRS 2k appears to run fine on the new maching, but when I go into this VS2003 project (it was copied from the old machine) and build i...more >>

Overlapping Report Items via HTML?
Posted by Sam at 5/30/2006 1:43:43 AM
Has anybody managed to get Overlapping Report Items to display properly in Internet Explorer or some other browser? (Ignoring Microsoft's statement that overlapping items are not supported in HTML) Extensions or additions to the Rendering Extension, or any other suggestions would be welcome. ...more >>

Combine 2 Dataset
Posted by Hei at 5/30/2006 1:00:01 AM
Is that possible to do that?? Coz I use BSM to export a scorecard to RS and It becomes 2 seperate dataset. I just wanna know if it's possible to combine those 2 dataset easily?/ thanks ...more >>

Date Field Question
Posted by Tony at 5/30/2006 12:10:02 AM
Hi, In SQL server, I can use select dateadd(d, -1, getdate() ). How to do in reporting ? i.e. correct statement for dateadd(d, -1, Parameters!FromDate.Value) Thank You! Tony...more >>

Reporting services error
Posted by Frederik Vanderhaeghe at 5/30/2006 12:00:00 AM
Hi, I get the following error: a.. The path of the item '/StatistiekenSites/Sites_BezPerSitePerJPerM_I&year=2006&site=/sites/FTP/Site+Pictures' is not valid. The full path must be less than 260 characters long, must start with slash; other restrictions apply. Check the documentation for ...more >>


DevelopmentNow Blog