MS SQL Server :: Report Properties Window

No Certificates Available In The Protocols For MSSQKSERVER Properties Window

Apr 4, 2007

I am trying to set up SQL Server 2005 to use a test certificate from Thawte for SSL encryption. I have installed the certificate in the local computer, current user and service account's personal certificates folders. I have also installed the root certificate in the Trusted Root Certification Authorities folders of each. All this was done using MMC.

However, when I go to tell SQL Server to use the certificate, no certificates show up in the drop down box. I am using SQL Server Configuration Manager and doing the right-clickPropertiesCertificate steps shown in multiple KB and forum articles.

I have also checked the registry entry at HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerMSSQL.1MSSQLServerSuperSocketNetLibCertificate. It is blank, which tells me SQL Server should be looking in the certificate store.

If I simply set the ForceEncryption flag, SQL Server starts up OK and generates a self-signed certificate. Using that, the session does get encrypted. However, I need to use a third party certificate.

I have hit a brick wall and am at a loss. Any help would be greatly appreciated.

View 10 Replies View Related

Cannot Access Expression Builder Via Variable Properties Window (no Ellipsis)

Sep 5, 2007

Has anyone encountered this before?

My colleague opens up an SSIS package with variables, many of which use expressions built with the Expression Builder. She cannot bring up the Expression Builder by clicking the ellipsis (...) in the "Expression" Property of the Property Window, regardless of whether "EvaluateAsExpression" is set to True or False.

I can open up this same package and use the Expression Builder just fine. Any ideas?

Apologies if this has been answered already, I did many searches to try to find the solution before posting here.

Thanks much!

Brian Pulliam

View 14 Replies View Related

Integration Services :: Updating SSIS Task Standard Properties Window

May 25, 2015

If, in an SSIS package, you put an instance of an 'Execute SQL Task' task in the Control Flow, in the Properties window, you can see the properties of the task, for example CodePage.

If you double click on the task, the Execute SQL Task Editor appears, with several of the properties which are also in the Properties window, including CodePage.

If, in the Editor, you update the value of CodePage, then click OK, the value of CodePage in the Properties window is updated immediately.

I have written a custom SSIS task, which also has the same properties in the Properties window and in the Editor. The Editor also has an OK button. When OK is clicked, the values of the task properties are updated. An example property is FolderToArchive. If I open the Editor, change the value of FolderToArchive and click the OK button, the value of FolderToArchive in the Properties window is NOT immediately updated.

If, however, I select the FolderToArchive field in the Propertiesd window, it is then updated with the value I entered in the Editor.

How do I get my task to update the values in the Properties window, after changing a value in the Editor, when I click the OK button?

I would have thought I would need something like, in pseudo-code,

Task.Parent.PropertiesWindow.Refresh
where task is of type Microsoft.SqlServer.Dts.Runtime.Task and Task.Parent is of type Microsoft.SqlServer.Dts.Runtime.Package.

View 9 Replies View Related

SQL Server Agent Job Step Properties Window Loses Property Values Containing Semicolon (;)

May 16, 2007

Here's a weird one:

We are setting up a job for the SQL Server Agent via SSMS. The Job Step Type is SSIS.

In the Job Step Properties window, on the Set values tab, you can enter Values to override your package variables - normally all well and good.

