Dataset cannot be generated error

When editing the data driven subscription query I SOMETIMES get the following error: The dataset cannot be generated. An error occurred while connecting to a data source, or the query is not valid for the data source. (rsCannotPrepareQuery) Invalid object name '##XX'. The datasource is ok, authentication also, the query works... Why can't it see the temporary table?

|||How would I make it work with a temporary table? To update the problem: when I validate the query I get the error described above however if I run the same stored procedure that is used in a query in let's say management studio and leave it open, the query in data driven subscription web interface is validated succesfully. I'm running RS2005 on a Win2003Server.
|||I really woul appreciate any suggestions, cause it's basically messing with my report server stability...thanks
|||

Did you ever find a solution? I have the same problem. My data set involves concatenated SQL which causes the SP to not return the columns, but if I don't do it this way, I will be creating a monumental amount of work to have individual tables.

Dataset cannot be generated error

When editing the data driven subscription query I SOMETIMES get the following error: The dataset cannot be generated. An error occurred while connecting to a data

source, or the query is not valid for the data source. (rsCannotPrepareQuery) Invalid object name '##XX'. The datasource is ok, authentication also, the query works... Why can't it see the temporary table?

How would I make it work with a temporary table? To update the problem:

when I validate the query I get the error described above however if I

run the same stored procedure that is used in a query in let's say

management studio and leave it open, the query in data driven

subscription web interface is validated succesfully. I'm running RS2005

on a Win2003Server.|||I really woul appreciate any suggestions, cause it's basically messing with my report server stability...thanks|||

Did you ever find a solution? I have the same problem. My data set involves concatenated SQL which causes the SP to not return the columns, but if I don't do it this way, I will be creating a monumental amount of work to have individual tables.

Dataset cannot be generated error

When editing the data driven subscription query I SOMETIMES get the following error: The dataset cannot be generated. An error occurred while connecting to a data

source, or the query is not valid for the data source. (rsCannotPrepareQuery) Invalid object name '##XX'. The datasource is ok, authentication also, the query works... Why can't it see the temporary table?

How would I make it work with a temporary table? To update the problem:

when I validate the query I get the error described above however if I

run the same stored procedure that is used in a query in let's say

management studio and leave it open, the query in data driven

subscription web interface is validated succesfully. I'm running RS2005

on a Win2003Server.|||I really woul appreciate any suggestions, cause it's basically messing with my report server stability...thanks|||

Did you ever find a solution? I have the same problem. My data set involves concatenated SQL which causes the SP to not return the columns, but if I don't do it this way, I will be creating a monumental amount of work to have individual tables.

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

Data-Driven Subscriptions

