Showing posts with label button. Show all posts
Showing posts with label button. Show all posts

Wednesday, March 28, 2012

no help dialog in vs ssis

At this point in time, I can think of nothing more annoying than a button that doesn't work. Especially when that button is the HELP button.

Inside SSIS designer, say I add a "derived column tool" to the data flow task. Now if I double-click on the "derived column tool", and then click on the help button in the dialog box that appears, NO help is displayed. What gives?

I am using 64 bit editions of win2k3 and ss05.

Works for me I'm afraid, admittedly not on 64bit!!!

-Jamie

|||There was a bug in the CTPs with the help buttons not working. Are you running RTM edition?|||No, I am not running CTPs. This was boxed product (OEM) from dell with a new server. Note that this is 64 bit Sql Server, so maybe the bug was not fixed in this edition?|||HAS NO ONE ELSE RUN INTO THIS PROBLEM? HOW MANY 64 BIT USERS ARE OUT THERE?|||I suggest you raise a bug at the product feedback centre

Monday, March 26, 2012

No Data-Driven Subscription Button

Hi,
I have a test server and a production RS server. On the test server I can
create data-driven subscriptions with no problems. However, on the
production server I do not get the "New Data-Driven Subscription" button and
I can't figure out why.
- I'm a domain administrator so I have local admin rights on both boxes.
- I'm Content Manager on both boxes
- The Config files look identical (impersonate is on for both of them,
however the connection string is encrypted so it could be that it's running
under a user without priveleges.)
- I'm not using integrated security for the data sources
- The data sources are shared. I found this on MSDN: "This button is not
available when you access subscriptions through a shared data source", but
the development server works okay with a shared data source, and even when I
switch a report over to use a non-shared (custom) data source the button is
not availab.e
- The ReportServer's are running under the same account
Obviously I'm missing something. Any ideas?
Thx, JoelAre you sure the production server has the Enterprise Edition of Reporting
Services installed? Data-driven subscriptions are not available in the
Standard Edition.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
news:%23n8mtuH7EHA.2676@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I have a test server and a production RS server. On the test server I can
> create data-driven subscriptions with no problems. However, on the
> production server I do not get the "New Data-Driven Subscription" button
and
> I can't figure out why.
> - I'm a domain administrator so I have local admin rights on both boxes.
> - I'm Content Manager on both boxes
> - The Config files look identical (impersonate is on for both of them,
> however the connection string is encrypted so it could be that it's
running
> under a user without priveleges.)
> - I'm not using integrated security for the data sources
> - The data sources are shared. I found this on MSDN: "This button is not
> available when you access subscriptions through a shared data source", but
> the development server works okay with a shared data source, and even when
I
> switch a report over to use a non-shared (custom) data source the button
is
> not availab.e
> - The ReportServer's are running under the same account
>
> Obviously I'm missing something. Any ideas?
> Thx, Joel
>|||That's probably it ...
how can I tell which version I'm running? Is there a query or a setting in
the config files?
Thx, Joel
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:uPD54tI7EHA.2600@.TK2MSFTNGP09.phx.gbl...
> Are you sure the production server has the Enterprise Edition of Reporting
> Services installed? Data-driven subscriptions are not available in the
> Standard Edition.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
> news:%23n8mtuH7EHA.2676@.TK2MSFTNGP12.phx.gbl...
>> Hi,
>> I have a test server and a production RS server. On the test server I can
>> create data-driven subscriptions with no problems. However, on the
>> production server I do not get the "New Data-Driven Subscription" button
> and
>> I can't figure out why.
>> - I'm a domain administrator so I have local admin rights on both boxes.
>> - I'm Content Manager on both boxes
>> - The Config files look identical (impersonate is on for both of them,
>> however the connection string is encrypted so it could be that it's
> running
>> under a user without priveleges.)
>> - I'm not using integrated security for the data sources
>> - The data sources are shared. I found this on MSDN: "This button is not
>> available when you access subscriptions through a shared data source",
>> but
>> the development server works okay with a shared data source, and even
>> when
> I
>> switch a report over to use a non-shared (custom) data source the button
> is
>> not availab.e
>> - The ReportServer's are running under the same account
>>
>> Obviously I'm missing something. Any ideas?
>> Thx, Joel
>>
>|||Just check under Control Panel : Add/Remove Programs. It should say
"Microsoft SQL Server 2000 Reporting Services Enterprise Edition".
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
news:uasoRaQ7EHA.2804@.TK2MSFTNGP15.phx.gbl...
> That's probably it ...
> how can I tell which version I'm running? Is there a query or a setting in
> the config files?
> Thx, Joel
>
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:uPD54tI7EHA.2600@.TK2MSFTNGP09.phx.gbl...
> > Are you sure the production server has the Enterprise Edition of
Reporting
> > Services installed? Data-driven subscriptions are not available in the
> > Standard Edition.
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >
> > "Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
> > news:%23n8mtuH7EHA.2676@.TK2MSFTNGP12.phx.gbl...
> >> Hi,
> >>
> >> I have a test server and a production RS server. On the test server I
can
> >> create data-driven subscriptions with no problems. However, on the
> >> production server I do not get the "New Data-Driven Subscription"
button
> > and
> >> I can't figure out why.
> >>
> >> - I'm a domain administrator so I have local admin rights on both
boxes.
> >> - I'm Content Manager on both boxes
> >> - The Config files look identical (impersonate is on for both of them,
> >> however the connection string is encrypted so it could be that it's
> > running
> >> under a user without priveleges.)
> >> - I'm not using integrated security for the data sources
> >> - The data sources are shared. I found this on MSDN: "This button is
not
> >> available when you access subscriptions through a shared data source",
> >> but
> >> the development server works okay with a shared data source, and even
> >> when
> > I
> >> switch a report over to use a non-shared (custom) data source the
button
> > is
> >> not availab.e
> >> - The ReportServer's are running under the same account
> >>
> >>
> >> Obviously I'm missing something. Any ideas?
> >>
> >> Thx, Joel
> >>
> >>
> >
> >
>|||So it's definitely Standard Edition which explains that.
Next question: is Sql Server Enterprise Edition required to have Reporting
Services Enterprise Edition installed or are they mutually exclusive? I
currently only have servers with Sql Server Standard Edition.
Thanks for the replies so far.
-Joel
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:u6eE59Q7EHA.2540@.TK2MSFTNGP09.phx.gbl...
> Just check under Control Panel : Add/Remove Programs. It should say
> "Microsoft SQL Server 2000 Reporting Services Enterprise Edition".
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
> news:uasoRaQ7EHA.2804@.TK2MSFTNGP15.phx.gbl...
>> That's probably it ...
>> how can I tell which version I'm running? Is there a query or a setting
>> in
>> the config files?
>> Thx, Joel
>>
>> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
>> news:uPD54tI7EHA.2600@.TK2MSFTNGP09.phx.gbl...
>> > Are you sure the production server has the Enterprise Edition of
> Reporting
>> > Services installed? Data-driven subscriptions are not available in the
>> > Standard Edition.
>> >
>> > --
>> > This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> >
>> > "Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
>> > news:%23n8mtuH7EHA.2676@.TK2MSFTNGP12.phx.gbl...
>> >> Hi,
>> >>
>> >> I have a test server and a production RS server. On the test server I
> can
>> >> create data-driven subscriptions with no problems. However, on the
>> >> production server I do not get the "New Data-Driven Subscription"
> button
>> > and
>> >> I can't figure out why.
>> >>
>> >> - I'm a domain administrator so I have local admin rights on both
> boxes.
>> >> - I'm Content Manager on both boxes
>> >> - The Config files look identical (impersonate is on for both of them,
>> >> however the connection string is encrypted so it could be that it's
>> > running
>> >> under a user without priveleges.)
>> >> - I'm not using integrated security for the data sources
>> >> - The data sources are shared. I found this on MSDN: "This button is
> not
>> >> available when you access subscriptions through a shared data source",
>> >> but
>> >> the development server works okay with a shared data source, and even
>> >> when
>> > I
>> >> switch a report over to use a non-shared (custom) data source the
> button
>> > is
>> >> not availab.e
>> >> - The ReportServer's are running under the same account
>> >>
>> >>
>> >> Obviously I'm missing something. Any ideas?
>> >>
>> >> Thx, Joel
>> >>
>> >>
>> >
>> >
>>
>|||Looks like the editions must match.
" The edition of SQL RS that can be installed must correspond to the
edition of SQL Server that is installed : "
http://msmvps.com/anguslogan/archive/2004/10/03/14788.aspx
Why not include data driven subscriptions in the SE version of SRS? It seems
to be a basic element. Although, I understand it will drive some purchases
of Sql Server EE.
Thx, Joel
"Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
news:OrhblKR7EHA.3708@.TK2MSFTNGP14.phx.gbl...
> So it's definitely Standard Edition which explains that.
> Next question: is Sql Server Enterprise Edition required to have Reporting
> Services Enterprise Edition installed or are they mutually exclusive? I
> currently only have servers with Sql Server Standard Edition.
> Thanks for the replies so far.
> -Joel
>
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:u6eE59Q7EHA.2540@.TK2MSFTNGP09.phx.gbl...
>> Just check under Control Panel : Add/Remove Programs. It should say
>> "Microsoft SQL Server 2000 Reporting Services Enterprise Edition".
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
>> news:uasoRaQ7EHA.2804@.TK2MSFTNGP15.phx.gbl...
>> That's probably it ...
>> how can I tell which version I'm running? Is there a query or a setting
>> in
>> the config files?
>> Thx, Joel
>>
>> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
>> news:uPD54tI7EHA.2600@.TK2MSFTNGP09.phx.gbl...
>> > Are you sure the production server has the Enterprise Edition of
>> Reporting
>> > Services installed? Data-driven subscriptions are not available in the
>> > Standard Edition.
>> >
>> > --
>> > This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> >
>> > "Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
>> > news:%23n8mtuH7EHA.2676@.TK2MSFTNGP12.phx.gbl...
>> >> Hi,
>> >>
>> >> I have a test server and a production RS server. On the test server I
>> can
>> >> create data-driven subscriptions with no problems. However, on the
>> >> production server I do not get the "New Data-Driven Subscription"
>> button
>> > and
>> >> I can't figure out why.
>> >>
>> >> - I'm a domain administrator so I have local admin rights on both
>> boxes.
>> >> - I'm Content Manager on both boxes
>> >> - The Config files look identical (impersonate is on for both of
>> >> them,
>> >> however the connection string is encrypted so it could be that it's
>> > running
>> >> under a user without priveleges.)
>> >> - I'm not using integrated security for the data sources
>> >> - The data sources are shared. I found this on MSDN: "This button is
>> not
>> >> available when you access subscriptions through a shared data
>> >> source",
>> >> but
>> >> the development server works okay with a shared data source, and even
>> >> when
>> > I
>> >> switch a report over to use a non-shared (custom) data source the
>> button
>> > is
>> >> not availab.e
>> >> - The ReportServer's are running under the same account
>> >>
>> >>
>> >> Obviously I'm missing something. Any ideas?
>> >>
>> >> Thx, Joel
>> >>
>> >>
>> >
>> >
>>
>>
>|||Technically, this is the case only if you want to install them on the same
box. You can buy an EE license of SQL Server to run Reporting Services and
connect to an external STD SQL relational database.
Anyawy, we had to make some decisions about what would go in each edition.
After talking to customers, data driven subscriptions seemed like a
reasonable EE feature.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
news:OiWkmPR7EHA.3120@.TK2MSFTNGP12.phx.gbl...
> Looks like the editions must match.
> " The edition of SQL RS that can be installed must correspond to the
> edition of SQL Server that is installed : "
> http://msmvps.com/anguslogan/archive/2004/10/03/14788.aspx
> Why not include data driven subscriptions in the SE version of SRS? It
> seems to be a basic element. Although, I understand it will drive some
> purchases of Sql Server EE.
> Thx, Joel
> "Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
> news:OrhblKR7EHA.3708@.TK2MSFTNGP14.phx.gbl...
>> So it's definitely Standard Edition which explains that.
>> Next question: is Sql Server Enterprise Edition required to have
>> Reporting Services Enterprise Edition installed or are they mutually
>> exclusive? I currently only have servers with Sql Server Standard
>> Edition.
>> Thanks for the replies so far.
>> -Joel
>>
>> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
>> news:u6eE59Q7EHA.2540@.TK2MSFTNGP09.phx.gbl...
>> Just check under Control Panel : Add/Remove Programs. It should say
>> "Microsoft SQL Server 2000 Reporting Services Enterprise Edition".
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
>> news:uasoRaQ7EHA.2804@.TK2MSFTNGP15.phx.gbl...
>> That's probably it ...
>> how can I tell which version I'm running? Is there a query or a setting
>> in
>> the config files?
>> Thx, Joel
>>
>> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
>> news:uPD54tI7EHA.2600@.TK2MSFTNGP09.phx.gbl...
>> > Are you sure the production server has the Enterprise Edition of
>> Reporting
>> > Services installed? Data-driven subscriptions are not available in
>> > the
>> > Standard Edition.
>> >
>> > --
>> > This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> >
>> > "Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
>> > news:%23n8mtuH7EHA.2676@.TK2MSFTNGP12.phx.gbl...
>> >> Hi,
>> >>
>> >> I have a test server and a production RS server. On the test server
>> >> I
>> can
>> >> create data-driven subscriptions with no problems. However, on the
>> >> production server I do not get the "New Data-Driven Subscription"
>> button
>> > and
>> >> I can't figure out why.
>> >>
>> >> - I'm a domain administrator so I have local admin rights on both
>> boxes.
>> >> - I'm Content Manager on both boxes
>> >> - The Config files look identical (impersonate is on for both of
>> >> them,
>> >> however the connection string is encrypted so it could be that it's
>> > running
>> >> under a user without priveleges.)
>> >> - I'm not using integrated security for the data sources
>> >> - The data sources are shared. I found this on MSDN: "This button is
>> not
>> >> available when you access subscriptions through a shared data
>> >> source",
>> >> but
>> >> the development server works okay with a shared data source, and
>> >> even
>> >> when
>> > I
>> >> switch a report over to use a non-shared (custom) data source the
>> button
>> > is
>> >> not availab.e
>> >> - The ReportServer's are running under the same account
>> >>
>> >>
>> >> Obviously I'm missing something. Any ideas?
>> >>
>> >> Thx, Joel
>> >>
>> >>
>> >
>> >
>>
>>
>>
>|||Thanks for the clarification.
Technically speaking, I could request a SRS EE cd, install it, and then
point it to a STD Edition Sql Server (on another machine). But, to do this,
an Sql Server EE license is required, although Sql Server EE wouldn't
necessarily need to be installed.
The pricing info for a Sql Server EE license is the same as purchasing the
software correct?
Thanks!!
Joel
"Brian Welcker [MS]" <bwelcker@.online.microsoft.com> wrote in message
news:eP6t6lR7EHA.3616@.TK2MSFTNGP11.phx.gbl...
> Technically, this is the case only if you want to install them on the same
> box. You can buy an EE license of SQL Server to run Reporting Services and
> connect to an external STD SQL relational database.
> Anyawy, we had to make some decisions about what would go in each edition.
> After talking to customers, data driven subscriptions seemed like a
> reasonable EE feature.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
> news:OiWkmPR7EHA.3120@.TK2MSFTNGP12.phx.gbl...
>> Looks like the editions must match.
>> " The edition of SQL RS that can be installed must correspond to the
>> edition of SQL Server that is installed : "
>> http://msmvps.com/anguslogan/archive/2004/10/03/14788.aspx
>> Why not include data driven subscriptions in the SE version of SRS? It
>> seems to be a basic element. Although, I understand it will drive some
>> purchases of Sql Server EE.
>> Thx, Joel
>> "Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
>> news:OrhblKR7EHA.3708@.TK2MSFTNGP14.phx.gbl...
>> So it's definitely Standard Edition which explains that.
>> Next question: is Sql Server Enterprise Edition required to have
>> Reporting Services Enterprise Edition installed or are they mutually
>> exclusive? I currently only have servers with Sql Server Standard
>> Edition.
>> Thanks for the replies so far.
>> -Joel
>>
>> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
>> news:u6eE59Q7EHA.2540@.TK2MSFTNGP09.phx.gbl...
>> Just check under Control Panel : Add/Remove Programs. It should say
>> "Microsoft SQL Server 2000 Reporting Services Enterprise Edition".
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
>> news:uasoRaQ7EHA.2804@.TK2MSFTNGP15.phx.gbl...
>> That's probably it ...
>> how can I tell which version I'm running? Is there a query or a
>> setting in
>> the config files?
>> Thx, Joel
>>
>> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in
>> message
>> news:uPD54tI7EHA.2600@.TK2MSFTNGP09.phx.gbl...
>> > Are you sure the production server has the Enterprise Edition of
>> Reporting
>> > Services installed? Data-driven subscriptions are not available in
>> > the
>> > Standard Edition.
>> >
>> > --
>> > This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> >
>> > "Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
>> > news:%23n8mtuH7EHA.2676@.TK2MSFTNGP12.phx.gbl...
>> >> Hi,
>> >>
>> >> I have a test server and a production RS server. On the test server
>> >> I
>> can
>> >> create data-driven subscriptions with no problems. However, on the
>> >> production server I do not get the "New Data-Driven Subscription"
>> button
>> > and
>> >> I can't figure out why.
>> >>
>> >> - I'm a domain administrator so I have local admin rights on both
>> boxes.
>> >> - I'm Content Manager on both boxes
>> >> - The Config files look identical (impersonate is on for both of
>> >> them,
>> >> however the connection string is encrypted so it could be that it's
>> > running
>> >> under a user without priveleges.)
>> >> - I'm not using integrated security for the data sources
>> >> - The data sources are shared. I found this on MSDN: "This button
>> >> is
>> not
>> >> available when you access subscriptions through a shared data
>> >> source",
>> >> but
>> >> the development server works okay with a shared data source, and
>> >> even
>> >> when
>> > I
>> >> switch a report over to use a non-shared (custom) data source the
>> button
>> > is
>> >> not availab.e
>> >> - The ReportServer's are running under the same account
>> >>
>> >>
>> >> Obviously I'm missing something. Any ideas?
>> >>
>> >> Thx, Joel
>> >>
>> >>
>> >
>> >
>>
>>
>>
>>
>|||You are correct. RS is part of the SQL Server license so you are buying a
license even if you don't install the relational database component.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
news:Ot1B9iS7EHA.1596@.tk2msftngp13.phx.gbl...
> Thanks for the clarification.
> Technically speaking, I could request a SRS EE cd, install it, and then
> point it to a STD Edition Sql Server (on another machine). But, to do
> this, an Sql Server EE license is required, although Sql Server EE
> wouldn't necessarily need to be installed.
> The pricing info for a Sql Server EE license is the same as purchasing the
> software correct?
> Thanks!!
> Joel
>
> "Brian Welcker [MS]" <bwelcker@.online.microsoft.com> wrote in message
> news:eP6t6lR7EHA.3616@.TK2MSFTNGP11.phx.gbl...
>> Technically, this is the case only if you want to install them on the
>> same box. You can buy an EE license of SQL Server to run Reporting
>> Services and connect to an external STD SQL relational database.
>> Anyawy, we had to make some decisions about what would go in each
>> edition. After talking to customers, data driven subscriptions seemed
>> like a reasonable EE feature.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
>> news:OiWkmPR7EHA.3120@.TK2MSFTNGP12.phx.gbl...
>> Looks like the editions must match.
>> " The edition of SQL RS that can be installed must correspond to the
>> edition of SQL Server that is installed : "
>> http://msmvps.com/anguslogan/archive/2004/10/03/14788.aspx
>> Why not include data driven subscriptions in the SE version of SRS? It
>> seems to be a basic element. Although, I understand it will drive some
>> purchases of Sql Server EE.
>> Thx, Joel
>> "Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
>> news:OrhblKR7EHA.3708@.TK2MSFTNGP14.phx.gbl...
>> So it's definitely Standard Edition which explains that.
>> Next question: is Sql Server Enterprise Edition required to have
>> Reporting Services Enterprise Edition installed or are they mutually
>> exclusive? I currently only have servers with Sql Server Standard
>> Edition.
>> Thanks for the replies so far.
>> -Joel
>>
>> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
>> news:u6eE59Q7EHA.2540@.TK2MSFTNGP09.phx.gbl...
>> Just check under Control Panel : Add/Remove Programs. It should say
>> "Microsoft SQL Server 2000 Reporting Services Enterprise Edition".
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
>> news:uasoRaQ7EHA.2804@.TK2MSFTNGP15.phx.gbl...
>> That's probably it ...
>> how can I tell which version I'm running? Is there a query or a
>> setting in
>> the config files?
>> Thx, Joel
>>
>> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in
>> message
>> news:uPD54tI7EHA.2600@.TK2MSFTNGP09.phx.gbl...
>> > Are you sure the production server has the Enterprise Edition of
>> Reporting
>> > Services installed? Data-driven subscriptions are not available in
>> > the
>> > Standard Edition.
>> >
>> > --
>> > This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> >
>> > "Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
>> > news:%23n8mtuH7EHA.2676@.TK2MSFTNGP12.phx.gbl...
>> >> Hi,
>> >>
>> >> I have a test server and a production RS server. On the test
>> >> server I
>> can
>> >> create data-driven subscriptions with no problems. However, on the
>> >> production server I do not get the "New Data-Driven Subscription"
>> button
>> > and
>> >> I can't figure out why.
>> >>
>> >> - I'm a domain administrator so I have local admin rights on both
>> boxes.
>> >> - I'm Content Manager on both boxes
>> >> - The Config files look identical (impersonate is on for both of
>> >> them,
>> >> however the connection string is encrypted so it could be that
>> >> it's
>> > running
>> >> under a user without priveleges.)
>> >> - I'm not using integrated security for the data sources
>> >> - The data sources are shared. I found this on MSDN: "This button
>> >> is
>> not
>> >> available when you access subscriptions through a shared data
>> >> source",
>> >> but
>> >> the development server works okay with a shared data source, and
>> >> even
>> >> when
>> > I
>> >> switch a report over to use a non-shared (custom) data source the
>> button
>> > is
>> >> not availab.e
>> >> - The ReportServer's are running under the same account
>> >>
>> >>
>> >> Obviously I'm missing something. Any ideas?
>> >>
>> >> Thx, Joel
>> >>
>> >>
>> >
>> >
>>
>>
>>
>>
>>
>

