dataset isn't showing

SQL/RS 2K, VS .Net 2003 - several single resultset/dataset reports working
just fine, finally got some multiple-resultset/dataset reports working very
well, too. today, however, i am creating a new one that isn't working, and i
can't yet determine why.
i have 5 different datasets so far, each are command type text, each field
presents the data just fine in the Data tab. I've created tables in the
Layout tab for each dataset, and dragged/dropped the fields into each
accordingly. When I go into the Preview tab, each dataset/table is visible
only intermittently' Meaning, I'm in Preview, and 3 of the five
datasets/tables are showing data, the other two are blank. Now, if i hit
refresh, only two are showing data... AND one of them is one that wasn't
showing data a moment ago.
I'm setting this thing up just like the three i did yesterday, which are
working just fine.
Can anybody provide any direction on this? It's very, very important, and I
do appreciate any assistance.
--
LynnWeird. I haven't seen this before. I suggest trying to deploy and see if
this is something only from the development environment.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Lynn" <Lynn@.discussions.microsoft.com> wrote in message
news:278379C7-06BF-4726-B3DA-18EE50B6EAFA@.microsoft.com...
> SQL/RS 2K, VS .Net 2003 - several single resultset/dataset reports working
> just fine, finally got some multiple-resultset/dataset reports working
> very
> well, too. today, however, i am creating a new one that isn't working,
> and i
> can't yet determine why.
> i have 5 different datasets so far, each are command type text, each field
> presents the data just fine in the Data tab. I've created tables in the
> Layout tab for each dataset, and dragged/dropped the fields into each
> accordingly. When I go into the Preview tab, each dataset/table is
> visible
> only intermittently' Meaning, I'm in Preview, and 3 of the five
> datasets/tables are showing data, the other two are blank. Now, if i hit
> refresh, only two are showing data... AND one of them is one that wasn't
> showing data a moment ago.
> I'm setting this thing up just like the three i did yesterday, which are
> working just fine.
> Can anybody provide any direction on this? It's very, very important, and
> I
> do appreciate any assistance.
> --
> Lynn

Data-Driven Subscription not shown

I am upgradinding to sql 2005 and the Data-Driven subscription is not working. the data-Driven option It is now showing in report manager and in code I get the error " rsOperationisNotSupported".... I have the same security permitions I had before in sql 2000. Does anyone knows if there is another difference that would prevent the subscription from working ?

thank you

drey

What sku of SQL 2005 are you using? Data driven subscriptions are only supported on developer and enterprise editions.|||

thank you,

I am using Standard edition, my company does not have enterprise. I guess that is a deal breaker for upgrading...

|||

Data driven subscriptions was also an Enterprise / Developer Edition in RS 2000. It was not available for the Standard Edition.

-- Robert

Databases not showing up in EM on sql 2000, but do in 2005.

We have a SQL 2000 server that started showing 'no items' in enterprise
manager. However, when you connect with SQL2005 client tools they show up.
Any ideas?Eric
Have you "Refresh" on database folder?
"Eric" <Eric@.discussions.microsoft.com> wrote in message
news:0AE0271E-33B9-4225-B007-A8D023103627@.microsoft.com...
> We have a SQL 2000 server that started showing 'no items' in enterprise
> manager. However, when you connect with SQL2005 client tools they show up.
> Any ideas?

Databases not showing up in EM on sql 2000, but do in 2005.

We have a SQL 2000 server that started showing 'no items' in enterprise
manager. However, when you connect with SQL2005 client tools they show up.
Any ideas?
Eric
Have you "Refresh" on database folder?
"Eric" <Eric@.discussions.microsoft.com> wrote in message
news:0AE0271E-33B9-4225-B007-A8D023103627@.microsoft.com...
> We have a SQL 2000 server that started showing 'no items' in enterprise
> manager. However, when you connect with SQL2005 client tools they show up.
> Any ideas?

Databases not showing up in EM on sql 2000, but do in 2005.

We have a SQL 2000 server that started showing 'no items' in enterprise
manager. However, when you connect with SQL2005 client tools they show up.
Any ideas?Eric
Have you "Refresh" on database folder?
"Eric" <Eric@.discussions.microsoft.com> wrote in message
news:0AE0271E-33B9-4225-B007-A8D023103627@.microsoft.com...
> We have a SQL 2000 server that started showing 'no items' in enterprise
> manager. However, when you connect with SQL2005 client tools they show up.
> Any ideas?