Dataset Filtering Not Working

I am trying to filter data at the dataset level after it is returned.

However, the filters tab on in the Dataset window does not appear to work correctly.

I have tried the following expressions:

Expression Operator Value

=(Fields!IdLog.Value = Parameters!Id_Log.Value) = =True

=Fields!IdLog.Value = =Parameters!Id_Log.Value

When I rerun my dataset query, the entire dataset is returned, instead of the filtered dataset. This same behavior occurs if I try to run the report itself.

I do not understand why the filtering does not occur.

Any help would be greatly appreciated.

To get maximum performance with filtering its the best to build the parameter into the SQL-Query:

="select your_colums from your_table where ID='" & Parameters!Id_Log.Value & "'"

I never tried something different, because its waste of resources to retrieve 1000records from a database and filter out 999 of them..

|||

BenniG,

Thank you for your comment. However, I am try to filter the results that are returned from a Web Service, and therefore, I cannot specify the SQL Statement used to query the database.

|||

I tried the filter-tab:

=Fields!ID.Value = =Parameters!ID.Value

works if both fields have the same datatype, if one is a string and one an integer I get an error.. Maybe you have to change the datatype for the Parameter?
I think the filter has no effect on the !-Icon in datasets, but in my case it worked in preview mode..

Data-driven subscriptions - SQLRS Ent vs Std

I want to use data-driven subscriptions but cannot create one - the "New
data-driven subscription" button does not appear in Report manager. I
believe this may be because I'm running SQLRS Standard - can someone confirm
this please?
If true, is there an easy way to upgrade to SQLRS Enterprise or do I have to
uninstall Std and do a fresh install of Enterprise? Is there a way to save
and restore all my subscriptions?
thanks
PeterThe data Driven Subscriptions are only part of the enterprise version. I
don't think you have to uninstall to put in the entprise license. It won't
affect your subscriptions.
Stuart
"PeterB" wrote:
> I want to use data-driven subscriptions but cannot create one - the "New
> data-driven subscription" button does not appear in Report manager. I
> believe this may be because I'm running SQLRS Standard - can someone confirm
> this please?
> If true, is there an easy way to upgrade to SQLRS Enterprise or do I have to
> uninstall Std and do a fresh install of Enterprise? Is there a way to save
> and restore all my subscriptions?
> thanks
> Peter|||From Microsoft Website
Evaluation, Developer, or Enterprise Edition of SQL Server 2005. Support for data-driven subscriptions is not available in Standard, Workgroup, or SQL Server Express Editions. For more information, see Features Supported by the Editions of SQL Server 2005.
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

Databases Not appearing in EM

SQL Server 2000 Service Pack 4
Client is using XP Service Pack 1
When the user opens the database folder in EM no databases appear. However,
I have XP Service Pack 1 and I can see all the databases. The difference i
s
I am a SysAdmin.
Has anyone seen this before. I had the client install SQL sp 4 on his
workstation.System or user-defined databases? System databases can be hidden in the
registration properties. Does the user have permissions to the user-defined
databases (i.e., a database user account)?
HTH
Jerry
"T Man" <TMan@.discussions.microsoft.com> wrote in message
news:BF678997-E93D-4FC4-8AE2-1451136068AA@.microsoft.com...
> SQL Server 2000 Service Pack 4
> Client is using XP Service Pack 1
> When the user opens the database folder in EM no databases appear.
> However,
> I have XP Service Pack 1 and I can see all the databases. The difference
> is
> I am a SysAdmin.
> Has anyone seen this before. I had the client install SQL sp 4 on his
> workstation.|||All databases, we did further checking if we give sysadmin privalages to the
user they can see the databases. I also found out this issue occurred
earlier and another DBA resolved the issue with a reboot of the sql server.
THis time a reboot did not work. I verified the user has access to his
default database on the server
"Jerry Spivey" wrote:

