Groups | Blog | Home


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 wednesday may 31

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

SSRS 2005 SP1 - No more "Select ALL" option when using multi-value parameters after SP1?
Posted by Benjamin Chan at 5/31/2006 5:12:35 PM
Just installed SP1 last night. Today I don't have a "Select All" option anymore. Anyone else notice this and or have a way to make it so I can have a "select all" option on multi-value parameters? Bug or decision to decrease functionality? Thanks! Benjamin Chan...more >>

Add Column Values To the Bottom Of the Row By Condition
Posted by vamsi at 5/31/2006 4:02:06 PM
Hi I am getting some results from stored procedure. Name Value1 Value2 Value3 Total North 1 2 3 6 North 4 5 6 15 South 5 ...more >>

Permissions to data source in Report Manager
Posted by Wannabe_Kiwi at 5/31/2006 3:28:58 PM
I'm deploying some reports to a customer box and am having some quirks in getting the right permissions to the data source. Instead of going into detail about my specific problem (which I don't think I can even give a good description of since I can't see what groups the accounts I'm using are m...more >>

Stored Procedure performance
Posted by jhcorey NO[at]SPAM yahoo.com at 5/31/2006 1:45:05 PM
Just some info here. I created a very simple report against a stored procedure. The sp ran in about 1 second in SS Management Studio. When running the report it took at least 30 seconds. When I went back to the Data Tab and ran the procedure, it also ran for what seemed to be at least 30 ...more >>

Page Formatting Nightmare -- Please help!!
Posted by OriginalStealth at 5/31/2006 12:46:01 PM
I have a report that has many columns. When the report is fully expanded you can see all 75 columns. When I run the report in the report viewer the report is a total of 8 pages. When I export to .pdf the report is 45 pages long with over 30 blank pages. Is there anything I can do to get it...more >>

Suppress Matrix Row
Posted by DvH at 5/31/2006 8:33:01 AM
I have a simple matrix that uses the group visibility based on toggle. when hidden, the data is not visible but the group row is. how does one suppress the group row when its data is hidden? currently, there is a great deal of white space on this report when all groups are hidden....more >>

Table missing border on page break
Posted by Carmen at 5/31/2006 8:01:02 AM
I have a report using a single table. I set the table border to solid for left, right, top and bottom. Currently the report is printing in 2 pages. On the first page the table doesn't show the bottom border. It does show on the second page. I'm guessing is only placing the bottom border at the...more >>

Matrix formatting
Posted by David Maynard at 5/31/2006 7:49:02 AM
I want to know if this is possible. I have a Matrix that could have 5 to 100 columns in it. Each column will have 5 rows. A B C D E F G H 1 X X X X X X X X 2 X X X X X X X X 3 X X X X X X X X 4 X ...more >>



set default parameter for a report programmatically
Posted by sachin laddha at 5/31/2006 7:34:13 AM
hi, Is it possible to programmatically set default parameter to a report while deploying it or after deploying it. It is possible to set it using report manager web application. But I want to set it programmatically, preferably while deploying the reports. Please help, regards, SAchin ...more >>

Issue with Render Stream method in Reporting Services 2005
Posted by Arthas at 5/31/2006 6:21:00 AM
Hi, In reporting services 2000 we had provision to pass report parameters to Render Stream method. Now i am not able to do this in Render Stream method of report execution api in RS 2005. I need to get the stream in the form of html based on the parameters passed (e.g;in RS 2000 i used to do ...more >>

Trouble adding second dataset
Posted by Jim at 5/31/2006 6:02:02 AM
I am trying to add a second data set to a report to drive a dopdown for a selection parameter. The parameter is for user id to filter the report. I have done this many times on other reprots with no problem - that is why it is so frustrating :( After adding the dataset I can execute it just...more >>

Problems with the rs explorer web part for sharepoint
Posted by erlend.dalen NO[at]SPAM gmail.com at 5/31/2006 5:48:31 AM
Hi everyone! I'm trying to get my Reporting Services reports to display in a sharepoint site. Sharepoint and reporting services are set up on two different computers. When I set up the rs explorer web part, it just displays "Retrieving data..." and nothing happens. In the rs report view we...more >>

Large Dataset
Posted by Ashish at 5/31/2006 1:40:01 AM
Hi, I have a requirement where in I need to render a report from a query that returns about 1,500,000 odd records. The report is a simple tabular report. SSRS 2005 fails. The same report is generated easily by Crystal report. How do I get the SSRS to generate the report ? Kind Regar...more >>

Can inherited from a custom report
Posted by ad at 5/31/2006 12:00:00 AM
I must make many report in my project. All the reports must have header of company name and footer of page number. Can I desgin a template custom report, then all reports in my project are inherited from it? ...more >>

How to use DisplayName in report
Posted by ad at 5/31/2006 12:00:00 AM
I use the new feature of VS2005 to develp LocalReport. I have set the DisplayName of a LocalReport like this: ReportViewer1.LocalReport.DisplayName = sDisplayName; It will change the top node of the Document Map. How can I bring the DisplayName into the report, for example I want t...more >>


DevelopmentNow Blog