Report Builder imported questions from a customer

Hi,
1. If a table has a relation to itself example :
employee id emp name manager id
1 Melissa 2
2 Steven 100
This means Steven is the manager of Melissa.
Is it possible to make a report in Report Builder to have a list with of the
managers and their employees?
2.Following example in report builder an organization with his employees you
will see in Report builder this : (organization will appear only once)
Microsoft Steven
Melissa
BMW Jan
Els
In export to xls the customer wants to see this :
Microsoft Steven
Microsoft Melissa
BMW Jan
BMW Els
Is this possible?
And if a certain organization does not have employees they want to see this
organization for the moment the report only list organizations with employees?
3. If the email field of a person (table 1) is empty they want to see in the
report the email field of the organization (table 2) is this possible with
the function if then else... in the creation of a new field without having
fields of the organization in the report displayed?"carolineb" <carolineb@.discussions.microsoft.com> wrote in message
news:FE5D33EF-66CC-4420-B60C-CC8AC82AA616@.microsoft.com...
> Hi,
> 1. If a table has a relation to itself example :
> employee id emp name manager id
> 1 Melissa 2
> 2 Steven 100
> This means Steven is the manager of Melissa.
> Is it possible to make a report in Report Builder to have a list with of
> the
> managers and their employees?
Write query like this:
select
c2.Name as ManagerMame,
c1.*
from Employees c1
left join Employees c2
on c2.EmployeeID = c1.ManagerID
order by c1.ReportsTo
> 2.Following example in report builder an organization with his employees
> you
> will see in Report builder this : (organization will appear only once)
> Microsoft Steven
> Melissa
> BMW Jan
> Els
> In export to xls the customer wants to see this :
> Microsoft Steven
> Microsoft Melissa
> BMW Jan
> BMW Els
> Is this possible?
> And if a certain organization does not have employees they want to see
> this
> organization for the moment the report only list organizations with
> employees?
As far as I know this is not possible (export should be WYSIWYG if it is
working correctly)
> 3. If the email field of a person (table 1) is empty they want to see in
> the
> report the email field of the organization (table 2) is this possible with
> the function if then else... in the creation of a new field without having
> fields of the organization in the report displayed?
>
Yes it is possible, you don't have to display all fields.
Regards,
Stjepan|||"Stjepan Puljko" wrote:
> "carolineb" <carolineb@.discussions.microsoft.com> wrote in message
> news:FE5D33EF-66CC-4420-B60C-CC8AC82AA616@.microsoft.com...
> > Hi,
> >
> > 1. If a table has a relation to itself example :
> >
> > employee id emp name manager id
> > 1 Melissa 2
> > 2 Steven 100
> >
> > This means Steven is the manager of Melissa.
> > Is it possible to make a report in Report Builder to have a list with of
> > the
> > managers and their employees?
> Write query like this:
> select
> c2.Name as ManagerMame,
> c1.*
> from Employees c1
> left join Employees c2
> on c2.EmployeeID = c1.ManagerID
> order by c1.ReportsTo
> caroline : we cannot write a select in report builder?
> >
> > 2.Following example in report builder an organization with his employees
> > you
> > will see in Report builder this : (organization will appear only once)
> >
> > Microsoft Steven
> > Melissa
> > BMW Jan
> > Els
> > In export to xls the customer wants to see this :
> > Microsoft Steven
> > Microsoft Melissa
> > BMW Jan
> > BMW Els
> > Is this possible?
> > And if a certain organization does not have employees they want to see
> > this
> > organization for the moment the report only list organizations with
> > employees?
> As far as I know this is not possible (export should be WYSIWYG if it is
> working correctly)
> > 3. If the email field of a person (table 1) is empty they want to see in
> > the
> > report the email field of the organization (table 2) is this possible with
> > the function if then else... in the creation of a new field without having
> > fields of the organization in the report displayed?
> >
> Yes it is possible, you don't have to display all fields.
caroline : I have tried to do this and was only allowed to use fields of one
table in the if then else function, he did allowed to select a field from
another table in the if then else but indicated with an error message that
the function is not valid?
> Regards,
> Stjepan
>
>

replication. change user in client and not replicate all data (only new data).