However in this particular case, the variable Value contains semicolons ( - it is a Connection String for an ODBC driver. Eg: Driver={Client Access ODBC Driver (32-bit)};system=MYSERVER;...

The behaviour for this Value is weird:

If the Value is not surrounded with double quotes ("), the job fails with "The command line parameters are invalid."
If the Value is surrounded with double quotes ("), the job will run as intended. The catch is: that entry and any subsequent "Set Values" entries disappear next time the Job Step Properties window is opened.

This looks like a bug with the parsing of those strings by the Job Step Properties window?

Or am I missing something?

Mike

View 5 Replies View Related

Open Report In New Window: Window.open Method Gives Error

Jun 26, 2006

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

View 1 Replies View Related

Installing Report Service In Window XP - Report Builder And Other Option Are Not Displaying

Dec 15, 2006

hi

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

View 10 Replies View Related

Jump To Report In New Window?

May 11, 2007

Hi all,

Is it possible to use the "jump to report " action and have the report open in a new window?

regards,

Bill

View 3 Replies View Related

Open A Url From Report In New Window

May 7, 2007

Hello,

I have areport with a text box. The text box is hyperlinked to another report url. The report opens in a new page when previewed with RS 2005 but when deployed the report opens in teh same page from where it is referenced.

How can I set a property with the texbox to always open in a new page the hyperlinked report.

Thanks in advance

'Kiran.

View 1 Replies View Related

How To Open URL In New Window In SSRS Report

Feb 21, 2014

I want to open a pdf file in a new window by clicking on its URL in SSRS reoprt. I heard that it is possible with Java script. So I tried with ="javascript:void window.open('yoururl&rs:Command=Render"')" in the SSRS expression. It is working only for https and http.

But the URL which I want to open is as follows.

ourcompanyname.localsystemsdocumentsabcd.pdf

View 1 Replies View Related

Publishing Report In Window Forms

Nov 27, 2007

I have a dropdown which shows all the available reports on reporting server. What I want to do is when a user select a report from dropdown and click on RUN REPORT button. That particular report will run. I am using VB.NET 2.0 version. One way which i am thinking is to use ReportViewer Control. Is there any other way to publish the reports in window forms or ReportViewer will take care. Kindly guide.

Thanks,

View 4 Replies View Related

Report Window Opens, Remains Blank

Aug 30, 2007

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

View 1 Replies View Related

Displaying A Report In A IE Window Before Changing To An ASP.NET Page

Feb 6, 2008

Hi

I have a strange problem that basically consists of showing a report in Internet Explorer and then using the same Internet Explorer window to show an asp.net page that contains some form where the user can enter some data. In this scenario, the form won't be processed on the server. I really need to know why and how I can work around this problem.

Precisely the problem can be reproduced like this:

Environment: Server: Windows 2003 Standard Server SP1 (German), IIS 6, Client: Windows XP SP2, Internet Explorer 6

First I open a new Internet Explorer Window and let it show me a Reporting Services Report (by entering its url into the address bar). Everything works. Then I change the address to a simple web application's address that is built with asp.net (.net 1.1). The application contains only a form with a submit-button, a text box and a label, that shows the textbox' text after submit was clicked. But when I click the submit button, although the form seems to have been sent to the server (the green progress bar in the status bar is flickering), it's reset. So the label does not show the value I have entered into the the textbox and the textbox itself is cleared. This only happens when the browser was first showing a Report from Reporting Services, so when I open a new Browser Window and go directly to the web app, everything works fine.

It does not happen when I open the Browser directly on the server.

Thank you
Christian

View 3 Replies View Related

Reporting Services Linked Report In A Pop Up Window.

May 15, 2007

Hi All,

We have a j2ee application which uses Microsoft Reporting Services 2005 for reports.

In our JSP page we show and hide an IFRAME for which the src url is given as the Report URL with queryString for parameters.

Is there a standard way to POST data to report rather than passing it to URL in query String.

We also have a linked report.

We need to display this report in a Popup or provide a back button .

How to do this..

Kindly help me in this regard as we are new to reporting services

View 2 Replies View Related

Sellect All In The Parameter Window In Report Builder

Jan 8, 2007

I installed the hot fix RS2005-KB920794-x86-ENU.exe, what supposes to solve the problem that "selection of multiple values in parameters of a report" generated in Report Builder is possible. Unfortunatly, this issue is not solved by the hot fix.

Could you please help me.

Thank you very much for your help in advance.

Best reagards,

Olga Jaufman

View 3 Replies View Related

[urgent]window Application Integrate SQL Report Service

Apr 24, 2008

i am new for SQL server report service, i have a project that need to generate report and integrate or shown on my window application,
so i have a few questions as follows:

1) do i need to add web reference ( report ) to my window application?.
2) how can i preview and print .rdl report within my window application?
3) how to automatically printer report? can this be done by within a store procedure or trigger or in window application?

ps: view reprot manager, ---- http://localhost/reportserver$SQLEXPRESS
ask me name & password? what name should i type in sa? or Administrator or ?

many thanks,

C

View 4 Replies View Related

