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 > july 2006 > threads for wednesday july 19

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

What to use instead of a Subreport?
Posted by Christian Nein at 7/19/2006 9:59:27 PM
Hi, I have a report containing 2 datasets: - dataset 1 containing ProductGroups - dataset 2 containing the Articels contained in the ProductGroups Both datasets are 1:N-related by the ProductGroupID (1 product group contains N articles) I want to display each product group with a list of ...more >>

Row Total In Table
Posted by Joe Delphi at 7/19/2006 7:30:58 PM
Hi, I have a table in my report (not a matrix) that displays 50 rows by 6 columns - fixed, no grouping requirements. The user wants to see the total of both the vertical column (easy) and also the horizontal row - not so easy. First I tried this expression = SUM(Fields...more >>

Select All Option in parameters
Posted by Reddy at 7/19/2006 7:26:01 PM
I know post of you know the answers to my question. Here is my question. Select All option works fine in my report parameter but when I unselect select all option and select multiple value it wont work. example: Select company,Comp_Id, state, city from company_info where (Comp_Id in (@r...more >>

Using Multiple Data Sets in a Report
Posted by Chris Taylor at 7/19/2006 4:54:57 PM
I was asked this question today by someone wanting to have multiple datasets in a report. Such as --Main report - GL Account Header - sub report data - GL Account header - sub data - sub data We are making a ton of SQL calls to execute this report and it takes f...more >>

New Folder button missing
Posted by DBA449 at 7/19/2006 11:15:02 AM
After installing reporting services we noticed that the New Folder button is missing as well as the contents tab. This has worked on several other systems that we installed. We referenced reporting services by typing in the browser http://localhost/reports. Any ideas on why or how to diagnose...more >>

height and width of the graph to be dynamic
Posted by venkat.oar NO[at]SPAM gmail.com at 7/19/2006 11:09:58 AM
Hi, I am using a "simple column"graph. on the Y axis, the Interval property is set as 100, the problem what i am having is if there are more # of plots on Y axis, the intervals all overlap on each other. Is there any way we can set the height and width of the graph to be dynamic?. --Ven...more >>

Where are the Report Files on the IIS Server?
Posted by ME at 7/19/2006 10:26:29 AM
I am looking for the RDL files and the RDS files on the IIS server but can't find it. Let's say someone created a report project on his laptop, didn't put it in VSS. Now if he leaves the company assuming there is nowhere we can find the RDL files and RDS files, where can we look for them on ...more >>

Report Server is not responding for XP2 sp2 and SQL Server 05 Dev
Posted by adam at 7/19/2006 9:23:01 AM
I am encountering this issue when I try and go to the Report Server url http://localhost/reports I get the message: "The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version." I get the same message when...more >>



Export to Excel
Posted by Gaurav at 7/19/2006 8:23:01 AM
Hi, I am new to reporting services. From the HTML toolbar, if i try to export to excel... i get the entire report. eg. if i have 3 sections in the report s1 - header s2- data s3 - footer all 3 of them are exported to excel. I want to export only the data section (s2). Is that possib...more >>

Windows Mobile
Posted by Nick at 7/19/2006 7:03:02 AM
Is it possible to run reporting services reports from a windows mobile browser. I can access the report server and it tries to render the reports but only the header section up to the parameters. No report body. Is this just a problem of the reporting services /pocket IE or some setting I can ...more >>

SSRS needed for BI Studio or .NET control- ReportViewer.....
Posted by Peter at 7/19/2006 6:37:01 AM
I have three questions as below: 1. Is a SSRS needed for BI Studio to develop a report ? 2. Is a SSRS needed for the ReportViewer control in a .net application? 3. When a window form using a reportViewer to host a report, is it much more efficient when processing a heavy-duty report because th...more >>


DevelopmentNow Blog