SSRS Keyboard Shortcuts/Usability

Jul 18, 2007



I have been using SSRS2k5 now since early CTP, and one thing that bothers me is the lack of keyboard shortcuts and windows standards.



For example: If I am in the data screen, and want to enter a SQL Query, I cannot use the tab key. So I copy it to SQL Management Studio, but I cant use CTRL-A to select all.



If I am in the layout tab, and want to bold a field, I hit CTRL-B, but that pulls up the breakpoint entry dialog.



If I have a table on a report, and want to add click-thru navigation, I have to:



Right click on cell 1

Click on properties

Select Navigation

Click on Jump to Report

Select the report from the list

Click on parameters

Select parameter 1

Now, if I want a field as the parameter, i can just select from the drop down, but most of the time I am passing parameters from the 1st report to the 2nd report. Then i have to:


Click on the Expression button

Either type the parameter name, or click on it from the list.

Press OK

Repeat number 8 for the number of parameters.

Hit OK.

Hit OK.

REPEAT FOR ALL CELLS
Now, here is the issue... If you have a 20 column table, and have similar click thru functionality, you have to repeat this process for each cell. You cannot multi select. THAT would be a huge timesaver. I would rather set all 20 cells the same, and tweak 1 or 2, rather than kill my wrist mousing thru the above process 20 times. (It hurts, trust me )

These seem like little things, until you are working on 50 reports in a short time frame.

Anyone else find this bothersome?
Is there any improvement on the GUI in the next release?

Thanks!

BobP

View 3 Replies


ADVERTISEMENT

Keyboard Shortcuts???

Aug 15, 2005

hello friends..

i am a new user to sql,
i was wondering if anyone here will help me to get all the keyboard shortcuts while working on sql...

thankyou

View 3 Replies View Related

Usability Vs. Injection Protection

Nov 30, 2007

I have a question that I am sure that others have had to deal with in the past. I am writing business requirements for a web application that stores names, addresses, etc. I have hit a bit of a problem in design with allowing users to enter data they need, like the name O'Brien, and developers saying that allowing the single quote in a field could allow for an injection attack.
Developers want to strip out single quotes when they occur in the data, however the users are insistent that names and addresses that have single quotes in them are shown properly.

Is there any middle ground so that the system can be built to avoid an injection, but still allow data to be entered as intended.

View 4 Replies View Related

Laws And Myths Of Usability && Interface Design

Dec 12, 2006

Laws and Myths of Usability & Interface Design

Introduction

Usability and relevance have been identified as the major factors preventing mass adoption of
Business Intelligence applications. What we have today are traditional BI tools that don't work
nearly as well as they should, even for analysts and power users. The reason they haven't
reached the masses is because most of the tools are so difficult to use and reveal so little
about the data that only power users are willing to put up with them. Just as Google redefined
the web by making search and therefore access easy … the same needs to occur with the BI
suite.

Overwhelmingly, traditional BI products are designed for the technology expert. The perceived functionality requirements are driven by widget wish lists
rather than actual business user (the BI consumers) needs.

Our design philosophy has been honed through experience and results in a simple equation:

Usability = Simplicity + Unity

This paper is a reflection on some of the design approaches used in the development of
Yellowfin. Its purpose is to provide an insight into what makes web based applications ‘work’
and how Yellowfin will continue to evolve and improve. The principles are defined by 5 laws
and 5 myths.

The laws:

1. Simplicity – the art of Zen and interface design
2. Strive for internal and external unity
3. Innovation stretchs engineering capability
4. Everything changes except change itself
5. First impressions count
The Myths:

1. Form follows function
2. Only users know what they want
3. Involve many people in your design process
4. Usability testing will ensure a great UI
5. You can’t live without rigorous design processes
At Yellowfin we use the principles outlined in this paper to continue to deliver innovation,
improvements and what we hope is an exceptional software experience for our customers.

#1 Simplicity – the art of Zen and interface design

Users want simplicity! They want to do the job they need to do with the minimum of effort and
complexity. Users must be able to perform their most frequent, most important tasks without
any resistance. This means:

