Report Distribution

Through report manager I am trying to see if it is possible
to set up a data-driven subscription, that will save the
file on a file share AND notifiy user via email based on values
stored in sql table.

I can get each to work as independent jobs but I want this to
be run as one.

Can this be done? How?

Thanks.

Not out of the box. Each subscription has only one delivery extension it uses. It is not possible to chain delivery extensions.

You can write a custom delivery extension that would do both of these operations. There's a printer delivery sample in the Samples that come with SQL Server 2000 Reporting Services and SQL Server 2005.

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi,
Me too wants to have some simillar to your requirement. Have you created some custom delivery extension for this purpose.

Regards;
Rakesh

Report Distribution

Through report manager I am trying to see if it is possible
to set up a data-driven subscription, that will save the
file on a file share AND notifiy user via email based on values
stored in sql table.

I can get each to work as independent jobs but I want this to
be run as one.

Can this be done? How?

Thanks.

Not out of the box. Each subscription has only one delivery extension it uses. It is not possible to chain delivery extensions.

You can write a custom delivery extension that would do both of these operations. There's a printer delivery sample in the Samples that come with SQL Server 2000 Reporting Services and SQL Server 2005.

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi,
Me too wants to have some simillar to your requirement. Have you created some custom delivery extension for this purpose.

Regards;
Rakesh

sql

Report Designer RDL Generator APIs

I'm just wondering - is there a way to use MS Report Designer's API's to
generate the actual RDL file with all groupings, sortings, etc., as it is
done using the Report Wizard. I know, there is an example to generate a
simple RDL file, using XmlTextWriter approach to generate a file manualy
from scratch, but when it comes to multiple groupings , it seems too complex
to achive that goal. The idea is to simulate web based report designer,
allow the end user to choose columns, group and sort fields and to generate
a report on fly.
Any ideas?
Thanks.No, nothing about this is documented. However, in RS 2005 there will be two
product, the current Report Designer and Report Builder. Report Builder is
an end user tool. Here are some links (note that RS 2005 comes out in
November).
>>>>>>>>>>
Links originally provided by Robert Bruckner (MS)
RS 2005 feature / editions:
http://www.microsoft.com/sql/2005/productinfo/rsfeatures.mspx
Some of the new RS 2005 features are shown in this whitepaper:
http://www.microsoft.com/technet/prodtechnol/sql/2005/2005ssrs.mspx
Product launch will happen in November 2005:
http://www.microsoft.com/presspass/misc/06-07flessner-teched05.mspx
Always a good place to find information about RS 2005 - the blog of our
group program manager:
http://blogs.msdn.com/bwelcker/default.aspx
>>>>>>>>>>
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message
news:eeqKkblqFHA.3544@.TK2MSFTNGP15.phx.gbl...
> I'm just wondering - is there a way to use MS Report Designer's API's to
> generate the actual RDL file with all groupings, sortings, etc., as it is
> done using the Report Wizard. I know, there is an example to generate a
> simple RDL file, using XmlTextWriter approach to generate a file manualy
> from scratch, but when it comes to multiple groupings , it seems too
> complex to achive that goal. The idea is to simulate web based report
> designer, allow the end user to choose columns, group and sort fields and
> to generate a report on fly.
> Any ideas?
> Thanks.
>

Report Design Previewer and Data Processing Extension DLL's

Hi all,
Do I need to define the Data Processing Extension (DPE) DLL's in the
Designer policy file: rspreviewpolicy.config ?
It's been my experience that the Report Preview mode runs in some "special"
mode that seems to bypass CAS (Code Access Security) - this makes me wonder
then if I need to define my DPE DLL's in Code Groups in this
rspreviewpolicy.config file at all.
Anyone with comments on this topic ?
- SimonSimon,
There are two preview modes - Report Preview (the Preview tab on the Report
Designer) which doesn't use CAS and the Report Host mode (F5) which uses the
settings in the rspreviewpolicy.config. The purpose of the later is to
similate the Report Server environment.
--
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/
---
"Simon" <Simon@.discussions.microsoft.com> wrote in message
news:345062E5-7002-45AD-A37D-B2126CE48354@.microsoft.com...
> Hi all,
> Do I need to define the Data Processing Extension (DPE) DLL's in the
> Designer policy file: rspreviewpolicy.config ?
> It's been my experience that the Report Preview mode runs in some
"special"
> mode that seems to bypass CAS (Code Access Security) - this makes me
wonder
> then if I need to define my DPE DLL's in Code Groups in this
> rspreviewpolicy.config file at all.
> Anyone with comments on this topic ?
> - Simon
>|||Teo,
Thanks for the quick response - I was just about to post my findings when I
saw you had already answered !
I found details on this subject at:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_rdl_8mue.asp
<-- Snip -->
... There are two preview modes for Report Designer: the preview tab and
the pop-up preview window that is launched when your report project is
started in DebugLocal mode. The preview tab executes all report expressions
using the FullTrust permission set and does not apply security policy
settings. ...
<-- Snip -->
thanks again,
- Simonsql