Each time I run a data-driven subscription, I recieve the following
information ... "Processing: 0 processed of 1 total; 0 errors" ... The report
runs fine manually and via a subscription, but not a data-driven
subscription. I'm at a lost, where do I start to find this problem?
--
~Jack~Start by looking the reportserverservice<data>.log file. See if it says
anything about picking up the items. What is the subscriptions result?
Have you checked if the subscriptions has succeeded but is just not
reporting it correctly?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jack Mac" <jackmacgregor@.aj-net.com> wrote in message
news:A5766903-014B-44A2-928F-597B8986755B@.microsoft.com...
> Each time I run a data-driven subscription, I recieve the following
> information ... "Processing: 0 processed of 1 total; 0 errors" ... The
> report
> runs fine manually and via a subscription, but not a data-driven
> subscription. I'm at a lost, where do I start to find this problem?
> --
> ~Jack~|||Daniel,
Thanks for the reply. The data-driven subscription is designed to save the
file as an excel file to a shared folder. Late yesterday I had changed the
User name to my own credentials to see if this would help. Now I recieve the
message "Processing: 1 processed of 1 total; 0 errors"; but no file is
delivered/created to the shared folder. This is at least a step better since
before I had changed the credentials, the message was "Processing: 0
processed of 1 total; 0 errors" . I did look through the log files and found
no errors (wish I had, it would make it simpler to track down the issue)
"Daniel Reib [MSFT]" wrote:
> Start by looking the reportserverservice<data>.log file. See if it says
> anything about picking up the items. What is the subscriptions result?
> Have you checked if the subscriptions has succeeded but is just not
> reporting it correctly?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Jack Mac" <jackmacgregor@.aj-net.com> wrote in message
> news:A5766903-014B-44A2-928F-597B8986755B@.microsoft.com...
> > Each time I run a data-driven subscription, I recieve the following
> > information ... "Processing: 0 processed of 1 total; 0 errors" ... The
> > report
> > runs fine manually and via a subscription, but not a data-driven
> > subscription. I'm at a lost, where do I start to find this problem?
> > --
> > ~Jack~
>
>|||Can you post a portion of the log file that contains the info for when the
subscription fired?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jack Mac" <jackmacgregor@.aj-net.com> wrote in message
news:E9BEDE9D-EEEA-4570-8D1D-B648986F46F4@.microsoft.com...
> Daniel,
> Thanks for the reply. The data-driven subscription is designed to save
> the
> file as an excel file to a shared folder. Late yesterday I had changed
> the
> User name to my own credentials to see if this would help. Now I recieve
> the
> message "Processing: 1 processed of 1 total; 0 errors"; but no file is
> delivered/created to the shared folder. This is at least a step better
> since
> before I had changed the credentials, the message was "Processing: 0
> processed of 1 total; 0 errors" . I did look through the log files and
> found
> no errors (wish I had, it would make it simpler to track down the issue)
> "Daniel Reib [MSFT]" wrote:
>> Start by looking the reportserverservice<data>.log file. See if it says
>> anything about picking up the items. What is the subscriptions result?
>> Have you checked if the subscriptions has succeeded but is just not
>> reporting it correctly?
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Jack Mac" <jackmacgregor@.aj-net.com> wrote in message
>> news:A5766903-014B-44A2-928F-597B8986755B@.microsoft.com...
>> > Each time I run a data-driven subscription, I recieve the following
>> > information ... "Processing: 0 processed of 1 total; 0 errors" ... The
>> > report
>> > runs fine manually and via a subscription, but not a data-driven
>> > subscription. I'm at a lost, where do I start to find this problem?
>> > --
>> > ~Jack~
>>|||Daniel, Here is the last log entries for the data-driven subscription
ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
processing item 09a38510-e45a-4050-a89d-856230aa4859
ReportingServicesService!dbpolling!1cbc!12/16/2004-08:23:02:: EventPolling
processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!library!1cf4!12/16/2004-08:23:02:: Schedule
f1955b4a-8e29-4b1c-a137-cfaafd32e584 executed at 12/16/2004 08:23:02.
ReportingServicesService!library!1cf4!12/16/2004-08:23:02:: Schedule
f1955b4a-8e29-4b1c-a137-cfaafd32e584 execution completed at 12/16/2004
08:23:02.
ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
finished processing item 09a38510-e45a-4050-a89d-856230aa4859
ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
processing item af247e4b-8fc1-451a-bcd2-5daaeaeebe52
ReportingServicesService!dbpolling!1cbc!12/16/2004-08:23:02:: EventPolling
processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!library!1cf4!12/16/2004-08:23:02:: Schedule
f1955b4a-8e29-4b1c-a137-cfaafd32e584 executed at 12/16/2004 08:23:02.
ReportingServicesService!schedule!1cf4!12/16/2004-08:23:02:: Creating Time
based subscription notification for subscription:
f914a139-fae6-4192-b98a-7d6ab51ec6e0
ReportingServicesService!library!1cf4!12/16/2004-08:23:02:: Schedule
f1955b4a-8e29-4b1c-a137-cfaafd32e584 execution completed at 12/16/2004
08:23:02.
ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
finished processing item af247e4b-8fc1-451a-bcd2-5daaeaeebe52
ReportingServicesService!dbpolling!1cbc!12/16/2004-08:23:02:: EventPolling
processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
processing item c7dffde0-062e-494b-b66e-e502b8eb714d
ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
finished processing item c7dffde0-062e-494b-b66e-e502b8eb714d
ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:03::
NotificationPolling processing item ab5e7c97-88d8-44af-83df-cff2ef6e7047
ReportingServicesService!dbpolling!1cbc!12/16/2004-08:23:03::
NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!crypto!1cf4!12/16/2004-08:23:03:: e ERROR:
DBUnProtectData failed: System.FormatException: Invalid length for a Base-64
char array.
at System.Convert.FromBase64String(String s)
at
Microsoft.ReportingServices.Diagnostics.DataProtection.DBUnprotectData(String
data)
ReportingServicesService!crypto!1cf4!12/16/2004-08:23:03:: i INFO: Current
user: NT AUTHORITY\SYSTEM
ReportingServicesService!notification!1cf4!12/16/2004-08:23:03:: e ERROR:
Error occured processing notification. Invalid length for a Base-64 char
array.
ReportingServicesService!library!1cf4!12/16/2004-08:23:03:: Data Driven
Notification for activation id 9845a8ff-e063-4a16-b6e1-ee8b59ba22ef was saved.
ReportingServicesService!library!1cf4!12/16/2004-08:23:03:: Status: Invalid
length for a Base-64 char array.
ReportingServicesService!notification!1cf4!12/16/2004-08:23:03::
Notification ab5e7c97-88d8-44af-83df-cff2ef6e7047 completed. Success: True,
Status: Invalid length for a Base-64 char array., DeliveryExtension: Report
Server FileShare, Report: Monthly Sales, Attempt 0
ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:03::
NotificationPolling finished processing item
ab5e7c97-88d8-44af-83df-cff2ef6e7047
ReportingServicesService!library!1cf4!12/16/2004-08:25:30:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 5
chunks, 0 running jobs
"Daniel Reib [MSFT]" wrote:
> Can you post a portion of the log file that contains the info for when the
> subscription fired?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Jack Mac" <jackmacgregor@.aj-net.com> wrote in message
> news:E9BEDE9D-EEEA-4570-8D1D-B648986F46F4@.microsoft.com...
> > Daniel,
> >
> > Thanks for the reply. The data-driven subscription is designed to save
> > the
> > file as an excel file to a shared folder. Late yesterday I had changed
> > the
> > User name to my own credentials to see if this would help. Now I recieve
> > the
> > message "Processing: 1 processed of 1 total; 0 errors"; but no file is
> > delivered/created to the shared folder. This is at least a step better
> > since
> > before I had changed the credentials, the message was "Processing: 0
> > processed of 1 total; 0 errors" . I did look through the log files and
> > found
> > no errors (wish I had, it would make it simpler to track down the issue)
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> Start by looking the reportserverservice<data>.log file. See if it says
> >> anything about picking up the items. What is the subscriptions result?
> >> Have you checked if the subscriptions has succeeded but is just not
> >> reporting it correctly?
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Jack Mac" <jackmacgregor@.aj-net.com> wrote in message
> >> news:A5766903-014B-44A2-928F-597B8986755B@.microsoft.com...
> >> > Each time I run a data-driven subscription, I recieve the following
> >> > information ... "Processing: 0 processed of 1 total; 0 errors" ... The
> >> > report
> >> > runs fine manually and via a subscription, but not a data-driven
> >> > subscription. I'm at a lost, where do I start to find this problem?
> >> > --
> >> > ~Jack~
> >>
> >>
> >>
>
>|||Are you using Fileshare delivery? If so there is a known issue where you
can not use dynamic values for the user name and password. From the log,
this looks like the issue.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jack Mac" <jackmacgregor@.aj-net.com> wrote in message
news:BD5AF19E-5055-41B8-9E1B-83648CD11037@.microsoft.com...
> Daniel, Here is the last log entries for the data-driven subscription
> ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
> processing item 09a38510-e45a-4050-a89d-856230aa4859
> ReportingServicesService!dbpolling!1cbc!12/16/2004-08:23:02:: EventPolling
> processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!library!1cf4!12/16/2004-08:23:02:: Schedule
> f1955b4a-8e29-4b1c-a137-cfaafd32e584 executed at 12/16/2004 08:23:02.
> ReportingServicesService!library!1cf4!12/16/2004-08:23:02:: Schedule
> f1955b4a-8e29-4b1c-a137-cfaafd32e584 execution completed at 12/16/2004
> 08:23:02.
> ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
> finished processing item 09a38510-e45a-4050-a89d-856230aa4859
> ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
> processing item af247e4b-8fc1-451a-bcd2-5daaeaeebe52
> ReportingServicesService!dbpolling!1cbc!12/16/2004-08:23:02:: EventPolling
> processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!library!1cf4!12/16/2004-08:23:02:: Schedule
> f1955b4a-8e29-4b1c-a137-cfaafd32e584 executed at 12/16/2004 08:23:02.
> ReportingServicesService!schedule!1cf4!12/16/2004-08:23:02:: Creating Time
> based subscription notification for subscription:
> f914a139-fae6-4192-b98a-7d6ab51ec6e0
> ReportingServicesService!library!1cf4!12/16/2004-08:23:02:: Schedule
> f1955b4a-8e29-4b1c-a137-cfaafd32e584 execution completed at 12/16/2004
> 08:23:02.
> ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
> finished processing item af247e4b-8fc1-451a-bcd2-5daaeaeebe52
> ReportingServicesService!dbpolling!1cbc!12/16/2004-08:23:02:: EventPolling
> processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
> processing item c7dffde0-062e-494b-b66e-e502b8eb714d
> ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
> finished processing item c7dffde0-062e-494b-b66e-e502b8eb714d
> ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:03::
> NotificationPolling processing item ab5e7c97-88d8-44af-83df-cff2ef6e7047
> ReportingServicesService!dbpolling!1cbc!12/16/2004-08:23:03::
> NotificationPolling processing 1 more items. 1 Total items in internal
> queue.
> ReportingServicesService!crypto!1cf4!12/16/2004-08:23:03:: e ERROR:
> DBUnProtectData failed: System.FormatException: Invalid length for a
> Base-64
> char array.
> at System.Convert.FromBase64String(String s)
> at
> Microsoft.ReportingServices.Diagnostics.DataProtection.DBUnprotectData(String
> data)
> ReportingServicesService!crypto!1cf4!12/16/2004-08:23:03:: i INFO: Current
> user: NT AUTHORITY\SYSTEM
> ReportingServicesService!notification!1cf4!12/16/2004-08:23:03:: e ERROR:
> Error occured processing notification. Invalid length for a Base-64 char
> array.
> ReportingServicesService!library!1cf4!12/16/2004-08:23:03:: Data Driven
> Notification for activation id 9845a8ff-e063-4a16-b6e1-ee8b59ba22ef was
> saved.
> ReportingServicesService!library!1cf4!12/16/2004-08:23:03:: Status:
> Invalid
> length for a Base-64 char array.
> ReportingServicesService!notification!1cf4!12/16/2004-08:23:03::
> Notification ab5e7c97-88d8-44af-83df-cff2ef6e7047 completed. Success:
> True,
> Status: Invalid length for a Base-64 char array., DeliveryExtension:
> Report
> Server FileShare, Report: Monthly Sales, Attempt 0
> ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:03::
> NotificationPolling finished processing item
> ab5e7c97-88d8-44af-83df-cff2ef6e7047
> ReportingServicesService!library!1cf4!12/16/2004-08:25:30:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 5
> chunks, 0 running jobs
>
> "Daniel Reib [MSFT]" wrote:
>> Can you post a portion of the log file that contains the info for when
>> the
>> subscription fired?
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Jack Mac" <jackmacgregor@.aj-net.com> wrote in message
>> news:E9BEDE9D-EEEA-4570-8D1D-B648986F46F4@.microsoft.com...
>> > Daniel,
>> >
>> > Thanks for the reply. The data-driven subscription is designed to save
>> > the
>> > file as an excel file to a shared folder. Late yesterday I had changed
>> > the
>> > User name to my own credentials to see if this would help. Now I
>> > recieve
>> > the
>> > message "Processing: 1 processed of 1 total; 0 errors"; but no file is
>> > delivered/created to the shared folder. This is at least a step better
>> > since
>> > before I had changed the credentials, the message was "Processing: 0
>> > processed of 1 total; 0 errors" . I did look through the log files and
>> > found
>> > no errors (wish I had, it would make it simpler to track down the
>> > issue)
>> >
>> > "Daniel Reib [MSFT]" wrote:
>> >
>> >> Start by looking the reportserverservice<data>.log file. See if it
>> >> says
>> >> anything about picking up the items. What is the subscriptions
>> >> result?
>> >> Have you checked if the subscriptions has succeeded but is just not
>> >> reporting it correctly?
>> >>
>> >> --
>> >> -Daniel
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >>
>> >>
>> >> "Jack Mac" <jackmacgregor@.aj-net.com> wrote in message
>> >> news:A5766903-014B-44A2-928F-597B8986755B@.microsoft.com...
>> >> > Each time I run a data-driven subscription, I recieve the following
>> >> > information ... "Processing: 0 processed of 1 total; 0 errors" ...
>> >> > The
>> >> > report
>> >> > runs fine manually and via a subscription, but not a data-driven
>> >> > subscription. I'm at a lost, where do I start to find this problem?
>> >> > --
>> >> > ~Jack~
>> >>
>> >>
>> >>
>>|||Yes I'm using file share and yes I am dynamically storing the user name and
password. Manually entered the user name and passwor as you suggest. Work
like charm. Thanks for all the help!!!
"Daniel Reib [MSFT]" wrote:
> Are you using Fileshare delivery? If so there is a known issue where you
> can not use dynamic values for the user name and password. From the log,
> this looks like the issue.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Jack Mac" <jackmacgregor@.aj-net.com> wrote in message
> news:BD5AF19E-5055-41B8-9E1B-83648CD11037@.microsoft.com...
> > Daniel, Here is the last log entries for the data-driven subscription
> >
> > ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
> > processing item 09a38510-e45a-4050-a89d-856230aa4859
> > ReportingServicesService!dbpolling!1cbc!12/16/2004-08:23:02:: EventPolling
> > processing 1 more items. 1 Total items in internal queue.
> > ReportingServicesService!library!1cf4!12/16/2004-08:23:02:: Schedule
> > f1955b4a-8e29-4b1c-a137-cfaafd32e584 executed at 12/16/2004 08:23:02.
> > ReportingServicesService!library!1cf4!12/16/2004-08:23:02:: Schedule
> > f1955b4a-8e29-4b1c-a137-cfaafd32e584 execution completed at 12/16/2004
> > 08:23:02.
> > ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
> > finished processing item 09a38510-e45a-4050-a89d-856230aa4859
> > ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
> > processing item af247e4b-8fc1-451a-bcd2-5daaeaeebe52
> > ReportingServicesService!dbpolling!1cbc!12/16/2004-08:23:02:: EventPolling
> > processing 1 more items. 1 Total items in internal queue.
> > ReportingServicesService!library!1cf4!12/16/2004-08:23:02:: Schedule
> > f1955b4a-8e29-4b1c-a137-cfaafd32e584 executed at 12/16/2004 08:23:02.
> > ReportingServicesService!schedule!1cf4!12/16/2004-08:23:02:: Creating Time
> > based subscription notification for subscription:
> > f914a139-fae6-4192-b98a-7d6ab51ec6e0
> > ReportingServicesService!library!1cf4!12/16/2004-08:23:02:: Schedule
> > f1955b4a-8e29-4b1c-a137-cfaafd32e584 execution completed at 12/16/2004
> > 08:23:02.
> > ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
> > finished processing item af247e4b-8fc1-451a-bcd2-5daaeaeebe52
> > ReportingServicesService!dbpolling!1cbc!12/16/2004-08:23:02:: EventPolling
> > processing 1 more items. 1 Total items in internal queue.
> > ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
> > processing item c7dffde0-062e-494b-b66e-e502b8eb714d
> > ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
> > finished processing item c7dffde0-062e-494b-b66e-e502b8eb714d
> > ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:03::
> > NotificationPolling processing item ab5e7c97-88d8-44af-83df-cff2ef6e7047
> > ReportingServicesService!dbpolling!1cbc!12/16/2004-08:23:03::
> > NotificationPolling processing 1 more items. 1 Total items in internal
> > queue.
> > ReportingServicesService!crypto!1cf4!12/16/2004-08:23:03:: e ERROR:
> > DBUnProtectData failed: System.FormatException: Invalid length for a
> > Base-64
> > char array.
> > at System.Convert.FromBase64String(String s)
> > at
> > Microsoft.ReportingServices.Diagnostics.DataProtection.DBUnprotectData(String
> > data)
> > ReportingServicesService!crypto!1cf4!12/16/2004-08:23:03:: i INFO: Current
> > user: NT AUTHORITY\SYSTEM
> > ReportingServicesService!notification!1cf4!12/16/2004-08:23:03:: e ERROR:
> > Error occured processing notification. Invalid length for a Base-64 char
> > array.
> > ReportingServicesService!library!1cf4!12/16/2004-08:23:03:: Data Driven
> > Notification for activation id 9845a8ff-e063-4a16-b6e1-ee8b59ba22ef was
> > saved.
> > ReportingServicesService!library!1cf4!12/16/2004-08:23:03:: Status:
> > Invalid
> > length for a Base-64 char array.
> > ReportingServicesService!notification!1cf4!12/16/2004-08:23:03::
> > Notification ab5e7c97-88d8-44af-83df-cff2ef6e7047 completed. Success:
> > True,
> > Status: Invalid length for a Base-64 char array., DeliveryExtension:
> > Report
> > Server FileShare, Report: Monthly Sales, Attempt 0
> > ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:03::
> > NotificationPolling finished processing item
> > ab5e7c97-88d8-44af-83df-cff2ef6e7047
> > ReportingServicesService!library!1cf4!12/16/2004-08:25:30:: i INFO:
> > Cleaned
> > 0 batch records, 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 5
> > chunks, 0 running jobs
> >
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> Can you post a portion of the log file that contains the info for when
> >> the
> >> subscription fired?
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Jack Mac" <jackmacgregor@.aj-net.com> wrote in message
> >> news:E9BEDE9D-EEEA-4570-8D1D-B648986F46F4@.microsoft.com...
> >> > Daniel,
> >> >
> >> > Thanks for the reply. The data-driven subscription is designed to save
> >> > the
> >> > file as an excel file to a shared folder. Late yesterday I had changed
> >> > the
> >> > User name to my own credentials to see if this would help. Now I
> >> > recieve
> >> > the
> >> > message "Processing: 1 processed of 1 total; 0 errors"; but no file is
> >> > delivered/created to the shared folder. This is at least a step better
> >> > since
> >> > before I had changed the credentials, the message was "Processing: 0
> >> > processed of 1 total; 0 errors" . I did look through the log files and
> >> > found
> >> > no errors (wish I had, it would make it simpler to track down the
> >> > issue)
> >> >
> >> > "Daniel Reib [MSFT]" wrote:
> >> >
> >> >> Start by looking the reportserverservice<data>.log file. See if it
> >> >> says
> >> >> anything about picking up the items. What is the subscriptions
> >> >> result?
> >> >> Have you checked if the subscriptions has succeeded but is just not
> >> >> reporting it correctly?
> >> >>
> >> >> --
> >> >> -Daniel
> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> >> rights.
> >> >>
> >> >>
> >> >> "Jack Mac" <jackmacgregor@.aj-net.com> wrote in message
> >> >> news:A5766903-014B-44A2-928F-597B8986755B@.microsoft.com...
> >> >> > Each time I run a data-driven subscription, I recieve the following
> >> >> > information ... "Processing: 0 processed of 1 total; 0 errors" ...
> >> >> > The
> >> >> > report
> >> >> > runs fine manually and via a subscription, but not a data-driven
> >> >> > subscription. I'm at a lost, where do I start to find this problem?
> >> >> > --
> >> >> > ~Jack~
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>

