ODBC no Stored Procedure

I create an ODBC connection to my datasource. Then in my data set i
only have a "Text" and no "Stored Procedure" in the drop down list.
How do i go around this and why is only "Text" available when using an
ODBC connection?
Thanks!I use ODBC extensively. For my stored procedures I use the generic query
designer. I have the command type of text and then put something like this
in:
pr_rpt_by_date_shift ?,?, 3
I usually first get it working by hardcoding the parameters and then I put
in the query parameters. Note that you have to use unnamed parameters. Then
you map those to the Report Parameters.
I am going against Sybase but it should act the same for other databases.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"muris" <rmuris@.hotmail.com> wrote in message
news:1114027214.114796.4340@.z14g2000cwz.googlegroups.com...
> I create an ODBC connection to my datasource. Then in my data set i
> only have a "Text" and no "Stored Procedure" in the drop down list.
> How do i go around this and why is only "Text" available when using an
> ODBC connection?
> Thanks!
>|||Ok, in generic query designer i have:
sp_qtrsumrpt ?, ?, ?, ?, ?
since my stored procedure takes in 5 parameters.
I'm able to get the list of the fields, but when i hit execute and in
the "Define Query Parameters" enter my parameter values, i get an error
message:
ERROR [42000][Microsoft][ODBC SQL Server Driver][SQL Server] Line 1:
Incorrect syntax near 'sp_qtrsumrpt'
How do you hard code your parameters and how do you map the unamed to
the report parameters? I'm not able to acomplish it! :(
Thanks!|||I answered this earlier today but I don't see my response here. When I get
into to work I'll see if it wasn't sent for some reason.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"muris" <rmuris@.hotmail.com> wrote in message
news:1114032042.597762.157350@.o13g2000cwo.googlegroups.com...
> Ok, in generic query designer i have:
> sp_qtrsumrpt ?, ?, ?, ?, ?
> since my stored procedure takes in 5 parameters.
> I'm able to get the list of the fields, but when i hit execute and in
> the "Define Query Parameters" enter my parameter values, i get an error
> message:
> ERROR [42000][Microsoft][ODBC SQL Server Driver][SQL Server] Line 1:
> Incorrect syntax near 'sp_qtrsumrpt'
> How do you hard code your parameters and how do you map the unamed to
> the report parameters? I'm not able to acomplish it! :(
> Thanks!
>|||By hardcoding I mean do this (obviously I don't know what values you should
be having).
sp_qtrsumrpt '1/1/2005','3/1/2005',25, 2.0, 10
Once it is working put in the ? marks. Then click on the ... and go to the
parameters tab. Sometimes (not always, not sure why it does sometimes and
not others), you should see the 5 parameters. RS then creates (if it did) 5
report parameters. I don't like the name that they create so I go to Report
Layout and the menu Report, Parameters and I change the name of the report
parameters. Then go back to the dataset, click on the ... and remap the
query parameters to the report parameters.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"muris" <rmuris@.hotmail.com> wrote in message
news:1114032042.597762.157350@.o13g2000cwo.googlegroups.com...
> Ok, in generic query designer i have:
> sp_qtrsumrpt ?, ?, ?, ?, ?
> since my stored procedure takes in 5 parameters.
> I'm able to get the list of the fields, but when i hit execute and in
> the "Define Query Parameters" enter my parameter values, i get an error
> message:
> ERROR [42000][Microsoft][ODBC SQL Server Driver][SQL Server] Line 1:
> Incorrect syntax near 'sp_qtrsumrpt'
> How do you hard code your parameters and how do you map the unamed to
> the report parameters? I'm not able to acomplish it! :(
> Thanks!
>