Report Delivery Option Missing

I have a SQL 2005 Reporting Server, and notice the only report delivery option
I see is 'export to a file share'. How to I enable the email option? Did
I perhaps miss something during installation?
Regards,
Pete Zerger, MCSE(Messaging), MVP - MOM
Co-founder and Webmaster, MOMResources.org
URL:http://www.momresources.org
BLOG: http://www.it-jedi.net/
mailto:pete.zerger@.gmail.com
...or find me in the forums at http://momcommunity.coAre your e-mail setting configured for ReportServer? You can check by going
to Report Services Configuration from Configuration Tools Under SqlServer2005.
"Pete Zerger" wrote:
> I have a SQL 2005 Reporting Server, and notice the only report delivery option
> I see is 'export to a file share'. How to I enable the email option? Did
> I perhaps miss something during installation?
> Regards,
> Pete Zerger, MCSE(Messaging), MVP - MOM
> Co-founder and Webmaster, MOMResources.org
> URL:http://www.momresources.org
> BLOG: http://www.it-jedi.net/
> mailto:pete.zerger@.gmail.com
> ...or find me in the forums at http://momcommunity.com
>
>

Report Definition Language

Using VS 2005, I have created a piece of software that creates an RDL file using XML. However, although my data (though a DataView control) is showing as it should, and I can update this to create new data, I cannot get the RDL to display a variable which I change and use as a 'header text' to the report. The variable is shown the first time I display the RDL through a ReportViewer Control but remains static thereafter. The interesting thing is that when I view the XML through a third-party viewer, it shows the correct value stored in the variable.

For information, I am using a child form in a MDI to create the data that is fed into another child form that contains the ReportViewer. The MDI has been programmed so that the child forms are not closed and disposed of, but are hidden from view.

Has anyone any initial ideas of what I could do to flush or clear the RDL or any other relevant object?

