Darren DICK
darrend at nimble.com.au
Mon Feb 20 22:33:14 CST 2006
Hi Francisco Microsoft SQL Server Report Designer Version 8.00.1038.00 - Dunno if that is RS 2000 or RS 2005 The SPROC returns various SQL statements depending on what is passed to it So I think it is a select from aTable - Dunno what a Cursor is - apart from a mouse cursor Thanks Darren ------------------------------ T: 0424 696 433 -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Francisco Tapia Sent: Tuesday, 21 February 2006 3:21 PM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] RepServices: Binding a table to a StoredProc is this RS 2000 or 2005? in your sproc is it a select from a table or temp? or cursor?... i've had the best luck on sprocs declaring a variable dummy table up front to get the fields I need... ie, declare @dummy Table (Field1 int, field2 varchar(8), ...) On 2/20/06, Darren DICK <darrend at nimble.com.au> wrote: > > Hi All > I have a table on an RS report > > When the table is bound to a simple Select statement EG select * from > Customers I can then further bind each control on the report to a > field in the recordset. > > EG I select the relevant text box - then from the property sheet I > select from the list of available fields in the 'Value' combo box on > the property sheet > > EG txtCustomer value in the property sheet = Fields!CustomerName.Value > Cool > > But when I change the recordset for the table to a Stored Proc I see > no available fields when I select a Text box and try to bind it to a > value in the propertyy sheet Infact rather than a list of available > fields, all I can see is <Expression> > > Don't know where to go from here - any suggestions appreciated > > Many thanks > > Darren > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > > -- -Francisco http://pcthis.blogspot.com |PC news with out the jargon! http://sqlthis.blogspot.com | Tsql and More... _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com