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 2007 > threads for friday may 18

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

View Question
Posted by Ryan Mcbee at 5/18/2007 1:12:00 PM
I have the following syntax: "select itemnmbr, locncode, (qtyonhnd-atyalloc) as "QTY Available Main" from iv00102 " The results look like; Itemnmbr locncode qty available main 121 944-16 90.00000 121 944-16 ...more >>


Administering via SQL Mgmt Studio
Posted by LTC at 5/18/2007 11:28:00 AM
Are BUILTIN\Administrators (local admins on the server) the only persons allowed to use the SQL Server Mgmt Studio (SSMS) to administer Reporting Services (SSRS)? Can others who may have the Content Manager Role on a folder or that have the System Administrator Role use SSMS? So far my exp...more >>

SSRS - Retrieving XML data from a web service/calling web service from report problems...
Posted by Jay at 5/18/2007 11:12:21 AM
OK I've been trying to both make my own example, as well as, get the Microsoft examples located here to work: http://msdn2.microsoft.com/en-us/library/aa964129.aspx ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/d23408e5-e65b-4f49- a98f-234454d5d267.htm I just want the report to call...more >>

Extracting SQL From User Created Reports Produced in Report Builde
Posted by Rikesh at 5/18/2007 8:50:00 AM
Hi We have RS2005/SS2005 running as part of our company MI system. We have many users creating reports using Report Builder, I was wondering is there anyway, in which we can work out what data is utilised in the reports, since we are getting many duplicate reports and would like to perform...more >>

Dual Y Axes in RS2005
Posted by KF103 at 5/18/2007 8:19:58 AM
In RS2005, is it possible to have a chart with dual Y axes? ...more >>

A single group spanning pages...
Posted by Michael C at 5/18/2007 8:10:02 AM
Is there any way to identify if a group is going to be split between pages? I basically want to put a "product XXX continued on next page..." at the bottom of the page if the group is going to be split. Thanks in advance. Michael ...more >>

Admin. of SSRS via SQL Server Mgmt Studio
Posted by LTC at 5/18/2007 7:18:01 AM
I would like to be able to administer SQL Server Reporting Services (SSRS) via the SQL Server Management Studio (SSMS). It appears, in our setup at least, that the only individuals who are able to use the SSMS are those who are included in the BUILTIN\Administrators group (admins on the serve...more >>

linked matrix together on same page?
Posted by Kevin Blount at 5/18/2007 7:01:31 AM
I have a report that is 2 thin columns: a date and an avg value for that date. Naturally this doesn't take much space on the page, and the longer this report gets the more pages it takes up. Rather than waste this on-screen real estate, I was wondering if it is possible to have the matrix repeat...more >>



SQL 2005 RS Report Manager - load time
Posted by Olof at 5/18/2007 4:54:01 AM
Every morning it takes about 30 seconds to load Report Manager. (But of course next loading is within speed of light). Any ideas how to decrease load time?...more >>

Previewing a URL image in Reporting Services
Posted by _george at 5/18/2007 12:00:00 AM
Hi all I need to place an image from a web site onto a RS report. Is it possible to do this in SRS 2000? IE. http://<servername>/<directory>/<image.jpg> and render the image on the report? Thanks in advance George ...more >>


DevelopmentNow Blog