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 > april 2006 > threads for wednesday april 26

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

Printing a report
Posted by Jeremy at 4/26/2006 5:20:02 PM
I am pulling down reports using the reporting services web services, and for various reasons I am not using the report viewer. So I am rendering them in EMF format and previewing them in the print preview control. However, whenever I preview them or print them directly, the PrintPage event of ...more >>

Windows Authentication Problem
Posted by Cayman Visitor at 4/26/2006 4:18:01 PM
I'm having problems with Windows Authentication in RS 2000. This is on a brand new server. Here is the setup I've done. -Install Win2003 SP1 (install all updates to be current) -Install IIS (with ASP.NET and FrontPage extensions) -Install VS.NET 2003 -Install SQL 2000 (with SP4) -Install ...more >>

SQL_2005 Reporting Services Performance
Posted by Naveen at 4/26/2006 3:18:02 PM
A single server running side by side SQL instances. SQL 2000 as default instance and SQL 2005 as named instance. Designed a report using 2005 Reporting Services to query data from SQL 2000 Database. Report by itself works fine the problem is with performance. Report has multiple parameters...more >>

Set Report to print to Landscape by Default
Posted by Jack Bender at 4/26/2006 2:26:02 PM
Does anyone know a way to set a report to print out to Landscape by default? I do not see an option anywhere for this setting within Visual Studio 2005 when creating the report....more >>

Erro install Reportig Service
Posted by Clayton Cardozo at 4/26/2006 12:21:54 PM
> Hello, > > I`m try install Microsoft SQL Reporting Service 2000 in Windows 2003 > Standard, but appers error message no log file rsstp.log > > InstallBootstrapPackage' Return='2' GetLastError='183 > > anyone can help me? > Clayton Cardozo. ...more >>

Union all in Reporting Services Dataset Referring to parameters.
Posted by Sen at 4/26/2006 10:06:44 AM
I am using this below query which is with a Union all. The database I am trying to connect is Oracle. Once I go to preview I get an ORA error which mentions thatt the query is not properly terminated. Is there a way to create a Union all in a paraemeterized dataset with connection to Oracle. ...more >>

Debugging Log Files...
Posted by isideveloper at 4/26/2006 10:02:01 AM
I'm having trouble with a few subscriptions getting emailed. They are showing "email sent" in their status. I remember a while ago, finding a post about a log file I can read that showed transactions and their error or success messages, but I can't find it now. I didn't have to look in the ...more >>

Comparing fields from multiple datasets
Posted by BillTWD at 4/26/2006 9:24:02 AM
I have one report with two dataset (one from a table and one from a Cube). Within my report are two tables, one uses the ‘Table’ dataset and one uses the ‘Cube’ dataset. The two dataset are similar (i.e. they return similar data/fields). I would like to compare some of the fields fr...more >>



Navigation: page position
Posted by Vyv at 4/26/2006 8:39:42 AM
Hi everybody, I have this "minor" problem... This is the situation: a list of orders is shown I scroll downwards in my page to look for a certain order I click on the order to see the order details (jump to the detail report) use the back button to go back to the list of orders (previous ...more >>

Subreport only sometimes shows
Posted by Louis Ryder at 4/26/2006 8:14:06 AM
I have a sub report that is only showing part of the time. I have run the report with following scenerios: peramter "status" = "active" , and perameter "session" = 1 and it runs corectly peramter "status" = "inactive" , and perameter "session" = 1 and it runs corectly peramter "status" =...more >>

SSRS 2005 Deployment Problem
Posted by Paul Noe at 4/26/2006 8:06:01 AM
I'm fairly new to SSRS, having switched over from Crystal recently. I've created a report, which is working fine in the designer and the debugger. The problem is that when try to deploy the report to the reportserver (localhost/reportserver), I receive an error described here: "A connecti...more >>

Tranferring Reporting Services database to another server in another domain
Posted by Frank at 4/26/2006 7:37:57 AM
I'm transerring a Reporting Services db from server 1 tot server 2 in a different domain. To do this I followed these steps: - Create back-ups from ReportingServicesProductie and ReportingServicesProductieTempDB - Create encryption key on the Reporting Services machine - Restored the backups -...more >>

Cannot read the next data row for the data set
Posted by Pam Richardson at 4/26/2006 7:25:01 AM
Hello all - Our users are getting the above error when trying to execute a report. Permission has been granted to the security group that they belong to, for the report folder and report (browser permissions), as well as the Analytical Services database and the associated data warehouse data...more >>

Formatting text
Posted by Pasquale at 4/26/2006 6:35:03 AM
I need to format a text in a text box to show a text field truncated. In other terms, I must show only 40 characters of a very long string. Do I use the statement "format"? How can I solve this issue? Many thanks...more >>

Reporting Services web access with Sharepoint portal Server
Posted by Kam at 4/26/2006 5:19:02 AM
I installed SQL Developer Edition on W2003 STD, plus sharepoint portal server 2003. after the installation, I try to acces http://localhost/Reports, failed. How can I setup the reporting services web access with sharpoint portal server on the same machines? Is there any web parts for Re...more >>

email notification
Posted by Dewald at 4/26/2006 5:18:01 AM
Hi All, We need to email RS reports to various sales persons within a branch. Sales persons are only allowed to see their own report. Therefor a report will be executed for the amount of sales persons, passing thru the salesperson's ID as a parameter. We do not want to schedule a report fo...more >>

SSRS 2005 URL/Hyperlink Conflict(s)
Posted by Terry at 4/26/2006 5:17:02 AM
I am receiving an Internet Explorer (v6) error when clicking on hyperlinks in reports. The Visual Studio designed and deployed reports with hyperlinks does not work. However, they work well in Visual Studio during design time and while previewing the reports. I did not have th...more >>

report model cross join
Posted by kamel at 4/26/2006 4:36:01 AM
Is it possible to define cross join relationship within report model? TIA, Kamel ...more >>

Report server spawning multiple w3wp.exe threads
Posted by andygadget at 4/26/2006 2:33:09 AM
We have Win2003 SP1, SQL 2000 SP4, RS 2000 SP2 installed on our dev machine and it works ok - having problems using anonamous access under IIS but that is another issue...... On our production server ( win2003 SP1, SQL 2000 SP4 ) we installed RS 2000 and SP2, accepting all the default installa...more >>

How to change the caption of parameter at run time
Posted by CKW at 4/26/2006 1:21:01 AM
Hi, I would like to change the caption of parameter based upon the other parameter value in RS 2000 / 2005. Thanks...more >>


DevelopmentNow Blog