Is it possible to recieve a notification when a subscription fails?

Is it possible for me to receive an email notification from SSRS if one of my report data-driven subscriptions fail?

Status of this memo
This document is an Internet-Draft. Internet-Drafts are working documents of the Internet Engineering Task Force (IETF), its areas, and its working groups. Note that other groups may also distribute working documents as Internet-Drafts.

Internet-Drafts are draft documents valid for a maximum of six months and may be updated, replaced, or made obsolete by other documents at any time.It is inappropriate to use Internet-Drafts as reference material or to cite them other than as "work in progress".

To learn the current status of any Internet-Draft, please check the "1id-abstracts.txt" listing contained in the Internet-Drafts Shadow Directories on ftp.is.co.za (Africa), nic.nordu.net (Europe), munnari.oz.au (Pacific Rim), ftp.ietf.org (US East Coast), or ftp.isi.edu (US West Coast).

Distribution of this document is unlimited. Please send comments to theHTTP working group at . Discussions of theworking group are archived at .

Abstract
This specification defines an HTTP notification architecture that transmits notifications between HTTP resources. An HTTP resource could be any object which might need to send or receive a notification, for example a distribution list, buddy list, print job, etc.

Is it possible to fire a WinForms app from SSRS?

Heya,

Imagine I've got a report with an 'Edit' button to the right of each record.

When the button gets clicked, I'd like to fire a WinForms app on the remote computer.

Is this possible? I'm thinking that I'd have to use the ReportViewer control, but I'm not sure...

Thanks for the insight.

Justin

One way you can accomplish this is to add hyperlink navigation to your "Edit" textbox. It can call a web page and pass in information identifying the data the user wants to edit. You can then either edit that information on a web page and redirect back to a refreshed view of the report. If you want a WinForms app, you can have that web page fire off a .net application (like we do with Report Builder), an embedded activex control, or an external application.

Thanks, Donovan.

Is it possible to dynamically create columns in a table in SSRS

Hi,

I have a sproc that returns somevalues and everything is working fine... and in my reports i am assigning the header data (in a detail column) based on the some feilds in the sproc... and there around 20 feilds that i want to show... but at a given time i am pretty sure that there wont be more than 10 fields that will have data.

So is it possible that show only the columns that have data in it and sometimes if there is less that 5 - 6 fields.. i want to realign the widths of the column in those tables without shrinking the size of the Table...

any help is appreciated..

Regards

Karen

Hi,

So is it possible that show only the columns that have data in it and sometimes if there is less that 5 - 6 fields.. i want to realign the widths of the column in those tables without shrinking the size of the Table...

If there's no record in one of your row, you can use =IsNothing(Fields!productname.Value) filter your record. But if you want to hide the column that has no data, I suggest you to handle these works in your data accessing modular. For example, if you check one of your column is empty, just remove the column in your record set, so the column would not show in the report.

Thanks.

|||

Jin,

Thanks for your response.. what do u mean by remove the column from the recordset... cause i am populating the Reports using a stored procedure and sometimes... there may be some data or not..

Can u pls give me code snipet or an example

Regards

Karen

|||

Hi,

if you check one of your column is empty, just remove the column in your record set, so the column would not show in the report.

Here's the sample code, suppose you have two fields, Sp and Hd. If there's no data in Hd field of your return set, then only Sp field would been selected.

DECLARE @.NULLCOUNTINTSELECT @.NULLCOUNT =COUNT(*)FROM MatrixCapitalWHERE MatrixCapital.Spisnot nullif @.NULLCOUNT=0BEGIN SELECT MatrixCapital.HdFROM MatrixCapitalEND ELSEBEGIN SELECT MatrixCapital.Hd,MatrixCapital.SpFROM MatrixCapitalEND

Thanks.|||

Jin,

Thanks a lot for your answer so this mean that if i have more 5 - 6 columns NULL... i have check for each column in the NULL count and then prob union for each feild so that my end resultset will be columns that has data in them?

I have another question too.. if i have a table variable like

Declare @.tbl table

(

tblid int indentity(1,1),

Col 1,

Col 2,

..,

Col n

)

Is it possible to have a variable column size depending on the number of entries in my select column like for example.. my if i have 10 columns in my select statement and in that 5 are null... so can just insert 5 rows to the table and then remove the remaining columns out.

Regards

Karen

|||

Hi,

i have check for each column in the NULL count and then prob union for each feild so that my end resultset will be columns that has data in them?

Yes, that's right.

Is it possible to have a variable column size depending on the number of entries in my select column like for example..

Based on my knowledge, another way i can see is to use CASE WHEN clause in your SQL, but it still requires you to give differrent sql statments accoring to the "isNUll" result of a column.

Thanks.

sql

Is it possible to create reports in SSRS 2005 by mining data in SQL Server 2000

All,