No Data-Driven Subscription button

I have created a report and published it on the reporting server. My connection is working, and I have followed the steps in the BOL tutorial for "Defining a Data-Driven Subscription" i.e. Credentials stored securely on report server, using windows credentials when connecting to the data source. When I click on "Subscriptions", I only see "New Subscriptions". However, when I look at other reports (not even created by me), I see the option to create data driven subscriptions. Can somebody tell me what I need to do to see this?I got it; the report cannot be in the "My Reports" folder.

Monday, February 20, 2012

Newbie: printing question

Please (do not) confirm:
- To have a "print" button on report in order to print a report and not the
html page do I need to wait for sp2?
When could the sp2 be available?Yes, print functionality will be available in SP2 in the form of a
downloadable control. SP 2 is currently undergoing beta testing and it
should be out before the end of the year based on what I know. So, make a
wish to Santa if you've been a good boy :-)
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], 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/
---
"Marko Linke" <mlinke@.inet.hr> wrote in message
news:ufPVShU0EHA.4004@.tk2msftngp13.phx.gbl...
> Please (do not) confirm:
> - To have a "print" button on report in order to print a report and not
the
> html page do I need to wait for sp2?
> When could the sp2 be available?
>|||Sure it helps, thank you very much! So, then, first I'll start by helping
people cross the street and polishing my shoes for Santa's name day 6th
December in hope SP2 will fit my chimney later on. I'll also tip my boss to
do the same :-)
Best regards,
Marko
"Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> wrote in message
news:%23rZG7cZ0EHA.3156@.TK2MSFTNGP10.phx.gbl...
> Yes, print functionality will be available in SP2 in the form of a
> downloadable control. SP 2 is currently undergoing beta testing and it
> should be out before the end of the year based on what I know. So, make a
> wish to Santa if you've been a good boy :-)
> --
> Hope this helps.
> ---
> Teo Lachev, MVP [SQL Server], 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/
> ---
> "Marko Linke" <mlinke@.inet.hr> wrote in message
> news:ufPVShU0EHA.4004@.tk2msftngp13.phx.gbl...
>> Please (do not) confirm:
>> - To have a "print" button on report in order to print a report and not
> the
>> html page do I need to wait for sp2?
>> When could the sp2 be available?
>>
>|||You never know what works :-)
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], 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/
---
"Marko Linke" <mlinke@.inet.hr> wrote in message
news:uhiv34e0EHA.3588@.TK2MSFTNGP14.phx.gbl...
> Sure it helps, thank you very much! So, then, first I'll start by helping
> people cross the street and polishing my shoes for Santa's name day 6th
> December in hope SP2 will fit my chimney later on. I'll also tip my boss
to
> do the same :-)
> Best regards,
> Marko
> "Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> wrote in message
> news:%23rZG7cZ0EHA.3156@.TK2MSFTNGP10.phx.gbl...
> > Yes, print functionality will be available in SP2 in the form of a
> > downloadable control. SP 2 is currently undergoing beta testing and it
> > should be out before the end of the year based on what I know. So, make
a
> > wish to Santa if you've been a good boy :-)
> >
> > --
> > Hope this helps.
> >
> > ---
> > Teo Lachev, MVP [SQL Server], 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/
> > ---
> >
> > "Marko Linke" <mlinke@.inet.hr> wrote in message
> > news:ufPVShU0EHA.4004@.tk2msftngp13.phx.gbl...
> >> Please (do not) confirm:
> >>
> >> - To have a "print" button on report in order to print a report and not
> > the
> >> html page do I need to wait for sp2?
> >>
> >> When could the sp2 be available?
> >>
> >>
> >
> >
>