Hello :
I have a report which calls another report, and I want that everything the links clickable on my reports open one new
window.
I know that there is a way of defining that C# but I managed to make it walked.
Is that you an idea to say that I want everything click on my report call another report but in a new window.
Thank's.
I am trying to open reports through an existing application. When I click the button to run the report, the new window opens, appears to be trying to load (the windows logo in the top corner is flowing, the hourglass is present), and then stops. I am left with a blank window, no report, and no error message.
I am able to view and run the reports through the Report Server. Other users are able to run the reports through the application.
Any ideas?
Thanks,
Michelle
When i giving a url passing some parameter..in Jump to Url of cell navigation properties..
In VS Studio its opening in new window ..but when deployed in server and its opening same browser while my requirement is to open in new window..
I have a report with a hyperlink. When I go to the navigation tab, it does not give me any options to open the link in a new window. I have a link to show help and I do not want the user to actually move away from the reports
View 18 Replies View Relatedhi
I have installed SQL Server Reporting Service on window xp. everything working fine except one thing.
I have installed sql server with my a/c. my a/c have admin rights. when i giving http://dineshpatel/reports it is displaying page but Report Builder and other option are not displaying. I hope i don't have admin rights.
I have checked with local administrator login also but same problem.
what additional setting are require for admin rights?
Dinesh Patel
I have the Function, that fires from onLoad even of one of the asp:Label controls on my main page.
Here is it's code:
SqlConnection conn = new SqlConnection(); conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["UkraineConnectionString"].ToString(); SqlCommand comm = new SqlCommand("SELECT [Greeting] FROM [Misc]", conn);
try { conn.Open(); } catch { Response.Write("Error opening connection in Page_Load of default.aspx to retrieve the greetings"); }
string MyGreet = (string)comm.ExecuteScalar();
Greetings.Text = MyGreet;
try { conn.Close(); } catch { Response.Write("Error closing connection in Page_Load of default.aspx after retrieving the greetings"); } }
When it gests to conn.Open() in the debugging mode I see that the ServerVersion = 'conn.ServerVersion' threw an exception of type 'System.InvalidOperationException'.
The most interesting thing is that it used to work before.
Here is the connection string it retrieves fine.
"Data Source=MDM1;AttachDbFilename=|DataDirectory|Ukraine.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"
As I said it used to work, but one day I tried to access the web site and it said this error that I get, that the connection is closed. Then I was using the SQL Server Express. When in the Visual studio if I would run this same site in debug, everything was working fine. I decided to uninstall the SQL Express and installed the SQL Server.
If I open the SQL Server Managment Studio in the Server name field I see MDM1(this is the name of the PC, but probably it is the same name for the Server. Well, in the MAnagment Studio it conects fine to the MDM1 so it is no probably the naming problem. Ithink it has something to do with permisssions.
If someon can - please help. Thanks.
Hello,I have a C++ / MFC app which uses CDatabase and CRecordset to connect to aODBC data source for a SQL Server 7 database. The application workedproperly with a MySQL database, but after swapping it for SQL Serverproblems emerged. In particular, any calls to CRecordset::AddNew() andCRecordset::Edit() cause an exception to be thrown with the error message"Recordset is read-only". Stepping through the code for CRecordset::Open(),I can see that it indeeds fail to open the recordset with SQL_CONCUR_ROWVERand SQL_CONCUR_LOCK, finally succeeding with SQL_CONCUR_READ_ONLY. I need tobe able to write to the db!! What is going on here??I call CRecordset::Open() with no SQL string and no options (which defaultsto full access and not read-only).I am not a SQL Server expert, but I tried playing with the config a littlebit:- The database is NOT set for read-only.- The database option "Restrict Access" is NOT selected.- I checkmarked all permissions (SELECT, INSERT, UPDATE, DELETE, DRI)for my app's user on all tables in the db.- My connection string uses the user 'sa', which is the login name forthe user 'dbo'.In the ODBC data source config, I set authentication to SQL Serverauthentication, and accepted the default for all the other options.I haven't tried using a different class (say, CDaoRecordset) nor do I planon doing that. I really need to get this to work with CRecordset. Any helpis appreciated.Thanks,SL
View 3 Replies View RelatedHey guys i have installed SQL Server Express and getting a problem. Every time I use the runcommand and enter sqlcmd. It opens the window but then I cannot enter any information into it. And after a while the window just closes.
Anyone know the reason for this?
Dallr
several months ago I briefly set up a data source, tested it and created a very simple report.
I now have an chance to get back into it and when I am at the SSRS Home page and click the button to start "Report Builder I get the yellow bar at the bottom of the page like I'm trying to open a file. It says: "Do you Want to open or save ReportBuilder_3_0_0_0_0.appliation(15.2 KB) from caholoweckyw7" and then the Open, Save and Cancel buttons. If I click open, the actual XML code behind the page appears and the application does not start. ?
The data source has been created and the connection has been tested successfully. I am running SQL Server 2012 and Windows 7 and IE 9.
Is there anyway to disable this functionality?
View 7 Replies View RelatedHi everyone In my SqlServer Management Studio Express, on start up it shows the server type option, but greyed.So that value is fixed to database engine. ( I'm trying to work on an SqlServer Compact Edition database through the SSMStudiothat's why I'm trying to get this to change.)Besides, after I connect i go to the Object Explorer, expand the server node, and go to Replication.When i expand replication, i get the "Local Subscription" option, but nothng for Publication.( I want to work on Merge Replication, that's why I desparately need Publication to work)Am i missing something here? I did not install SqlServer separately, I only have what comes bundled with the Visual Studio 2005 Setup.
View 2 Replies View RelatedI have created an Access2003 project (existing data) that links to external data. First I connected to a SQL Server 2000 database. Success. Then I tried to set up a Transact SQL data connection to a legacy MDW-secured Access97 database. (A third-party VB6 application goes against it, and we don't have the source code, so we cannot upgrade it.)
The Transact SQL link tests OK but I cannot select any of the tables or queries from the list presented. However, with the same credentials, I can use these same objects in Excel 2003.
When setting up the link in Access2003, I specify JET 4.0 OLE DB Provider, I enter the MDW file on the All tab, a username and a password on the Connection tab where I browse to the MDB file, and specify Shared Deny None on the Advanced tab. When I test the connection, it tests OK ("Test connection succeeded"). Yet on the "Select the Database and Table/Cube which contains the data you want" dialog, "(Default)" appears in the grayed-out dropdown. Then, beneath that dropdown, there is a grid with Name and Description columns. The grid contains query names but the grid is not enabled. The list of queries is this table is grayed out. Neither of the scrollbars works.
BUT... if I use the SAME username and password in Excel2003, and specify the same MDW, there is no problem working with these same database objects in the legacy Access97 database. WHAT IS DIFFERENT ABOUT THE WIZARD IN EXCEL THAT ALLOWS IT TO SUCCEED AND THE WIZARD IN ACCESS THAT CAUSES IT TO FAIL HERE? In Excel, the list of available providers says Microsoft Access Driver, not JET 4.0 OLE DB Provider.
Thanks
TR
When trying to link to an SQL table in Access 2003, the software appears to be malfunctioning.
The sequence of events is File - Get External Data - Link Tables - Files of Type: ODBC Databases().
The Problem: On two of my computers, the select data source window does not pop up, preventing me from linking to any ODBC data source.
Observations: This function has worked normally in the recent past and works on other computers running Access 2003. One difference between the computers working and non-working computers is Norton Antivirus 2006 (recent upgrade).
Has anyone experienced anything like this? What's going on?
Dear members,
In MSDN, it says that it is recommended to use windows authentication to connect to SQL Server rather than use mixed authentication.
I create user deltasqluser on windows OS, and I specify in my webform ASP.NET script below :
protected System.Web.UI.WebControls.Label Label1;
private string _connString = @"data source=deltasql2000;initial catalog=northwind;integrated security=false;user id=deltasqluser";
/*
comment : I login to my windows as deltakoronx, and I want to every user (including me), connected to sql server through IIS, will be identified as deltasqluser not as user's login (impersonate)
*/
private void Page_Load(object sender, System.EventArgs e)
{
SqlConnection conn = new SqlConnection(_connString);
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select suser_sname()";
conn.Open();
string userName = cmd.ExecuteScalar() as string;
conn.Close();
conn.Close();
Label1.Text = userName;
}
at web.config, I add :
<identity impersonate="false" userName="deltasqluser" password="" />
at IIS webApplication1's properties, tab "Directory Security", at "Authentication and access control" section, I checked "enable anonymous access" with user : DELTAIUSR_DELTA and checked "Integrated Windows Authentication",
at query analyzer, I login as "sa" and execute script below :
exec sp_grantdbaccess 'deltasqluser','northwind'
when I run the ASP.NET script, error at conn.Open(); with error message :
Login failed for user 'NT AUTHORITYNETWORK SERVICE'.
What should I do so that IIS login to SQL Server as user deltasqluser not as "NT AUTHORITYNETWORK SERVICE" ?
Regards,
Koronx
when i click on the modify option on a stored procedure it is not opening for editing as earlier. it opens as if for scripting.for example i clicked modify procedure on stored proc. "text" and the result is as follows.
/****** Object: StoredProcedure [dbo].[test] Script Date: 05/01/2015 7:50:08 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[test]') AND type in (N'P', N'PC'))
[code]....
Hi,
I am using SSRS Microsoft SQL Server Reporting Services Designers
Version 9.00.1399.00. I want to open linked report in new window.
I tried whats mentioned in http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=240172&SiteID=1 but i get an error on Window.Open method.
How do I solve the problem?
Thanks
So I started a new job recently and have noticed a few strange configurations. Typically I would never mess with min memory per query option and index create memory option configuration because i just haven't seen any need to. My typical thought is that if it isn't broke... They have been modified on every single server in my environment.
From Books Online:
• This option is an advanced option and should be changed only by an experienced database administrator or certified SQL Server technician.
• The index create memory option is self-configuring and usually works without requiring adjustment. However, if you experience difficulties creating indexes, consider increasing the value of this option from its run value.
made my first web application using vb script. I am trying to use window authentication for my web page and try to give all permission based on window domain user account. Here is the connecting string I was using to connect to the sql server and it was working fine.
Protected Const sql_connection_string As String = _
"workstation id= DATA-02;" & _
"packet size=4096;" & _
"user id=ASP;" & _
"password=ASP;" & _
"data source=ARENS-DATA-01;" & _
"persist security info=True;" & _
"initial catalog=SupplierTrack;"
I made couple of changes so it run on based on window domain user.
1) my server is set on window and sql server
2) Web.config file – I set Authentication mode = “ Window�
3) I also added under set <authorization>
<deny users="?" />
</authorization>
4) change the connecting string to : ( Added "Integrated Security=True;" and removed line for user and password)
Protected Const sql_connection_string As String = _
"workstation id= DATA-02;" & _
"packet size=4096;" & _
"Integrated Security=True;" & _
"data source=ARENS-DATA-01;" & _
"persist security info=True;" & _
"initial catalog=SupplierTrack;"
5) run the application and now I am getting error said “Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.�
I was expecting window pop up log in to enter domain user and password and then verity the user and password against sql server and the take it from there. Where I made mistake. Need help.
How can I call the SQL Server environment from a MS DOS window ?
Is there a command to do that ?
I know i type SVRMGR23 using Oracle...
Thank you.
I need to make a homemade Search form for my users....one that they can press a button type in lastname or TM#, FirstName or SSN and BAM!!!!!! theres the results populated on the form. Anyone know of any good sites where I can obtain some info on how to create one of these or something??
View 9 Replies View RelatedRunning sql server 2005 standard edition (SP1).
Server properties, permissions window seems to be different to what it should be.
In this window I do not see System Administrator and System User column. I see a different window i.e. permission, Grantor, Grant, WithGrant, Deny columns.
Any thoughts please?
Thanks
hi frnds,
i want to view the runtime variable value in the watch window while the package is running,
how i will get that watch window. i searched all the menus but i didnt get it.
im using Microsoft Visual Studio 2005 for SSIS package.
Hello Guys,
One of the fields in my report is a web address (i.e. http://www.yahoo.com). Navigation property for this field is "Jump to URL". Users will access the report with a browser, using a "sharepoint-like" application. Default behavior of "Jump to URL" seems to be to open the link in the same window (or tab in IE7). Is there a way to force the link to be open in the new window?? Please let me know if you have any suggestions. Thanks!!
I honestly don't see where to view the watch window. Can someone please advise.
Thanks
hi, I got a problem with reporting services 2005.
I have to create a link activated by clicking on an image.
In the image navigation properties I inserted the link in "jump to url" but the problem is that no new window is opened, the url is opened in the initial report page.
I tried to use jscript this way:
javascript:window.open("myurl","", "scrollbars=yes,width=800,height=600,left=0,top=0");
but in this case the url opens in a new window but a blank page is shown in the report page.
How can I solve this problem and open the url in a new window without changing the report page?
Thanks in advance and sorry for my english
Hi,
In my report, I would like to have the following functionality :
The report will have a table with table header columns. If the user clicks on the header column, a window or text box should show up specifying the rules how that cloumn is calculated.
I can do that through sub-report, but I cannot use subreport, according to our specifications.
Please help me
thanks
I have areport which needs to jump to another report when clicking on a text box.
I have used the following code in the jump to url
= "javascript:void(document.open('http://houapps277/ReportServer/Pages/ReportViewer.aspx?%2fIMS-Reports%2fCR000619','_blank'))"
This does not open any page and when i rightclick to open in new page it gives the url as
javascript:void(document.open('http://houapps277/ReportServer/Pages/ReportViewer.aspx?%2fIMS-Reports%2fCR000619','_blank'))
This works fine though when I give this in jump to url and google opens
= "javascript:void(window.open('http://www.google.com/','_blank'))"
What am I doing wrong here.
Thanks
Hello All,
I am wondering if someone can shed some light on how to display "Variables" window in Integration Services. I am trying to add a new variable by clicking SSIS menu, and choosing Variables. However, the Variables window never showed up. Is there some property settings that I need to set before I could view the Variables window?
Your help is much appreciated!
-Lawrence
I just upgraded to Windows Vista and now am told that it does not support SQLServer 2000 nor will it. My question is; will I be able to write code for my website which runs off of a remote SQL 2000 using Visual Studio 2005? From what I have read Microsoft seems to be saying that SQL 2000 is not and will not be supported and that only ODBC drivers and providers will function with either classic ADO.Net or ADO.Net 2.0, am I misunderstanding? I am particularly wondering if I can still create stored procedures etc. I have re-loaded my VS 2005 and I do not see any of my SQL 2000 connection objects in the Server Window. Sure looks to me like a major disaster for anyone upgrading to Windows Vista that is using SQL 2000. I hope I am wrong.
View 1 Replies View RelatedWhen I start the server agent - it opens up a black (command prompt type) window that seems to serve no purpose - that I know of yet.
What is this and can I stop it opening up all the time?
Thanks
JB
Is there anyone can help me to run window when after done with installation, i wana open but i got message" this installation package could not be opened. verify that the package exists and that you can access it. or contact the application vedor to verify that this is a valid Windows Installer package" My comp is running w/ Win home XP. thanks
View 1 Replies View RelatedI have an desktop app that uses a system DSN to access SQL Server 7. I backed up a database from another machine and restored it on my machine. Now when my app starts, it prompts for login/pw for SQL Server. I have checked my ODBC connection, and the login and pw are correct. I have also used Enterprise Mgr to check it in SQL Server. Does anyone have any thoughts on why it is now popping up? Drop me a line at bcarlson@documentsolutions.com, and I can answer any questions. I was wondering if any info about the prev machine exists for the database (on the restore)?
Thanks,
Brian
Hi,
On sql server 6.5 running on a win/nt platform my Current Activity window comes up blank when I click on it. Everything else seems to be working fine. This is a new problem, it just stopped reporting any info when I click on it.
Any suggestions would be greatly appreciated.
Thanks,
Jerry