Datasets window display

Hi

When designing a report layout, I want to use the Datasets window, however, I could not find how to open this window. In MSDN, it says" On the View menu, click Datasets" to display the Datasets window. But I could not find the Datasets under the View menu on my local. Any advice? Thanks.

Hi,jiamei:

Would you please tell in which article from MSDN, you have found this words?

|||

Rex,

Here it is:http://msdn2.microsoft.com/en-us/library/ms365160.aspx

|||

Hi,jiamei:

Which project are you in? When you stay in the report project, you can click the 'view menu' on the top of the window and you will find the dataset option in the last position of the pop up list.

datamodelling

Hi,
I'm designing a database where i have some tables about contacts. What i
would like to know is what the best design is for creating contacts.
I have a table relations where i store persons name and company names. Now
to determine the relation where who is related to who, e.g. a company and
their contacts or a family with their family members, i need some sort of a
recursive table/query.
Can anyone help me with this or is what i want not the right way?
First of all you have to know what are your entities an their atributes,
after that need to know what kind of relation you want, then you determine
the cardinality of it, and only at the end of work you will see if is
necessary some other indexes or special constraints and can evaluate the
performance.
Ex:
The entitys and atributes are:
Family (familyid, familyname) and Family members (memberid, membername)
If you want a family have various members and a member is on only one
family, then it is a 1 to N relation.
Then you will model your tables (2 tables and 1 relation) like:
Family (familyid as PK, familyname) <- Family members (memberid as PK,
familyid as PK and FK, membername)
If you want a family have various members and a member is on more than one
family, then it is a N to N relation.
Then you will model your tables (3 tables and 2 relations) like:
Family (familyid as PK, familyname) <- Familymembers (memberid as PK and FK,
familyid as PK and FK)
Members (memberid as PK, membername) <- Familymembers (memberid as PK and
FK, familyid as PK and FK)
It seems you need to study a little about normalization. ; )
Regards
BMartins (Brazil)
"Jason" <jlewis@.homail.com> escreveu na mensagem
news:OiGcCjJNFHA.2680@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I'm designing a database where i have some tables about contacts. What i
> would like to know is what the best design is for creating contacts.
> I have a table relations where i store persons name and company names. Now
> to determine the relation where who is related to who, e.g. a company and
> their contacts or a family with their family members, i need some sort of
a
> recursive table/query.
> Can anyone help me with this or is what i want not the right way?
>

datamodelling

Hi,
I'm designing a database where i have some tables about contacts. What i
would like to know is what the best design is for creating contacts.
I have a table relations where i store persons name and company names. Now
to determine the relation where who is related to who, e.g. a company and
their contacts or a family with their family members, i need some sort of a
recursive table/query.
Can anyone help me with this or is what i want not the right way?First of all you have to know what are your entities an their atributes,
after that need to know what kind of relation you want, then you determine
the cardinality of it, and only at the end of work you will see if is
necessary some other indexes or special constraints and can evaluate the
performance.
Ex:
The entitys and atributes are:
Family (familyid, familyname) and Family members (memberid, membername)
If you want a family have various members and a member is on only one
family, then it is a 1 to N relation.
Then you will model your tables (2 tables and 1 relation) like:
Family (familyid as PK, familyname) <- Family members (memberid as PK,
familyid as PK and FK, membername)
If you want a family have various members and a member is on more than one
family, then it is a N to N relation.
Then you will model your tables (3 tables and 2 relations) like:
Family (familyid as PK, familyname) <- Familymembers (memberid as PK and FK,
familyid as PK and FK)
Members (memberid as PK, membername) <- Familymembers (memberid as PK and
FK, familyid as PK and FK)
It seems you need to study a little about normalization. ; )
--
Regards
BMartins (Brazil)
"Jason" <jlewis@.homail.com> escreveu na mensagem
news:OiGcCjJNFHA.2680@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I'm designing a database where i have some tables about contacts. What i
> would like to know is what the best design is for creating contacts.
> I have a table relations where i store persons name and company names. Now
> to determine the relation where who is related to who, e.g. a company and
> their contacts or a family with their family members, i need some sort of
a
> recursive table/query.
> Can anyone help me with this or is what i want not the right way?
>

datamodelling