Are you viewing the RDL in the report designer when this happens? Report Designer has a functionality to cache the data in preview (http://msdn2.microsoft.com/en-us/library/ms157366.aspx). You should be able to click on the refresh button to get new data.

Report Builder in June CTP

Does the Report Builder included in the June CTP work?
How can I create a report in Report Builder?
The cmmand File.. New report... said that I don't have a data source...

Also the documentation for Report Builder is pre-alpha, and it is supposed to be beta 3.
Thank you

You can't make a report with report builder because you don't have a model installed in reporting services.
With BI Development Studio you could make a model then deploy it and that's all (New Report Model Project). By the way the documentation for these things exists, you must read and try. The only way I now to learn.
Good Luck.
VectorR3|||In addition to using BI Dev. Studio, you can auto-generate models directly from report manager. The data source page in June CTP has a new button called "Generate model".

--Robert|||Here is a good webcast that will show you everything you need.
http://msdn.microsoft.com/msdntv/episode.aspx?xml=episodes/en/20050531SQLServerCC/manifest.xml

-w

Report Builder 401

When attempting to run Report Builder I get error below. After reading
earlier posts I have tried several combinations on the File Security
properties of the 6 Report Builder files and seem to get the furthest (I get
the Application Run - Security Warning dialog) while enabling Anonymous
access using the Report Server service account and also using Authenticated
access (Integrated Windows Authentication). I also tried changing the
RSWebApplication.Config from FullTrust to Partial Trust but that did not work.
Thanks in advance for any help
Please note that unlike earlier posts I have a Win32Exception at the end of
the error detail.
PLATFORM VERSION INFO
Windows : 5.1.2600.131072 (Win32NT)
Common Language Runtime : 2.0.50727.42
System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200)
mscorwks.dll : 2.0.50727.42 (RTM.050727-4200)
dfdll.dll : 2.0.50727.42 (RTM.050727-4200)
dfshim.dll : 2.0.50727.42 (RTM.050727-4200)
SOURCES
Deployment url :
http://reporting.voyagerlearning.com/ReportServer/ReportBuilder/ReportBuilder.application
Server : Microsoft-IIS/6.0
X-Powered-By : ASP.NET
X-AspNet-Version: 2.0.50727
Application url :
http://reporting.voyagerlearning.com/ReportServer/ReportBuilder/ReportBuilder.exe.manifest
Server : Microsoft-IIS/6.0
X-Powered-By : ASP.NET
X-AspNet-Version: 2.0.50727
IDENTITIES
Deployment Identity : ReportBuilder.application, Version=9.0.2047.0,
Culture=neutral, PublicKeyToken=c3bce3770c238a49, processorArchitecture=msil
Application Identity : ReportBuilder.exe, Version=9.0.2047.0,
Culture=neutral, PublicKeyToken=c3bce3770c238a49, processorArchitecture=msil,
type=win32
APPLICATION SUMMARY
* Online only application.
* Trust url parameter is set.
ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later
in the log.
* Activation of
http://reporting.voyagerlearning.com/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading
http://reporting.voyagerlearning.com/ReportServer/ReportBuilder/reportbuilder.chm.deploy did not succeed.
+ The remote server returned an error: (401) Unauthorized.
+ The logon attempt failed
COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.
WARNINGS
There were no warnings during this operation.
OPERATION PROGRESS STATUS
* [8/9/2006 11:26:32 PM] : Activation of
http://reporting.voyagerlearning.com/ReportServer/ReportBuilder/ReportBuilder.application has started.
* [8/9/2006 11:26:32 PM] : Processing of deployment manifest has
successfully completed.
* [8/9/2006 11:26:32 PM] : Installation of the application has started.
* [8/9/2006 11:26:32 PM] : Processing of application manifest has
successfully completed.
* [8/9/2006 11:26:35 PM] : Request of trust and detection of platform is
complete.
ERROR DETAILS
Following errors were detected during this operation.
* [8/9/2006 11:26:35 PM]
System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading
http://reporting.voyagerlearning.com/ReportServer/ReportBuilder/reportbuilder.chm.deploy did not succeed.
- Source: System.Deployment
- Stack trace:
at
System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
at
System.Deployment.Application.FileDownloader.Download(SubscriptionState
subState)
at
System.Deployment.Application.DownloadManager.DownloadDependencies(SubscriptionState
subState, AssemblyManifest deployManifest, AssemblyManifest appManifest, Uri
sourceUriBase, String targetDirectory, String group, IDownloadNotification
notification, DownloadOptions options)
at
System.Deployment.Application.ApplicationActivator.DownloadApplication(SubscriptionState
subState, ActivationDescription actDesc, Int64 transactionId, TempDirectory&
downloadTemp)
at
System.Deployment.Application.ApplicationActivator.InstallApplication(SubscriptionState subState, ActivationDescription actDesc)
at
System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut)
at
System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
-- Inner Exception --
System.Net.WebException
- The remote server returned an error: (401) Unauthorized.
- Source: System
- Stack trace:
at System.Net.HttpWebRequest.GetResponse()
at
System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
-- Inner Exception --
System.ComponentModel.Win32Exception
- The logon attempt failed
- Source: System
- Stack trace:
at System.Net.NTAuthentication.GetOutgoingBlob(Byte[] incomingBlob,
Boolean throwOnError, SecurityStatus& statusCode)
at System.Net.NTAuthentication.GetOutgoingBlob(String incomingBlob)
at System.Net.NegotiateClient.DoAuthenticate(String challenge, WebRequest
webRequest, ICredentials credentials, Boolean preAuthenticate)
at System.Net.NegotiateClient.Authenticate(String challenge, WebRequest
webRequest, ICredentials credentials)
at System.Net.AuthenticationManager.Authenticate(String challenge,
WebRequest request, ICredentials credentials)
at System.Net.AuthenticationState.AttemptAuthenticate(HttpWebRequest
httpWebRequest, ICredentials authInfo)
at System.Net.HttpWebRequest.CheckResubmitForAuth()
at System.Net.HttpWebRequest.CheckResubmit(Exception& e)
COMPONENT STORE TRANSACTION DETAILS
No transaction information is available.Never mind. Just use How to Enable Anonymous Access on the ReportBuilder
Folder in Configure a Report Server for Report Builder Access