1. not having to spend time sifting through an array of irrelevant options, and
2. not having to browse help files or a manual to accomplish simple tasks
The goal, then, is obvious: to maximize performance while minimizing confusion. But as
vendors and users are discovering, that's no small trick. Simplicity is sometimes the least
simple thing to achieve." 1

Simplicity requires that your code does all the hard work, rather than the user. Google, as an
example, maintains the simplest of search interfaces. No distractions from blogs, news or
ads, you simply type in your query and go. Behind this simplicity is up to 500,000 computers
globally linked and participating in answering your query. In essence, one of the most
complex hardware/software systems on the planet is hidden behind a very simple webpage
that is virtually 100% whitespace.

Deliver the right level of blatant functionality to suit user skills

The most common UI issue in report writers is BOS (Button Overuse Syndrome). If there is a
formatting option, or any option for that matter, then traditionally it needs a button. How
wrong can you be! BOS delivers too many options and results in a user confused by choice.

The cure for BOS is UI simplification through minimalism – the art of Zen and interface
design. Focus on what users do 90% of the time. Chances are your users will not mind using
a drop down menu or popup forms if the action they are performing is not regularly repeated.
Provide buttons for those actions that are regularly used and then drop down menus or side
panel menus for all the others. Whatever you do, keep the interface simple and consistent.

Of course the level of competence of your user will influence your design decisions. An
example of a product that is tailored for user sophistication is the video camera. Consumer
versions have lots of functionality but hidden in layers of menus, whilst professional versions
tend to be button centric to allow rapid access to all the functions desired.

Taking this lesson into account we have designed the UI specifically to suit the technical
ability of the average user. The interface is made more flexible through role based access,
where greater control is exposed as technical proficiency increases. For example the report
writer (a business user function is menu driven) but the more technical metadata layer is
panel and options driven.

Simplicity in everything you do

View 4 Replies View Related

Use Of Keyboard

Dec 10, 2007

I have SQL Server 2005. Holding shift while pressing the spacebar selects an entire row. I can then use my arrow keys to move about the cells and it selects the entire cell I'm on. I am looking for a way to modify the cell without clicking the mouse. Is there a way to go from entire cell selected to cursor in the cell by using the keyboard? Thanks

View 1 Replies View Related

DTS (shortcuts)

May 31, 2001

I want someone to be able to execute a DTS Package but I do not want to give them access to Enterprise Manager. Is there anywhere way of doing this. Like a shortcut on their desktop. Thanks in adavnce for help.

View 1 Replies View Related

Shortcuts On And/or Logic With Different Variables

Mar 6, 2008

Hi,

I have a relatively common scenario. There is a stored procedure which takes two input parameters which are used as clauses in the query, e.g:


select * from myTable where (field1 = @param1 or field2 = @param2)


Now, the behaviour I'm ideally looking for is for the SP to implement different logic depending on what parameters have been supplied. If either one of the params has a value of zero then I want to run the query on the other param only, or if both params have values greater than zero, then I want to run the query using both parameters e.g.:


pseudocode:
If @param1 = 0 then
select * from myTable where field2 = @param2
else if @param2 = 0 then
select * from myTable where field1 = @param1
else if param2 <> 0 and param1 <> 0 then
select * from myTable where field1 = @param1 and field2 = @param2


Looks straightforward enough. In reality of course the actual query is much more complicated than that, and it's a mess to write it out three times just to do a bit of if/else logic.

There are two obvious solutions to this: either do the if/else in code and call different SPs, or make the query an SP on its own which is called by my original SP with different logic. For various reasons I'd rather not do either of these things.

This is such a common scenario that I'm wondering whether or not there's some easier, cleaner solution that I've missed, or don't know about. Is there?

Cheers,
Matt

View 5 Replies View Related

Keyboard Shortcut To Add &&<NULL&&> Value

Apr 20, 2008

Is there a keyboard shortcut to add a <NULL> value into a field on my SQL Server 2000 database table, using SQL Server Enterprise Manager