I have found a lot of comments on the net but nowhere was I able to have a direct answer to this question:
My client has a complex database deployed on SQL Server 2000. He wishes to create reports based on this data using SSRS. Another division of the same company just implemented SQL Server 2005 and SSRS 2005.
I wish to know if SSRS 2005 is able to create reports based on data from SQL Server 2000?

Thank you.
S
Sure. You'll have no problems reporting against 2005 and 2000 together...

Is it possible to create a cover page in SSRS 2005?

Very simply, I need to add a cover page to my SSRS 2005 report. I've tried this using the Page Header region, but the cover page will not show up on Preview or Export. How and where do I create a cover page?

Hi, Bibble,

Whatever you place first on the Report Design surface (the dotted white area), renders first. So try adding a rectangle which will act as a container, put whatever you want in the rectangle, and set a page break at the end of the rectangle.

==========================================================

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

is Crystal XI easier than SQL Reporting - 2005?

Is Crystal XI easier to use and manage than SQL Reporting 2005 (SSRS)? Also
is the print quality of Crystal XI better than SQL Reporting? (SSRS)
if I have to make a Sales Invoice, which will be better SQL Reporting or
Crystal?
Does Crystal have a BI Tool like SQL has SQL Reporting for MIS Graphs / Pie
charts etc?
Regards,
Akshay.Interesting. You are asking a newsgroup that supports SQL Reporting Servies
and you want them to tell you another product is easier and better.
"iweb" wrote:
> Is Crystal XI easier to use and manage than SQL Reporting 2005 (SSRS)? Also
> is the print quality of Crystal XI better than SQL Reporting? (SSRS)
> if I have to make a Sales Invoice, which will be better SQL Reporting or
> Crystal?
> Does Crystal have a BI Tool like SQL has SQL Reporting for MIS Graphs / Pie
> charts etc?
> Regards,
> Akshay.
>|||easy answer, crystal does some stuff easier, SQL Reporting does other stuff
easier... after using both for years... they both have pluses and minuses...
neither is exactly easier then the other, but each does a set of tasks
easier then the other
"iweb" <iweb@.discussions.microsoft.com> wrote in message
news:B9B9B74D-0098-4C46-BBC8-EFF34886F7B8@.microsoft.com...
> Is Crystal XI easier to use and manage than SQL Reporting 2005 (SSRS)?
> Also
> is the print quality of Crystal XI better than SQL Reporting? (SSRS)
> if I have to make a Sales Invoice, which will be better SQL Reporting or
> Crystal?
> Does Crystal have a BI Tool like SQL has SQL Reporting for MIS Graphs /
> Pie
> charts etc?
> Regards,
> Akshay.
>|||My reading says: For making a printable and user friendly Sales Invoice or
financial statement Crystal XI seems better.
BUT for an easy MIS, Tabular / Columnar / Dashboard and graphical reports
SQL Reporting seems a better opotion.
Am I correct? If not pls correct me and guide me too.
Regards,
Akshay.
"Smokey Grindel" wrote:
> easy answer, crystal does some stuff easier, SQL Reporting does other stuff
> easier... after using both for years... they both have pluses and minuses...
> neither is exactly easier then the other, but each does a set of tasks
> easier then the other
>
> "iweb" <iweb@.discussions.microsoft.com> wrote in message
> news:B9B9B74D-0098-4C46-BBC8-EFF34886F7B8@.microsoft.com...
> > Is Crystal XI easier to use and manage than SQL Reporting 2005 (SSRS)?
> > Also
> > is the print quality of Crystal XI better than SQL Reporting? (SSRS)
> >
> > if I have to make a Sales Invoice, which will be better SQL Reporting or
> > Crystal?
> >
> > Does Crystal have a BI Tool like SQL has SQL Reporting for MIS Graphs /
> > Pie
> > charts etc?
> >
> > Regards,
> > Akshay.
> >
>
>|||On Mar 19, 2:25 am, iweb <i...@.discussions.microsoft.com> wrote:
> My reading says: For making a printable and user friendly Sales Invoice or
> financial statement Crystal XI seems better.
> BUT for an easy MIS, Tabular / Columnar / Dashboard and graphical reports
> SQL Reporting seems a better opotion.
> Am I correct? If not pls correct me and guide me too.
> Regards,
> Akshay.
> "Smokey Grindel" wrote:
> > easy answer, crystal does some stuff easier, SQL Reporting does other stuff
> > easier... after using both for years... they both have pluses and minuses...
> > neither is exactly easier then the other, but each does a set of tasks
> > easier then the other
> > "iweb" <i...@.discussions.microsoft.com> wrote in message
> >news:B9B9B74D-0098-4C46-BBC8-EFF34886F7B8@.microsoft.com...
> > > Is Crystal XI easier to use and manage than SQL Reporting 2005 (SSRS)?
> > > Also
> > > is the print quality of Crystal XI better than SQL Reporting? (SSRS)
> > > if I have to make a Sales Invoice, which will be better SQL Reporting or
> > > Crystal?
> > > Does Crystal have a BI Tool like SQL has SQL Reporting for MIS Graphs /
> > > Pie
> > > charts etc?
> > > Regards,
> > > Akshay.
Just a few comparisons. Crystal Reports has been around a lot longer
than SQL Server Reporting Services, so it is a bit more 'seasoned,' if
you will. That said, if you don't have or need a web server (i.e.,
IIS), then Crystal Reports would be better suited for your needs.
Crystal Reports XI seems to have a larger footprint than SQL Server
Reporting Services 2005 (takes up more hard drive space). The main
differences are in the GUI tools, exporting options and licensing. The
GUI tools look quite different. Crystal Reports XI has both a
completely separate GUI tool and has been integrated w/Visual Studio
2005 (though it is limited somewhat). SQL Server Reporting Services
2005 is part of the Business Intelligence Development Environment (or
full version of Visual Studio 2005). If you have a licensed version of
SQL Server, Reporting Services comes free of charge on the
processor(s) that the SQL Server is licensed on. Crystal Reports XI's
license costs around $750 or so. SQL Server Reporting Services 2005
reports export to Excel, XML, PDF, CSV, Web archive (mhtml) and Tiff.
Crystal Reports XI does not export to XML or Web archive; but it
exports to Word (which SSRS 2005 does not). So it really depends on
your specific needs and the minor differences between the two. Hope
this was helpful.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||Hi,
Thanks for yr detailed analysis. Was useful and better than the earlier ones
:-)
Now coming to my specific needs, what I see missing in Crystal XI is the
drag drop feature which we have in SQL Reporting to make easy and quick MIS.
In Crystal still we need to set the object, check and then finalize on the
same. I hope u got me? Drag drop and real time connectivity to Database seems
missing in Crystal - right'
Secondly, we make views first and then the Crystal design. In Crystal
reporting do we have to make the views or since its directly connects to the
database, once we drag drop tables into the templates, the views are auto
created?
Please guide and on your personal take - Would u make a Sales Invoice in
Crystal XI or SQL Reporting? especially when the customer will print and send
it to his customers / suppliers.
I understand for a BI and Bar charts / pie charts, real time Dashboard and
stuff SQL Reporting will be better as we need to take a BI License for
Crystal which all customers will not pay for.
Pls inform.
Akshay.
"EMartinez" wrote:
> On Mar 19, 2:25 am, iweb <i...@.discussions.microsoft.com> wrote:
> > My reading says: For making a printable and user friendly Sales Invoice or
> > financial statement Crystal XI seems better.
> >
> > BUT for an easy MIS, Tabular / Columnar / Dashboard and graphical reports
> > SQL Reporting seems a better opotion.
> >
> > Am I correct? If not pls correct me and guide me too.
> >
> > Regards,
> > Akshay.
> >
> > "Smokey Grindel" wrote:
> > > easy answer, crystal does some stuff easier, SQL Reporting does other stuff
> > > easier... after using both for years... they both have pluses and minuses...
> > > neither is exactly easier then the other, but each does a set of tasks
> > > easier then the other
> >
> > > "iweb" <i...@.discussions.microsoft.com> wrote in message
> > >news:B9B9B74D-0098-4C46-BBC8-EFF34886F7B8@.microsoft.com...
> > > > Is Crystal XI easier to use and manage than SQL Reporting 2005 (SSRS)?
> > > > Also
> > > > is the print quality of Crystal XI better than SQL Reporting? (SSRS)
> >
> > > > if I have to make a Sales Invoice, which will be better SQL Reporting or
> > > > Crystal?
> >
> > > > Does Crystal have a BI Tool like SQL has SQL Reporting for MIS Graphs /
> > > > Pie
> > > > charts etc?
> >
> > > > Regards,
> > > > Akshay.
> Just a few comparisons. Crystal Reports has been around a lot longer
> than SQL Server Reporting Services, so it is a bit more 'seasoned,' if
> you will. That said, if you don't have or need a web server (i.e.,
> IIS), then Crystal Reports would be better suited for your needs.
> Crystal Reports XI seems to have a larger footprint than SQL Server
> Reporting Services 2005 (takes up more hard drive space). The main
> differences are in the GUI tools, exporting options and licensing. The
> GUI tools look quite different. Crystal Reports XI has both a
> completely separate GUI tool and has been integrated w/Visual Studio
> 2005 (though it is limited somewhat). SQL Server Reporting Services
> 2005 is part of the Business Intelligence Development Environment (or
> full version of Visual Studio 2005). If you have a licensed version of
> SQL Server, Reporting Services comes free of charge on the
> processor(s) that the SQL Server is licensed on. Crystal Reports XI's
> license costs around $750 or so. SQL Server Reporting Services 2005
> reports export to Excel, XML, PDF, CSV, Web archive (mhtml) and Tiff.
> Crystal Reports XI does not export to XML or Web archive; but it
> exports to Word (which SSRS 2005 does not). So it really depends on
> your specific needs and the minor differences between the two. Hope
> this was helpful.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>