Reply to Importing Error

Hi all,

I am facing problem on importing csv data file into table,

For Ex:

csv file which has 2 columns & 4 records are as follows

EmpNo EmpName

1 a
2 b
3 c
1 a

I created new table called T4, structure of T4 is

EmpNo Varchar(50) with Primary Key
EmpName Varchar(50) disabled Allow Nulls

Now I started importing csv data to T4 table, during importing it couldn't finish entire process. Throwing error, when I remove primary key with disable Allow Nulls for both constraints of a table T4. Importing data successfull.
My question is if I have above said structure for the table T4 (with primary Key), during importing instead of throwing error let it be import first 3 rows then throw error as primary key enabled could not able to import. Is this can be possibe, if so please suggest me to solve the problem.Can I use Bulk Insert or SQL Scripts to solve this problem.

Thanks in advance
Karna

I believe that I understand your current situation, but I do not think I understand what it is you are trying to do.

If you're trying to insert the three "good rows" and "fail" the one "bad" row without failing the package as a whole, you may be able to accomplish this by adding an error output to the destination to which you're writing these records. Then the "bad" records will be redirected to that portion of the data flow, where you can count them, log them, or ignore them if you want.

Is this what you're trying to accomplish? If so, please let us know if this technique gives you the solution you need. If not, please see if you can rephrase your goal, and I can try again.

|||Hi Mathew,

Thanks for your reply. I am executing wizard in SQL Server 2005. Actual problem is "I am preparing a job which can import CSV data file to the table. Table already has primary key & disabled allow null option. Here in CSV file it has duplicate records & empty rows. During importing of job is not successfully done, it is throwing error." My question is if the duplicate data lies in 1000th record, let job be success for until 999 record. Then let it can show error for 1000 record & logged .
Please suggest me to how to succeed the job.

Thanks in advance
Karna|||

I'm honestly not certain how I would go about doing that. For most situations where I'm using SSIS, the behavior you're trying to achieve would be inappropriate for my needs (I would either need the entire load to fail with no rows written to the destination, or else have error rows redirected to a log file or table) so I've never tried to set things up this way. I'm also pretty unfamiliar with the Input/Output Wizard, so that's two strikes against me.

With that said, the first thing I would try would be to update the destination component in the package (i do not know if this is exposed through the wizard - i assume it is not) to turn off fast load. This will slow things down quite a bit as each row will be inserted into the destination database one by one, but it might give you what you need.

Perhaps someone else has more experience with this problem than I...

|||Hi Mathew,

Actually I have to run a job for which it has to import csv data file to table. CSV has duplicate records. My job should not import duplicate records, it should append only actual records. If I set primary key & disabled allow null option. After this when I run the job, job is not even appending actual records (which is not duplicated), job is throwing error which is not importing any data from csv file.
Please suggest me to solve this issue.

Thanks in advance
Karna|||Hi Mathew,

Actually I have to run a job for which it has to import csv data file to table. CSV has duplicate records. My job should not import duplicate records, it should append only actual records. If I set primary key & disabled allow null option. After this when I run the job, job is not even appending actual records (which is not duplicated), job is throwing error which is not importing any data from csv file.
Please suggest me to solve this issue.

Thanks in advance
Karna|||

Karna,

I think you best option use the error output in the destination component to redirect the errors. If you don't change the default value of the error configuration; then the package will fail as soon as the 1st duplicate hit the destination table. This is nothing diffrent from what Matthew has already suggested.

|||Hi,

Thanks for reply. My problem is I need to import CSV data file to one of the table in the database. During importing it shouldn't import null rows & same rows to the table. The method which should checks the data in the table before importing, if data exists it shouldn't import any data else it should. Please suggest me to solve this problem.

Thanks in advance
Karna|||

See this link for a number of different ways to see if a row exists:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1211340&SiteID=1