Showing posts with label filters. Show all posts
Showing posts with label filters. Show all posts

Tuesday, March 20, 2012

Problems with merge replication and pull subscription

Hi, i have configured a merge replication with pull subscription. The
articles of the publication has filters defined. The filters are like
this:
where divis in (1, 2, 3, 4, 5)
Last week on the subscriber a user insert information where divis = 6,
so the replicatin sent the data to the publication but it was deleted
in the subscriber.
I have the doubt, Why the replication sent the information to the
publisher, if it wasn't part of the filters?
Why does the replication delete the information in the subscriber?
At this moment I already change the article filters', and this is the
new filter:
where divis in (1, 2, 3, 4, 5, 6)
And everything is working find.
Thanks a lot for your help.
*** Sent via Developersdex http://www.codecomments.com ***
Maria,
this is normal. There is a view created which 'defines' your filter and this
view however only exists at the publisher. So, the check is done after the
data is uploaded and a delete sent to the client to remove the record. The
filter applies to the publication when synchronizing so the data isn't
removed at this stage. I must admit I can think of more intuitive designs,
but this design does have occasional advantages when you need to amalgamate
data.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Wednesday, March 7, 2012

Problems with Dataset, Table Filters SSRS 2000 SP2

Hello all..
I've put this question out before, but I still haven't figured out a
solution..
When I apply this filter at the dataset or table level to get rid of
commission code 100 it blanks out the report
Expression: =Cstr(Fields!CommissionCode.Value)
Operator: = Value: '100'
I did discover that when I run this under the data tab to look at the raw
data, the filter works! But the report still comes up blank when I preview
it..
Help!!
Thanks.Its pretty apparent to me that due to the lack of response on this issue
that dataset and table filters aren't well supported on this version of
SSRS.. I will take another approach. I hope this post will save someone else
some time in the future.. Thanks
"jereviscious" <here@.there.com> wrote in message
news:eJTkrZ7bHHA.4000@.TK2MSFTNGP02.phx.gbl...
> Hello all..
> I've put this question out before, but I still haven't figured out a
> solution..
> When I apply this filter at the dataset or table level to get rid of
> commission code 100 it blanks out the report
> Expression: =Cstr(Fields!CommissionCode.Value)
> Operator: => Value: '100'
> I did discover that when I run this under the data tab to look at the raw
> data, the filter works! But the report still comes up blank when I preview
> it..
> Help!!
> Thanks.
>
>|||Wrong assumption.
People answer on a volunteer basis. You post might or might not be seen.
Take my case. I don't use filters because I think they are mostly a bad idea
to do. Filters are used after the data is brought over to the report. I use
query parameters. Query parameters do the same thing but it applies the
filter at the database, not at the report.
However, just because I don't use it does not means that filters don't work.
I have not seen any indications that they don't work. If you didn't get a
response you could try posting again. Or try the web forums. The web forums
have a lot more eyeballs.
If you have MSDN you might check out managed newsgroups. Managed newsgroups
are done by registering a fake email address with microsoft. That email
address gets monitored in the newsgroup and you are guaranteed a response
from a MS employee within two business days.
One last thing, have you tried query parameters? That really is the way to
go in most cases.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"jereviscious" <here@.there.com> wrote in message
news:ecjpzh%23bHHA.5044@.TK2MSFTNGP05.phx.gbl...
> Its pretty apparent to me that due to the lack of response on this issue
> that dataset and table filters aren't well supported on this version of
> SSRS.. I will take another approach. I hope this post will save someone
> else some time in the future.. Thanks
> "jereviscious" <here@.there.com> wrote in message
> news:eJTkrZ7bHHA.4000@.TK2MSFTNGP02.phx.gbl...
>> Hello all..
>> I've put this question out before, but I still haven't figured out a
>> solution..
>> When I apply this filter at the dataset or table level to get rid of
>> commission code 100 it blanks out the report
>> Expression: =Cstr(Fields!CommissionCode.Value)
>> Operator: =>> Value: '100'
>> I did discover that when I run this under the data tab to look at the raw
>> data, the filter works! But the report still comes up blank when I
>> preview it..
>> Help!!
>> Thanks.
>>
>>
>|||Bruce, thanks for your thoughtful response .
I'm not making any assumption here. I have anectdotal evidence, and in my
OPINION, which I have a right to, this filtering mechanism is NOT well
supported/implemented.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eL6kw8%23bHHA.260@.TK2MSFTNGP02.phx.gbl...
> Wrong assumption.
> People answer on a volunteer basis. You post might or might not be seen.
> Take my case. I don't use filters because I think they are mostly a bad
> idea to do. Filters are used after the data is brought over to the report.
> I use query parameters. Query parameters do the same thing but it applies
> the filter at the database, not at the report.
> However, just because I don't use it does not means that filters don't
> work. I have not seen any indications that they don't work. If you didn't
> get a response you could try posting again. Or try the web forums. The web
> forums have a lot more eyeballs.
> If you have MSDN you might check out managed newsgroups. Managed
> newsgroups are done by registering a fake email address with microsoft.
> That email address gets monitored in the newsgroup and you are guaranteed
> a response from a MS employee within two business days.
> One last thing, have you tried query parameters? That really is the way to
> go in most cases.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "jereviscious" <here@.there.com> wrote in message
> news:ecjpzh%23bHHA.5044@.TK2MSFTNGP05.phx.gbl...
>> Its pretty apparent to me that due to the lack of response on this issue
>> that dataset and table filters aren't well supported on this version of
>> SSRS.. I will take another approach. I hope this post will save someone
>> else some time in the future.. Thanks
>> "jereviscious" <here@.there.com> wrote in message
>> news:eJTkrZ7bHHA.4000@.TK2MSFTNGP02.phx.gbl...
>> Hello all..
>> I've put this question out before, but I still haven't figured out a
>> solution..
>> When I apply this filter at the dataset or table level to get rid of
>> commission code 100 it blanks out the report
>> Expression: =Cstr(Fields!CommissionCode.Value)
>> Operator: =>> Value: '100'
>> I did discover that when I run this under the data tab to look at the
>> raw data, the filter works! But the report still comes up blank when I
>> preview it..
>> Help!!
>> Thanks.
>>
>>
>>
>|||Yes you are right to your opinion, I'm not saying you aren't. However, if
you mean supported as in does the product support (work with) filters then I
have never seen anything with any posts where filters did not function. If
you mean supported because of response in this newsgroup, this newsgroup is
dying. Most of the action is in the web forums. Pretty much 0 MS people come
here, except for managed newsgroup postings. MS is putting all its focus on
the web forum. I prefer newsgroups but I am thinking of heading over to the
web forums.
So, if you want to use filters (which I suggest you do only as a last
resort) you should try both searching and posting at the web forums.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"jereviscious" <here@.there.com> wrote in message
news:%23cIgSwHcHHA.4004@.TK2MSFTNGP06.phx.gbl...
> Bruce, thanks for your thoughtful response .
> I'm not making any assumption here. I have anectdotal evidence, and in my
> OPINION, which I have a right to, this filtering mechanism is NOT well
> supported/implemented.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:eL6kw8%23bHHA.260@.TK2MSFTNGP02.phx.gbl...
>> Wrong assumption.
>> People answer on a volunteer basis. You post might or might not be seen.
>> Take my case. I don't use filters because I think they are mostly a bad
>> idea to do. Filters are used after the data is brought over to the
>> report. I use query parameters. Query parameters do the same thing but it
>> applies the filter at the database, not at the report.
>> However, just because I don't use it does not means that filters don't
>> work. I have not seen any indications that they don't work. If you didn't
>> get a response you could try posting again. Or try the web forums. The
>> web forums have a lot more eyeballs.
>> If you have MSDN you might check out managed newsgroups. Managed
>> newsgroups are done by registering a fake email address with microsoft.
>> That email address gets monitored in the newsgroup and you are guaranteed
>> a response from a MS employee within two business days.
>> One last thing, have you tried query parameters? That really is the way
>> to go in most cases.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "jereviscious" <here@.there.com> wrote in message
>> news:ecjpzh%23bHHA.5044@.TK2MSFTNGP05.phx.gbl...
>> Its pretty apparent to me that due to the lack of response on this issue
>> that dataset and table filters aren't well supported on this version of
>> SSRS.. I will take another approach. I hope this post will save someone
>> else some time in the future.. Thanks
>> "jereviscious" <here@.there.com> wrote in message
>> news:eJTkrZ7bHHA.4000@.TK2MSFTNGP02.phx.gbl...
>> Hello all..
>> I've put this question out before, but I still haven't figured out a
>> solution..
>> When I apply this filter at the dataset or table level to get rid of
>> commission code 100 it blanks out the report
>> Expression: =Cstr(Fields!CommissionCode.Value)
>> Operator: =>> Value: '100'
>> I did discover that when I run this under the data tab to look at the
>> raw data, the filter works! But the report still comes up blank when I
>> preview it..
>> Help!!
>> Thanks.
>>
>>
>>
>>
>|||I'm wasn't criticizing the forum. It took me 6-7 hours to come up with the
correct syntax for this expression
=Cstr(Fields!CommissionCode.Value) = '100'
Simply refuses to work. I tried probably 30 different permutations
attempting to work with the string value. I finally tried this expression,
and it worked
=Cint(Fields!CommissionCode.Value) = =100
Which works fine unless you have a commission code = 032, which fortunately
for this report, doesn't affect anything, but it easily could have.
This should have taken 2 minutes. This was not a last resort problem, but it
WAS a much cleaner solution (far less code) than the alternative.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:ONB%23kzHcHHA.4312@.TK2MSFTNGP05.phx.gbl...
> Yes you are right to your opinion, I'm not saying you aren't. However, if
> you mean supported as in does the product support (work with) filters then
> I have never seen anything with any posts where filters did not function.
> If you mean supported because of response in this newsgroup, this
> newsgroup is dying. Most of the action is in the web forums. Pretty much 0
> MS people come here, except for managed newsgroup postings. MS is putting
> all its focus on the web forum. I prefer newsgroups but I am thinking of
> heading over to the web forums.
> So, if you want to use filters (which I suggest you do only as a last
> resort) you should try both searching and posting at the web forums.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "jereviscious" <here@.there.com> wrote in message
> news:%23cIgSwHcHHA.4004@.TK2MSFTNGP06.phx.gbl...
>> Bruce, thanks for your thoughtful response .
>> I'm not making any assumption here. I have anectdotal evidence, and in my
>> OPINION, which I have a right to, this filtering mechanism is NOT well
>> supported/implemented.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:eL6kw8%23bHHA.260@.TK2MSFTNGP02.phx.gbl...
>> Wrong assumption.
>> People answer on a volunteer basis. You post might or might not be seen.
>> Take my case. I don't use filters because I think they are mostly a bad
>> idea to do. Filters are used after the data is brought over to the
>> report. I use query parameters. Query parameters do the same thing but
>> it applies the filter at the database, not at the report.
>> However, just because I don't use it does not means that filters don't
>> work. I have not seen any indications that they don't work. If you
>> didn't get a response you could try posting again. Or try the web
>> forums. The web forums have a lot more eyeballs.
>> If you have MSDN you might check out managed newsgroups. Managed
>> newsgroups are done by registering a fake email address with microsoft.
>> That email address gets monitored in the newsgroup and you are
>> guaranteed a response from a MS employee within two business days.
>> One last thing, have you tried query parameters? That really is the way
>> to go in most cases.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "jereviscious" <here@.there.com> wrote in message
>> news:ecjpzh%23bHHA.5044@.TK2MSFTNGP05.phx.gbl...
>> Its pretty apparent to me that due to the lack of response on this
>> issue that dataset and table filters aren't well supported on this
>> version of SSRS.. I will take another approach. I hope this post will
>> save someone else some time in the future.. Thanks
>> "jereviscious" <here@.there.com> wrote in message
>> news:eJTkrZ7bHHA.4000@.TK2MSFTNGP02.phx.gbl...
>> Hello all..
>> I've put this question out before, but I still haven't figured out a
>> solution..
>> When I apply this filter at the dataset or table level to get rid of
>> commission code 100 it blanks out the report
>> Expression: =Cstr(Fields!CommissionCode.Value)
>> Operator: =>> Value: '100'
>> I did discover that when I run this under the data tab to look at the
>> raw data, the filter works! But the report still comes up blank when I
>> preview it..
>> Help!!
>> Thanks.
>>
>>
>>
>>
>>
>|||I have missed your earlier post. As far as your assumptions, I am with Bruce.
Infact its not like they are not supported, people have not come across, like
this, that's why no one replied or like me, have missed the post.
Anyways, so giving in query parameters is good, answering your post.
It s something to do with your data type and your single and double quote.
ie you are converting to string and giving single quote in the expression
window.
How to find out is sometime you need to give the wrong input to find out the
way to give the right input. Try diff. options give integer as input, give it
in double quotes or give a blank input. see what happens.
Let me know whether it works.
Amarnath, MCTS.
"Bruce L-C [MVP]" wrote:
> Wrong assumption.
> People answer on a volunteer basis. You post might or might not be seen.
> Take my case. I don't use filters because I think they are mostly a bad idea
> to do. Filters are used after the data is brought over to the report. I use
> query parameters. Query parameters do the same thing but it applies the
> filter at the database, not at the report.
> However, just because I don't use it does not means that filters don't work.
> I have not seen any indications that they don't work. If you didn't get a
> response you could try posting again. Or try the web forums. The web forums
> have a lot more eyeballs.
> If you have MSDN you might check out managed newsgroups. Managed newsgroups
> are done by registering a fake email address with microsoft. That email
> address gets monitored in the newsgroup and you are guaranteed a response
> from a MS employee within two business days.
> One last thing, have you tried query parameters? That really is the way to
> go in most cases.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "jereviscious" <here@.there.com> wrote in message
> news:ecjpzh%23bHHA.5044@.TK2MSFTNGP05.phx.gbl...
> > Its pretty apparent to me that due to the lack of response on this issue
> > that dataset and table filters aren't well supported on this version of
> > SSRS.. I will take another approach. I hope this post will save someone
> > else some time in the future.. Thanks
> > "jereviscious" <here@.there.com> wrote in message
> > news:eJTkrZ7bHHA.4000@.TK2MSFTNGP02.phx.gbl...
> >> Hello all..
> >>
> >> I've put this question out before, but I still haven't figured out a
> >> solution..
> >>
> >> When I apply this filter at the dataset or table level to get rid of
> >> commission code 100 it blanks out the report
> >>
> >> Expression: =Cstr(Fields!CommissionCode.Value)
> >> Operator: => >> Value: '100'
> >>
> >> I did discover that when I run this under the data tab to look at the raw
> >> data, the filter works! But the report still comes up blank when I
> >> preview it..
> >>
> >> Help!!
> >>
> >> Thanks.
> >>
> >>
> >>
> >>
> >
> >
>
>|||I have answered this question ad infinitum. I have not made any assumptions
thank-you
"Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
news:7236F647-63FA-47A3-A90E-79D1A77A5C17@.microsoft.com...
>I have missed your earlier post. As far as your assumptions, I am with
>Bruce.
> Infact its not like they are not supported, people have not come across,
> like
> this, that's why no one replied or like me, have missed the post.
> Anyways, so giving in query parameters is good, answering your post.
> It s something to do with your data type and your single and double quote.
> ie you are converting to string and giving single quote in the expression
> window.
> How to find out is sometime you need to give the wrong input to find out
> the
> way to give the right input. Try diff. options give integer as input, give
> it
> in double quotes or give a blank input. see what happens.
> Let me know whether it works.
> Amarnath, MCTS.
>
> "Bruce L-C [MVP]" wrote:
>> Wrong assumption.
>> People answer on a volunteer basis. You post might or might not be seen.
>> Take my case. I don't use filters because I think they are mostly a bad
>> idea
>> to do. Filters are used after the data is brought over to the report. I
>> use
>> query parameters. Query parameters do the same thing but it applies the
>> filter at the database, not at the report.
>> However, just because I don't use it does not means that filters don't
>> work.
>> I have not seen any indications that they don't work. If you didn't get a
>> response you could try posting again. Or try the web forums. The web
>> forums
>> have a lot more eyeballs.
>> If you have MSDN you might check out managed newsgroups. Managed
>> newsgroups
>> are done by registering a fake email address with microsoft. That email
>> address gets monitored in the newsgroup and you are guaranteed a response
>> from a MS employee within two business days.
>> One last thing, have you tried query parameters? That really is the way
>> to
>> go in most cases.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "jereviscious" <here@.there.com> wrote in message
>> news:ecjpzh%23bHHA.5044@.TK2MSFTNGP05.phx.gbl...
>> > Its pretty apparent to me that due to the lack of response on this
>> > issue
>> > that dataset and table filters aren't well supported on this version of
>> > SSRS.. I will take another approach. I hope this post will save someone
>> > else some time in the future.. Thanks
>> > "jereviscious" <here@.there.com> wrote in message
>> > news:eJTkrZ7bHHA.4000@.TK2MSFTNGP02.phx.gbl...
>> >> Hello all..
>> >>
>> >> I've put this question out before, but I still haven't figured out a
>> >> solution..
>> >>
>> >> When I apply this filter at the dataset or table level to get rid of
>> >> commission code 100 it blanks out the report
>> >>
>> >> Expression: =Cstr(Fields!CommissionCode.Value)
>> >> Operator: =>> >> Value: '100'
>> >>
>> >> I did discover that when I run this under the data tab to look at the
>> >> raw
>> >> data, the filter works! But the report still comes up blank when I
>> >> preview it..
>> >>
>> >> Help!!
>> >>
>> >> Thanks.
>> >>
>> >>
>> >>
>> >>
>> >
>> >
>>

Saturday, February 25, 2012

Problems with a table in a publication

I have a database with two publications, one for SQL CE Clients with filters that send each client its data and keeps it database with "low weight" filtering data not older than a week, and the other publications for SQL Servers.
The publication for SQL CE Clients works excelent, the other one has this problem:

In the publisher i can insert data that should be replicated to subscribers, but subscribers don't receive it. And if I try to insert both in the publisher and the subscriber, the subscriber throws a Primari Key exception.
In the other way, if i insert the data in the subscriber, when it synchronizes, the publisher pulls this data to the table and keeps it, but deletes the subscriber table due to a "conflict". And it never sends the data back to the subscriber, keeping the subscriber's table always clear.

Any Idea?

Thank you.

Omar.Rojaswhat kind of replication are you using is it merge, transaction or snapshot