Hi,
I'm designing a database where i have some tables about contacts. What i
would like to know is what the best design is for creating contacts.
I have a table relations where i store persons name and company names. Now
to determine the relation where who is related to who, e.g. a company and
their contacts or a family with their family members, i need some sort of a
recursive table/query.
Can anyone help me with this or is what i want not the right way?First of all you have to know what are your entities an their atributes,
after that need to know what kind of relation you want, then you determine
the cardinality of it, and only at the end of work you will see if is
necessary some other indexes or special constraints and can evaluate the
performance.
Ex:
The entitys and atributes are:
Family (familyid, familyname) and Family members (memberid, membername)
If you want a family have various members and a member is on only one
family, then it is a 1 to N relation.
Then you will model your tables (2 tables and 1 relation) like:
Family (familyid as PK, familyname) <- Family members (memberid as PK,
familyid as PK and FK, membername)
If you want a family have various members and a member is on more than one
family, then it is a N to N relation.
Then you will model your tables (3 tables and 2 relations) like:
Family (familyid as PK, familyname) <- Familymembers (memberid as PK and FK,
familyid as PK and FK)
Members (memberid as PK, membername) <- Familymembers (memberid as PK and
FK, familyid as PK and FK)
It seems you need to study a little about normalization. ; )
Regards
BMartins (Brazil)
"Jason" <jlewis@.homail.com> escreveu na mensagem
news:OiGcCjJNFHA.2680@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I'm designing a database where i have some tables about contacts. What i
> would like to know is what the best design is for creating contacts.
> I have a table relations where i store persons name and company names. Now
> to determine the relation where who is related to who, e.g. a company and
> their contacts or a family with their family members, i need some sort of
a
> recursive table/query.
> Can anyone help me with this or is what i want not the right way?
>

Datamart

Hi,
I need some advise. We are in he process of designing our first data
mart. This Datamart will consists of sales orders activity. Sales
orders have lines created, deleted and inserted on a daily basis as
long as the sales order is open.
It has been suggested that we do triggers the these tables and then
populate the Datamart. Which the DBA is not thrilled with. is there
another way to do this wihtout triggers.?
The data needs to get updated daily and the volume is about 500K rows.
The data is being sourced from an ERP and the DB is oracle 9i. We also
have the option of using SQL Server if need be. Our BI tool is Cognos
and ETL tool is not an option since our data tranformations are very
simple.
Please share your experience.
Regards
Ather
Ather
I only put complete / closed / posted items into my DWH unless the business
can justify why they want incomplete / incorrect data in the DWH, so i would
only transfer closed orders
Use MS- SQL as your DWH server as you get DTS (Data Transformation
Services) with it, which can be used as a lightweight ETL tool
Create some DTS packages to update your DWH at the end of each day ( or any
other viable interval) with the new closed orders
Unless you have paid for / are forced to use COGNOS look carefully at
reporting services and analysis services as your BI tools
Regards
Reg Besseling
"Ather Mian" <ather@.nowwhere.com> wrote in message
news:eIdrqSV4EHA.2180@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I need some advise. We are in he process of designing our first data
> mart. This Datamart will consists of sales orders activity. Sales
> orders have lines created, deleted and inserted on a daily basis as
> long as the sales order is open.
> It has been suggested that we do triggers the these tables and then
> populate the Datamart. Which the DBA is not thrilled with. is there
> another way to do this wihtout triggers.?
> The data needs to get updated daily and the volume is about 500K rows.
> The data is being sourced from an ERP and the DB is oracle 9i. We also
> have the option of using SQL Server if need be. Our BI tool is Cognos
> and ETL tool is not an option since our data tranformations are very
> simple.
> Please share your experience.
> Regards
> Ather
>
|||Identify all the OPEN orders (order status or some other combination of
field(s) ) which will narrow the list of orders that will get affected in
your datamart. For these open orders:
(1) Delete the orders from your datamart.
(2) Re-insert the data about the open orders.
I am making an assumption that you do not have track the order status
history itself. I am also making an assumption that data about "closed"
orders does not change and/or you do not want to change them in the datamart
in any way.
Hope this helps.
Rangarajan Suresh
www.picarossolutions.com
*********************
"Ather Mian" wrote:

> Hi,
> I need some advise. We are in he process of designing our first data
> mart. This Datamart will consists of sales orders activity. Sales
> orders have lines created, deleted and inserted on a daily basis as
> long as the sales order is open.
> It has been suggested that we do triggers the these tables and then
> populate the Datamart. Which the DBA is not thrilled with. is there
> another way to do this wihtout triggers.?
> The data needs to get updated daily and the volume is about 500K rows.
> The data is being sourced from an ERP and the DB is oracle 9i. We also
> have the option of using SQL Server if need be. Our BI tool is Cognos
> and ETL tool is not an option since our data tranformations are very
> simple.
> Please share your experience.
> Regards
> Ather
>
>
|||What Will happen to orders that change from open to closed ? it seems to me
that they will get "Lost" until the next full refresh
Regards
Reg Besseling
"Rangarajan Suresh" <RangarajanSuresh@.discussions.microsoft.com> wrote in
message news:DC96DE91-8994-41BD-A84F-5FED65FBA3D6@.microsoft.com...[vbcol=seagreen]
> Identify all the OPEN orders (order status or some other combination of
> field(s) ) which will narrow the list of orders that will get affected in
> your datamart. For these open orders:
> (1) Delete the orders from your datamart.
> (2) Re-insert the data about the open orders.
> I am making an assumption that you do not have track the order status
> history itself. I am also making an assumption that data about "closed"
> orders does not change and/or you do not want to change them in the
> datamart
> in any way.
> Hope this helps.
> Rangarajan Suresh
> www.picarossolutions.com
> *********************
>
> "Ather Mian" wrote:
|||I guess I should have also addressed the issue of "closed orders" along with
"open orders" -- The closed orders are to be loaded as inserts into the
datamart. They do not necessarily fall under the issue of "replacing"
existing open orders that may have changed in some fashion. Since we are
deleting existing open orders from the datamart, the same order will not go
into the datamart as it is no longer open.
Sorry for the confusion.
Rangarajan Suresh
www.picarossolutions.com
*********************
"Reg Besseling" wrote:

