Custom Userform for entering paremeters

How would I intergrate a userform into a report?
I have no problem creating the form in VB.
I want to use the form instead of the default paremeter controls that RS
uses. The form will ask a series of paremeters many of which will be an
either/or and create the SQL statement for which I would then want to pass on
to Reporting Services to get the data for the report.
Just point me in the right direction.David wrote:
> How would I intergrate a userform into a report?
> I want to use the form instead of the default paremeter controls that
> RS uses. The form will ask a series of paremeters many of which will
> be an either/or and create the SQL statement for which I would then
> want to pass on to Reporting Services to get the data for the report.
> Just point me in the right direction.
Use the report viewer control on a asp.net webform
regards
Frank

Custom Primary Key

Not sure where to post this as it may be a form operation but here goes...

I want to generate a custom unique identifier for a table similar to the Northwind Customers database (ie ALFKI, ANTON, etc...) which can be used as a descriptive identifier as well.

For example, I have a Products table and I want to have my keys look like: CHR-0001-05.

"CHR" is my abbreviation for Chairs
"0001" is the auto-incrementing number (in this case the first record of the table)
"05" is the last 2 digits of the year recieved (2005)

Can somebody please point me in the right direction? I'm having problems finding resources on the web relating to this topic (prolly not using the correct keywords for my searches)

Cheers =)

You can use '+' operator to concatinate strings, here is a sample script:

if object_id('tbl_GPK','U') is not null
drop table tbl_GPK
go
Create table tbl_GPK (EName varchar(50),EDate smalldatetime)
go
insert into tbl_GPK select 'Peacock Margaret',GetDate()

if object_id('UDF_Gen_PK','FN') is not null
drop function UDF_Gen_PK
go
create function UDF_Gen_PK (@.S varchar(50))
returns varchar(60)
as
begin
declare @.outstring varchar(60)
declare @.i int
select @.i=1,@.outstring=''
while (@.i<=len(@.S))
begin
select @.outstring=@.outstring+substring(@.S,@.i,1)
set @.i=@.i+5
end
select @.outstring=@.outstring+'-'+convert(varchar(10),count(*)+1)
from tbl_GPK
return @.outstring
end

go
alter table tbl_GPK
add PK as (dbo.UDF_Gen_PK(EName)+'-'+convert(varchar(4),Year(EDate)))
go

select * from tbl_GPK

Custom Forms Authentication - fails every two or three hours after working fine.

I'm enclosing the pertinent log entries form the
ReportServer_DD_DD_DDDD_HH_MM_SS.log file.
Problem: I've written a custom forms auth extension that (naturally)
works fine in the test environment. In production, under about 25 - 20
users (80 - 150 report requests) per hour, everything works fine until
after about two or three hours, for some reason, the following errors
(below) appear in the log, and in the event log an error is thrown that
simply states:
"Report Server cannot load the forms extension."
Then, no can access the report manager becuase you get an error that
says a configuration file for report server was changed and it can't
acces report server (sorry, i don't have the exact message text). NO
CHANGE HAS BEEN MADE TO ANY CONFIG FILE!
All I then do is restart the reporting service and restart IIS, and
everything is just fine again for a few hours.
My client has to have this Single Sign on solution, and it works really
nice. But to have it go down every few hours on the production server
doesn't instill confidence.
The following two line from the report server logfile reference
something about trying to add a 'delete schedules' key. We don't allow
any subscriptions, nor do we have any custom schedules defined. We do
have Sql Agent running for data feeds and execution log stats on our db
server. I don't know where its getting 'delete schedules' from.
Any help would help...
btw we're running WIN2003 SP1, ENT RS SP1 on web server, WIN2003 SP1 on
database server.
here's the log file entries:
w3wp!extensionfactory!c70!05/10/2005-15:12:03:: e ERROR: Exception
caught instantiating report server extension:
System.Reflection.TargetInvocationException: Exception has been thrown
by the target of an invocation. --> System.ArgumentException: Item has
already been added. Key in dictionary: "DeleteSchedules" Key being
added: "DeleteSchedules"
at System.Collections.Hashtable.Insert(Object key, Object nvalue,
Boolean add)
at System.Collections.Hashtable.Add(Object key, Object value)
at
Thrivent.FPM.ReportingServices.CustomSecurityExtension.Authorization.InitializeMaps()
at
Thrivent.FPM.ReportingServices.CustomSecurityExtension.Authorization..ctor()
-- End of inner exception stack trace --
at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly)
at System.Activator.CreateInstance(Type type, Boolean nonPublic)
at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr,
Binder binder, Object[] args, CultureInfo culture, Object[]
activationAttributes)
at System.Activator.CreateInstance(Type type, BindingFlags
bindingAttr, Binder binder, Object[] args, CultureInfo culture,
Object[] activationAttributes)
at System.Reflection.Assembly.CreateInstance(String typeName,
Boolean ignoreCase, BindingFlags bindingAttr, Binder binder, Object[]
args, CultureInfo culture, Object[] activationAttributes)
at System.Reflection.Assembly.CreateInstance(String typeName)
at
Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.AssertAndCreate(Assembly
assembly, String typeName)
at
Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.AssertAndCreate(Assembly
assembly, String typeName)
at
Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.GetNewExtensionInstance(String
extensionName, String extensionType).
w3wp!extensionfactory!34c!05/10/2005-15:12:03:: e ERROR: Exception
caught instantiating report server extension:
System.Reflection.TargetInvocationException: Exception has been thrown
by the target of an invocation. --> System.Exception: Number of
catalog names don't match.
at
Thrivent.FPM.ReportingServices.CustomSecurityExtension.Authorization.InitializeMaps()
at
Thrivent.FPM.ReportingServices.CustomSecurityExtension.Authorization..ctor()
-- End of inner exception stack trace --
at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly)
at System.Activator.CreateInstance(Type type, Boolean nonPublic)
at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr,
Binder binder, Object[] args, CultureInfo culture, Object[]
activationAttributes)
at System.Activator.CreateInstance(Type type, BindingFlags
bindingAttr, Binder binder, Object[] args, CultureInfo culture,
Object[] activationAttributes)
at System.Reflection.Assembly.CreateInstance(String typeName,
Boolean ignoreCase, BindingFlags bindingAttr, Binder binder, Object[]
args, CultureInfo culture, Object[] activationAttributes)
at System.Reflection.Assembly.CreateInstance(String typeName)
at
Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.AssertAndCreate(Assembly
assembly, String typeName)
at
Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.AssertAndCreate(Assembly
assembly, String typeName)
at
Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.GetNewExtensionInstance(String
extensionName, String extensionType).
w3wp!library!34c!05/10/2005-15:12:03:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details
in the log files, Could not load Authorization extension;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details
in the log files
w3wp!library!c70!05/10/2005-15:12:03:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details
in the log files, Could not load Authorization extension;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details
in the log files
w3wp!processing!34c!05/10/2005-15:12:03:: e ERROR: An error has
occurred while retrieving datasources for a sub-report. Details: The
Report Server has encountered a configuration error; more details in
the log files
w3wp!processing!c70!05/10/2005-15:12:03:: e ERROR: An error has
occurred while retrieving datasources for a sub-report. Details: The
Report Server has encountered a configuration error; more details in
the log files
w3wp!processing!34c!05/10/2005-15:12:03:: e ERROR: Stack trace: at
Microsoft.ReportingServices.Library.Security.get_AuthorizationExtension()
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
catItemType, Byte[] secDesc, ReportOperation rptOper)
at
Microsoft.ReportingServices.Library.RSService.ProcessingGetDataSources(CatalogItemContext
reportContext, String subreportPath, CatalogItemContext&
subreportContext, GetReportChunk& getCompiledDefinition,
DataSourceInfoCollection& dataSources)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report
A_0, DataSourceInfoCollection A_1, CatalogItemContext A_2,
SubReportDataSourcesCallback A_3, RuntimeDataSourceInfoCollection A_4,
Int32 A_5, Boolean A_6, ServerDataSourceSettings A_7)
w3wp!processing!c70!05/10/2005-15:12:03:: e ERROR: Stack trace: at
Microsoft.ReportingServices.Library.Security.get_AuthorizationExtension()
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
catItemType, Byte[] secDesc, ReportOperation rptOper)
at
Microsoft.ReportingServices.Library.RSService.ProcessingGetDataSources(CatalogItemContext
reportContext, String subreportPath, CatalogItemContext&
subreportContext, GetReportChunk& getCompiledDefinition,
DataSourceInfoCollection& dataSources)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report
A_0, DataSourceInfoCollection A_1, CatalogItemContext A_2,
SubReportDataSourcesCallback A_3, RuntimeDataSourceInfoCollection A_4,
Int32 A_5, Boolean A_6, ServerDataSourceSettings A_7)
w3wp!library!c70!05/10/2005-15:12:03:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details
in the log files, Could not load Authorization extension;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details
in the log files
w3wp!processing!c70!05/10/2005-15:12:03:: e ERROR: An error has
occurred while retrieving datasources for a sub-report. Details: The
Report Server has encountered a configuration error; more details in
the log files
w3wp!processing!c70!05/10/2005-15:12:03:: e ERROR: Stack trace: at
Microsoft.ReportingServices.Library.Security.get_AuthorizationExtension()
from here on everything comes up with the same error.Hi,
I am implementing a Single Sign on for my Web application and RS to fetch
the reports using URL. But when I try to access the report, RS shows the
logon screen, which I don't wan as user is already logged on to the web
application. Logon screen is shown only for first request.
Please let me know if I need to do some settings or add some infor in
Request/Response.
Thanks,
Mahesh
"jahles" wrote:
> I'm enclosing the pertinent log entries form the
> ReportServer_DD_DD_DDDD_HH_MM_SS.log file.
> Problem: I've written a custom forms auth extension that (naturally)
> works fine in the test environment. In production, under about 25 - 20
> users (80 - 150 report requests) per hour, everything works fine until
> after about two or three hours, for some reason, the following errors
> (below) appear in the log, and in the event log an error is thrown that
> simply states:
> "Report Server cannot load the forms extension."
> Then, no can access the report manager becuase you get an error that
> says a configuration file for report server was changed and it can't
> acces report server (sorry, i don't have the exact message text). NO
> CHANGE HAS BEEN MADE TO ANY CONFIG FILE!
> All I then do is restart the reporting service and restart IIS, and
> everything is just fine again for a few hours.
> My client has to have this Single Sign on solution, and it works really
> nice. But to have it go down every few hours on the production server
> doesn't instill confidence.
> The following two line from the report server logfile reference
> something about trying to add a 'delete schedules' key. We don't allow
> any subscriptions, nor do we have any custom schedules defined. We do
> have Sql Agent running for data feeds and execution log stats on our db
> server. I don't know where its getting 'delete schedules' from.
> Any help would help...
> btw we're running WIN2003 SP1, ENT RS SP1 on web server, WIN2003 SP1 on
> database server.
> here's the log file entries:
> w3wp!extensionfactory!c70!05/10/2005-15:12:03:: e ERROR: Exception
> caught instantiating report server extension:
> System.Reflection.TargetInvocationException: Exception has been thrown
> by the target of an invocation. --> System.ArgumentException: Item has
> already been added. Key in dictionary: "DeleteSchedules" Key being
> added: "DeleteSchedules"
> at System.Collections.Hashtable.Insert(Object key, Object nvalue,
> Boolean add)
> at System.Collections.Hashtable.Add(Object key, Object value)
> at
> Thrivent.FPM.ReportingServices.CustomSecurityExtension.Authorization.InitializeMaps()
> at
> Thrivent.FPM.ReportingServices.CustomSecurityExtension.Authorization..ctor()
> -- End of inner exception stack trace --
> at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly)
> at System.Activator.CreateInstance(Type type, Boolean nonPublic)
> at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr,
> Binder binder, Object[] args, CultureInfo culture, Object[]
> activationAttributes)
> at System.Activator.CreateInstance(Type type, BindingFlags
> bindingAttr, Binder binder, Object[] args, CultureInfo culture,
> Object[] activationAttributes)
> at System.Reflection.Assembly.CreateInstance(String typeName,
> Boolean ignoreCase, BindingFlags bindingAttr, Binder binder, Object[]
> args, CultureInfo culture, Object[] activationAttributes)
> at System.Reflection.Assembly.CreateInstance(String typeName)
> at
> Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.AssertAndCreate(Assembly
> assembly, String typeName)
> at
> Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.AssertAndCreate(Assembly
> assembly, String typeName)
> at
> Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.GetNewExtensionInstance(String
> extensionName, String extensionType).
> w3wp!extensionfactory!34c!05/10/2005-15:12:03:: e ERROR: Exception
> caught instantiating report server extension:
> System.Reflection.TargetInvocationException: Exception has been thrown
> by the target of an invocation. --> System.Exception: Number of
> catalog names don't match.
> at
> Thrivent.FPM.ReportingServices.CustomSecurityExtension.Authorization.InitializeMaps()
> at
> Thrivent.FPM.ReportingServices.CustomSecurityExtension.Authorization..ctor()
> -- End of inner exception stack trace --
> at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly)
> at System.Activator.CreateInstance(Type type, Boolean nonPublic)
> at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr,
> Binder binder, Object[] args, CultureInfo culture, Object[]
> activationAttributes)
> at System.Activator.CreateInstance(Type type, BindingFlags
> bindingAttr, Binder binder, Object[] args, CultureInfo culture,
> Object[] activationAttributes)
> at System.Reflection.Assembly.CreateInstance(String typeName,
> Boolean ignoreCase, BindingFlags bindingAttr, Binder binder, Object[]
> args, CultureInfo culture, Object[] activationAttributes)
> at System.Reflection.Assembly.CreateInstance(String typeName)
> at
> Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.AssertAndCreate(Assembly
> assembly, String typeName)
> at
> Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.AssertAndCreate(Assembly
> assembly, String typeName)
> at
> Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.GetNewExtensionInstance(String
> extensionName, String extensionType).
> w3wp!library!34c!05/10/2005-15:12:03:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> The Report Server has encountered a configuration error; more details
> in the log files, Could not load Authorization extension;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> The Report Server has encountered a configuration error; more details
> in the log files
> w3wp!library!c70!05/10/2005-15:12:03:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> The Report Server has encountered a configuration error; more details
> in the log files, Could not load Authorization extension;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> The Report Server has encountered a configuration error; more details
> in the log files
> w3wp!processing!34c!05/10/2005-15:12:03:: e ERROR: An error has
> occurred while retrieving datasources for a sub-report. Details: The
> Report Server has encountered a configuration error; more details in
> the log files
> w3wp!processing!c70!05/10/2005-15:12:03:: e ERROR: An error has
> occurred while retrieving datasources for a sub-report. Details: The
> Report Server has encountered a configuration error; more details in
> the log files
> w3wp!processing!34c!05/10/2005-15:12:03:: e ERROR: Stack trace: at
> Microsoft.ReportingServices.Library.Security.get_AuthorizationExtension()
> at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
> catItemType, Byte[] secDesc, ReportOperation rptOper)
> at
> Microsoft.ReportingServices.Library.RSService.ProcessingGetDataSources(CatalogItemContext
> reportContext, String subreportPath, CatalogItemContext&
> subreportContext, GetReportChunk& getCompiledDefinition,
> DataSourceInfoCollection& dataSources)
> at
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report
> A_0, DataSourceInfoCollection A_1, CatalogItemContext A_2,
> SubReportDataSourcesCallback A_3, RuntimeDataSourceInfoCollection A_4,
> Int32 A_5, Boolean A_6, ServerDataSourceSettings A_7)
> w3wp!processing!c70!05/10/2005-15:12:03:: e ERROR: Stack trace: at
> Microsoft.ReportingServices.Library.Security.get_AuthorizationExtension()
> at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
> catItemType, Byte[] secDesc, ReportOperation rptOper)
> at
> Microsoft.ReportingServices.Library.RSService.ProcessingGetDataSources(CatalogItemContext
> reportContext, String subreportPath, CatalogItemContext&
> subreportContext, GetReportChunk& getCompiledDefinition,
> DataSourceInfoCollection& dataSources)
> at
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report
> A_0, DataSourceInfoCollection A_1, CatalogItemContext A_2,
> SubReportDataSourcesCallback A_3, RuntimeDataSourceInfoCollection A_4,
> Int32 A_5, Boolean A_6, ServerDataSourceSettings A_7)
> w3wp!library!c70!05/10/2005-15:12:03:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> The Report Server has encountered a configuration error; more details
> in the log files, Could not load Authorization extension;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> The Report Server has encountered a configuration error; more details
> in the log files
> w3wp!processing!c70!05/10/2005-15:12:03:: e ERROR: An error has
> occurred while retrieving datasources for a sub-report. Details: The
> Report Server has encountered a configuration error; more details in
> the log files
> w3wp!processing!c70!05/10/2005-15:12:03:: e ERROR: Stack trace: at
> Microsoft.ReportingServices.Library.Security.get_AuthorizationExtension()
>
> from here on everything comes up with the same error.
>

