Report Builder Filter Newbie Question

Sorry for the newbie question.

I've just started building a report to display my IIS logs. I want to filter out all internal IP's, how would I do this?

Thanx

I've figured out NOT but how do I use a range of IP's?

Could I use a wild card

<>"192.168.1.*"

Or should I give it a range'

<>"192.168.1.1-192.168.1.254"

Thanx

|||

Try this

In Filter list

Use an expression instead of selecting the field/column itself like

if u have IPField

left(IPField,10) (this gives value - 192.168.1. (10 chars))

In Operator use != (Not equals)

In Value use an expression = "192.168.1."

Hope this helps u

Report Authentication

This is a newbie question. I have the report viewer component on one of my
aspx pages. When the user tries to open this page, he/she is prompted with a
user/password on the server. How do I set up the reporting services so that
it uses a generic account for all requests from the web. Thanks.
PremWell, the wrong way is to turn on Anonymous access to the Report Server. The
proper way is to create a custom security extension to replace the default
Windows-based security.
--
Hope this helps.
----
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
----
"Prem" <Prem@.discussions.microsoft.com> wrote in message
news:607E279E-7CC5-4135-BA35-F786EEE2A4E6@.microsoft.com...
> This is a newbie question. I have the report viewer component on one of my
> aspx pages. When the user tries to open this page, he/she is prompted with
a
> user/password on the server. How do I set up the reporting services so
that
> it uses a generic account for all requests from the web. Thanks.
> Prem
>|||Thanks Nell. That works.
"Nell" wrote:
> You need to grant permissions to your users and groups on the report server.
> You can do this at 'http://servername/reports', select the folder you want to
> apply permissions to, then select 'properties' and 'security'. Check out this
> article on Ode to Code for more info.
> http://odetocode.com/Articles/215.aspx
> You need to give browse access to the accounts you want to be able to view
> your reports, if you're using anonymous access then you need to make sure
> that the user you have set up in IIS for anonymous access (usually
> IUSR_computername or IWAM_computername) has this level of access. Don't
> give this account any unnecessary permissions though!
> "Prem" wrote:
> > This is a newbie question. I have the report viewer component on one of my
> > aspx pages. When the user tries to open this page, he/she is prompted with a
> > user/password on the server. How do I set up the reporting services so that
> > it uses a generic account for all requests from the web. Thanks.
> >
> > Prem
> >|||You need to grant permissions to your users and groups on the report server.
You can do this at 'http://servername/reports', select the folder you want to
apply permissions to, then select 'properties' and 'security'. Check out this
article on Ode to Code for more info.
http://odetocode.com/Articles/215.aspx
You need to give browse access to the accounts you want to be able to view
your reports, if you're using anonymous access then you need to make sure
that the user you have set up in IIS for anonymous access (usually
IUSR_computername or IWAM_computername) has this level of access. Don't
give this account any unnecessary permissions though!
"Prem" wrote:
> This is a newbie question. I have the report viewer component on one of my
> aspx pages. When the user tries to open this page, he/she is prompted with a
> user/password on the server. How do I set up the reporting services so that
> it uses a generic account for all requests from the web. Thanks.
> Prem
>

Replication: remove merge subscription without existing publisher?

Hi all,
I'm a rather newbie, not only to this forum but also to sql server having a question to the following issue:
Is it possible to drop/remove/delete the "orphan" of a merge subscription on one instance of sql server without having the (former) distributor/publisher (on other instance) available?
The background is: I had a small replication infrastructure with two instances (on two machines), one the publisher and distributor, the other the subscriber. Now it happened that the publisher/distributor machine was completely set up new without having the replication dropped in advance, what remained on the subscriber is now a database with all the merge/replication tables and the guid columns in the user tables.
Moreover this, an entry remained in the subscription saying that a subscription with the former publisher exists...

Can I remove these "orphans" without having to setup the instance again?

Thank you,
AndyDid you recreate the Publisher again?|||Originally posted by smasanam
Did you recreate the Publisher again?

No, I didn't recreate the publisher, but I plan to do so, however, with slightly different properties (e.g. publisher db name has changed)...|||Originally posted by AndreasJaehn
No, I didn't recreate the publisher, but I plan to do so, however, with slightly different properties (e.g. publisher db name has changed)...
Sorry to ask again. Can you please give more details about your question.

Looks like you want to drop the subscription. If that is so you can drop the subscription or subscriber database.

Once you dropped the subscription and remove the subscription databases you can go head and change the schema of the database at the subscriber|||Originally posted by smasanam
Once you dropped the subscription and remove the subscription databases you can go head and change the schema of the database at the subscriber

The thing is that I cannot drop the subscription as this implies having a valid publisher, but I don't have the publisher anymore. The system Stored Procedure requires the publishing/distributing instance alive, even if I set the ignore_distributor flag...

I found something in the archive which comes quite close to my problem: http://dbforums.com/arch/69/2002/4/348973

I'll try it that way (see Ramakrishna Koni's comment)...

Thank you.