View 1 Replies View Related

Shortcuts, Direct Keys In Management Studio ?

Dec 8, 2007

 Hello. Does anybody knows if the are shortcuts to differrent menu items in Sql 2005 Management Studio ?For example i will to use the "Execute " button without need to use the mouse, as this case as of others.Any knows where can i find a map or a page info with the shortcuts of SQL2005 Management Studio ? Thanks 

View 1 Replies View Related

Keyboard Shortcut To Edit TextBox In Table

Mar 29, 2007

Anyone know if there is one and if so what it is? I know I can type directly into a text box in a table, but what if I want to edit the contents? Equivalent of F2 in Excel...



Thanks



View 3 Replies View Related

How Start/Stop Shortcuts In System Tray ?

Oct 22, 2006

Hi,

I want to tell to user about SQL Server Configuration Manager and wants to allow him "START / PAUSE / STOP" for SQL Server Express in system Tray. It is easy for the end user who don't know SQL Server.

Thanks

View 3 Replies View Related

Administrator Cannot See Administration Toolbar, Buttons And Shortcuts On Report Manager

Dec 23, 2006

Hy everybody.

I have recently installed from scratch RS 2003 on a WIN2003 SRV and got that the problem that the administrator cannot access or even see the regular administration toolbar and links at the Report Manager, such as Site Configuration, Upload New File, the common 'Contents | Properties ' tab, among other stuff. The only options available are 'Home', 'My Subscriptions' and 'Help', in the right superior link bar. I find this behaviour very strange, since the RS comes right out of the box configured with full access to administrator, but right now I CAN'T do any administration task on the RS Server.

Another strange behaviours I've found:
- The few links that appear redirect to the internal ip address of the server.
- When you call the '/ReportServer/ReportingService.asmx' it returns an XML document, not the usual browsing interface.

There's some information about the server configuration I think it might help:
- IIS is running more than one website, and the RS server is not installed on the Default WebSite, wich is stopped.
- SharePoint Services is running in the server, but not in the DefaultWebSite.
- The security settings of the virtual directory of the Report Manager are configured to use Windows Authentication and are NOT configured to use anonymous authentication.
- The server is published to the Internet.

There's some stuff that I tried and for now didn't worked:
- Create the virtual directories in other websites.
- Switch the attributes of the 'impersonate' attribute in Web.config file between true and false.
- Enable anonymous authentication and use the administrator account to impersonate.
- The steps described in the help article 'Troubleshooting a Side-by-Side Installation of Reporting Services and Windows SharePoint Services'
- Reinstalling the RS product.

I really hope you guys can help me with this.

Thanks in advance.
JC

View 1 Replies View Related

Analysis :: Large Tabular Cube With Lots Of Measures - Keyboard Stuck?

Apr 24, 2015

large tabular cubes (SSAS 2012 SP2), with lots of calculations, the keyboard seems to be stuck, one cannot type or make any modifications to any measures, even after closing a project.

The only workaround is to completely restart the machine.  Using Visual Studio 2010 Shell.

Are there any possibly corruptions or calc limitations that one should be aware of?

Notable that this never happens with any small cubes, but just with the largest cube that we have, that has probably tens of calcs.  

View 6 Replies View Related

Keyboard Not Working (backspace And Arrow Keys) When Viewing 2000 DTS Packages From 2005 (backward Compatibility)

May 4, 2006

I know my problem is not directly associated w/ SSIS, so please forgive the post here. I figured this would be the "most" appropriate place to post this challenge.

We're attempting to edit a 2000 DTS package in Design mode from within the 2005 SQL Management Studio. To do this we downloaded/installed the following packages from the MS download site:

Microsoft SQL Server 2000 DTS Designer Components
Microsoft SQL Server 2005 Backward Compatibility Components

We're able to open the package in design mode from the Management Studio (Server > Management > Legacy > Data Transformation Services > DTS Package Name). But, when the DTS designer is open, the backspace and arrow keys won't respond in the Management Studio. They begin responding when we close the DTS designer. There are no error messages when we close the DTS designer.