> What Will happen to orders that change from open to closed ? it seems to me
> that they will get "Lost" until the next full refresh
> Regards
> Reg Besseling
> "Rangarajan Suresh" <RangarajanSuresh@.discussions.microsoft.com> wrote in
> message news:DC96DE91-8994-41BD-A84F-5FED65FBA3D6@.microsoft.com...
>

Database/Query Design Help

I am designing an ASP.NET app that can be used to keep track ofattendance at office hours for a class. The purpose of this isthat we need to know if a student is attending office hours bydifferent people (so that we can flag them as "in trouble"). Idon't know if I have chosen the best database design, and I'm lost asto how to accomplish a query I need.
I have a table HoursAttendance that has the following design.
Column_Name Data_Type Length Allow_Nulls
TA char 4 n
Date smalldatetime 4 n
Start smallint 2 n
End smallint 2 n
Student1 bit 1 y
Student2 bit 1 y
Student3 bit 1 y
Student4 bit 1 y
Student5 bit 1 y
I chose to have the students as columns because the students don'tchange, and then you add rows of office hours. If students arethe rows, then you would be adding columns as the semester continuedwhich I thought was odder...? I'm completely open to suggestionson Database Design, because I really wasn't sure.
Ok, so now I need useful queries. The one that I am stuck on (andalso the first one besides select * from HoursAttendance) is that Iwant the names of Students who have attended more than x officehours. So I need something like
select <column name> from HoursAttendance where count(sum(<column name>)) > x
Granted a better table design could help with this. I'mrelatively new to design, so constructive criticism is desired please

You can't run a query like that if the students are columns. My suggestions:

Students
---
StudentID int
StudentLastName varchar(25)
StudentFirstName varchar(25)
HoursAttendance
------
HoursAttendanceID int
StudentID int
TA char(4)
AttendanceDate smalldatetime
Hours tinyint
Select StudentID, Sum(Hours)
From HoursAttendance
Group By StudentID
Having Sum(Hours) > x
Hope that helps!
Marcie

|||This is why I didn't go with something like what you suggested: It seems with the HoursAttendance table set up like that that it should be broken into an Hours table and an Attendance table.
This seems like way too many tables lol!!
Oh well, I guess.|||Could be -- what would you put in the Hours table vs. the Attendance table? For the most part, trying to cram everything into one table leads to a poor database design (and is not normalized).

This seems like way too many tables lol!!

Scoff...at work I work on a system with several hundred tables, this is nothing!
Marcie|||

There are 9 TA's that hold weekly office hours. I have a TA table and a DefaultHours table. The DefaultHours table has when the TA normally holds hours (I use this to set selectedValue in time drop down lists. 5-20 students attend each office hour. So that means there are 5-20 rows that have TA, Date, Start, End in common. Which is where I was referring to moving that to a separate table. *shrug*

|||Sure, you could put that in a separate table then:
OfficeHours
----
OfficeHourID int
TA char(4)
Date smalldatetime
Start int
End int
Attendance
----
OfficeHourID
StudentID
Marcie|||I'm just not sure as to what would be the "best" (most efficient in terms of performance and space)
|||Having the extra tables *saves* space because data isn't repeated in any one table. (Normalization) The performance difference between having one HoursAttendance table and splitting them into two would not even be measurable.
Marcie

database updates not reflected in report

Iam using visual web developer express with sql server 2005 with advanced services. Iam designing my database reports with sql server reporting services(SQL server business interlligence development studio) and they are running correctly. Problem is, when i add records to my database and then go back and run my reports, the new records effects are not reflected in my new report runs.May be i should say my reports do not update. they only retrieve the data that was already in the database table during the time of report design. I dont know a way of forcing updates to be reflected in the reports.

Help Appreciated.

The updates aren't instant. Try closing the report and reopening after you make an update.