[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...