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

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

Problem with Parameterized reports - changing default values
Posted by Graham Smith at 6/22/2006 11:46:02 PM
Hi I have two issues: I have recently migrated SSRS2000 to SSRS2005. 1. When I run CRM3 parameterized reports using the RS Report Manager interface i get error messages like " The 'CRM_Locale' parameter is missing a value " or "The 'CRM_Locale' parameter is missing a value", however when ...more >>


What Datatype Is RS Using for String Parameter
Posted by Mike Harbinger at 6/22/2006 7:33:41 PM
Is it VARCHAR(8000) ? Thanks ...more >>

One server, many databases and stored procedures
Posted by ddaniels via SQLMonster.com at 6/22/2006 7:08:35 PM
Hi - I have a single database structure that will be implemented several times in SQL Server 2000 to support multiple clients. I would like to have a single instance of a report to use against all of these databases. I envision using the connection string to control which database the report...more >>

TextBox Expression Problem
Posted by Joe Delphi at 6/22/2006 5:15:27 PM
Hi, I am attempting to avoid a divide by zero error in a text box. The value for the text box is: =IIF((ReportItems!textbox2.Value+ReportItems!textbox3.Value+ReportItems!textbox4.Value) <> 0 , ReportItems!textbox3.Value/(ReportItems!textbox2.Value+ReportItems!textbox3.Value+Repo...more >>

how to stagger reporting services scheduled deliveries?
Posted by ===Steve L.=== at 6/22/2006 3:46:59 PM
i'm new to sql2k5 and reporting services 2k5. is there a way to automatically stagger various scheduled deliveries? or to check certain things, for example, a temp table needed to be populated before the report is generated, or stop the rest of deliveries if one of them failed and so on. somethi...more >>

publishing a ssrs2005 reprot on a 2000 system
Posted by Amedeo Feroce at 6/22/2006 3:41:47 PM
Hello everyone! Does anyone know if you can depoly a report created in SSRS2005 environment on a SQL Server 2000 report server??? Thanks! Amedeo ...more >>

Page footers in Sub report not visible in main report.
Posted by Manuraj VS at 6/22/2006 2:07:20 PM
Hi , I have a sub report which has a page footer.This page footer has page number & a text box which dispalys something based upon the parameter send from the main report. Iam calling this sub report 5 times from the main report by passing a parameter , say @D ( @D =1 ,@D =2 , @D ...more >>

My own report parameters
Posted by Ravi Manda at 6/22/2006 1:45:02 PM
Hi there, Can I add my own report parameters on report parameter area of a sql server report 2005. I have a label, textbox followed by a button. Open a aspx search page onclicking the button. Thanks, Ravi...more >>



Using "ALL" in Parameters
Posted by Benw at 6/22/2006 1:13:02 PM
I am trying to use 'ALL" in my parameters but it doesnt seem to work. My parameter dataset query looks like this: SELECT Empid AS EMPLOYEE FROM smServFault WHERE (TaskStatus <> 'C') UNION SELECT 'ALL' AS EMPLOYEE ORDER BY EMPLOYEE and my main query looks like this: ...more >>

File System Access With Custom Assembly Method
Posted by jeffjones176 NO[at]SPAM gmail.com at 6/22/2006 1:01:45 PM
Hello All, I am building a dashboard report that will read through the file system for a record's document folder on our server and report to the user if there are any files missing in the directory. I am using a custom assembly to house the method. When using the assembly in the dev enviro...more >>

Reporting Services Question
Posted by KC at 6/22/2006 11:52:02 AM
I have an associate who needs Reporting Services 2005 installed. They do not have a Visual Studio 2005 license of any kind. Does this normally go on a desktop and if so, what is the minimum license required to remain compliant? THANK YOU in advance!...more >>

Reports Not Updating
Posted by dotNetDave at 6/22/2006 10:53:01 AM
I'm running Reporting Services on SQL 2000. I have some reports that automatically run when you bring them up because the don't require parameters. If I run the report (in IE) and then get out of the report. Then change the underlying data in the database. Go back to Reporting Services and r...more >>

How would i build a development environment for reportingservices
Posted by AG at 6/22/2006 10:39:03 AM
I have configured a development server with sql standard edition 2005 and have to give developer acees to this machine.I cannot install the client tools of standard edition on windows xp systems and i get the error "TYhe installation package is not supported by this processor type". How shoul...more >>

Report Designer: Refreshing Fields VERY Slow
Posted by Chance at 6/22/2006 9:35:02 AM
I have a query that uses temp tables, and the query seems to execute and refresh fields fine, but as soon as I put in a parameter for a DateTime field the query will run but the Refresh Fields button takes forever...like 2 hours! I think it is running my rather lengthy query without the parame...more >>

Custom data extension has trust issues
Posted by Ryan at 6/22/2006 8:55:46 AM
I wrote a custom data processing extension for reporting services in SQL Server 2005. The extension works in preview mode, but when viewing it from the report server I get the error: ---- An error has occurred during report processing. (rsProcessingAborted) Cannot create command for data source...more >>

Change background color on toggle
Posted by GopherGold at 6/22/2006 7:27:03 AM
I have a report with a table, four columns. I added a second row to the table and inserted a subreport. The subreport's ToggleItem is the first column in the first detail row of the table. When I toggle a row to display the subreport, I'd like to change the background color of the row. I c...more >>

Hardware considerations for Report Server?
Posted by Marc at 6/22/2006 6:59:02 AM
Hi all, we use SSRS based on SSAS Cubes. We thought about installing SSAS on one server, the relational data on an other SQL Server and put the Report Server with the IIS 6.0 on a third machine. As we haven't any experiences with load and performance for BI-Applications I'm wondering ...more >>

Parameter All Values and Values
Posted by Benw at 6/22/2006 6:32:02 AM
I am new at this parameter thing. I have a paramater that uses a drop down list and can select multiple values. How can I let the user choose all of the values without having to click on all the values individually. And also How can I get the parameter to import the values into the dropdown...more >>

Matrix - Total in non column group
Posted by Maran at 6/22/2006 6:05:02 AM
Is it possible to create a "total" for a non "column group" ? Usually you add a "SubTotal" to get values in column groups summarized. Is it possible to do something similar to a "row group column"? Like: DataTable "Q1", Id1, "NonGroup", 1, "Group1", 5 "Q1", Id1, "NonGroup", 1, "Group2", ...more >>


DevelopmentNow Blog