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 > november 2006 > threads for friday november 10

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

general Reporting Services question
Posted by Vadim at 11/10/2006 4:08:43 PM
Hi, Is it possible to run Reporing Services reports from a client Server app without installing anything to the IIS? Kind of Like Crystal does where you can distribute report viewer and install on a client's machine. Thank you, Vadim ...more >>

"Next Page" is extremely slow - like it's requerying
Posted by Jordan at 11/10/2006 1:41:55 PM
I have a report with a single dataset, 3-levels of table grouping, and returns 5 pages. When I preview the report in VStudio, it returns the 5 pages and I can navigate the pages real quickly. The problem is, when I run it online via the RS front-end and click "Next Page," it takes a good 30 ...more >>

Detecting the Render Setting at Runtime to Affect Report Formatting
Posted by mmurphy1005 at 11/10/2006 1:14:51 PM
Is it posisble to detect at runtime the render type that was selected? And if so, can the rendering of the report objects be controlled based on the render type that was selected. For example, if I render a report to PDF, I want to display a nice title header at the top of the page. But if I ...more >>

RS formatting ?
Posted by aggiechick717 at 11/10/2006 12:11:34 PM
Hi all, I have a report that allows users to choose one or more parameter values and then a report is rendered based off of that input. I have a table that I want to always have 8 rows, but if the report returns only 2 rows I need to add 6 blank rows to the end of the table. If the report r...more >>

Firefox(2?) report rendering problems
Posted by Brian Orrell at 11/10/2006 11:55:01 AM
Hi, recently added a reportviewer control to a page and it rendered incorrectly in Firefox 2. So we made a custom report control that calls the reporting services and renders in HTML 4.0 and the formatting is still messed up. Basically everything is crammed into the left 5% or so of the page...more >>

conditional subscriptions / business day logic
Posted by Lynn at 11/10/2006 11:42:01 AM
I need to know if there's any way to refrain from sending an email if the tSQL behind the rdl is empty? it's a trading report, clearing-type information is sent out in a report via reporting services. i do not want to send a blank email if no trades exist. but i must have it in place/enab...more >>

parameter question
Posted by Brian L at 11/10/2006 10:38:02 AM
I'm passing a parameter to a SP in SSRS '05. The parameter values are derived from a query that selects values based upon a group membership. What I need to be able to do is add a value to the list so that a NULL is passed back so that those values not belonging to the group are selected (thi...more >>

Custom Report Item: Textbox
Posted by gbouzebra at 11/10/2006 10:06:01 AM
Hi all, If it is possible, how I can extend the Textbox item with a DataSet property. In order to display a field from multiple rows, with a separator ? Example: a dataset with 10 rows (and 1 field "Name") and I want to display in the Textbox "Name1, Name2, Name3, Name4, Name5, Name6,...more >>



Report Builder
Posted by Steve at 11/10/2006 10:02:45 AM
I'm very experienced with SQL Server, but new to reporting services. I'm currently working with the Report builder, and I'm having a hard time trying to get it to work as I need. From my web app, I'm able to put a link on there for ad-hoc reports. Clicking it opens the report builder. The...more >>

multi value parm derived from other multi value parm problem
Posted by OyVey at 11/10/2006 8:42:01 AM
Hey all, I have a sql query dataset that uses parameters derived from 2 previous sql query datasets: SELECT MachineID, ModelNumber, ProductName FROM Admin.dbo.PricingMachine WHERE MachineType IN (@GroupType) ...more >>

Multi Value Parameter and Filtering
Posted by Are friends electric? at 11/10/2006 8:34:02 AM
Hi All I am trying to filter a table on my report based on a multi-value parameter, I have tried several methods to no avail. When I use the following I do not get an error but I do not get data showing on the report. Expression is set to =Fields!Account.Value Operator is set to In Valu...more >>

Matrix Report Background Color
Posted by duhaas NO[at]SPAM gmail.com at 11/10/2006 8:21:41 AM
I have the following applied as an expression to the background color on a cell =IIF( Sum(Fields!Percentile.Value, "RegionalSnaps") >= 10, "Yellow", "White") I only want the ones above 10% to be yellow, otherwise white. Any ideas anyone on why the entire range of cells are yellow and not...more >>

Unable to add New Role Assignment
Posted by Brian Ackermann at 11/10/2006 6:44:16 AM
Hello all! I've researched this problem and was not able to find anything like what I'm experiencing in the archives. Basically, my Reporting Services is running on SQL Server 2000, and has been working flawlessly for more than a year. I am unaware of any changes having been made to it at ...more >>

Reporting services offline
Posted by aka at 11/10/2006 4:47:01 AM
Hi all, Can any one help me how reporting services work offline .I heard in Sqlserver2005 reporting services ,there is a component which ables to run reporting services on client system also. Please kindly help me. I am very much in need of it. thanks in advance to all miiku...more >>

How can I Associate DataSource with Report using Code
Posted by Krishna kumar.M at 11/10/2006 4:42:01 AM
hi, Thx. in advance. How can I Associate DataSource with Report using Code.I'm using Reporting Service Web Serivice I tried this below code but it is giving error like "The data source 'DS_Code_002' cannot be found in this report. --> The data source 'DS_Code_002' cannot be found...more >>


DevelopmentNow Blog