Hi Friends,
I have created a report using SSRS 2005, and I am able to call another reports by clicking a column (using jump to report) from my first report. I would like to know is it possible to have a pulldown menu by right clicking a column at runtime in SSRS 2005? Please let me know
Thanks & Regards,
Naveen J V
Is anyone else having an issue with SSRS menus not being able to be clicked on?
When I roll the mouse over the menu item, it highlights, but when I click, nothing happens.
It affects the top menu items, and any right click menu.
This is an intermittent problem, but it does happen daily. I have to shut down VS to fix.
BobP
I have created a database with several tables. I want to create a database diagram to show the relationshipbetween the tables. Below are the steps from the SQL Server 2005 documentation on how to create a database diagram. The problem is that when I right click on the Database Diagrams folder I am only given two options. They are:"Working with SQL Server diagrams" and "Refresh"There is no menu choice to create a new database diagram. Can anyone tell me what the problem here is?
To create a new database diagramIn Object Explorer, right-click the Database Diagrams folder or any diagram in that folder.
Choose New Database Diagram on the shortcut menu.
The Add Table dialog box appears.
Select the required tables in the Tables list and click Add.
The tables are displayed graphically in the new database diagram.
Hello,
I have installed SQL server 2005 enterprise edition on Windows 2003 virtual PC (full installation). The installation went through successfully. However, after install completed, I cannot find any of the client tools under the start menu -> all programs -> Microsoft SQL server 2005 menu. The only item listed under the SQL server 2005 is Configuration Tools, which is used to configure the database server.
I have tried to install the client component again (in case I didn't install them at the first place) but the installation process cannot be started since it detected that the client components have been installed already. I can also see the sql server native client running in the services.
The server engine is working fine since I can connect to that sql server using another machine where I have the client tool (SQL server management studio).
One of my friends has exactly the same problem. He installed the sql server 2005 Standard edition on windows 2003 server (full installation), but the client tools are not showing up in the start menu either.
I also checked the location for the SQL server management studio (Microsoft SQL server/90/Tools/Binn/VSShell/Common7/IDE), there is only one folder called publicAssemblies listed under. Is this correct or something is missing?
Thanks
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,
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
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
Dear All,
I am basically new as far as SQl server 2005 concern.
I want to try out reporting services provided by sql server 2005.
That is make report using sql server 2005 and call that report from web or window application.
Please guide me in doing so or give me some useful link.
Thanks
How do you create a php or html page with a drop down menu from a table a database? Please show any code or helpful links,
Thanks!
Hi,As subj says. A simple menu is defined in a table. But how to extract it?Heres the deal:Table menu has these 3 columns: menuid parent menudescOk this should be easy right? Those menu-rows that has parent=0 is"toplevel". And so forth. An example:1 0 "Items"2 0 "Standings"3 0 "Test"4 2 "Liverpool"5 2 "AC Milan"6 1 "Itemno1"This menu should in layout come in this order:ItemsItemno1TestStandingsAC MilanLiverpoolThat is: Alphabetically sorted and with the children underneath the parents.Right? Yes - and selecting the menu and doing some gymnastics in ASP isntthat hard. But ASP must be the language that has the "crapiest" way ofhandling arrays...so a simple task is really messy. Creating a storedprocedure involes 2-3 temporary tables as I see it. Not vey elegant either.So my question is: Isnt there any way of selecting this order directly usingSQL?? Some nice clean and beautiful way?--Thanks,Summa
View 2 Replies View Related
Hi everybody.
I'm looking to upgrade to SQL Server 2005 (Standard Edition). I'm interested in using SSIS, SSRS and SSAS. I hear that BIDS runs inside of Visual Studio 2005, and comes with the SQL 2005 software. I currently have VS 2003. My question is: Do I need to purchase anything besides SQL Server 2005 Standard, or do I need to buy anything separately, like VS 2005? (if so, which version would you recommend?)
Thank you very much!
- Trevor
I followed an article which was recently published by Jeff Prosise in his "Wicked Code" column in MSDN magazine and I was able to make it work.My problem is that I do not know how to refresh the menu. If I add new record in the sitemap table what needs to happen to refresh the menu.
View 2 Replies View RelatedHello,I am upgrading my (simple) cms from one menu layer to two layers. So i have two tables in de my DB- table_mainmenu- table_submenuThe submenu records are linked to the mainmenu records on the mainmenu id. So far so good. Heres my problem, i cant figure out how to change the order of the pages...!? What is the theory behind recording the stacking order of the menu items? How can i record this information in the DB?I just need the theory, i can figure out the details for myself. Thanks in advance!Corstiaanp.s. is the the right forum to post this?
View 4 Replies View RelatedHow do I get a distinct value of menu from tables
Here is my script
select distinct menu, others, clientele,menuID from myrestaurant where username = 'mary' and batch = 238335
hi all,
I have a table called suppliers where i type my suppliers details.
I have also a table called supp_corellation in which i have the proffesion of my suppliers.
there is one column in the table of suppliers which it takes data from the table supp_corellation . Is it possible to choose the values from a list instead of typing in my table (lets say drop down list)???
Hi
is there any way of getting the values of a row in a table to be reflected as the values of a drop down menu?
Hello, I need permission to work with SQL jobs on particular sever, currently I'm not able to see SQL agent menu.
What permissions should i need to have to view SQL Agent Menu.
Please some one help in this.
Thanks,
Malathi.
Is it possible in SQL Reporting 2005 to have dropdown menu(eg..on mouseover list of static menu appears from which i can navigate to other rdl files while passing all parameters) ..
I am now starting to create actual database projects in SSMS but the problem is that when I go to create add a new item by right-clicking on the project all i get is
Existing Item
New Connection
New Query
So, can anyone tell me how do I get the 'Add New Item' menu item to appear so I don't have do the riduculous way of creating a new query, then open another non-project script item from template explorer, then copy the contents from latter to former and then close the superfluous non-project script item.
Instead of explaining my question here I've made a seperate
html page with a full explanation of my problem with pictures
and examples.
I've posted the question to this URL
http://miona.com/listmenus/
Hello,
I installed SQL Server 2005 Standard Edition and SQL Server Management Studio Express. I am trying to set up merge replication. When I right-click the Replication folder in Object Explorer, the Configure Distribution menu item is not there. Also missing is the New - Publication menu item. All I can do is add New Subscriptions. I am logged in as admin with full priveledges. Am I missing something? Thanks!
FYI: I am running Windows XP SP2 and have installed SQL Server 2005 SP2. Thanks again...
Hey Geeks,
I have found in the SQL Server Logs under Management Menu that says something like this :
Login failed for user 'sa'. [CLIENT: 59.144.69.233], Time : 3/9/2006 3:41:53 PM
And for every second there is addition in the messages.
Why is it happening? Can anyone tell me?
Thanks in Advance.
Snehal
I'm packaging SQL 2005 Express as part of the installer for a custom program. The installer works fine and everything runs fine, but I don't want users to see the sql server > configuration tools start menu group and start playing around with settings.
Is there a command line option to not create the start menu group that anyone knows about, or another way to have the installer not create the icons?
Thanks,
Michael
Hi,
I have created a menu using code behind i.e from c#.
is there a property of menuitem, with which i can expand i particular menutiem.
following is my code:-
*****************************************************
Menu objmnu = new Menu();
MenuItem objmnu1 = new MenuItem();
objmnu1.header = "Root"
objmnu.Items.Add(objmnu1);
MenuItem objm1 = new MenuItem();
objm1.header = "Child1"
objmnu1.Items.Add(objm1);
MenuItem objm2 = new MenuItem();
objm2.header = "Child2"
objmnu1.Items.Add(objm2);
MenuItem objm21 = new MenuItem();
objm21.header = "Node1"
objm2.Items.Add(objm21);
MenuItem objm22 = new MenuItem();
objm22.header = "Node2"
objm2.Items.Add(objm22);
*****************************************************
what i want is on click of a button i want to expand "Child2" node.
i need help.
bye
Mohan Nautiyal
I have a multivalued drop down menu that isn't wide enough to display the entire label. It only displays about half of the label. The text it is trying to display should look like "Global Zone 1 - Global Zone 2 - Global Zone 3 - Global Zone 4", and the only visible text is "Global Zone 1 - Global Zone2". It does have a scroll bar at the bottom, but it is ridiculous.
When I set it to not be multivalued, the drop down menu grows to the size of my label. The menu has plenty of space to grow, it is only taking up a very small amount of the screen.
Is there any way to correct this issue?
Thanks
When using SQL Server Management Studio Express I get multiples of all the standard Windows menu items as well as in the dropdowns. I have also experienced this in the Visual Basic 2005 Exprerss edition IDE. What is causing this?
View 10 Replies View RelatedHello,
I´ve made a mistake on my part. I have deleted my complete program icons for "Microsoft SQL Server" in my start menu.
Is there a simple way to just renew all the icons in my start menu without reinstalling the complete sql server.
Thank you very much for any tips.
Hi Everyone,I'm drawing a blank here and I am hoping someone can point me in the right direction. I have a table with the following columns (some omitted)IDGUIDPageNameParentPageID I want to build a hierarchical navigation system (2-tier). The conceptual problem that I am running into was getting this information from the same table. Initially I was going to use a nested repeater but I am thinking a treeview would be better. Anyway, the problem is the query. How would I start with something like this? Let's use the following as an exampleRows(ID '1', GUID '888....', PageName 'Page A', ParentPageID '-1')(ID '2', GUID '111....', PageName 'Page B', ParentPageID '-1')(ID '3', GUID '222....', PageName 'Page C', ParentPageID '-1')(ID '4', GUID '375....', PageName 'Page 1', ParentPageID '1')(ID '5', GUID '562....', PageName 'Page 2', ParentPageID '1')(ID '6', GUID '874....', PageName 'Page 3', ParentPageID '2')
(ID '7', GUID '388....', PageName 'Page 4', ParentPageID '3') So, I want to be able to build a query so that I can do the followingPage A Page 1 Page 2Page B Page 3Page C Page 4 Any help would be greatly appreciated. Thanks!
I have a 2003 Server which has two Named Instances of SQL Server 2000.
I need to add a third Named Instance, but when I logged onto the Server this morning, I noticed that all of the
'Microsoft SQL Server' Entries are missing from the START/PROGRAMS menu !! Enterprise Manager, BOL... everything!! The SQL Server Service Manager is running and both of my Instances are up and running (this is a production box). I can launch Enterprise Manager from MMC.EXE in WINDOWSSystem32 folder... very weird!!!!
In my Add/Remove Programs, I see MS SQL Server listed Twice.. one time for each of the two named Instances.
Has anyone ever seen this before??? Do you think it's safe to run SQL Server Installation to Install a Third Instance on this box???
Hi,
I have created an SQL Server instance in SQL Server Management Studio. I have a few databases, and stored procedures in them. When I right click on the stored procedure, I have the menu for "New Stored Procedure, Modify, Script Procedure as, and so on". But, I could not see the "Execute Stored Procedure" item.
Could any one help to find out what could be the problem and solve it?
Thanks,
Luke.
Information stored within the database is as follows, although the number of sub levels could easily grow :
PageID - Title - ParentID
1 - Title1 - 0
2 - Title2 - 0
3 - Title3 - 1
4 - Title4 - 1
5 - Title5 - 4
Required outcome :
[+] Title1
.....[+] Title3
.....[+] Title4
..........[+] Title5
[+] Title2
Hi AllWondered if you could help me with the below query.I have 1 simple table called STOCKCATS that consists of 2 fields.These fields are called CATID and LEVEL.The contents of this table are as follows:CATID LEVELcat01 <nothing>cat02 <nothing>cat03 cat01cat04 <nothing>cat05 cat01cat06 cat02cat07 cat04etc.. etc...The way this table works is that I have an ASP page that allows the user tocreate a stock category at 2 levels, category level and sub-category level.When I file the entered data into the table, if the user has chosen tocreate a category level stock category then the LEVEL field is left blankand if they chose to create a sub-category level category then I post therelevant category level stock category code in the LEVEL field. Forexample, in the above list cat01 is a category level stock category andcat05 is a sub-category as it is a sub-category of cat01.My query is that I want to populate a simple HTML <SELECT> menu (using ASP),but instead of it being a straightforward 'select catid from stockcats orderby catid', I want to group this list into some kind of order, eg:instead of:cat01 <nothing> << I need to bring back this 2nd column so that I cando a simple IF THEN in asp to indent sub-catscat02 <nothing>cat03 cat01cat04 <nothing>cat05 cat01cat06 cat02cat07 cat04I would likecat01 <nothing> << dittocat03 cat01cat05 cat01cat02 <nothing>cat06 cat02cat04 <nothing>cat07 cat04Do you know if this is possible in pure SQL (I must confess that I'm usingMySQL, but I would have thought the SQL syntax would be the same if it ispossible) or a combo of ASP & SQL?ThanksRobbie
View 3 Replies View RelatedI'm stuggling to find information on how to use the Deploy menu within a project in solution explorer. I would like to understand how to setup modify and delete the attributes that affect the actions of the Deploy menu. How to set different settings so that I can deploy to a test server ad then later change it so that I can deploy to a production server.
All help is welcome.
Thanks