Interactive Prompting

Sep 22, 2004

Hi,

I am migrating few my oracle codes to T-SQL. Currently am using & (ampersand) interactive prompt of SQLPlus. Is there any equivalent for the above said in SQL Server.

-Cheeku

View 1 Replies


ADVERTISEMENT

[scripts] Prompting User

Dec 21, 2006

please, how to promt user in mu sql 2005 script? For example, I need user toconfirm some operations.. .Thx in advance

View 10 Replies View Related

EncryptSensitiveWithPassword NOT Prompting For Password

Feb 14, 2008

I have 2 tasks. Both of them were set for EncryptSensitiveWithPassword. One of them prompts for the password when inporting to the server and again when the job is scheduled. it puts the DECRYPT statement in the config line. Everything works as it should.

The second task does not prompt for the password at any time. There is no DECRYPT statement added and the task fails to run.

WTF is going on????

View 3 Replies View Related

DTExec And Pasword Prompting

Feb 2, 2007

A colleague of mine is having problems when trying to schedule package execution via a .bat file that executes a .dtsx on a sql server (not file system). The scheduling system that is employed by the company requires a .bat file to execute the package. The packages themselves move data from AS400 servers to SQL Servers. Occasionally (very randomly) when the scheduling system runs the statement in the bat files, the package prompts for password information (for connectivity).

We've tried a number of solutions to this, mostly on the "ProtectionLevel" property of the package itself. We did some research and it seems as though there are a few options.What is the best solution to eliminate this from happening? We certainly don't want to have people checking to make sure the packages don't prompt for passwords.

Thanks.

View 9 Replies View Related

EncryptSensitiveWithPassword NOT Prompting For Password - AGAIN

Feb 26, 2008

I posted this earlier but did not get a sufficient response.

I have 2 tasks. Both of them were set for EncryptSensitiveWithPassword. One of them prompts for the password when inporting to the server and again when the job is scheduled. it puts the DECRYPT statement in the config line. Everything works as it should.

The second task does not prompt for the password at any time. There is no DECRYPT statement added and the task fails to run.

I have deleted the task and recreated it. I have used dtutil and forced the password. In any case I CANNOT get the job scheduler to see a password is required and add the DECRYPT line, hence I can't execute the tasks.

WTF is going on????

View 2 Replies View Related

PRompting The User To Enter Dates

Apr 21, 2008



Is it possible in Reporting Services to prompt a user for dates that can then be used to do calculations?

View 4 Replies View Related

How To Let User Open The Reports Without Prompting Login?

Aug 17, 2007

My PC is in the domain group of SQL Server 2005 Reporting Service, so I can publish the reports. After the reports were published, I can viw the reports from ASP.NET application on the web server, but everyone else was prompted for login. Only my login can view the reports. What can I do to let others to open the reports with the same web application? Thanks.

DanYeung

View 12 Replies View Related

Stop Management Studio Prompting To Save Files?

Sep 19, 2007

Hey all,

I know this is a very minor gripe, but I cannot find any way to get SQL Server Management Studio to stop prompting me to save queries. I've poked through all the options without success, but it doesn't seem possible that they would have left this out.

Am I out of luck?

View 3 Replies View Related

Prompting For Date Range Parameters With Report Builder?

Nov 22, 2005

Hello,

View 6 Replies View Related

Preview Report Tab Is Prompting For An Input Parameter That Does Not Exist For The Dataset

Apr 11, 2008



I created a dataset based on a stored procedure. There are nine input parameters. When I click on the preview tab, it is asking me for ten input parameters.

I double checked my dataset on the data tab, and it only shows the expected nine parameters when I look at the parameters tab. I can also run the query without issue from the data tab.

I have no idea why it is asking for an extra parameter on the preview tab. It is a column name that does exist in my database, but is in no way used in the stored procedure in question.

Has anyone else run into a similar situation?

View 1 Replies View Related

Reporting Services :: SSRS Report Prompting For User ID And Password Of Admin

Nov 5, 2015

After publishing report on server and accessing it from URL its prompting for the USER ID and pAssword of Admin user of the server. Have tried to find the Virtual Directory of the Reporting server on IIS - which is not available. or unable to find the same. Apart from this have saved the Database credential in the report itself. 

View 5 Replies View Related

Interactive Reporting

May 17, 2007

Software packages like Microsoft Small Business Accounting and Quickbooks offer a very powerful reporting module that lets end users change grouping, filtering, sorting, etc at run time (having it change the report dynamically infront of them). More importantly, their reporting tools let users click on details on the reports which opens the data in the form based portion of their software.



For example: If the end user pulls up a financial report, lets say "All Bills for February 07", the user get a report of all the bills that have gone out in that time frame. The end user can then click on the actual details in the report, and the Bill will come up in the Windows Forms portion of their software so they edit the bill, or create a new bill.



