Keyboard Shortcuts???
Aug 15, 2005hello 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
ADVERTISEMENT
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
Use Of Keyboard
Dec 10, 2007I 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 RelatedDTS (shortcuts)
May 31, 2001I 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 RelatedShortcuts On And/or Logic With Different Variables
Mar 6, 2008Hi,
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
Keyboard Shortcut To Add &&<NULL&&> Value
Apr 20, 2008Is 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 RelatedShortcuts, Direct Keys In Management Studio ?
Dec 8, 2007Hello. 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 RelatedKeyboard Shortcut To Edit TextBox In Table
Mar 29, 2007Anyone 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
How Start/Stop Shortcuts In System Tray ?
Oct 22, 2006Hi,
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
Administrator Cannot See Administration Toolbar, Buttons And Shortcuts On Report Manager
Dec 23, 2006Hy 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
Analysis :: Large Tabular Cube With Lots Of Measures - Keyboard Stuck?
Apr 24, 2015large 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.
Keyboard Not Working (backspace And Arrow Keys) When Viewing 2000 DTS Packages From 2005 (backward Compatibility)
May 4, 2006I 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