Data-driven subscription: put parameter in the filename text

Hi all,

I've developed a data driven subscription report. I have a paramete (named "Data") that is a result of my query to the current date. It is working fine.

Now I would like to make one change: In the step4 of the creation of the data-driven report we have the option to give a name to the filename.The name that I gave was TestFile. In this option i'm also able to select the parameter instead of giving the name to the filename. Can I make something like TestFile_ & @.Data? Wich would result in TestFile_01-02-2007? Or the only way is to make, in the query of the paramenter another field with this result?

Thanks in advance.

Marco.

I tried the other option, making it by a query and this is what I want.

Anyway, instead of making this in my query, I couldn't have done this in the text? Like I said TestFile_ & @.Data? This would be interpreted as a string am I right?

Data-driven subscription with multi-select parameter

I'm trying to create a data-driven subscription with the ability to pass
multiple values using a multi-select parameter. Is this possible, and if so
how does one store the data in the database?
Thanks,
JoshI need this ability also, and according to this post, it is really not
possible. The solution proposed here is not feasable for my needs as I have
potentially from 1 to many many values for each parameter. Also, have no idea
how to use the SOAP API.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=518858&SiteID=1
"JSI" wrote:
> I'm trying to create a data-driven subscription with the ability to pass
> multiple values using a multi-select parameter. Is this possible, and if so
> how does one store the data in the database?
> Thanks,
> Josh