> System or user-defined databases? System databases can be hidden in the
> registration properties. Does the user have permissions to the user-defin
ed
> databases (i.e., a database user account)?
> HTH
> Jerry
> "T Man" <TMan@.discussions.microsoft.com> wrote in message
> news:BF678997-E93D-4FC4-8AE2-1451136068AA@.microsoft.com...
>
>|||Have you tried deleting and re-registering the SQL Server?
"T Man" <TMan@.discussions.microsoft.com> wrote in message
news:447CCB04-487E-43AF-93F7-F5E4DF058E1F@.microsoft.com...[vbcol=seagreen]
> All databases, we did further checking if we give sysadmin privalages to
> the
> user they can see the databases. I also found out this issue occurred
> earlier and another DBA resolved the issue with a reboot of the sql
> server.
> THis time a reboot did not work. I verified the user has access to his
> default database on the server
> "Jerry Spivey" wrote:
>

Databases Not appearing in EM

SQL Server 2000 Service Pack 4
Client is using XP Service Pack 1
When the user opens the database folder in EM no databases appear. However,
I have XP Service Pack 1 and I can see all the databases. The difference is
I am a SysAdmin.
Has anyone seen this before. I had the client install SQL sp 4 on his
workstation.
System or user-defined databases? System databases can be hidden in the
registration properties. Does the user have permissions to the user-defined
databases (i.e., a database user account)?
HTH
Jerry
"T Man" <TMan@.discussions.microsoft.com> wrote in message
news:BF678997-E93D-4FC4-8AE2-1451136068AA@.microsoft.com...
> SQL Server 2000 Service Pack 4
> Client is using XP Service Pack 1
> When the user opens the database folder in EM no databases appear.
> However,
> I have XP Service Pack 1 and I can see all the databases. The difference
> is
> I am a SysAdmin.
> Has anyone seen this before. I had the client install SQL sp 4 on his
> workstation.
|||All databases, we did further checking if we give sysadmin privalages to the
user they can see the databases. I also found out this issue occurred
earlier and another DBA resolved the issue with a reboot of the sql server.
THis time a reboot did not work. I verified the user has access to his
default database on the server
"Jerry Spivey" wrote:

> System or user-defined databases? System databases can be hidden in the
> registration properties. Does the user have permissions to the user-defined
> databases (i.e., a database user account)?
> HTH
> Jerry
> "T Man" <TMan@.discussions.microsoft.com> wrote in message
> news:BF678997-E93D-4FC4-8AE2-1451136068AA@.microsoft.com...
>
>
|||Have you tried deleting and re-registering the SQL Server?
"T Man" <TMan@.discussions.microsoft.com> wrote in message
news:447CCB04-487E-43AF-93F7-F5E4DF058E1F@.microsoft.com...[vbcol=seagreen]
> All databases, we did further checking if we give sysadmin privalages to
> the
> user they can see the databases. I also found out this issue occurred
> earlier and another DBA resolved the issue with a reboot of the sql
> server.
> THis time a reboot did not work. I verified the user has access to his
> default database on the server
> "Jerry Spivey" wrote:

Databases Not appearing in EM

