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 > august 2006 > threads for tuesday august 29

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

Combine table and matrix with different dataset
Posted by vetaldj at 8/29/2006 4:09:20 PM
Hello all, I need to combine table and matrix.. Problem is that they have different dataset and matrix depends from info from table. In table I show user info and in matrix i should show user activity by event type... I did it with subreport... It very-very slow.. SQL for both dataset are pr...more >>


Reporting services any good?
Posted by Smokey Grindel at 8/29/2006 3:56:46 PM
We use reports heavely and have LOTS of data to work with that needs reports run on, and right now we have a couple reports in crystal XI, but were looking at reporting services on SQL 2005 since we already have it... honest opinnions please, is it a good product? anything its lacking that cry...more >>

Table style
Posted by Ranga at 8/29/2006 1:59:01 PM
I used a report wizard to create a table report...How can I change the table style in design mode ? ...more >>

Sort Issues
Posted by Joe at 8/29/2006 1:44:35 PM
Not sure what best approach is but I think I need to just add zero's in front to solve sorting and if so - how do I do it: 1 11 12 19 2 22 I want 1 2 11 12 22 ...more >>

Delete Column Problems
Posted by Joe at 8/29/2006 1:25:26 PM
I created a report with say 5 columns, then decide I only want 4 of them. My approach was: 1) go to data area and remove from query 2) go to Layout Tab and remove from display But when I preview it - I get error - it still seems to always be looking for the column I deleted - what can I do...more >>

javascript:void(window.open problem - two windows opening
Posted by Glen M at 8/29/2006 1:16:01 PM
I am having a probelm with the javascript functionality in RS 2000 (sp2 installed). When the field is clicked (using jump to url with javascript...), a first new window is opened with the javascript... in the address bar and "The page cannot be displayed". Then a second window appears automati...more >>

object locks when running reports
Posted by Leyva at 8/29/2006 11:51:01 AM
We are in the testing phase of report service; several time through this testing the end users experience performance issue (system come to a crawl). I'm new to sql server 2005 and have not been able to resolve performance issue. I have search several sites and have located several articles ...more >>

Local Drillthrough Report 'Data source Instance has not been supplied'
Posted by hurst.andy NO[at]SPAM gmail.com at 8/29/2006 11:27:16 AM
I've searched and searched and can't find how to do this. I've got a main report and a report that I am trying to use the 'Jump to' ability with. I am capturing the ReportViewer1.DrillThrough event and am doing this: ReportViewer1.LocalReport.DataSources.Add(New ReportDataSource("JobApplic...more >>



procedure, report parameters
Posted by Lynn at 8/29/2006 10:50:01 AM
(sql/rs v2K, VS .Net 2003) I have a problem with several multi-dataset reports. I've got several single-dataset reports working just fine, but these multi-datasets are problematic. For example, I have one procedure which works w/out parameters, just returns a statistics report. I have modi...more >>

end user report modification
Posted by B at 8/29/2006 10:43:42 AM
Hi, I need to allow users to modify end reports to their liking. Changing grouping format etc. Currently I am using Crystal Reports and heard that sql server reporting services offer end user report modifications. I was wondering if any one using it can give me some feedback. Do you know wher...more >>

Multiple Render types with single subscription
Posted by dbutler at 8/29/2006 9:25:02 AM
I want to be able to create a single subscription, but have the render format be BOTH .xls and .pdf. Is this possible? Currently, I'm having to either run 15 large reports manually, or set up 30 subscriptions. I would like to be able to automate this process. Any advice would be greatly ...more >>

Connection designer in RS 2005?
Posted by Stephen Walch at 8/29/2006 6:11:25 AM
I have upgraded our Custom Data Extension from SQL 2000 Reporting Services to 2005. I see that the Report Wizard will now launch my Query Designer for editing command strings (thank you!) but I still can not see a way to get RS to launch my "Connection Designer" dialog. When running Report W...more >>

grouping similar data
Posted by Bkana at 8/29/2006 5:25:30 AM
In layout view: how do I group all the company names together who have the same value for a certain field? For instance, 10 companies all have the same booth size, but in Preview mode, it lists each company seprately with the booth size on each line. I need to have the booth size listed once with al...more >>

carry over values to next page
Posted by Carsten D at 8/29/2006 3:19:01 AM
hi, all. is it possible to carry-over a subtotal of a page to the page header of the next page? we use ssrs 2005. thx, Carsten...more >>

Protect .rdl-files from being extracted from the Report Server
Posted by wbiRalph at 8/29/2006 2:54:02 AM
Hello, is there any way to protect our .rdl-files on a Report Server of a customer to be extracted from the Report Server by one of our customer's administrators? Our customers should not be able to modify or develop further the reports developed by us. Kind regards, Ralph ...more >>

Installing WSS on top of RS
Posted by Bjorn at 8/29/2006 2:04:37 AM
Hi, Until now, I only fount tutorials/howto's on installing Reporting Services, after a WSS install. In my situation, I have RS fully up & running, and I need to add WSS to the same machine. Which steps do I have to take? Can I use the same steps as in this link: http://msdn.microsoft.c...more >>

integrating RS with asp.net app
Posted by kamel at 8/29/2006 12:26:47 AM
Hi, I would like to integrate RS with asp.net application. Need your help, some how-to... TIA, Kamel ...more >>


DevelopmentNow Blog