Data-driven Subscription with Date Parameter from DB

I'm not having fun anymore... I have done this in the past and now I am
unable to get this to work.
I have a report that accepts a date as a parameter. When called through the
web-page or in a subscription with static values for the date, this works. It
also works if the default value for the parameter is used. The default value
is a call to a datasource that simply calls "SELECT GETDATE()".
When I set up a data-driven subscription, give it the same datasource, give
the query of "SELECT GETDATE() AS REPORTDATE", and set the parameter to use
the REPORTDATE value; an error occurs stating that a type mismatch has been
encountered.
I have created a test report (attached below) that exhibits the same issue.
Set up a data-driven subscription with the "SELECT GETDATE() AS REPORTDATE"
query on any datasource.
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition"
xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<PageHeader>
<PrintOnLastPage>true</PrintOnLastPage>
<PrintOnFirstPage>true</PrintOnFirstPage>
<Style />
<Height>0.25in</Height>
</PageHeader>
<RightMargin>1in</RightMargin>
<Body>
<ReportItems>
<Textbox Name="textbox1">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<rd:DefaultName>textbox1</rd:DefaultName>
<Width>2.6875in</Width>
<CanGrow>true</CanGrow>
<Value>=Parameters!STARTDATE.Value</Value>
<Left>1.625in</Left>
</Textbox>
</ReportItems>
<Style />
<Height>0.375in</Height>
</Body>
<TopMargin>1in</TopMargin>
<DataSources>
<DataSource Name="CPR_commerce">
<rd:DataSourceID>ec9dccfe-38c9-45ca-a0c0-7364bfc665e8</rd:DataSourceID>
<DataSourceReference>CPR_commerce</DataSourceReference>
</DataSource>
</DataSources>
<Width>6.5in</Width>
<DataSets>
<DataSet Name="DEFAULTDATE">
<Fields>
<Field Name="ID">
<DataField />
<rd:TypeName>System.DateTime</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>CPR_commerce</DataSourceName>
<CommandText>SELECT GETDATE()</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
</DataSets>
<LeftMargin>1in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<rd:DrawGrid>true</rd:DrawGrid>
<rd:ReportID>2549c4c5-9946-4a66-abda-7784310a7b58</rd:ReportID>
<PageFooter>
<PrintOnLastPage>true</PrintOnLastPage>
<PrintOnFirstPage>true</PrintOnFirstPage>
<Style />
<Height>0.25in</Height>
</PageFooter>
<BottomMargin>1in</BottomMargin>
<ReportParameters>
<ReportParameter Name="STARTDATE">
<DataType>DateTime</DataType>
<DefaultValue>
<DataSetReference>
<DataSetName>DEFAULTDATE</DataSetName>
<ValueField>ID</ValueField>
</DataSetReference>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>STARTDATE</Prompt>
</ReportParameter>
</ReportParameters>
<Language>en-US</Language>
</Report>Well... I've solved it. It seems that the locale setting was set to en-CA and
it was messing up the times. Not sure why or how this got set to that but I'm
sure I'll be able to figure it out or avoid it in the future... man, what a
pain.
"Rixmann" wrote:
> I'm not having fun anymore... I have done this in the past and now I am
> unable to get this to work.
> I have a report that accepts a date as a parameter. When called through the
> web-page or in a subscription with static values for the date, this works. It
> also works if the default value for the parameter is used. The default value
> is a call to a datasource that simply calls "SELECT GETDATE()".
> When I set up a data-driven subscription, give it the same datasource, give
> the query of "SELECT GETDATE() AS REPORTDATE", and set the parameter to use
> the REPORTDATE value; an error occurs stating that a type mismatch has been
> encountered.
> I have created a test report (attached below) that exhibits the same issue.
> Set up a data-driven subscription with the "SELECT GETDATE() AS REPORTDATE"
> query on any datasource.
> <?xml version="1.0" encoding="utf-8"?>
> <Report
> xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition"
> xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
> <PageHeader>
> <PrintOnLastPage>true</PrintOnLastPage>
> <PrintOnFirstPage>true</PrintOnFirstPage>
> <Style />
> <Height>0.25in</Height>
> </PageHeader>
> <RightMargin>1in</RightMargin>
> <Body>
> <ReportItems>
> <Textbox Name="textbox1">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <rd:DefaultName>textbox1</rd:DefaultName>
> <Width>2.6875in</Width>
> <CanGrow>true</CanGrow>
> <Value>=Parameters!STARTDATE.Value</Value>
> <Left>1.625in</Left>
> </Textbox>
> </ReportItems>
> <Style />
> <Height>0.375in</Height>
> </Body>
> <TopMargin>1in</TopMargin>
> <DataSources>
> <DataSource Name="CPR_commerce">
> <rd:DataSourceID>ec9dccfe-38c9-45ca-a0c0-7364bfc665e8</rd:DataSourceID>
> <DataSourceReference>CPR_commerce</DataSourceReference>
> </DataSource>
> </DataSources>
> <Width>6.5in</Width>
> <DataSets>
> <DataSet Name="DEFAULTDATE">
> <Fields>
> <Field Name="ID">
> <DataField />
> <rd:TypeName>System.DateTime</rd:TypeName>
> </Field>
> </Fields>
> <Query>
> <DataSourceName>CPR_commerce</DataSourceName>
> <CommandText>SELECT GETDATE()</CommandText>
> <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
> </Query>
> </DataSet>
> </DataSets>
> <LeftMargin>1in</LeftMargin>
> <rd:SnapToGrid>true</rd:SnapToGrid>
> <rd:DrawGrid>true</rd:DrawGrid>
> <rd:ReportID>2549c4c5-9946-4a66-abda-7784310a7b58</rd:ReportID>
> <PageFooter>
> <PrintOnLastPage>true</PrintOnLastPage>
> <PrintOnFirstPage>true</PrintOnFirstPage>
> <Style />
> <Height>0.25in</Height>
> </PageFooter>
> <BottomMargin>1in</BottomMargin>
> <ReportParameters>
> <ReportParameter Name="STARTDATE">
> <DataType>DateTime</DataType>
> <DefaultValue>
> <DataSetReference>
> <DataSetName>DEFAULTDATE</DataSetName>
> <ValueField>ID</ValueField>
> </DataSetReference>
> </DefaultValue>
> <AllowBlank>true</AllowBlank>
> <Prompt>STARTDATE</Prompt>
> </ReportParameter>
> </ReportParameters>
> <Language>en-US</Language>
> </Report>

