Ok, Apply buttons not working in Report Manager

This is weird. I have 2 different installs of Reporting Services and both do
nothing when trying to upload a file (rdl, datasource, etc)
Basically, the buttons don't post. This also happens on the apply buttons
in the property pages. Cancel and other buttons work.
I am thinking I need something in my aspnet_client folder that is not there.
I have the 1_1_4322 folder.
Any ideas?Nevermind...This happens if you misconfigure stuff when moving virtual
directories to another site.
"Eric" wrote:
> This is weird. I have 2 different installs of Reporting Services and both do
> nothing when trying to upload a file (rdl, datasource, etc)
> Basically, the buttons don't post. This also happens on the apply buttons
> in the property pages. Cancel and other buttons work.
> I am thinking I need something in my aspnet_client folder that is not there.
> I have the 1_1_4322 folder.
> Any ideas?

ODBC Text file to SQL conversion

I have a large comma delimited text file (130K records) that I want to convert to an SQL data file. I want to use this data file as a datasource in a Visual Basic 2005 application.

Can I use the txt file directly?

If not, how can I convert/import the data into an SQL data file?

Thanks, Bob

Steve Kass has good info:
http://www.users.drew.edu/skass/sql/TextDriver.htm

You could also use openrowset() to query the data.

exec master..xp_cmdshell 'echo "this is a test" >> c:\temp\test.txt & echo
"this is a test2" >> c:\temp\test.txt'
go
select *
from OpenRowset('Microsoft.Jet.OLEDB.4.0',
'Text;Database=c:\temp\;HDR=NO',
'select * from test.txt')

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!
>