How To Avoid RS Login Window At Time Of Deploying Report?

Nov 27, 2007

Hi,

i created report and i have to deploy report , at time of deploying it asks report services login credentials.my sql server is windows authentication .it doesn't accept any credentials.how to avoid RS login window at time of deploying report.

Plz help me ASAP

thanks,

...kalyan

View 1 Replies View Related

Report Properties - Author

Apr 25, 2007

Hi All,

I cannot find any way to retrieve the "author" of the report via code in asp .net. The author is in the "report properties" window.

Could somebody please help me with this ?

Thanks

View 8 Replies View Related

Report Textbox Properties / Formats

Feb 28, 2006

Greetings -

Am having problems setting a normal SSN xxx-xx-xxx format for a report textbox using the Textbox Properties / Format tab. The data is stored as text, and am using the "Format Code .... " option. When I choose "Custom" option, and attempt any formatting string containing the "-", the SSN is displayed without the "-". Nothing I have tried works.

What is the correct context string for this format?

Tks.

View 2 Replies View Related

Reporting Services :: Hide SSRS Report Address Bar In JavaScript Window

Aug 2, 2015

I need to hide the address bar in the SSRS report pop-up using the JavaScript. I tried using below property

"&rc:Toolbar=False"
="javascript:void(window.open('https://dev/PWA/ProjectBICenter/_vti_bin/reportserver?https://dev/PWA/ProjectBICenter/Report Library/ProjectStatusReport.rdl&rv:Paramode=Hidden&rc:Toolbar=False&rv:HeaderArea=None&vuidProjectUID=Fields!ProjectUID.Value','_blank','location=no,toolbar=no,left=100,top=100,height=600,width=800'))"

What I am missing using this property?

View 6 Replies View Related

Reporting Services :: Where Is Window Report Data In Visual Studio 2013

Oct 6, 2015

I have an assignment where I am asked to create a test report with Cascaded parameters in a report for use on an Intranet. Found a good guide on a site named slqtips. The only problem is, that when I have created my data source, my data sets and my queries, I should go to the window "Report parameter properties", for specifing the data which should be included in the choices in the report, and I cannot find it! As a matter of fact the milieu I work in, Report designer in Visual Basic Studio Shell 2013, on a MS SQL 2012 Server, looks different in many way compared to the guide. It actually also differs from the Pictures in the book "Microsoft SQL Server 2012 Reporting Services" I also try to use for the purpose.Am I perhaps working in the wrong place, or what can the problem be? Is this Visual basic 2013 Window some kind of upgrade which is different from the original version where you used to work with Report designer?

View 6 Replies View Related

Reporting Services :: Window To Choose One Report From Bunch Of SSRS Reports

May 28, 2015

I have 6 SSRS reports for account receivable module. All of these 6 reports are for one specific business requirement. The difference between these reports are layout, number of columns and styles. I want user to choose one from these 6 reports based on their requirement.

When user clicks the menu in their application to initiate the report, Is there any way that the SSRS show list of these reports in a window so that user can choose one of them?

As I am working on a 3rd party ERP application, I cannot provide a form or window in that ERP to choose one report out of these 6 reports. I believe that there is a way to do this in Crystal report, but do not know how to do this in SSRS.

View 3 Replies View Related

Setting Up Default Report Startup Properties

Apr 13, 2007

Hello,

Is it possible to establish a set of default report and report body properties, perhaps in an ini file of some sort so that upon creating a new project and adding a new report item the developer does not have to go through the process of setting up all the interactive sizes, margins, paper sizes, etc each and every time? We have an established header that we incorporate on all reports and while in transition to the new Reporting Services it was my hope of finding something will create the first set of default conditions to help us automate the process just a bit.

Thank you.

View 2 Replies View Related

Can't See Function For Code Added In Report Properties

Sep 12, 2007

I put a function in the code section of Report Properties. I went to add an expression and can't find the function. I type =code. and did not see the function I created in the list.

Here's my code below:

Code Snippet
Public Function ConvertToStartDate(ByVal StartDate As String) As DateTime
Select Case StartDate
Case "Today"
Return DateTime.Today
Case "Yesterday"
Return DateTime.Today.AddDays(-1)
Case "30DaysOut"
Return DateTime.Today.AddDays(+30)
Case "2DaysPrior"
Return DateTime.Today.AddDays(-2)
' Additional cases
Case Else
Throw New ArgumentException("Unknown argument, " & StartDate, "StartDate")
End Select
End Function