Data-driven subscription not working

I created a data-driven subscription for my report with "Null Delivery Provider" set in report manager. I set the processing to "On a schedule created for this subscription" and scheduled the report to "run once" in the next 1 minute so I could test it. The subscription added successfully, but I don't see the "last run information" even after 5 minutes. Am I missing something?

Thanks in advance!!!

Check SQL Server for any failures reported in the log.

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

data-driven subscription not available

I would like to setup a data-driven subscription for a report, but the New
Data-driven Subscription button is not available on the subscription page -
only the New Subscription button appears. I have checked that the report
uses a custom data source and stores the user name and password credentials
in the report server. The account that I am using to access Report Manager
is in the System Administrators role and the Content Manager role for the
report. What am I missing?
Thanks,
RobertDo you have Enterprise Edition? This feature is not available in Standard
Edition.
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"RMac" <@.news.postalias> wrote in message
news:EC568923-1967-44FE-8A17-4E2E67AC53D2@.microsoft.com...
>I would like to setup a data-driven subscription for a report, but the New
> Data-driven Subscription button is not available on the subscription
> page -
> only the New Subscription button appears. I have checked that the report
> uses a custom data source and stores the user name and password
> credentials
> in the report server. The account that I am using to access Report
> Manager
> is in the System Administrators role and the Content Manager role for the
> report. What am I missing?
> Thanks,
> Robert|||That is the problem then. I was not aware that Data-driven subscriptions
are not available in Standard Edition. Thanks Jasper.
"Jasper Smith" wrote:
> Do you have Enterprise Edition? This feature is not available in Standard
> Edition.
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "RMac" <@.news.postalias> wrote in message
> news:EC568923-1967-44FE-8A17-4E2E67AC53D2@.microsoft.com...
> >I would like to setup a data-driven subscription for a report, but the New
> > Data-driven Subscription button is not available on the subscription
> > page -
> > only the New Subscription button appears. I have checked that the report
> > uses a custom data source and stores the user name and password
> > credentials
> > in the report server. The account that I am using to access Report
> > Manager
> > is in the System Administrators role and the Content Manager role for the
> > report. What am I missing?
> > Thanks,
> > Robert
>
>

