Report dynamic fields

Hi all,
I need to let my report user to select the columes in the report:
I want to make a report with all the relevant fileds .
the user will have window that read the rdl file and display all the reports
fields.
The user can select only the columes he need from the colume list.
How can I doit ?
Can I change the rdl file before the user use the report ?
10x,
Shachar.My suggestion if you decide to do this is to use RS 2005 (out in November).
RS 2005 along with the new controls shipping with Visual Studio 2005 will
make this much much easier than trying to do this with RS 2000. RS 2000 is
totally server based. You would have to deploy your new RDL (uniquely names,
remember you are server based) and then get your client to execute that
report (using either URL integration or web services). Then you would need
to remove it when done. With the new control with VS 2005 you can operate in
local mode where you give it a dataset and the rdl. No deployment necessary.
If all your reports are done this way then you don't even need the server
product, just the new controls.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Shachar" <me@.use.com> wrote in message
news:OXJyiTlpFHA.3040@.TK2MSFTNGP10.phx.gbl...
> Hi all,
> I need to let my report user to select the columes in the report:
> I want to make a report with all the relevant fileds .
> the user will have window that read the rdl file and display all the
> reports fields.
> The user can select only the columes he need from the colume list.
> How can I doit ?
> Can I change the rdl file before the user use the report ?
> 10x,
> Shachar.
>|||What if the application is a web base apllication ?
What is the right colume filter solutuin ?
10x,
Liz.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OlEEZcmpFHA.272@.TK2MSFTNGP15.phx.gbl...
> My suggestion if you decide to do this is to use RS 2005 (out in
November).
> RS 2005 along with the new controls shipping with Visual Studio 2005 will
> make this much much easier than trying to do this with RS 2000. RS 2000 is
> totally server based. You would have to deploy your new RDL (uniquely
names,
> remember you are server based) and then get your client to execute that
> report (using either URL integration or web services). Then you would need
> to remove it when done. With the new control with VS 2005 you can operate
in
> local mode where you give it a dataset and the rdl. No deployment
necessary.
> If all your reports are done this way then you don't even need the server
> product, just the new controls.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Shachar" <me@.use.com> wrote in message
> news:OXJyiTlpFHA.3040@.TK2MSFTNGP10.phx.gbl...
> > Hi all,
> >
> > I need to let my report user to select the columes in the report:
> > I want to make a report with all the relevant fileds .
> > the user will have window that read the rdl file and display all the
> > reports fields.
> > The user can select only the columes he need from the colume list.
> >
> > How can I doit ?
> > Can I change the rdl file before the user use the report ?
> >
> > 10x,
> >
> > Shachar.
> >
>|||I use RS 2005 .
"Liz Matyas" <lizmts@.mail.com> wrote in message
news:Ozf7%23yopFHA.3064@.TK2MSFTNGP15.phx.gbl...
> What if the application is a web base apllication ?
> What is the right colume filter solutuin ?
> 10x,
> Liz.
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:OlEEZcmpFHA.272@.TK2MSFTNGP15.phx.gbl...
> > My suggestion if you decide to do this is to use RS 2005 (out in
> November).
> > RS 2005 along with the new controls shipping with Visual Studio 2005
will
> > make this much much easier than trying to do this with RS 2000. RS 2000
is
> > totally server based. You would have to deploy your new RDL (uniquely
> names,
> > remember you are server based) and then get your client to execute that
> > report (using either URL integration or web services). Then you would
need
> > to remove it when done. With the new control with VS 2005 you can
operate
> in
> > local mode where you give it a dataset and the rdl. No deployment
> necessary.
> > If all your reports are done this way then you don't even need the
server
> > product, just the new controls.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Shachar" <me@.use.com> wrote in message
> > news:OXJyiTlpFHA.3040@.TK2MSFTNGP10.phx.gbl...
> > > Hi all,
> > >
> > > I need to let my report user to select the columes in the report:
> > > I want to make a report with all the relevant fileds .
> > > the user will have window that read the rdl file and display all the
> > > reports fields.
> > > The user can select only the columes he need from the colume list.
> > >
> > > How can I doit ?
> > > Can I change the rdl file before the user use the report ?
> > >
> > > 10x,
> > >
> > > Shachar.
> > >
> >
> >
>

Report Designer Dynamic Filter

I have a requirement to add the ability to filter a report by partial last name, at the report level (i.e. not at the database server). In case someone else needs to work out how to do this, here is what I did.

Add a Parameter to the report. In my case it is named LastName, is non-queried, allows Null or Blank, and has a default of null.

Add a filter to the dataset that contains the field to be searched. Set its Expression to:
=IIF(Parameters!LastName.Value = System.DBNull.Value OR Parameters!LastName.Value = "",
Fields!LastName.Value, Nothing) ,
its operator to "="
and its value to =IIF(Parameters!LastName.Value = Nothing OR Parameters!LastName.Value = "", Nothing, Parameters!LastName.Value & "*")

voila!

Helen

I'm not sure I fully understand. What exactly does this do?

Would this have the same effect as using a query with a parameter for lastname (@.lastname) where lastname LIKE @.lastname + "%"?

|||

It allows me to make entering a value for the parameter optional. If the user does not want to filter by last name, my filter expression still has to work. I got it to work by using an expression for both the filter and its value, and returning Nothing for both when the value is null or empty.

When using an expression for the filter, the LIKE option for the comparator is disabled, so I had to use = as the operator.

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
>