Publishing A View In Excell With Parameters
Mar 9, 2007
Hi
I am publishing a SQL view in excell using the external data/new database query option and accessing SQL server via ODBC datasource defined.
The query I use aggregates data between 2 diferent dates. I am able to pass the initial date and the end date to SQL, but the results are not aggregated becase I am forced to put in the view the GroupBy clause for the field DATE.
Is there any way of passing parameters to SQL (via Excell) and retrienve the aggregated data based on this parameters?
Many Thanks
ds9
View 3 Replies
ADVERTISEMENT
Oct 31, 2007
Hi,
I have couple of Web pages linking to my RDLs using report viewer Web controls. I have no problem running and viewing them in VS2005 debug mode and report manager until I published them to local folder and set the local folder as an application on my IIS7. When running the published version of the Web pages, all my calendar image buttons (which happen to be part of the report parameter fields) turned to red 'X':
http://dyzimw.bay.livefilestore.com/y1pwxE9mLpX4JV7e438WA4DeGwu6YHQOkRoC20r_EhQ5uoXkt15dqs99LmiDSTauSvUCno9HnOwYKR34rPpFYA_lQ/ssrs.jpg
When clicking the View Report button, the animated progress icon not appearing at all. Before the occurance of this problem, I did face the problem whereby the 'NT AUTHORITYNETWORK SERVICE' does not have enough permission to view the report. After referring to some threads, I finally be able to get rid of this error by assigning Browser role to 'NT AUTHORITYNETWORK SERVICE' from the report manager. I wonder could this solution be related to the problem that I'm facing now. Any help would be appreciated.
Thank you.
Regards,
Antonio
View 1 Replies
View Related
Nov 21, 2005
Hi all. i hope you can help me.
I´m exporting an ado recordset (SQL Server) to Excel from vb6.
This is what i´m doing but it only works on local server
********************************
Public Sub Export()
On Error GoTo Error
Dim strSheetName As String
Dim Conn As New ADODB.Connection
CDB.DialogTitle = "Exportar Datos"
CDB.Filter = "Archivos Excel (*.xls)|*.xls"
CDB.FileName = "Bitacora"
CDB.ShowSave
CDB.CancelError = True
If CDB.FileName = "" Then Exit Sub
If Conn.State = 1 Then Conn.Close
Conn.CursorLocation = adUseServer
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" & CDB.FileName & "';Extended Properties=Excel 8.0;Persist Security Info=False"
strSheetName = "CREATE TABLE `Bitacora` (`IdUser` VarChar (3) ,`IdMenu` VarChar (20) ,`Fecha` DateTime ,`Referencia` VarChar (60) ,`Actividad` VarChar (120) ,`IP` VarChar (15) ,`HN` VarChar (15) )"
Conn.Execute strSheetName
If Conn.State = 1 Then Conn.Close
Conn.Open SisSession.SisConeccion
strSheetName = "insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=" & CDB.FileName & "; HDR=YES', 'SELECT * FROM [Bitacora]') " & AdoData.Source & ""
Conn.Execute strSheetName
MsgBox "Datos Exportados en " & Chr(13) & CDB.FileName, vbOKOnly + vbInformation
Exit Sub
Error:
If Err.Number = 0 Then Exit Sub
ProcessError Err, Me.Name & " - Exportar", , , True
End Sub
*******************************************
Whe in configure the app for a network server it gives an error.
OLE/DB provider returned message: Microsoft Jet culd not find the object 'Bitacora'. Make sure the object exists and the route is ok.
This i assume is because the cange of the server from local to remote.
Can you help me with a solution?
View 1 Replies
View Related
Sep 14, 2005
hello All,
Am not sure if this is the right forum to post this. But here goes
I have a phone book, which users could enter numbers via a web interface and a SP.
However i was wondering how to generate a bulk insert script, that would
Import from an uploaded excell workbook to MS SQL
How could this be done
NOTE: Am doing an upload via an ASP page, then hoping that either the ASP page, via a SP or an SQL command Statement do a bulk copy for the user who uploaded it to my SQL table
difficult ???
Thanks Anyway
Afrika
View 5 Replies
View Related
Sep 19, 2005
I need to import data in several hunderd excell spreadsheets to a sql 2000 table. What function should I use? Do I need to create a table in sql with the same columns as the excell file and then run a query? Iam pretty new to sql, so please be gentle
View 4 Replies
View Related
Mar 4, 2008
Hello, i'd like to know if it's possible to export to excel from SQL Server Management Studio Express (maybe with the toolkit?). Or if there is freeware that can export the dataset of a custom query (or a view) to an excel or CSV file?
thanks,
Leon
View 2 Replies
View Related
Sep 18, 2002
Can I pass a parameter to a view? Can something like this even be done?
CREATE view co_interlinks1
AS
SELECT [TDirectorships].[IDDir], [TDirectors].[DirLName] + ', ' + [TDirectors].[DirFName] AS DirectorName, [TDirectorships].[Ticker], [TCompanies].[CompanyName]
FROM TDirectorships
INNER JOIN TCompanies
ON [TCompanies].[Ticker]=[TDirectorships].[Ticker]
INNER JOIN TDirectors
ON [TDirectorships].[IDDir]=[TDirectors].[IDDir]
WHERE [TDirectorships].[IDDir] in (SELECT [TDirectorships].[IDDir]
FROM TDirectorships
WHERE Ticker=@Ticker)--This line requires a variable value corresponding to Ticker for the chosen company
and [TDirectorships].[Ticker] <> =@Ticker --This line requires a variable value corresponding to Ticker for the chosen company
View 2 Replies
View Related
Sep 13, 2007
Trying to create a view with parameters. I want to use view inside the SP. But I'm getting an error. Why?
-- 1st
-- drop table funkete
create table funkete (funketeid int, funketeFname varchar(20))
insert funkete
select 1, 'funkete' union all
select 5, 'amanda' union all
select 6, 'funkete'
go
-- 2nd
-- drop proc a
create proc a (@funketeid int)
as
select @funketeid, funketefname from funkete
go
-- 3rd
exec a @funketeid = 4
go
-- 4th
create view vw_funkete4 as
declare @funketeid int
select @funketeid, funketefname from funkete
go
=============================
http://www.sqlserverstudy.com
View 6 Replies
View Related
Nov 18, 2005
i have data on a spreadsheet and i need to read it to a table in SQL server ? how can i do that ? some one refere to me a method for that but i need to see what other think is the best option and the most effecienet way let us say!!
View 4 Replies
View Related
Mar 7, 2006
Hi, I am using sql server 2005 entreprise edition. I am just wondering
when I have a report with parameters and the report uses stored
procedure to retrieve the result set for use in the report, if two
people from different places are trying to view the report at the same
time, and each of them use different set of parameters.
Will they be able to view their report correctly??
View 6 Replies
View Related
Jun 7, 2007
The only way the job success is if I select the option add rows wich is copying all rows even the ones that are already there, I tried to drop amd recreate the table option but i just dosn't run that way, help please..
View 1 Replies
View Related
Jan 18, 2007
SSRS - SP2
We have many reports with cascading multivalue parameters. The reports and the parameters work as expected within the BI development and when deployed to the RS server. The issue we are having is that when we go to the Report Manager webpage for one of these reports and create a New Subscription the report parameters in the subscription field fail to populate. The first one or two parameters may properly populate but the 3rd, 4th, and 5th fail to populate. As a result we can not select the parameters to submit the subscription.
We have two example reports where one report uses only sql (text) and the other report uses only stored procedures. Both reports have 2 or more cascading parameters.
Any known issues with cascading multivalue parameters in the Report Manager subscription view?
View 1 Replies
View Related
Mar 12, 2007
I have a stored procedure that takes a date range and returns all the sales in that date range. I'm trying to create the report model for ad-hoc reporting. When I go to create the dataset view, it only lets me select tables or views.... how do I get around this?
View 2 Replies
View Related
Aug 2, 2007
web site made in web dev
db all ok locally
got server at local ip.......
need to upload script files to server...
got microsoft publishing wizard all working and database all scripted out.
server consul looks like horrible unix outfit.....virtuozzo
question is now what?
ip says use enterprise manager to publish to server......is that the old
version of management studio express, which i have
View 17 Replies
View Related
Jun 22, 2001
Hi Guys,
I have been trying to use SQL Server 7.0's Web page Publishing tools with Microsoft Frontpage without sucess. I can created the web pages using SQL that it works fine. I have the page set to change automatically when the data is changed and this works while the page is accessed from the SQL Server, however when I upload the page to a frontpage Web, the automatic update does not work. Any ideas what I'm doing wrong?
View 7 Replies
View Related
Jan 16, 2001
Dear All,
I am experimenting with the Web Publishing feature in MSSQL 70. Does anyone have any pros and cons when utilizing this feature within MSSQL 70?
I also would like to ask if anyone knows of a different way to access the Web Page designed other than placing it in an accessible file either in a repository or a central site and have people click on the *.htm document thus pulling up the related page on the W3.
Has anyone been able to go from the MSSQL 70 directly to a browser instead of opening the created *.htm file?
Please let me know.
TIA,
Daimon
daimon.russell@bridge.com
View 1 Replies
View Related
Nov 14, 2001
Hi everybody ,
can't see web publishing icon on any of 6 Sql 2000 servers
What has to be set first ?
Thanks
View 2 Replies
View Related
Sep 23, 1999
We are experiencing intermitant problems on out SQL 7 system. Its running FTP publishing, MS SMTP service and the www publishing service. We reset the services using net stop <service> each morning. When I use the command 'net stop www publishing service' I get the message - The service could not be controlled in its present state. This would indicate that the service has hung. The problems seem to happen over night and is cured by a reboot.
Any ideas anybody ?
Thanks in advance
View 1 Replies
View Related
Aug 16, 2000
When managing publication for a particular database, not all the tables are listed as articles to add to the publication. Is this a permissions problem? Any way I can check out why they aren't available or, better yet, make them available for the publication?
View 2 Replies
View Related
Sep 24, 2001
Hi!
How is it possible to set up a repl. scenario, where a subscriber of a DB
is also the publisher of this DB for other subscribers. i mean 3 level repliction. MAINPUB
SUB1 SUB2 SUB3
notebookSUB1...................notebooksubN
SUB1..3 are subscribing to MAINSUB and publishing to a number of notebooks!
Any help would be greatly appreciated!!!
TIA
View 1 Replies
View Related
Apr 11, 2008
Hi,
I have created a data file using SSIS, I want to publish this on a web, how could i achive that any step by step approach is welcome.
Thanks,
With Best Regards,
Madhu
View 2 Replies
View Related
Dec 31, 2006
My test sql seems to be working like a train now. Also now discovering the full functionality
of sql and can see that im at the bottom of a large hill, but an interesting one.
My next problem is publishing.
My hosting package has been upgraded to the version 2.0 asp.net runtime. and has sql enabled.
web dev.......copy function drops all the files into the server nicely and i can see them all.
The problem is it will not compile or show, and returns.........you do not have privaleges to view this htm.
All a bit strange to me but???
I have not touched any of the security controls in the config manager or code.
Anybody else had these issues or problems
regards Richard
View 1 Replies
View Related
Jun 29, 2006
Hello to everybody.
I got a problem like this:
I developped a project using Visual Studio 2005 Standard Edition on a XP pro x64 Machine using a developpemet data area on a SQL 2005 Express Edition.
Everything is ok, even the user and profile management. But when I try to publish my application on IIS (we're talking about a little Intranet), I get my problems. I think is important to say that the server is a Windows Server 2003 and data (database reproduced as a backup of the developpement one) are under an SQL 2005 Standard. The strange thing is that by publishing the "site" VS create a DB under SQL Std named with the path of local ASPNETDB.MDF.
I can reach everything, all data are ok, but when I pass the login page going to main menu on my web-application, I get this error:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
I think the problem is SQL STD and the fact that it's not "able" to manage MDF files.
I even tried to re-map the SQL DB (named simply as ASPNETDB on the SQL std) by adjusting the web.config file on connection type and user and password to reach the DB ASPNETDB but it does't work anyway.
Can anybody solve my problem?
Thank You
View 4 Replies
View Related
Apr 18, 2007
I am using ASP.NET 2.0 C#, SQL Server 2000Connection string is: "Data Source=USMAN;Initial Catalog=CMS;Integrated Security=True"
And by searching forums and goodle, I have also set sql server 2000's secutiry as mixed modeInfact When I compile and run my projcet from visual studio it is fine, every thing works ok
Then I publish my site to a folder on desktop, when publishing completed I right clicked the folder and in web sharing option I added alias = CMS
Now when I open: http://localhost/CMS/Home.aspx, then it works fine infact all the pages that dont have SQL Server 2000 connectivity work fine, but as soon as I open some page that has connectivity with the database, it gives me error like:
Login failed for user'USMAN/ASPNET'
I wonder why this error only comes after publishing, there is nothing probemaltic when running it from Visual Studio, plz tell me what to do
View 1 Replies
View Related
Apr 20, 2007
HI,
I am working on a project in which a user can upload his database to the server...then he is able to view all the schema or execute any kind of query. Then he goes to some other machine and login and wants to download the database.
For example Alex have uploaded the database consisting of 1000 records to mysite. Then He goes to texas to find some oil wells. He is on another machine ... I download the database .... inseert new records and upload it back.
Its an example basically I want to know how to include the users' uploaded into my sqlserver and when required publish with data on his machine...
Thanks.
View 4 Replies
View Related
Aug 26, 2007
I've been working with the Database Publishing Wizard and have found what I initially thought was a bug but have decided is a rather nasty "feature". Or am I missing something?
I have membership implemented in a live database. I took a backup and loaded it into a local database. I created a new table locally that is foreign-keyed off aspnet_roles, and added some data.
Using the Publishing Wizard for a partial deployment, I followed the steps which seem perfectly clear to script out ONLY the new table and its data. The screens provide a nice GUI for selecting specific database objects, and I carefully chose the one new table.
From good habits I looked at the script before deploying it. It drops and recreates aspnet_roles and aspnet_applications as well (and inserts the data from the development tables).
Presumably this is because of the foreign key relationships. But there's no need to do so. What if I or another developer had added in some roles to the live table in the meantime? This script would blow them away.
Am I missing an option with the Wizard that would script out only what is specified? I've tidied up the script (i.e. removed the undesirable sections) - but this seems to be a naughty wizard. Any thoughts?
View 5 Replies
View Related
May 27, 2008
We are trying to script out database schema and data with the Database Publishing Wizard and are having problems with output script trying to create views and stored procedures before the tables they depend on.
I've seen discussion of this on their codeplex site and back in April 2007 they said that the CTP they just released fixed the problem - but we are still seeing it. Does anyone know a solution for this (beyond the obvious copy and pasting into the right order)?
What we are trying to do is move the SQL and some basic reference data into source control and a CI process.
View 2 Replies
View Related
Dec 22, 2004
Hey all,
I received this publishing error a while back and can't think of a reason I would be receiving this error.
SQL error occurred. See entry specific information. Error : 21010, 01000, [Microsoft][ODBC SQL Server Driver][SQL Server]Removed 0 replicated transactions consisting of 0 statements in 6 seconds (0 rows/sec).
The error came just before another error:
SQL error occurred. See entry specific information. Information : 1205, 40001, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 62) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
I'm wondering what would cause these errors, if someone could point me in the right direction that would be great.
Cheers,
-Kilka
View 2 Replies
View Related
Jun 11, 2008
Sir,
I have created reports in SQL Server reporting services(SSRS)and when i publish the report in the Localhost server it can be viewed in browser only in the INTRANET network but my intention is to generate the INTERNET URL of the report such that report published can be viewed in INTERNET outside this network..
Can u suggest any solution to do the same..
Looking Forward to an early reply..
Thank You!!!
View 1 Replies
View Related
Feb 11, 2007
Hi All,
I have developed a database application using c# and SQL Express 2005.
I have coded a connection string that works fine on the development machine but upon publishing to another machine I am getting the following error message:
Cannot open database "name of database" requested by the login. The login failed. Login Failed for user "machine nameuser name".
The remote machine has SQL server express installed.
Now on the development machine the machine name and user names are different to that on the remote machine. I am using Windows Auth. The application successfully runs on the remote machine. It even updates the same database (as mentioned in the issue above) on a different form which all connection strings etc were created automatically by c#. I'm pretty new to all this and don't know where to go from here.
Any help would be greatly appritiated.
Thanks
Jon.
View 3 Replies
View Related
Jun 5, 2007
Hi!
I have a rdl file and would like to publish it programmatically? Is there any API or Web Service available for this.
View 1 Replies
View Related
Jul 8, 2006
hello All,
i am trying to delete publications in SQL 2000, SP4 and getting this
error:
SQL Server Enterprise Manager could not disable publishing and distribution on '<publishername>'.
Error 3724 : cannot drop the procedure
'dbo.sp_sel_F854ED4CD7EA4399EFDB9697F4E24A10_pal' because itis being used for replication.
Thanks and Regards
Kanna
View 1 Replies
View Related
May 7, 2008
Anyone know how I can direct different reports in the same project to different folder on the SSRS site? I can get everyone to publish to one folder, but want to know if its possible on a report/report basis to different folders
View 3 Replies
View Related