I should be able to put in expression =code.ConvertToStartDate.StartDate("Today"), but that does not work. I get a red squiggly line under StartDate.

Thanks for your help,

Iris

View 3 Replies View Related

Question On Particular Report Region Layout Properties

May 3, 2007

Hi, all experts here,

Thanks a lot for your kind attention.

I have been trying to adjust the report regions fit into the whole report page. I could see the width and height property of the whole report page from the report property dialogue, but where can I find the width and height for the particular report region like the table? Then I could accordingly adjust the layout of both the report page and report region like table?

Hope my question is clear for your help.

With best regards,

Yours sincerely,

View 5 Replies View Related

Reporting Services :: Open URL In SSRS Report In New Window While URLs Keep Changing In Every Record

Jun 29, 2015

I want to be able to open URLs in a new window in my SSRS report, and the URLs keep changing in every record. The problem is these links are not the only things present in the record, and there is other data present. I keep seeing examples where they are considering only a link to be present in the record with no other data.

Also the data in the record includes HTML tags and I checked the option that says "HTML - Interpret HTML tags as styles" on the placeholder properties window.

Example of data in the record:
Hello! Welcome to google, the most used search engine.
Click on www.google.com to go the website

So when I click on the www.google.com URL, it should open in a new window.

View 2 Replies View Related

Reporting Services :: Referencing SSRS Variables Set In Report Properties

Jun 20, 2013

I am modifying a report that sets this variable at the beginning of every dataset:

declare @current_minute int
set @current_minute = DATEPART(N, GETDATE()) % 3

My idea is to set this variable in the Report Properties instead. When I do set this variable it in a Text Box or a Dataset, I get errors such as:

The expression used for the calculated field '=Variables!report_var.Value' includes a variable reference. Variable values cannot be used in calculated field expressions.

The Variable(report_var) expression for the report ‘body’ contains an error: [BC30451] Name 'N' is not declared.

What other strategies can I use to set a variable globally, instead of at the beginning of each dataset?

View 3 Replies View Related

Expression To Get CreatedBy, CreationDate, ModifiedBy, And ModifiedDate Properties For Report?

Jun 6, 2007

If you look at the General Properties for a report in Report Manager, there are 4 properties listed at the top:

Modified Date:

2/26/2007 6:37 PM

Modified By:

DOMAINusername1

Creation Date:

2/14/2006 5:19 PM

Created By:

DOMAINusername2

What I'm looking for is if there's a way to retrieve these properties via an expression from a textbox within a report. For instance, there's already an expression that is:

=Globals!ReportName

I know it won't be that easy for the CreatedBy, CreationDate, ModifiedBy, and ModifiedDate properties, but I thought I'd ask if there was a workaround or hack.

We're wanting to put that info into the footer of all our reports. (Actually this is for Report Builder reports, but you can still use expressions in Report Builder reports, so it should apply as it would to normal reports.)

View 1 Replies View Related

SQL 2012 :: Connection Properties Versus SSMS Server Properties

Mar 16, 2015

I have an ODBC connection string that is working fine with the following properties:

Database="XXXXXXX",Network="YYYYYY"; strangely no server is specified in the string, but it is specified in the ODBC Connection file.

I am trying to do a new server registration in SSMS for this database.However, I don't understand where the network spec is placed.

Under Registered server name I've tried:

YYYYYYXXXXX

When I browse the server for the database instance list, I receive "network path was not found".

I even tried:"XXXXXXX",Network="YYYYYY" for the registered server name.Same error message.

What am I doing wrong ?

View 1 Replies View Related

How To Connect To Sql Server As Other's Window Login Rather Than User's Window Login Thorugh ASP.NET.

Dec 14, 2006

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

View 1 Replies View Related

Window Authentication Log In

Apr 29, 2005

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.

View 1 Replies View Related

SQL Command Window

Aug 24, 1999

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.

View 1 Replies View Related

Search Window

Dec 30, 2004

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 Related