hello, I need to replicate data in several clients of SQL server. The
replication I do it by means of a dynamic filter, according to suser_sname.
The problem is that I need the client can change the user and replicate
another data set, but only the created new data from last time that the
same user executed the replication (possibly in another client). how it
could make this?
I think what you are talking about is called realignments.
This is where a salesman is getting a subscription based on a filter which
only gives him data for his clients, ie the filter is on Salesman_A. You
want him to be able to now get only Salesman_B's data.
Your best bet is probably to drop the subscription and create a new dynamic
subscription and this time perhaps filter on hostname and hardcode the value
of the HostName parameter in the merge agent as Salesman_B.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Toms Hernndez" <tomihernandez@.yahoo.es> wrote in message
news:OK4lkRNwEHA.3320@.TK2MSFTNGP14.phx.gbl...
> hello, I need to replicate data in several clients of SQL server. The
> replication I do it by means of a dynamic filter, according to
suser_sname.
> The problem is that I need the client can change the user and replicate
> another data set, but only the created new data from last time that the
> same user executed the replication (possibly in another client). how it
> could make this?
>
|||Yes I could drop and recreate a new dynamic subscription with other
user. But my problem is replicate only the new data from the last
replication by this user,
although it does not have in local the previous data because this
replication became in another client.
Are you understand my problem?
Thanks.
"Hilary Cotter" <hilary.cotter@.gmail.com> escribi en el mensaje
news:O6hqeeNwEHA.3296@.TK2MSFTNGP10.phx.gbl...
> I think what you are talking about is called realignments.
> This is where a salesman is getting a subscription based on a filter which
> only gives him data for his clients, ie the filter is on Salesman_A. You
> want him to be able to now get only Salesman_B's data.
> Your best bet is probably to drop the subscription and create a new
dynamic
> subscription and this time perhaps filter on hostname and hardcode the
value
> of the HostName parameter in the merge agent as Salesman_B.
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "Toms Hernndez" <tomihernandez@.yahoo.es> wrote in message
> news:OK4lkRNwEHA.3320@.TK2MSFTNGP14.phx.gbl...
> suser_sname.
>
|||Perhaps I don't understand your problem.
Is your problem that this laptop could have some recently entered data in,
and you want to sync it up to the publisher, before deploying your new
subscription?
If so, you could set the merge agent to run on a schedule (make sure you
remove the -Continuous switch) and run the merge agent a couple of times
before dropping the subscription.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Toms Hernndez" <tomihernandez@.yahoo.es> wrote in message
news:u$vJJmNwEHA.3840@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> Yes I could drop and recreate a new dynamic subscription with other
> user. But my problem is replicate only the new data from the last
> replication by this user,
> although it does not have in local the previous data because this
> replication became in another client.
> Are you understand my problem?
> Thanks.
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> escribi en el mensaje
> news:O6hqeeNwEHA.3296@.TK2MSFTNGP10.phx.gbl...
which[vbcol=seagreen]
> dynamic
> value
replicate[vbcol=seagreen]
the[vbcol=seagreen]
it
>
|||no, I will try to explain,
The replication begin in the subscriber, it is a pull merge
subscription. And the data to replicate depends of the user (suser_sname)
who is selected in the start of an application. Today is John and tomorrow
is Charles the user, and the data set is different to download to the client
and I dont need to download all the data of Charles, I need only from a
date (the date of the last sync from Charles in this laptop or in the other
laptop).
Are you understand now?
"Hilary Cotter" <hilary.cotter@.gmail.com> escribi en el mensaje
news:O8KVfqNwEHA.3872@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> Perhaps I don't understand your problem.
> Is your problem that this laptop could have some recently entered data in,
> and you want to sync it up to the publisher, before deploying your new
> subscription?
> If so, you could set the merge agent to run on a schedule (make sure you
> remove the -Continuous switch) and run the merge agent a couple of times
> before dropping the subscription.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "Toms Hernndez" <tomihernandez@.yahoo.es> wrote in message
> news:u$vJJmNwEHA.3840@.tk2msftngp13.phx.gbl...
> which
You[vbcol=seagreen]
The
> replicate
> the
> it
>