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 > january 2006 > threads for thursday january 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

SQL 2000 RS -> SQL2005 RS
Posted by NO[at]SPAM at 1/12/2006 3:31:02 PM
Hi, Hopefully someone can help me answer a few quick questions I have regarding transitioning over to SQL Server 2005. 1) Forms Authentication Extension ---------------------------------------- Is the installation and configuration the same for SQL Server 2005 RS? Does a new extension nee...more >>


rotate a text box 270 deg
Posted by John230873 at 1/12/2006 3:02:02 PM
I am trying to rotate text in a text box by 270 deg, I have read I can use tb-rl but when I enter this into the direction Propertie of the textbox I get an invaild Direction error. Any Ides Using VS 2005 & RS2005...more >>

Start Shared Schedules Programatically
Posted by Michael Pusateri at 1/12/2006 1:38:04 PM
I have a bunch of reports that need to be kicked off after a DTS package or some other event happens, how can I do this programatically from DTS or some other dependency scheduler. Example, Job A Job B Job C Reports Generated So, a user kicks off Job A, Job B is t...more >>

Pass multi value parameter to another report
Posted by Billy at 1/12/2006 1:31:01 PM
I have two reports, ReportA and ReportB. In ReportA I have a hyperlinked field that when cliked opens ReportB. ReportB must then be filtered on the values of the multi value parameters selected in ReportA. My question is: How do I pass multi value parameters to another report? Thanks in ad...more >>

POSTing report parameters
Posted by Sean at 1/12/2006 1:25:03 PM
We are having an issue POSTing report parameters to reporting services. One of our report parameters can be very long (hundreds or even thousands of characters) and is far to long to pass on a URL. Our solution has been to POST the parameter, which does work, but not quite as we want it to. We...more >>

Customize where clause c# (RDL)
Posted by dgator at 1/12/2006 1:12:02 PM
We have may reports that need to customize the where clause based on parameters entered by the end user. Is there a way to modify the RDL on the fly in order to achieve this? I am using VS2005 and SQLServer 2005. Example: if user selects run report by week ending date the following line ne...more >>

Appending a custom sql where clause
Posted by gigijk NO[at]SPAM gmail.com at 1/12/2006 12:35:43 PM
Hello, I am in the process of evaluating SSRS 2005 to replace an home grown reporting tool. In my reporting application all users have access all the tables\fields in the database. In the home grown tool, data security is implemented by the following mechanism. When users run reports, a stand...more >>

can't get to report manager
Posted by ACreel at 1/12/2006 12:24:03 PM
My company recently upgraded to CRM 3.0 and i was trying to get to the report manager page in my browser to make custom reports. Unfortunately, whenever i try to go to the report manager page i get the error listed below. Has anyone ever seen this before? Thanks in advance for any help you can...more >>



SQL Server does not exist or access denied
Posted by Michael W. Krout, MCSE at 1/12/2006 10:05:02 AM
When I run reports directly from the SRS they run fine. When I try to access the reports over the internet then I get this message once in a while. If I run the same report from the SRS then I can run it again in the browser on the client. I am running a database server with SQL 2000 SP4 on...more >>

Subreport performance
Posted by TJ at 1/12/2006 9:26:07 AM
I've worked with Crystal and Access and now SRS and I have a question regarding subreports in SRS. Take a standard header/details report in which the details are a subreport (in this case we can't put all the records in one Stored Proc. Do the parameter link and it all works fine except wh...more >>

Formating Reports To Print
Posted by igor.santos at 1/12/2006 8:18:07 AM
How can I fixa report that displays correctly on the web page (Report manager) but when I either print or convert to .pdf, some of the text boxes shifts to a second and maybe a third ? The report is actualy smaller than a regular letter page. Any ideas ?...more >>

Report Builder - Entities list behaving poorly.
Posted by ScottT at 1/12/2006 7:38:10 AM
While attempting to create a new report, I came across what I feel is some odd behavior. I select an item in the Entities list, then drag an item from the newly populated Fields list to the report area. Once I drop the field item, the Entities list changes scope showing only the Entity fro...more >>

If statement help
Posted by Are friends electric? at 1/12/2006 6:42:02 AM
I am trying to make a field either a particualr name or a value in a field within my data using an iif statement, the statement is =iif(Fields!Reserve_ID = 1, 'Revenue Reserve', Fields!group_id) this returns the error The value expression for the textbox ‘CAP_short_id’ contains an err...more >>

Dundas chart not being toggled hidden by toggle item
Posted by Peter Nolan at 1/12/2006 5:32:52 AM
Hi All, I am using dundas chart for RS on 2005. I have charts which I want toggled hidden based on text boxes. The toggle works on all the other objects on the charts. I talked to Dundas and they were saying that the hide/show was inside RS and that their control did not control this. They als...more >>

system event log as data source ?
Posted by dbaguru at 1/12/2006 5:12:04 AM
is it possible to report from the server system or application event log ? I'd like to pull in events based on severity from several servers into one report. thanks in advance....more >>

Implementation of a customized RS-2000 Datasource
Posted by BB_Reporting at 1/12/2006 2:45:23 AM
Hi, I'm crurrently planning to implement an own SQL Server 2000 - Datasource extension (c#) for Reporting Services, which should only fill in a report parameter during the run time a string. Has anybody found a good code example to implement such a datasource extension for RS?!?! Would ...more >>


DevelopmentNow Blog