I have done a very limited amount of reporting in SQL Server, so I am not sure of how they were able to achieve this. If someone could give me some key words or ideas that I can bring up more information from in google, or even on here, I'd appreciate it.



Thanks in advance!

View 3 Replies View Related

Interactive Sort

Mar 25, 2008


The Items Display is like this.

Project Name Acronym ID


7ked
SedRich Sed 123

Diercrom Dife 256
Fireup Fip 563

8IOP
Hiluke Hik 478

Jikerty Jer 125
Kilert Kre 458

The Report idea, u Got Right, now I want to implement Interactive sorting to Name ,Acronym,ID
Please help me

View 6 Replies View Related

Interactive Sorting

Jun 14, 2007

I know this is not available now, but is it plan in the near future:



I want to be able to set the initial sort order on the interactive sort.

for example, I have a report sorted Asc by Rank. If I click on the interactive sort button on the Rank column, it resorts ascending... totally pointless, and my customers point this out on a weekly basis...



Any plans to add this feature? If not, I will go to connect and suggest it.



Also, does anyone else find this annoying?



Thanks!



BobP

View 5 Replies View Related

Interactive Subreport

Jan 19, 2008

I have a report that lists customers. Is it possible to create an interactive mechanism so that a user can somehow select a customer and have a subreport update to show that customer's data, without jumping away from the parent report?

Thanks.

J

View 3 Replies View Related

Interactive Sort Bug?

Nov 20, 2007

We have an issue with interactive sorting. Interactive sorting works in our Dev and test environments but does not work on our production server. We have deployed exactly the same report to each server. All servers are sp2 (9.00.3042.00). When the interactive sort buttons are clicked on production nothing happens. Has anyone seen this?

View 1 Replies View Related

Interactive Sorting In A Matrix

Oct 16, 2006

Bill,

You say, "we enjoy the option of specifying sorting for
multiple columns within the matrix, table or list within which we
are working." But, when I add interactive sorting to the headers of a matrix, the up and down toggles appear in the preview, but the rows are not sorted after clicking.

This works perfectly fine on tables, as you say, but I have yet to see it on a matrix.

Thanks,

Tom

View 7 Replies View Related

Interactive Sort Doesn't Do Anything

Apr 16, 2008



I can't get interactive sort to work on Report Server reports (but it works on reports I've done in Report Builder using one table per report).
I tried it on a different database in a Report Server report and it did work.

There was another post that talked about the collation, which is Latin1_General_CI_AS_KS_WS for the ReportServer and ReportServerTempDB, and SQL_Latin1_General_CP1_CI_AS for the two databases I reported on. But it seems like I'm not doing something correctly since it works in RB but not RS (though the one database report did work).

Any ideas?

View 2 Replies View Related

Interactive Dashboard With Subreports

Sep 14, 2007

I am trying to create a dashboard that is split into the five main focus areas of Customer, Finance, Management, People and Innovation. Each focus area has a main report and a series of subreports (within a panel). I use the €˜Jump to report:€™ property at the domain level €“ which works well.

My problems arise when dealing with the subreports. For example, in the €˜People€™ focus area €“ the panel contains 4 subreports covering; contractor vs. fte trends, gender balance trends, compliance trends and investment trends.

Ideally I would like to have four €˜tabs€™ which when clicked would show the relevant subreport. I know this can be done via a full report refresh, but it looks clumsy and is more complex and costly to maintain.

I am happy for any method that might change the €˜Subreport€™ property dynamically or set the visibility of the objects. I want to avoid using the toggle capability as this could result in two or more subreports conflicting and being visible at the same time.

View 2 Replies View Related

SP2 Breaks Interactive Sort

May 2, 2007

We have run into a really bizzare problem after upgrading to SQL Server 2005 SP2. We have a bunch of matrix reports that have interactive sort in the upper left hand corner, the sort based on Numeric and Text fields. For Example

=Fields!City.Value

=Sum(Fields!Pax.Value)

Now for whatever reason after upgrading to SP2 and making NO CHANGES to the reports or under data sources, interactive sorts that use the =Sum(....) no longer work but interactive sorts on text values still work.



Any ideas???

View 1 Replies View Related

Drill Down Interactive MDX Query

Sep 17, 2007

Hi,

I am new to reporting services. We are creating a report with drill-down capability. We have a Date dimension hierarchy defined as Year - Month - Day.

On the report, we expect reporting services send MDX query to SSAS to get the total sales just for the the year, say 2007, when we click the year 2007. Then it send query just to aggregate sales for that month when we click a month.

But when we build the reports, it looks like it always aggregate for all levels. So the performance is bad to first open the report.

How do I resolve this issue? Please help.

Thanks,
Jia

View 3 Replies View Related

Interactive Sort Has Probs

Jun 11, 2007

Hi All,



I've designed a simple sales report , first grouped by Transport type and then by item.

Example

Category Item Sales



DHL A 2000