Data-Driven Subscription not appearing

Hi All,
When I click on a report in report manager, and go to subscriptions only a
Normal Subscription Oprion appears.
The Data-Driven Subscription does not appear.
Is there an otion to make this visible somewhere.?
Thanks
SanjeevData Driven Subscriptions are only available for the Enterprise Sku. Do you
have enterprise?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sanjeev" <sanjeev@.microsoft.com> wrote in message
news:%23u7wLD09FHA.3928@.TK2MSFTNGP11.phx.gbl...
> Hi All,
> When I click on a report in report manager, and go to subscriptions only a
> Normal Subscription Oprion appears.
> The Data-Driven Subscription does not appear.
> Is there an otion to make this visible somewhere.?
> Thanks
> Sanjeev
>|||Yes I do have Enterprise Sku.
We are planning to install SQL Server 2005 at some stage as well.
Does data driven subscriptions only come with the enterprise edition of this
as well?
Thanks for your assistance
Sanjeev
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:uEjA5Nq%23FHA.3852@.TK2MSFTNGP14.phx.gbl...
> Data Driven Subscriptions are only available for the Enterprise Sku. Do
> you have enterprise?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Sanjeev" <sanjeev@.microsoft.com> wrote in message
> news:%23u7wLD09FHA.3928@.TK2MSFTNGP11.phx.gbl...
>> Hi All,
>> When I click on a report in report manager, and go to subscriptions only
>> a Normal Subscription Oprion appears.
>> The Data-Driven Subscription does not appear.
>> Is there an otion to make this visible somewhere.?
>> Thanks
>> Sanjeev
>|||Yes it does.
The Data Driven button will also not show up if you do not have permission
to create DD subscriptions for that report. Make sure you have Manage All
Subscription permission.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sanjeev" <sanjeev@.microsoft.com> wrote in message
news:%23NP0WT$%23FHA.912@.TK2MSFTNGP11.phx.gbl...
> Yes I do have Enterprise Sku.
> We are planning to install SQL Server 2005 at some stage as well.
> Does data driven subscriptions only come with the enterprise edition of
> this as well?
> Thanks for your assistance
> Sanjeev
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:uEjA5Nq%23FHA.3852@.TK2MSFTNGP14.phx.gbl...
>> Data Driven Subscriptions are only available for the Enterprise Sku. Do
>> you have enterprise?
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Sanjeev" <sanjeev@.microsoft.com> wrote in message
>> news:%23u7wLD09FHA.3928@.TK2MSFTNGP11.phx.gbl...
>> Hi All,
>> When I click on a report in report manager, and go to subscriptions only
>> a Normal Subscription Oprion appears.
>> The Data-Driven Subscription does not appear.
>> Is there an otion to make this visible somewhere.?
>> Thanks
>> Sanjeev
>>
>|||Sorry, I misinterpreted you, we actually do not have Enterprise sku
installed at our site where I was trying to create DD subscriptions.
Unfortunately, we need to send reports, which takes the recipient's name as
a parameter, to about 500 recipients.
DD Subscriptions would have been ideal.
I do not think this is feasible to create 500 subscriptions for each report
using the normal subscription way.
Thanks for all your help
Sanjeev
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:ea1jIDC$FHA.3136@.TK2MSFTNGP15.phx.gbl...
> Yes it does.
> The Data Driven button will also not show up if you do not have permission
> to create DD subscriptions for that report. Make sure you have Manage All
> Subscription permission.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Sanjeev" <sanjeev@.microsoft.com> wrote in message
> news:%23NP0WT$%23FHA.912@.TK2MSFTNGP11.phx.gbl...
>> Yes I do have Enterprise Sku.
>> We are planning to install SQL Server 2005 at some stage as well.
>> Does data driven subscriptions only come with the enterprise edition of
>> this as well?
>> Thanks for your assistance
>> Sanjeev
>> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
>> news:uEjA5Nq%23FHA.3852@.TK2MSFTNGP14.phx.gbl...
>> Data Driven Subscriptions are only available for the Enterprise Sku. Do
>> you have enterprise?
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Sanjeev" <sanjeev@.microsoft.com> wrote in message
>> news:%23u7wLD09FHA.3928@.TK2MSFTNGP11.phx.gbl...
>> Hi All,
>> When I click on a report in report manager, and go to subscriptions
>> only a Normal Subscription Oprion appears.
>> The Data-Driven Subscription does not appear.
>> Is there an otion to make this visible somewhere.?
>> Thanks
>> Sanjeev
>>
>>
>

Data-Driven Subscription Link

Hi,
I'm setting up a data driven subscription for a report. I'm using email as
the delivery option, am NOT including the report in the email, instead using
the hyperlink feature to bring the user to the report on the server. I
tested it out and I received the email with the link but the link displays
the full address of the server, report path and parameters to the recipient.
We designed the system to use URL access and hidden parameters to hide all
paths and parameter options from the user, how can we have the link in the
email display something like: "Click here to view report" instead of:
http://myserver/ReportServer?/Reporting/FullReport&Client=xxx&date=xx/xx/xxxx.
It is very important to my company that we hide this string from the user.
thank you
JerryI'm not sure how you could accomplish this. Even if we put just the text
you suggest and make it a hyperlink, the url would still be visible to the
user. You could always modify the comments section to include html and put
the hyperlink in yourself, but this would not hide the parameter.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jerry" <idroppeddabomb@.hotmail.com> wrote in message
news:OJUzVIblEHA.2820@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I'm setting up a data driven subscription for a report. I'm using email as
> the delivery option, am NOT including the report in the email, instead
using
> the hyperlink feature to bring the user to the report on the server. I
> tested it out and I received the email with the link but the link displays
> the full address of the server, report path and parameters to the
recipient.
> We designed the system to use URL access and hidden parameters to hide all
> paths and parameter options from the user, how can we have the link in the
> email display something like: "Click here to view report" instead of:
>
http://myserver/ReportServer?/Reporting/FullReport&Client=xxx&date=xx/xx/xxxx.
> It is very important to my company that we hide this string from the user.
> thank you
> Jerry
>|||We worked around this by displaying the report within a pop-up window that we
instanciated via Javascript. That allowed us to turn off the address bar and
hide the URL. The user could still access it by right-clicking on the page
and going to properties, but at least it's not obvious.
sebring1130
"Daniel Reib [MSFT]" wrote:
> I'm not sure how you could accomplish this. Even if we put just the text
> you suggest and make it a hyperlink, the url would still be visible to the
> user. You could always modify the comments section to include html and put
> the hyperlink in yourself, but this would not hide the parameter.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Jerry" <idroppeddabomb@.hotmail.com> wrote in message
> news:OJUzVIblEHA.2820@.TK2MSFTNGP15.phx.gbl...
> > Hi,
> >
> > I'm setting up a data driven subscription for a report. I'm using email as
> > the delivery option, am NOT including the report in the email, instead
> using
> > the hyperlink feature to bring the user to the report on the server. I
> > tested it out and I received the email with the link but the link displays
> > the full address of the server, report path and parameters to the
> recipient.
> > We designed the system to use URL access and hidden parameters to hide all
> > paths and parameter options from the user, how can we have the link in the
> > email display something like: "Click here to view report" instead of:
> >
> http://myserver/ReportServer?/Reporting/FullReport&Client=xxx&date=xx/xx/xxxx.
> > It is very important to my company that we hide this string from the user.
> >
> > thank you
> >
> > Jerry
> >
> >
>
>|||In another situation, I didn't care that the URL was visible, I just had one
particular parameter that I couldn't allow the users to see (the username).
I solved this problem by "encrypting" that parameter. I created a simple SQL
function where I pass in the username, it manipulates the string a little and
then returns the SOUNDEX of the manipulated string. I used the function when
creating the data for the report and then again when selecting the parameters
for the data-driven subscription. I published the report, then went to
Report Manager and checked the "Prompt User" checkbox then set the "Prompt
String" to null. That allows me to send out the URL in the subscription
e-mails that are generated because the parameter value is meaningless to the
user (they see 'S165' instead of 'sebring', for example). They can click on
the URL link and the report comes up for them, but because the "Prompt
String" is set to null in the subscription, they cannot change that
parameter. It worked perfectly for what we needed.
sebring1130
"sebring1130" wrote:
> We worked around this by displaying the report within a pop-up window that we
> instanciated via Javascript. That allowed us to turn off the address bar and
> hide the URL. The user could still access it by right-clicking on the page
> and going to properties, but at least it's not obvious.
> sebring1130
>
> "Daniel Reib [MSFT]" wrote:
> > I'm not sure how you could accomplish this. Even if we put just the text
> > you suggest and make it a hyperlink, the url would still be visible to the
> > user. You could always modify the comments section to include html and put
> > the hyperlink in yourself, but this would not hide the parameter.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "Jerry" <idroppeddabomb@.hotmail.com> wrote in message
> > news:OJUzVIblEHA.2820@.TK2MSFTNGP15.phx.gbl...
> > > Hi,
> > >
> > > I'm setting up a data driven subscription for a report. I'm using email as
> > > the delivery option, am NOT including the report in the email, instead
> > using
> > > the hyperlink feature to bring the user to the report on the server. I
> > > tested it out and I received the email with the link but the link displays
> > > the full address of the server, report path and parameters to the
> > recipient.
> > > We designed the system to use URL access and hidden parameters to hide all
> > > paths and parameter options from the user, how can we have the link in the
> > > email display something like: "Click here to view report" instead of:
> > >
> > http://myserver/ReportServer?/Reporting/FullReport&Client=xxx&date=xx/xx/xxxx.
> > > It is very important to my company that we hide this string from the user.
> > >
> > > thank you
> > >
> > > Jerry
> > >
> > >
> >
> >
> >

Data-driven subscription error

I'm using Windows 2003 server with Sql server 2005 June CTP. When I create a data-driven subscription for a report everything works fine, the query that gets the subscribers from a database is validated successfully. The subscription is time triggered, but when it should start and deliver the reports I get a logon failure error. I use credentials stored securely in the report server. I tried it with sa account and it still doesn't work. When I try to edit the subscription I can see there is blank space where the password should be, is this just to prevent abuse or because it just doesn't store the password? Could someone please tell me what am I doing wrong, thanks.
I believe the problem was that the report server didn't want to store my execution account, still not sure why...

Data-Driven Subscription Error

I working through the 'Creating a Data-Driven Subscription' walkthrough
supplied as part of the BOL documentation, using Report Server File
Share as the delivery method. It cannot generate the report using the
three sets of dummy user details. The resulting status is: 'Done: 3
processed of 3 total: 3 errors'. How can I resolve this error?Sounds like possibly there was an error in writing out the files to the
file share (...since 3 of 3 procesed).
Open the ReportSever_ error log (C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\LogFiles), and do a Find on 'Success:
False' to locate errors in the log, using the timestamps to narrow
down the entries you look at. Errors could include illegal file names
or permissions on file share etc.
Matt A

Data-driven Subscription e-mail problem

Trying to test a data-driving subscription for 5 records for a specific
report. Run report interactively successfully in report services. Can't
figure out why e-mail is not being sent (set my e-mail address for all 5).
Status showing "Done: 5 processed of 5; 5 errors". Verified SMTPServer info
set correctly in rsReportServer Config file. Viewed the
ReportServer(date).log file and no information listed, checked windows
application log and report server is being activated successfully. Any
suggestions' Thanks. JanineAre you running RS on a Windows Server 2003? If so, I think that there is a
known issue that can be solved with a hotfix. We had a similar problem and it
wasn't the RS configuration that was causing the problem rather it was an
issue with Windows Server 2003. Sorry that I do not have any additional info.
"JanineB1129" wrote:
> Trying to test a data-driving subscription for 5 records for a specific
> report. Run report interactively successfully in report services. Can't
> figure out why e-mail is not being sent (set my e-mail address for all 5).
> Status showing "Done: 5 processed of 5; 5 errors". Verified SMTPServer info
> set correctly in rsReportServer Config file. Viewed the
> ReportServer(date).log file and no information listed, checked windows
> application log and report server is being activated successfully. Any
> suggestions' Thanks. Janine|||Do regular subscriptions work?
You need to look in the reportserverservice<date>.log file for the errors.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"B. Mark McKinney" <BMarkMcKinney@.discussions.microsoft.com> wrote in
message news:02470CE4-B6B0-48E5-B387-BF0691124515@.microsoft.com...
> Are you running RS on a Windows Server 2003? If so, I think that there is
a
> known issue that can be solved with a hotfix. We had a similar problem and
it
> wasn't the RS configuration that was causing the problem rather it was an
> issue with Windows Server 2003. Sorry that I do not have any additional
info.
> "JanineB1129" wrote:
> > Trying to test a data-driving subscription for 5 records for a specific
> > report. Run report interactively successfully in report services. Can't
> > figure out why e-mail is not being sent (set my e-mail address for all
5).
> > Status showing "Done: 5 processed of 5; 5 errors". Verified SMTPServer
info
> > set correctly in rsReportServer Config file. Viewed the
> > ReportServer(date).log file and no information listed, checked windows
> > application log and report server is being activated successfully. Any
> > suggestions' Thanks. Janine

Datadriven Subscription - Web Archive Improper formatting

Hi All,

I have a data driven subscription with Web Archive rendering format.

(SQL Reporting Service 2000). When a user gets this email, the format is not alligned properly, even, lines are missing in the report.

What could be the problem, is this a known issue? if yes, any patches available?

Please help me.

Thanks,

Nagesh

There are no replies to this query since one week...

Is this a silly query or tough one...

Data-driven subscription - Invalid parameter?

Hi,

I've set up a data-driven subscription on a report but it's not sending and the error log says it's because:

Default value or value provided for the report parameter 'CSRFaxID' is not a valid value.

For the particular dataset record causing the error I'm passing the value Null to the report parameter. The report parameter CSRFaxID is set up with "Allow Null" and with a default value of Null. I can run the report in my browser with CSRFaxID set to null, but the scheduled subscription is not able to produce the report with the same parameter value. Does anyone have any idea what the problem is and how I can fix it?

Regards,

Greg McNamara

Hi,

NULL values can cause plenty of headaches and unpredictable behavior in sub-systems.

Try not to use NULL. Set the default to 'UNK' or 0 instead and make sure that no null values are left over.

If needed disallow nulls or replace nulls by something like 'UNK'

Philippe

|||

Hi Philippe,

Thanks for your help. I actually tried something similar to this and it worked ok. The column is type uniqueidentifier so I just passed a guid with all zeroes. It seems a bit strange to have to use this workaround, there seems to be an inconsistency between data-driven subscription datasets and defined report parameters where NULL is concerned.

Regards,

Greg

Data-driven subscription - Invalid parameter?

Hi,

I've set up a data-driven subscription on a report but it's not sending and the error log says it's because:

Default value or value provided for the report parameter 'CSRFaxID' is not a valid value.

For the particular dataset record causing the error I'm passing the value Null to the report parameter. The report parameter CSRFaxID is set up with "Allow Null" and with a default value of Null. I can run the report in my browser with CSRFaxID set to null, but the scheduled subscription is not able to produce the report with the same parameter value. Does anyone have any idea what the problem is and how I can fix it?

Regards,

Greg McNamara

Hi,

NULL values can cause plenty of headaches and unpredictable behavior in sub-systems.

Try not to use NULL. Set the default to 'UNK' or 0 instead and make sure that no null values are left over.

If needed disallow nulls or replace nulls by something like 'UNK'

Philippe

|||

Hi Philippe,

Thanks for your help. I actually tried something similar to this and it worked ok. The column is type uniqueidentifier so I just passed a guid with all zeroes. It seems a bit strange to have to use this workaround, there seems to be an inconsistency between data-driven subscription datasets and defined report parameters where NULL is concerned.

Regards,

Greg

Data-Driven Subscription - Empty Field List on Step 4

I am attempting to create a data-driven subscription. I step through the
wizard, paste in the query, validate and click next. When I get to the screen
to map the fields from the database table to the fields in the subscription
(to, cc, reply-to, etc).
There are no fields in the drop-down. I have tried numerous different
queries, that I know work when I run them in a report, but don't seem to want
to populate the field list. The source database is Teradata, if that makes a
difference.
There is no error, and I can't seem to find any log entries, so I am not
sure where to turn. Any Ideas?
SteveUPDATED: I have confirmed that, in fact the data-driven subscription will
pull fields from SQL Server, so the issue seems to be with the Teradata
connection.
Any help?
"Steve Muise" wrote:
> I am attempting to create a data-driven subscription. I step through the
> wizard, paste in the query, validate and click next. When I get to the screen
> to map the fields from the database table to the fields in the subscription
> (to, cc, reply-to, etc).
> There are no fields in the drop-down. I have tried numerous different
> queries, that I know work when I run them in a report, but don't seem to want
> to populate the field list. The source database is Teradata, if that makes a
> difference.
> There is no error, and I can't seem to find any log entries, so I am not
> sure where to turn. Any Ideas?
> Steve