Displaying Fields from Multiple Datasets (RS2000)

Hi guys, I have this problem of displaying fields from multiple datasets.

When I drag a field from the first dataset into a table, it works and displayed correctly. However when I dragged a field from a second dataset, it will be shown as

=First(Fields!FirstName.Value, "DataSet2") for Strings and

=Sum(Fields!StatusFlag.Value, "DataSet2") for Integers

I just want the integer from that single row but it sums up all the rows. When I removed the SUM keyword, the IDE will show build errors when I try to build the report. Is there any way to get around this? thanks!

Use the First keyword for integers as well.|||According to the data types, the IDE will always choose SUM as the aggregate for numeric values and FIRST as the aggregate for non-Integers. As Brad mentioned you can changed that, this is just a suggestion of the Designer.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Display SQL Information in VB

How can I display and retreive information from an SQL Express 2005 database in a Visual Basic Express 2005 application?

I know that I can drag and drop a node onto the form (to display a sort of spreadsheet), but the method I wish to approach is to display information in a text box.

Start here to learn about all kinds of databinding goodness.

Mike

Display of SqlDataSource

I'm trying to follow along with lesson07 Web Development Express series and when I drag the SqlDataSource tool onto my form I do not see the object on the screen. I therefore can not configure it until I have placed GridView object onto my form.

I hope you can help me in how to view the SqlDataSource or inform me where I can get further informationThere is a menu option to show/hide the controls which have no display. Sorry, can't think of it off hand, but it's there.|||

Thanks;

I found it under View-Non_Visual Controls

Bruce

Display in pageHeader

Hi,

i got one problem. I want to show my username in pageHeader.when i drag and drop my value from dataset to pageheader its giving some error.

in Body its working.but i want show only in page header that username.

can any body help me.

kiran

common workaround for header errors occuring is this

create a textbox in your body, make it hidden in the textbox properties (hidden=true)

put the data you are interested in in the expression for the textbox

(e.g. in your case =User!UserID )

then in the header you can reference this as follows

= reportItems!<yourtextboxnamehere>.Value

|||there is also another way to display dataset value in Page Header/ Page Footer. It is that u do one thing that make one internal parameter for that field and put textbox in header/footer and go into expressions then click on parameter, u will get the list of parmeter select that parameter which u want.|||

Hi Thanx for reply. I know this one but actual problem is its not getting in my first page from 2 pages onewards only my user name is coming.because first header will come so first time no data. second time onwards its coming. i want to show in first page also?

thanx

|||You say that it is not appearing on the first page.

I'm only aware of the ability to supress after the first page and not the inverse of this.