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 friday may 12

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

Hidden Subreport Executes Query
Posted by Joe L at 5/12/2006 4:33:37 PM
Using SRS 2000. I have a subreport on my report that is only shown under certain conditions. I have handled this successfully with the Hidden property. I read somewhere that the hidden subreport would not execute, but if I profile SQL server when I run the report the SQL is being executed....more >>


How to set this up?
Posted by Paul at 5/12/2006 4:29:15 PM
I need to set up the security on the Reporting Services such that user can view the reports ONLY through a ReportViewer control on a asp.net web page ie not allow to navigate all other folders or areas in the Report Manager. Reporting services is installed on a stand alone server (not belong t...more >>

Can't open Business Intelligence studio to get at reporting servic
Posted by loulou at 5/12/2006 1:27:02 PM
I downloaded sql server express 2005 tool kit which contains Business Intelligence Studio which is what houses Reporting services. I installed it but now I can't find where to run it. I re-installed thinking something went wrong with the install but it says already installed. How can I run th...more >>

Permission on sub folders (URGENT)
Posted by ITDUDE27 at 5/12/2006 12:41:02 PM
Hi.. I've ran into an issue with a specific task in report services. I have folder that contains Financial Reports for management, for some odd reason all users are able to access that folder even though only the individuals from management are assigned to this folder and the reports. I...more >>

Cannot create user on Report Server 2005
Posted by RebeccaTS at 5/12/2006 11:49:01 AM
Hi, we installed SQL Server 2005 & Reporting Services on a box that had been running 2000. I launched the reports website. When I try to do New System Role Assignment, I type in a domain user and select a role and click OK, nothing at all happens. No error message, no response, nothing....more >>

Column Widths
Posted by Andy at 5/12/2006 10:43:01 AM
Is there a way to have columns automatically size themselves based on the contents of the column name and data? I guess I'm looking for something similar to Excel's Format|Column|AutoFit Selection option. What I see happening with our reports is that a column name of... Reservation Departur...more >>

Printing with margins and landscape mode set automatically...
Posted by jereviscious at 5/12/2006 9:30:55 AM
Hi all Is there a way to do this or is there a plan to do this in the future? This is a major complaint for my users... ...more >>

Printing from .Net Applications
Posted by Terry M at 5/12/2006 9:07:30 AM
Hello I am very new to RS having just setup SQL2000 reporting services. I did a couple of walk throughs and understand how to create a report to deploy on the report manager. But I am confused about what else I can do with RS. Can I create reports in VStudio to print directly from a .Ne...more >>



"File not in a recognizeable format" when rendering to excel
Posted by awtesta NO[at]SPAM gmail.com at 5/12/2006 8:27:39 AM
I am using a WinXP SP2 machine with SQL2000 SP4, and using Reporting Services SP2 when I get "File not in a recognizeable format" when rendering to excel. Same goes for trying to render to PDF. The weird thing is that on a virtual I have with Reporting Services RTM, the excel opens fine...so ...more >>

How to Define the reference DotNet Assembly
Posted by Pony Tsui at 5/12/2006 6:11:02 AM
I created a report include some DotNet Assembly in the reports property reference page like system.drawing, system.windows.forms, write some customer code using system.drawing & system.windows.forms, the reports display fine in the preview page, but after i deployee to the sql 2000 server, the...more >>

Windows Auth
Posted by Pat at 5/12/2006 2:20:02 AM
I'm trying to change the Auth method for users accessing the reports with Internet Explorer from basic auth to windows auth. I have checked the "Integrated Windows Authentication" box for the ReportServer virtual dir in IIS (and left the basic auth checked), verified that the auth method is W...more >>


DevelopmentNow Blog