Does anyone know of a fix or a workaround? Any help would be greatly appreciated.

Thanks, Mike

View 7 Replies View Related

List Of Parameters Used Together With Rs: Parameter In SSRS 2000 And SSRS 2005

Apr 24, 2007

Hi,

Does anyone know of a link or list that has all the parameters for the "rs:" section of the URL access parameter, except for the ones in the Microsoft books?

Thanks,

View 1 Replies View Related

Reporting Services :: Interface Code Compatibility Between Custom Delivery Extension Of SSRS 2008R2 And SSRS 2012?

Sep 3, 2015

Currently we are using Custom Delivery Extension for SSRS 2008R2 We are planning to move it SSRS2012

My Question is: Whether we can use the same Code used for SSRS2008R2 to SSRS2012?

if not what code changes we should do?

View 3 Replies View Related

Can I Write SSRS 2008 Reports To Run On SQL 2005 SSRS?

Sep 12, 2007

Is it possible to write SSRS 2008 reports to run on an existing SSRS 2005 server?

If yes, what do I need to do to be able to write SSRS 2008 reports on my developer PC that will run on the SQL 2005 Server (which also has SSRS 2005 installed on it)?

I installed Visual Studio 2008 beta on the development PC and it appears that it needs SSRS installed on it too. So I installed SQL 2008 SSRS (SQL Server Reporting Services) and SQL 2008 Workstation Components onto the developer PC. Next I run the SQL 2008 "Reporting Services Configuration" tool. When I click on the "Web Service URL" section it hangs indefinitely and I have to force it closed.

The developer PC is Windows Vista Business.

Any suggestions on making this work, or any other information that you can think of that would allow me to use Visual Studio 2008 and the SQL 2008 "Report Designer Preview" tool to develop SSRS reports that will run on the SQL 2005 SSRS server?

Thanks!
-ErikR

View 4 Replies View Related

SSRS 2005 - Migrating SSRS Subscriptions

Oct 25, 2007



Hi,
We are in need of migrating SSRS subscriptions along with the reports. Could you please let me know the process ?

I really appreciate your help on this.

Thanks,
Sam

View 6 Replies View Related

SSRS 64Bit And SSRS 32Bit

Mar 11, 2008

I did a quick Google for this but found nada...

If I develop a report in SSRS 64 bit, can it be ported to a 32 bit installation? Any issues?

I will do my own testing, but I was curious if anyone else had experience doing this.

View 1 Replies View Related

Ssrs

Jun 3, 2008

send me some procedures to test reports in ssrs (sql server 2005)

sunil

View 3 Replies View Related

SSRS From .net

Jan 14, 2008

Hi,
In a .net application there is a link that brings up a SSRS report.
I have noticed that if it is the first time this report is requested i.e. Application has just been opened and the report button is clicked, then it takes a while to get this report to appear on the screen. But if this report is requested again (i.e. for the second time or more) then it only takes a few moments for the report to appear on the screen.
So it seems that only the first time the report is requested it takes a longer time to get this report. Is there a way to reduce this initial load of the report?
Thanks

View 3 Replies View Related

SSRS To GP

Nov 12, 2007


Can anybody give share with me how to establish the basic connection between SQL Reporting Services and Great Plains 9.0? They are on two separate servers if that makes a difference.

Dennis.e.graham@hotmail.com

View 3 Replies View Related

Is This Possible With SSRS?

Aug 13, 2007

Hi. We currently have about a 100 Crystal Reports with embedded images and text in the *.rpt files. If we were to switch to SSRS 2005,


Can we do a global search-and-replace of images and text within the SSRS reports? We have some letterheads that have names of people who might change every year or two.

Are there any tools to convert Crystal Reports *.rpt files to SSRS reports? These 100 reports would be time-consuming trying to convert to SSRS.
Thank you much
Alex

View 2 Replies View Related

Using DTS Within SSRS

Mar 6, 2006

Hi Guys

I have an ancient app that produces a pipe delimited file for the printing of certain invoices (which i can present in reporting services). I am able to fire a batch file or script from this able and pass the name of the file through to the script...

