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 > october 2006 > threads for monday october 9

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

Deployment
Posted by Henrik Skak Pedersen at 10/9/2006 9:44:42 PM
Hello, What is the best way to deploy a Reporting Services solution. The solution consists of database scripts, reports, CRI dll's and roles. Thanks Henrik ...more >>


Parameter Question
Posted by TimS at 10/9/2006 6:48:02 PM
Hello, I posted this same question a while ago, but cannot seem to find it anymore. Anyway, I have what I think is a fairly simple question and am surprised that I have not received a reply to the original post, that I can no longer find. Here goes again. I have two parameters, one of w...more >>

Redeploying Reports
Posted by Tarun Mistry at 10/9/2006 4:37:57 PM
Hi everyone, is it possible to "package" my reports so that I can deploy them on different servers? If so, how would I go bout doing this? I dont want to instal VS everwhere, copy across a project and then deploy. Is there a better way? With kind regards Taz ...more >>

Local reports !
Posted by sean_mcad at 10/9/2006 4:14:01 PM
I have been working with server reports in the past now I am working on local reports and it apears as iif many things are different! For one, I cant get report parameters to show up in the report viewer is that normal for local reports? Additionally the "report parameters" screen for me is ...more >>

matrix row header
Posted by Rob K at 10/9/2006 3:26:02 PM
In RS 2000, how do you place headers on the columns in the row section of a matrix?...more >>

Formating Dates
Posted by jcl_tw at 10/9/2006 3:15:02 PM
In my chart report, my x-axis date is displaying as 9/1/05, 10/1/05, etc. I would like to display the date as 9/05, 10/05, etc, is it possible? Thanks, Jimmy...more >>

Viewing Report
Posted by Brian Shannon at 10/9/2006 3:11:59 PM
SQL RS 2005 I have numerous paramater reports - all of which have a default paramater assigned. When the report is opened it automatically begins processing. Is there a way to disable this functionality. Even though I have default paramaters associated with all paramaters I would like th...more >>

Conditional Page Breaks
Posted by bigbrorpi NO[at]SPAM gmail.com at 10/9/2006 3:03:19 PM
Hi - I'm trying to generate invoice reports where there are two types of line items (with a different number of columns). I am basically looking to have two sets of tables as follows: Case A - at least one of each item Table Items 1 <PAGE BREAK> Table Items 2 Case B - items 2 exist, but no...more >>



Problem with 'Reply-To' in data driven subscription
Posted by neilgould NO[at]SPAM gmail.com at 10/9/2006 2:29:38 PM
I am running SQL Server 2000 sp4 and Reporting Services 2000 sp2. I set up a data driven subscription with a static Reply-To address. However, when the report runs, the reply is the default in the config file. I've seen 1 other post on this but no solution. Help would be appreciated. Neil ...more >>

compare values within subreport to main report
Posted by aggiechick717 at 10/9/2006 1:52:37 PM
I was wondering if anyone knew how to take a value from a subreport and compare it to a value iwthin the main report. We are trying to see if the value in the subreport is greater than the value returned in the main report. We want to make the value test red if it is greater than. I know how to...more >>

Repeating a textbox on every page of the report
Posted by Ignacio Machin at 10/9/2006 1:45:02 PM
Hi, I have something like this in the report body >> TEXTBOX1 = Fields ! MyFieldName.Value << >> the table definition here << My problem is that I want to repeat TEXTBOX1 on all the pages if the table has more than one page, Right now only appear in the first page. I tried to set ...more >>

Suddenly file share subscription doesn't work - logon error occurs
Posted by Mike at 10/9/2006 10:39:02 AM
Dear fellows. A very frustrating error keeps occuring for my report subsciption. Even though the supplied credentials are valid (have tried to use administrator credentials and all kinds of workarounds) the following error message is received: "Failure writing file Tider.xls : A logon er...more >>

LoadReportDefinition->Root element is missing!?
Posted by Marc at 10/9/2006 9:56:51 AM
Hi all, I try to load a RDL-File by code with the following statement: rpvReport.ServerReport.LoadReportDefinition(strReader); Unfortunaltely the following error occurs "Root element is missing" (see more beneath). I dont get the point as in my eyes the rdl (xml) files i tried are well...more >>

Incorrect page count on reports that use drill-down or have hidden
Posted by Scott B. at 10/9/2006 8:22:01 AM
I am getting an incorrect page count on reports that use drill-down or where report items are hidden. The Globals!TotalPages returns 1 on a report that clearly has more than one page. On these reports, the Globals!TotalPages returns the correct page count for the print preview. I get the sam...more >>

Newbie question, how to report a stored procedure
Posted by Federico Caselli at 10/9/2006 6:33:02 AM
Hi, I would like to make a report against a Sql Server 2005 stored procedure. The SP returns a table-like resultset. I tried using the VS 2005 report wizard project, but, after clicking the finish button, I get the following error: << Deserialization failed: The element 'TableCells' in n...more >>

How to output newline character in Reporting Service
Posted by Nhu Huynh at 10/9/2006 12:00:00 AM
Hi all, I have a string variable in a SQL SELECT statement with newline characters in it, something like this: SELECT @a = '123' + '\r' + '\n' + 'xyz' When I output that string variable to Reporting Service, the newline chars are not shown as expected but still shown as '123\r\nxyz'. Cou...more >>


DevelopmentNow Blog