How To Automatically Expand A Menu Item Using WPF And C#

Oct 30, 2007



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



View 3 Replies


ADVERTISEMENT

SSMS Add New Item Not In Menu

Mar 5, 2008

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.

View 5 Replies View Related

Automatically Expand Identity Specification Node?

Mar 1, 2006

subject says it all -- is it possible to automatically expand the identity specification node in table properties for the Management Studio or VS2005 diagram mode? when creating a DB, it seems ridiculous that for EVERY table I have to add an extra click to get to just one more clickable item that ought to be exposed by default.

View 7 Replies View Related

Create A Query Where Semi Item Materials Are Also Listed In Finished Item Recipe?

Dec 6, 2013

I have a BOM table with all finished item receipes and semi items recipes. create a query where semi item materials are also listed in finished item recipe.

View 5 Replies View Related

Help, Running A Control Flow Item Does Not Kick Off The Next Item

Mar 6, 2007

Hi,

Here's my problem. I have 2 tasks defined in my Control Flow tab:

EXECUTE SQL--------->EXECUTE DTS 2000 PACKAGE

When I attempt to run it, by right-clicking the EXECUTE SQL task, and selecting "Execute Task", it only runs the EXECUTE SQL part (successfully), and does not "kick off" the EXECUTE DTS 2000 PACKAGE, after it is done running (even though it completes successfully, as shown by the green box).

Yes, they are connected by a dark green arrow, as indicated in my diagram above.

Why is this?? Am I missing something here? Need help.

THANKS

View 3 Replies View Related

How To Select The Last Identical Item# Until A Different Item# In The Table

Jul 12, 2007

Hello,Basically, I have a table with 2 fieldsId     item#1      33332      33333      22224      22225      22226      33337      33338      3333I would like to only select the last identical Item# which in this case would be  the id 6,7 and 8Any idea how could I do that?Thanks

View 1 Replies View Related

How Can I Create A New Custom Report Item? The Report Item Is Extends Matrix.

Jan 18, 2007

hi everyone

what the matrix's class name ?

where is the matrix's dll?

Can i create a new class extends the matrix?

I want to override the matrix's onpaint method.

Can i do this ?

why the table not have the column group?













View 9 Replies View Related

Finding Orders That Have At Least 1 Promo Item And 1 Non-promo Item

Oct 16, 2014

I am having trouble finishing the last bit of a report. The report shows orders that customers have placed that contain 0 promo items, All promo items (all items in order are promo items), and a mix of promo and non promo (at least 1 promo item and 1 non-promo item). Ive simplified this a bit for ease of understanding but lets assume we have 2 tables: A Promo table that contains the items on promotion and the dates that promotion is valid, and a Sales table, that contains the order number, order date, and sku ordered.

I've already written code that finds orders that have at least 1 promo item in them, and using that, I can determine what orders have 0 promo items in them. Where I am stuck is taking the orders that have at least 1 promo item in them, and separating them into orders that have only promo items, and those that have both promo and not promo items in them. Also, there are several promos throughout the year (called "Offers") so in my code below, you can see 2 different Offers ("JF" and "MA") with their corresponding dates they are valid. They will never overlap. My results also have to be split out by Offer so management can look at the results of each offer separately. Here is some code:

Code:
create table #Promos (
Offer varchar(2) null,
SKU int null,
StartDt date null,
EndDt date null

[Code] ....

So my results should show OrderNo A1111 in the Promo and No Promo group because of SKU 5 not being promotional during the time that order was placed. OrderNo A2222 should be in the Promo Only group because both SKUs on the order were promotional at the time the order was placed.

View 6 Replies View Related

How To Expand Table

Jun 13, 2007

I have a table t1
id maxday
1 4
2 6
3 3
4 10
5 10000

I want to expand it to t2
id d maxday
1 0 4
1 1 4
1 2 4
1 3 4
1 4 4
2 0 6
2 1 6
2 2 6
2 3 6
2 4 6
2 5 6
2 6 6
3 0 3
3 1 3
3 2 3
3 3 3
4 0 10
------

How can I do that? Thanks

View 9 Replies View Related

Expand Tempdb Database

Dec 8, 1999

Hi,

I need to expand tempdb database. The users keep getting this error
when they try to do a sort:
SQL Server message(1510): state 2
Sort failed. Out of space or locks in database 'tempdb'

Also in the error log I am getting these errors:
Error 1105, Severity: 17, State: 1
Can't allocate space for object '-641' in database 'tempdb'because
the 'system' segment is full. If you ran out of space in Syslogs, dump the
transaction log. Otherwise use ALTER DATABASE or sp_extendsegment to
increase the size of the segment.

What I am wondering is if expanding tempdb will fix the problem, or is
there another fix that I should be looking at.

Any direction you could give me on this would be appreciated. I have very
little experience with SQL 6.5

Thanks in advance
Phil

View 2 Replies View Related

File Auto Expand

Jan 9, 2008

In SQL 2005, when a file is expanded because of the auto expand option turned on, is this recorded anywhere (each time it expands)?

View 2 Replies View Related

How Can I Print What I See After I Expand A Drill Down?

Jun 14, 2007

I've created a report with drill downs that are hidden initially. While viewing the report in preview, I'll expand the drill down to see the data.



If I go and print the report, the report is printed as collapsed (which is the initial setting) rather than expanded (which i expanded in the preview).



Is there a way to print in the "what-you-see-is-what-you-get" kinda way expanding and collapsing drill downs?



Thanks in advance!

View 4 Replies View Related

Expand All/Collapse All In Snapshots

Mar 28, 2007

I posted last year about getting and Expand All/Collapse All link working in reports, and it does work perfectly for on-demand reporting. I was able to get these working using the boolean report parameter and then the Jump to Report option going back to itself changing that parameter.



The issue that I have just discovered is that when a report with these Expand All/Collapse All links are in a report snapshot, clicking those links will cause it to re-render the report from the datasource at the time the link is clicked. This is an issue for one of the datasources we are using because the data is always changing, so when it goes back to re-render the counts and data returned are completely different then they were when the snapshot was first created. As time goes on the data will no longer even be in the datasource since it can only maintain 4 months of data.



Is there another way to get all detail groups to expand/collapse at once that does not require the report to be completely re-rendered from the datasource?

View 1 Replies View Related

Global Expand And UnExpand

Oct 1, 2007



I would like to have a report that globally sets the visibility (or expanding and unexpanding) of a group. Right now, I have the + and - signs for a group, but have to select each on individually in the report.

Thanks,
Linda

View 1 Replies View Related

Can Not Expand MSDB Folder

Jul 23, 2007

Hi!



I am trying to deploy a package to SQL. However, when I open Integration services I can not expand MSDB folder. Error is; SQL Server specified in SSIS service configuration is not present or available.... Login time expired .....(MsDTSSrvr)



I have found post here that says MsDtsSrvr.ini.xml file needs to be changed from

<Name>MSDB</Name>
<ServerName>.</ServerName>

to

<Name>MSDB</Name>
<ServerName>MyServerName</ServerName>

I tried MyServerName - does not work. I also tried value from connecting to Database Engine ( MyServerNameSQL2K5LOCAL) - does not help either.

What am I doing wrong?



Also, I need some documentation on deploying packgaes using File System.

I have saved Copy of the Package as File System location.

When I doubleclick the .dtsx file, Connection Manager holds my local SQL info. Goal is to deploy this to Development and other environments. Can this be handled some other way so I do not have to modify this file on every environment?

Also, this Execute Utility Package says at the top to use this utility to run SSIS on local computer.

So far, help on MSoft sites did not really help me a lot.





this is what I am using:

Microsoft Visual Studio 2005
Version 8.0.50727.42 (RTM.050727-4200)
Microsoft .NET Framework
Version 2.0.50727

Installed Edition: IDE Standard

SQL Server Analysis Services
Microsoft SQL Server Analysis Services Designer
Version 9.00.2047.00

SQL Server Integration Services
Microsoft SQL Server Integration Services Designer
Version 9.00.2047.00

View 4 Replies View Related

Expand The Document Map Nodes

Feb 15, 2007

I was wondering if anyone can help me out with this. Is there any way that you can have a document map in SQL Reporting Services expand on load, or if there is a way to programmatically set the Document Map nodes to be expanded when a report is generated.

Thanks in advance for your help

View 1 Replies View Related

Drop Down Menu

Jul 15, 2004

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!

View 1 Replies View Related

SQL - A Menu System - Plz Help

Jul 20, 2005

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

SQL 2012 :: Cannot Expand Error Log In SSMS

Aug 5, 2015

I get the following error when I try to expand the sql server log in the management studio. My login is in the securityadmin server role.

TITLE: Microsoft SQL Server Management Studio
------------------------------

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

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

A severe error occurred on the current command. The results, if any, should be discarded. (Microsoft SQL Server, Error: 0)

View 5 Replies View Related

Can't Expand User Database Tables

Dec 5, 2007

We have a person who CAN connect to a named instance in SQL Server Management Studio. There is nothing in the log for a failed login for him. However, when he tries to expand the Tables folder under the only user database in the instance, he gets the error: Failed to retrieve data for this request (Microsoft.SQLServer.SmoEnum). Additional Information: An exception occured while executing a Transact-SQL statement or batch. Select permission denied on object 'extended_properties',database 'mssqlsystemresource', schema 'sys'(Microsoft SQL Server, Error:229).

He is trying to expand the Tables folder under a database named ADSALLDB. He can see the folder as well as the other folders (i.e. Views, Synonyms, Programmability,etc.), but can't expand any of them. He can expand the folders under the system databases.

Other uses set up just like him can connect. He is set up with read/write access to the database ADSALLDB. He can expand the system databases.

This is a named instance in a 6 node cluster. SQL Server 2005 SP1 Build Level 2221.

Thank you for any help.

View 2 Replies View Related

Database Server Will Not Expand Mdf Or Ndf Files

Jul 23, 2005

Has anyone had an issue with SQL Server not being able to expandagainst a RAID 5 file system? My current configuration is that theserver is started and stopped using the local system account. I haveonly one database (besides the master, model,etc)on the server. Whathas happend to me several times is that the primary database inquestion try's to expand the main datafile for the database (.mdf). Isetup the database to not expand automatically initially so that I canbe sure that we have enough file system space. Becuase of problems withthe application I decided to automatically expand. The other day thedevelopers came to me indicating that the databse was full and neededto be expanded. Knowing that the database was in automatic expandingmore I was surprise to hear this. I went into EM and attempted toexpand first the log and it would not indicating that it there was anissue in attempting to do so. I have never heard of a database notbeing able to expand. I ran DBCC's, etc and it came up clean. I triedto back the database up to disk and it would not backup. I finally hadto rename the datbase and rebuild it using DTS and scripts. I thoughtI had fixed it only to find out today that it (again) won't expand. Irenamed the datbase and then tried taking an older backup file andrestore it and it would not restore. This problem seems to be relatedto the file system but how I do not know.So, I am ready to run rebuild master but I have sone this before onlyto have this come back on me. I am at a complete loss. In the past Ihave had to rebuild the entire server and database from scratch. Theonly problem is that this has been done 3 times now with no completesolution or explaination. If any of you have seen this type ofbehavior and know whats going on please, please let me know what youthink the case and solution is!

View 8 Replies View Related

Conditional Expand/Collapse Of Groups

Dec 21, 2007

Hi All,

I have a report that is grouping phone calls by "Category" (Outgoing, Incoming, Voicemail, etc). When the report is rendered, each category (along with totals) is shown and the details (each actual call) are hidden. Using toggling, I allow the user to burst open any category to view all of the call details.

I join the query for this report so that even if a category has 0 calls for the day, it is still shown. When expand a category with no calls I get a blank record (as I should, because there are no call details).

The question I have is ... Can I have the toggle be conditional? Can I have the ability to toggle thr group only when there are call details? Can I have the + to the left of the category name not be shown?


Thanks in advance for any help!
Merry Christmas!!!

-Matt

View 5 Replies View Related

Problems With Group Collapse/expand

Feb 27, 2007

On one of my reports, the +/- for expand/collapse of groups is reversed -- i.e. when the group is expanded it displays "+" and when the group is collapsed it displays "-". The display of the document map is correct.

Has anyone else had this problem?

thx

Helen

View 9 Replies View Related

Solution To The Expand All Or Toggle All Issue

Mar 9, 2007

I have seen a few posts in several forums about SQL Reporting Services 2005 not supporting the expand all / toggle all / or show all feature that many of us require for our report clients. A simple method I use is to create a report parameter names ShowAll. In the properties I have the following: Name is ShowAll / Data type is String / Prompt is Show All? and the Allowo blank value box is checked. In available values I chose Non-queried and in Label and Value I placed Yes - Collapsed and No - Expanded then in Default values I put Collapsed

Then on the field's initial visibility property, I changed the default from collapsed to expression and added the following:

=iif(Parameters!ShowAll.Value = "Collapsed", True, False)

View 8 Replies View Related

How Do You Refresh Menu When Using SqlSiteMapProvider

Jun 23, 2005

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 Related

Database Menu Structure

Sep 30, 2005

Hello,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 Related

Get Distinct Value Of Menu From Table

Mar 29, 2014

How 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

View 4 Replies View Related

Foreign Key As Drop Down Menu

Apr 5, 2006

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)???

View 3 Replies View Related

Results From Sql To Drop Down Menu

Jun 12, 2006

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?

View 2 Replies View Related

View SQL Agent Menu

Mar 13, 2008

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.

View 3 Replies View Related

Dropdown Menu In Sql Reporting

Jan 22, 2007

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) ..



View 4 Replies View Related

Is There A Way To Redefine Expand/Collapse Sum Formula - Or Hide The Sum??

Feb 27, 2007

I have a relatively simple problem.

I have a db-query that returns quite a few rows which I must show in a table.
At initial load the report only shows the row group heading for the detailed data, and when clicked the detailed data for a group expands.

My problem is that reporting services assumes that when collapsed it should summarize everything in each column and display it.

Here is an illustration of the problem.

First the detailed view of my data (Notice the 5th and 6th rows which are simply the values in the 1st through 4th rows divided into groups - and the "Total" row shows the actual total for Row 1 Group Header:
[-] "Row 1 Group Header" "Detail data 1" "10" "Detail data 2" "10" "Detail data 3" "4" "Detail data 4" "6" "Row 1 group 1" "20" "Row 1 group 2" "10" "Total" "30"
The detailed view is just as I want it - no problems there.

However, when the detailed view is collapsed, reporting services calculates the sum for the column - which is 90 - not 30 as is the actual total:
[+] "Row 1 Group Header" "90"

Is there any way I can redefine the formula/insert filters used for calculating the "collapsed-total" for each column when the row is collapsed? Or maybe simply prevent it from showing a "collapsed-total" altogether? Or can you think of another way to structure the data so the "collapsed-totals" gives me the actual value (30)?

I thought about splitting the values into a column for each data-group, so that I'd have a column for the "Detail data n" values, a 2nd column for the "Row 1 group n" values and a 3rd column for the "Total" values - this would yield correct "collapsed-total" values. But is really a plan B - I really do not want to do that unless it is the only way out of my dilemma.

View 2 Replies View Related

Auto-expand Drill-downs On Print

Feb 6, 2008



Yet another newbie question here in my quest to learn reporting services.

Is there a property I can set to automatically expand all drill-downs when a user goes to print a report? As it is now all the drill-downs remain collapsed when the user goes to print, which is problematic on large reports where there may be many records between groupings (users may expand one group containing 1000's of records, and then decide to simply print everything -- but they'll only get the expanded data -- I'd like to expand everything automatically and have it all print.)

Thanks,

View 3 Replies View Related







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