SQL Server 2000 Service Pack 4
Client is using XP Service Pack 1
When the user opens the database folder in EM no databases appear. However,
I have XP Service Pack 1 and I can see all the databases. The difference is
I am a SysAdmin.
Has anyone seen this before. I had the client install SQL sp 4 on his
workstation.System or user-defined databases? System databases can be hidden in the
registration properties. Does the user have permissions to the user-defined
databases (i.e., a database user account)?
HTH
Jerry
"T Man" <TMan@.discussions.microsoft.com> wrote in message
news:BF678997-E93D-4FC4-8AE2-1451136068AA@.microsoft.com...
> SQL Server 2000 Service Pack 4
> Client is using XP Service Pack 1
> When the user opens the database folder in EM no databases appear.
> However,
> I have XP Service Pack 1 and I can see all the databases. The difference
> is
> I am a SysAdmin.
> Has anyone seen this before. I had the client install SQL sp 4 on his
> workstation.|||All databases, we did further checking if we give sysadmin privalages to the
user they can see the databases. I also found out this issue occurred
earlier and another DBA resolved the issue with a reboot of the sql server.
THis time a reboot did not work. I verified the user has access to his
default database on the server
"Jerry Spivey" wrote:
> System or user-defined databases? System databases can be hidden in the
> registration properties. Does the user have permissions to the user-defined
> databases (i.e., a database user account)?
> HTH
> Jerry
> "T Man" <TMan@.discussions.microsoft.com> wrote in message
> news:BF678997-E93D-4FC4-8AE2-1451136068AA@.microsoft.com...
> > SQL Server 2000 Service Pack 4
> > Client is using XP Service Pack 1
> >
> > When the user opens the database folder in EM no databases appear.
> > However,
> > I have XP Service Pack 1 and I can see all the databases. The difference
> > is
> > I am a SysAdmin.
> >
> > Has anyone seen this before. I had the client install SQL sp 4 on his
> > workstation.
>
>|||Have you tried deleting and re-registering the SQL Server?
"T Man" <TMan@.discussions.microsoft.com> wrote in message
news:447CCB04-487E-43AF-93F7-F5E4DF058E1F@.microsoft.com...
> All databases, we did further checking if we give sysadmin privalages to
> the
> user they can see the databases. I also found out this issue occurred
> earlier and another DBA resolved the issue with a reboot of the sql
> server.
> THis time a reboot did not work. I verified the user has access to his
> default database on the server
> "Jerry Spivey" wrote:
>> System or user-defined databases? System databases can be hidden in the
>> registration properties. Does the user have permissions to the
>> user-defined
>> databases (i.e., a database user account)?
>> HTH
>> Jerry
>> "T Man" <TMan@.discussions.microsoft.com> wrote in message
>> news:BF678997-E93D-4FC4-8AE2-1451136068AA@.microsoft.com...
>> > SQL Server 2000 Service Pack 4
>> > Client is using XP Service Pack 1
>> >
>> > When the user opens the database folder in EM no databases appear.
>> > However,
>> > I have XP Service Pack 1 and I can see all the databases. The
>> > difference
>> > is
>> > I am a SysAdmin.
>> >
>> > Has anyone seen this before. I had the client install SQL sp 4 on his
>> > workstation.
>>

Database Users Appear to be Corrupt

We had a hardware error on our production machine and had to replace it with
our backup machine. Both machines are running SQL Server 2000 on Windows
2000. I used the SQL Server database backup file from production to restore
the backup server.
I know about the sid's being out of sync between the logins and the database
users. I used our standard procedures to re-align them but must have done
something wrong. Now when I run sp_change_users_login 'Report', the list is
empty. I can see the users listed under the database using the enterprise
manager and the users can access the database but I fear that some table
somewhere pertaining to users is corrupted.You should be ok. The Report option of
sp_change_users_login only lists logins that are out of
sync. If you don't get any back from
sp_change_users_login 'Report', then they should all be in
sync.
This is taken directly from BOL pertaining to the Report
option:
"Lists the users, and their corresponding security
identifiers (SID), that are in the current database, not
linked to any login."
>--Original Message--
>We had a hardware error on our production machine and had
to replace it with
>our backup machine. Both machines are running SQL Server
2000 on Windows
>2000. I used the SQL Server database backup file from
production to restore
>the backup server.
>I know about the sid's being out of sync between the
logins and the database
>users. I used our standard procedures to re-align them
but must have done
>something wrong. Now when I run
sp_change_users_login 'Report', the list is
>empty. I can see the users listed under the database
using the enterprise
>manager and the users can access the database but I fear
that some table
>somewhere pertaining to users is corrupted.
>
>.
>|||Hi Robert,
Thank you for using MSDN Newsgroup! It's my pleasure to assist you with your issue.
As Van has pointed out, no report from sp_change_ueses_login means no sync problem of
the corresponding SID and everything seems fine on your side.
It is also recommended you try Database Consistency Checker (DBCC) statements after you
backup and restore your database.
You can use DBCC CHECKDB to check the allocation and structural integrity of the whole
database, or use DBCC CHECKALLOC / DBCC CHECKTABLE to check the individual objects
(including some suspicious tables).
For more information, please refer to Books Online on the topic "DBCC CHECKDB" and
"DBCC CHECKTABLE".
Robert, does this answer your question? If there is anything more we can do to assist you,
please feel free to post it in the group
Best regards,
Billy Yao
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.