DHL C 1500

DHL E -1700



AmEx A 200

Amex E 20



-------------------------------

when click on sales under group DHL it shouild sort -say descending-

so result should be

DHL A 2000

DHL C 1500

DHL E -1700



instead I get results



DHL A 2000

DHL E -1700

DHL C 1500



this is just an example but this is the sort of results I get when I try to use interactive sorting.

Any Ideas?



thanks



Sonny

View 5 Replies View Related

Interactive Sorting Icon

May 14, 2008

Is there any way to change the interactive sorting icon or even adjust it? When I add the functionality to a column, it skews the column heading to make room for it. This means that reports that previously displayed properly no longer look correct. If I adjust the width of the report to allow room for the icon, then the report overflows its boundary in terms of printing.

Also, the icon does not display evenly all the time. Sometimes, it displays directly next to the text and sometimes it is off to the right more.

View 6 Replies View Related

TextAlign Ignored When Using Interactive Sort

Aug 8, 2007

I have a table with WritingMode for the column labels set to tb-rl (vertical writing).
I want the text in each label to be right-aligned (i.e. aligned along the actual bottom of the cells), so I set TextAlign = Right.
This works fine for all columns until I enable Interactive Sort. When Interactive Sort is activated TextAlign ignores the value and always behaves as if General (or Center) was selected.
Is there a solution to this?


By the way: Is it possible to have the vertical text written upwards (bt-lr) instead of downwards?

View 1 Replies View Related

Interactive Column Sort

Mar 9, 2007



Hi All

I'm Climbing the walls here, does anyone know how to do an interactive sort but keep one of the returned rows pinned at the end of the result set?

i've tried this

=iif(Fields!Item.Value <> "c", 1 ,2) & Fields!Item.Value

Doesn't work to well

Results to Sort

d

e

a

b

c

Sort should return

which works fine on the ascending sort

a

b

d

e

c

with c remaining at the bottom

But i get this on the descending sort

c

a

b

d

e

Thanks in advance

Dave

View 1 Replies View Related

Toggled &&amp; Interactive Sort

Sep 23, 2006

Hello,



I have a table with interactive sort and toggled to hide and unhide details (table group is the toggled)

when user click on the interactive sort the collapse back to default.

e.g.

in the report all the details on the table group are hide and the group have toggled.

user open one of the group. after that click on the sort all the collapses are close also the group user click to unhide.

any workaround ?

View 1 Replies View Related

How To Use Web Services And Interactive Features

Dec 26, 2006

I've been having trouble getting my RS2005 reports with interactive features (drilldowns) to work in an Iframe and rendered with SOAP.

The main problem now is that the toggle buttons (+ / -) point to the reporting services server and do a URL Access call. I've tried the <ReplacementRoot> element in the DeviceInfo parameter but it doesn't appear to do anything.

I keep on reading about how everything is possible through the web services but it looks as if these interactive features are only available using the URL Access. Is this true?

Kwan

View 3 Replies View Related

Problem With Interactive Sort

Oct 25, 2007

I'm setting 'interactive sort' property on some columns of my SSRS report. By some reason, this functionality works only for some columns. Settings do not produce any errors and everything is OK on preview level but when report is accessed through web-based Report Manager only some of the sorting arrows appear.




View 1 Replies View Related

Interactive Sort In Matrix

Jan 24, 2007

Hi,

I making a report using Matrix with 2 row groups and 1 column group. The group names are:

Row : CompanyName, TotalUsers

Column: UserType

Detail Group has a count of number of user in each type.

I want to use interactive sort feature on my column group so that when I click on my column header, it sort my detail group data ascending or decending and companyName and total users based on datail group.

Thanks a lot,

-Rohit

View 2 Replies View Related

Interactive Debugging Of Stored Procedure

Oct 15, 2006

In VS 2005 with SQL Server Express: How do I debug a stored procedure that is called from a object datasource control while the asp.net code is running? Thanks     

View 1 Replies View Related

Interactive Reporting In ASP.NET Using SSRS (2005)

Jun 3, 2007

Hi, I am looking for some guidance on the way to go for achieving the task described below. 

View 2 Replies View Related

RMO + Interactive Conflict Resolver Setup

Nov 6, 2006

Hello,

I'm trying to setup the Interactive Conflict Resolver in my C# app via RMO. (using SQL Server 2005)

The only article I can find on MSDN or anywhere is involing T-SQL. Can someone please shed some light on this for me specificaly on the subscriber side.

Thank you! Chris

View 2 Replies View Related

Interactive Sort Does Not Work With SubReports

Nov 19, 2007



Hello All,

I have a subreport that has interactive sort on one of the columns in a table. The interactive sort works well when i run the subreport. But when i run the parent report that contains the subreport then the interactive sorting does not work.

Has anyone come across this issue, any help will be greatly appreciated.

Thanks a lot!

Mohit

View 16 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved