|
I'm creating a report in Microsoft Reporting tool which uses VB.NET (which I don't know very well) I'm trying to select the Top 1 payment type but I can't get the syntax to work.
I have =Top 1(Fields!paymenttype.Value) and it's not working, what would the correct expression be in VB.NET to pull the Top record?
Thank you for any help!
|
|
|
|
|
What kind of an object are you getting the data from? And what version of Visual Studio do you use?
If you are using a DataTable you could use
dtMyTable.Row(0)("PaymentType")
To access the "PaymentType" column in the very first record.
dtMyTable.Row(1)("PaymentType")
To access the second record, and so on.)
If you mean the greatest record, you would have to sort the data first, by which ever column you wish to sort by. You'd have to do the sorting in SQL or by using a DataView control.
Does this help?
|
|
|
|
|
I'm using Visual Studio 2003 and the data is coming from a SQL 2000 table that I am connected to and am pulling data from via a Query Select statement.
|
|
|
|
|
Can you give us your entire SQL statement. What you have there is invalid.
|
|
|
|
|
I don't know exactly where you are trying to use the top statement, but it's certainly in the wrong place. The top statement should be placed directly after the select statement:
select top 1 ... from ... where ... order by ...
---
b { font-weight: normal; }
|
|
|
|
|
Sorry for the delay, I was at work. What I realized I need is
=Max(Fields!paymentcode)
Thank you to everyone who responded, I'll try to be clearer next time.
|
|
|
|
|
I know you got the solution - but wanted to point out something - if the ONLY reason you are fetching the data is to get the top payment mode, then you should do it in the Select query and not after ALL the rows are fetched.
Shreekar
http://shreekarishere.blogspot.com
|
|
|
|
|
Hi,
I'm trying to write an addin for Visual Studio 2005 (using VB.NET) . I have all the functionality of the addin working fine as a bunch of macros. I want the addin to add some context menu items to each of the project items in my solution. But I have no idea how to do it! Can anyone tell me how it's done or point me in the right direction?
Thanks,
dlarkin77
|
|
|
|
|
Hi,
I have all the menu items working fine now but I still have a few other things to get sorted out.
I am adding some menu items to the context menu of the Project Folder. I want them all to appear after the Build, Rebuild and Clean menu items. How can I add a seperator before my first menu item and after my last menu item?
I have added a few menu items to the context menu of the code window. How can I fix it so that these menu items are only displayed when the active document is either a .cs or .vb file?
How can I get rid of the icons that are added automatically to my menu items?
Thanks very much,
dlarkin77
|
|
|
|
|
Hello, I am currentally having problems with the current line of code:
.Relations.Add("FK_Salaries_Employees", _
.Tables("Employees").Columns("EmployeeID"), _
.Tables("Salaries").Columns("EmployeeID"), True)
This program uses SQL server to draw its data from, but the following error occurs:
An unhandled exception of type 'System.ArgumentException' occurred in system.data.dll
Additional information: These columns don't currently have unique values.
Any futhur help on solving this error, or perhaps shed some more light on what this means?
Thanks,
Kashar
|
|
|
|
|
If you don't have unique values, then you can't create foreign keys. The purpose of a foreign key is to make sure that the 2 rows in each table can be lined up. To do this, one of the tables needs to have unique entries for the column name you listed.
|
|
|
|
|
The values are unique, Table Employees:
EmployeeID FirstName SurName DateOfBirth SecurityPhoto DateOfHire LastReview
1 Robin Johnson 6/19/1963 10:47:00 AM <binary> 5/3/2000 10:47:00 AM 3/9/2002 10:47:00 AM
2 Denise Samson 11/6/1972 10:47:00 AM <binary> 10/19/2002 10:47:00 AM 5/10/2001 10:47:00 AM
3 Jack Jones 2/22/1945 10:47:00 AM <binary> 4/16/1999 10:47:00 AM 3/15/2002 10:47:00 AM
4 John Doe 9/18/1986 10:47:00 AM <binary> 3/6/1998 10:47:00 AM 3/9/2002 10:47:00 AM
5 Linda Glucina 4/9/1944 10:47:00 AM <binary> 2/9/2000 10:47:00 AM 3/11/2002 10:47:00 AM
6 Laura Wright 2/7/1978 <binary> 2/23/1999 4/13/2002 11:23:00 PM
7 Stephanie Glucina 5/16/1963 <binary> 5/21/2001 4/12/2002 11:23:00 PM
8 Linda Anderson 12/10/1981 <binary> 7/9/2000 4/13/2002 11:23:00 PM
9 Graham Brown 6/7/1945 <binary> 8/11/1999 5/16/2001 11:23:00 PM
10 Suzanne Smith 11/2/1960 <binary> 1/6/1998 3/14/2002 11:23:00 PM
11 David Allan 9/22/1973 <binary> 11/21/1999 3/13/2002 11:23:00 PM
Table Salaries:
EmployeeID SalaryAppliedFrom SalaryLevel
2 1/25/2002 119896
3 1/17/2002 119792
4 1/1/2002 119584
5 11/30/2001 119168
6 9/27/2001 118336
7 5/22/2001 116672
8 9/8/2000 113344
9 4/15/1999 106688
10 6/25/1996 93376
11 11/16/1990 66752
|
|
|
|
|
Say:I have vb application which uses a .Net dll.If i had to repaint or refresh the calling VB application from the .Net dll's code,how could i do that?
I tried using (Application.DoEvents) method but it doesnt effectively work, the vb application screen becomes white when focus is moved to other open windows and brought back...
Do not wait to strike till the iron is hot; but make it hot by striking.
-- modified at 12:12 Thursday 1st June, 2006
|
|
|
|
|
Seeing a heading like that in the lounge I was thinking that someone was asking a sugestion to repaint their house. 
Please Move your post to the VB/VB.Net forum.
Tarakeshwar
MCP, CCIE Q(R&S)
Before you criticize someone, you should walk a mile in their shoes. That way, when you criticize them, you're a mile away and you have their shoes.
!sgub evah t'nseod margorP sihT ?sgub naem ayaddahW
|
|
|
|
|
Solution: Dont' use VB 
Never send a human to do a machine's job Agent Smith
|
|
|
|
|
That's only half a solution.
The other half would be what to use instead. 
---
b { font-weight: normal; }
|
|
|
|
|
Guffa wrote: The other half would be what to use instead
But that would be telling...;)
Never send a human to do a machine's job Agent Smith
|
|
|
|
|
thanks for ur suggestion
Do not wait to strike till the iron is hot; but make it hot by striking.
|
|
|
|
|
Ya see if you come to the right place, you'll learn an awful lot.
Never send a human to do a machine's job Agent Smith
|
|
|
|
|
Thank u ,that was my first message and realized later about what is lounge and other language specifc forums
Do not wait to strike till the iron is hot; but make it hot by striking.
-- modified at 3:18 Friday 2nd June, 2006
|
|
|
|
|
norm.net wrote: Ya see if you come to the right place, you'll learn an awful lot.
That goes for coming to the wrong place also. 
---
b { font-weight: normal; }
|
|
|
|
|
Guffa wrote: That goes for coming to the wrong place also
Never a true word.
Never send a human to do a machine's job Agent Smith
|
|
|
|
|
norm.net wrote: Never a true word.
No?
Say that you were trying to get to work, and accidently ended up in Toulouse instead. Don't you think that you would learn a lot?
---
b { font-weight: normal; }
|
|
|
|
|
Say:I have a house of cards which is built on a foundation of tissue paper. If i want to add a balcony filled with jumping beans, how could i do that?
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