custom forms

I have created custom form without borders , i have written functions to minimize, maximize, exit and even for moving the window, now i need to write function to resize the window , is there any way resize the window...locking this post as this isn't replication or sql server related, and I can't move it since I don't even know what programming language you're using. Please repost your question in the correct forum.

Custom Delivery Extension

Hi,
I have successfully created a custom data renderer(report to form) and a
data extension.
I need to create a custom delivery extension that will check if the reports
is returning data before delivering it.
Any pointers.....
Thanks
MandarUnfortunately the delivery extension API doesn't expose any mechanism for
knowing if the report contained data or not. The only work around is to use
data driven subscriptions such that the query for the subscription returns
no rows if the report will have no data.
If the delivery extension does not have to be generic, it could be written
to have knowledge of the reports and do some checking on its own.
This feature has been requested a lot and is on the list for consideration
for a future release.
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"IB Ghost" <ibghost@.hotmail.com> wrote in message
news:uD2hhfwSFHA.3312@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I have successfully created a custom data renderer(report to form) and a
> data extension.
> I need to create a custom delivery extension that will check if the
> reports
> is returning data before delivering it.
> Any pointers.....
> Thanks
> Mandar
>
>
>|||Hi Daniel,
Thanks for your response.
I have installed the PrinterDeliveryExtension sample.
The Webserver/ReportServer & SQL Server are installed on the same machine.
I am using RS SP2 and am able to use the print functionality in the
ReportViewer.
I tried adding the printer name in the RSWebApplication.config file &
RSReportServer.config under the Delivery tag.
The printer is a network printer installed in another machine & I had given
the path as "\\anothermachinename\printername".
This was giving me an error while setting up the subscription itself, saying
printer not found.
I have modified the code in the PrinterDeliveryProvider.vb file,
function-SetConfiguration().
Here instead of reading the printer names from the config files, I am using
the PrintDocument object to pick up all the printers on the network
programmatically.
I can see the list of all the printers on the network on the subscription
page in the "Select Printer" dropdown, and can now create the subscription.
But when the subscription runs the status says "The printer
\\anothermachinename\printername is not currently
installed on the server."
Any ideas on this.
Regards
Mandar Pai
mandarp@.infobahnlimited.com; mandarpai@.hotmail.com
"Daniel Reib (MSFT)" <danreib@.online.microsoft.com> wrote in message
news:ud5tZ55SFHA.2172@.tk2msftngp13.phx.gbl...
> Unfortunately the delivery extension API doesn't expose any mechanism for
> knowing if the report contained data or not. The only work around is to
use
> data driven subscriptions such that the query for the subscription returns
> no rows if the report will have no data.
> If the delivery extension does not have to be generic, it could be written
> to have knowledge of the reports and do some checking on its own.
> This feature has been requested a lot and is on the list for consideration
> for a future release.
>
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "IB Ghost" <ibghost@.hotmail.com> wrote in message
> news:uD2hhfwSFHA.3312@.TK2MSFTNGP12.phx.gbl...
> > Hi,
> >
> > I have successfully created a custom data renderer(report to form) and a
> > data extension.
> >
> > I need to create a custom delivery extension that will check if the
> > reports
> > is returning data before delivering it.
> >
> > Any pointers.....
> >
> > Thanks
> >
> > Mandar
> >
> >
> >
> >
> >
> >
>|||This is just a guess, but when the subscription runs it runs as the service
user. Perhaps this user does not have permission to see the network
printer. Try giving them permission.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"IB Ghost" <ibghost@.hotmail.com> wrote in message
news:%23QU7%23F8SFHA.2560@.TK2MSFTNGP10.phx.gbl...
> Hi Daniel,
> Thanks for your response.
> I have installed the PrinterDeliveryExtension sample.
> The Webserver/ReportServer & SQL Server are installed on the same machine.
> I am using RS SP2 and am able to use the print functionality in the
> ReportViewer.
> I tried adding the printer name in the RSWebApplication.config file &
> RSReportServer.config under the Delivery tag.
> The printer is a network printer installed in another machine & I had
> given
> the path as "\\anothermachinename\printername".
> This was giving me an error while setting up the subscription itself,
> saying
> printer not found.
> I have modified the code in the PrinterDeliveryProvider.vb file,
> function-SetConfiguration().
> Here instead of reading the printer names from the config files, I am
> using
> the PrintDocument object to pick up all the printers on the network
> programmatically.
> I can see the list of all the printers on the network on the subscription
> page in the "Select Printer" dropdown, and can now create the
> subscription.
> But when the subscription runs the status says "The printer
> \\anothermachinename\printername is not currently
> installed on the server."
>
> Any ideas on this.
> Regards
> Mandar Pai
> mandarp@.infobahnlimited.com; mandarpai@.hotmail.com
> "Daniel Reib (MSFT)" <danreib@.online.microsoft.com> wrote in message
> news:ud5tZ55SFHA.2172@.tk2msftngp13.phx.gbl...
>> Unfortunately the delivery extension API doesn't expose any mechanism for
>> knowing if the report contained data or not. The only work around is to
> use
>> data driven subscriptions such that the query for the subscription
>> returns
>> no rows if the report will have no data.
>> If the delivery extension does not have to be generic, it could be
>> written
>> to have knowledge of the reports and do some checking on its own.
>> This feature has been requested a lot and is on the list for
>> consideration
>> for a future release.
>>
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>>
>> "IB Ghost" <ibghost@.hotmail.com> wrote in message
>> news:uD2hhfwSFHA.3312@.TK2MSFTNGP12.phx.gbl...
>> > Hi,
>> >
>> > I have successfully created a custom data renderer(report to form) and
>> > a
>> > data extension.
>> >
>> > I need to create a custom delivery extension that will check if the
>> > reports
>> > is returning data before delivering it.
>> >
>> > Any pointers.....
>> >
>> > Thanks
>> >
>> > Mandar
>> >
>> >
>> >
>> >
>> >
>> >
>>
>