My question is: is it possible to have the stored procedure fire a DTS pkg to "massage the data" before running the report?

Has anyone had any experience doing this or other ideas i could try. i'm using SQL2k



TIA Stephen

View 4 Replies View Related

Ssrs

May 21, 2008



hi guys,

In ssrs i have two rows, The two row i have to design in to vertical, how to do?
anybody plz help me

View 3 Replies View Related

VPN And SSRS

Feb 14, 2008

I had a potential client ask if SSRS would work with a vpn connection if someone is off site. Does anyone know if this will work?

Thanks,
Ryan

View 6 Replies View Related

SSRS

Sep 3, 2007

Hi,
I want to get five tables of a report to be repeated on different sheets of excel based on a variable.

Thanks in Advance.
Nalini

View 5 Replies View Related

SSRS - HELP ME WITH THIS

May 20, 2008



I have a stored procedure wihich returns the table like

class sunday monday tuesday thursday friday saturday
001 $120 $110 $100 $80 $150 $120
021 $120 $110 $100 $80 $150 $120
003 $120 $110 $100 $80 $150 $120
022 $120 $110 $100 $80 $150 $120
005 $120 $110 $100 $80 $150 $120

041 $120 $110 $100 $80 $150 $120
006 $120 $110 $100 $80 $150 $120
002 $120 $110 $100 $80 $150 $120
036 $120 $110 $100 $80 $150 $120

i want to display a report in SSRS in two groups 1st group (001, 021, 003, 005) there is no 022 in this table where in another group (006,036) there is no 002. it should display as follow with the total of sales

class sunday monday tuesday thursday friday saturday
001 $120 $110 $100 $80 $150 $120
021 $120 $110 $100 $80 $150 $120
003 $120 $110 $100 $80 $150 $120
005 $120 $110 $100 $80 $150 $120
total 480 440 400 320 600 480

class sunday monday tuesday thursday friday saturday

006 $120 $110 $100 $80 $150 $120
036 $120 $110 $100 $80 $150 $120
total 240 220 200 160 300 240

in the Dataset of SSRS i can see only class, sunday,monday,tuesday,wednesday,thursday,friday,saturday.

plzzzzz help me how it is possible in SSRS or any other sujjestion. it will be appreciated... Thank u all in advance...

View 3 Replies View Related

How Do I Get Ssrs?

Jan 7, 2008



hi
we bought ss2000 std ed in 2003.
how can i get ssrs 2000? is it a free download?
thanks
evan

View 5 Replies View Related

SSRS IN NLB

Sep 26, 2007

Hello

I am going to Intsall SSRS on Cluster load balanced web servers. Shall i install SSRS on both nodes? When i go to msdn, the caption as:

"You must use other products to support access through a virtual server and cluster deployment. Reporting Services does not provide load balancing functionality or virtual server features that allow you to access all report server instances through a shared URL address."

I have my vip and virtual url ready for installation. how can i install SSRS in high availability? please advice. Thanks.



View 3 Replies View Related

Configuring SSRS On Win XP

Apr 4, 2008

Hi All,

I am fairly new to SSRS. I want to install SSRS on my local system which has OS of Win XP sp2 (not a server). I have installed SQL Server instance on this box. Can any body tell if i need Win Server 2000 or 2003 OS to install SSRS or can i use Win XP, if so please give some guidelines.

Thank's in advance..

View 2 Replies View Related

SSIS & SSRS

Apr 10, 2008

Hello everybody,
I'm new to SQL,I have a interview tomor,so please i need a website from where i can get questions related to SSIS & SSRS.Please help me.
Thanks in advance

View 3 Replies View Related

SSRS With SSIS

May 11, 2007

How it is possible to Run (2 or 3)Reports(SSRS) From SSIS With Default Parameters ? Please Help Me Out

Praveen John
Software Engg

Regards
Praveen John
+91-9895074288
"Frankly, my dear, I don’t give a damn"

View 1 Replies View Related







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