Thursday, March 22, 2012
Book recommendation
I am not sure which book to buy: Hitchhiker's Guide to SQL Server 2000
Reporting Services
or
Professional SQL Server Reporting Services -- by Paul Turley
I need a book that will also show me for example how to pass parameters from
asp.net to rss. I want the user to select parameters from asp.net and pass
those parameters to the stored procedure in the report.
ThanksI use the Wrox book (as you mentioned) and also SQL Reporting Services Step
by Step - by Microsoft. Both deal, in depth, with design, deployment and
server administration.
Depending on how you want the report to open from your aspx page, you can
simply use the URL for the RS report, and pass the parameters in that (that's
how RS does it), to open the report only, without any fuss. I also use
buttons on my ASP pages to render the report in PDF/Excel etc immediately
without having the user required to 'export' it themselves.
Tony
"collie" wrote:
> Hi,
> I am not sure which book to buy: Hitchhiker's Guide to SQL Server 2000
> Reporting Services
> or
> Professional SQL Server Reporting Services -- by Paul Turley
> I need a book that will also show me for example how to pass parameters from
> asp.net to rss. I want the user to select parameters from asp.net and pass
> those parameters to the stored procedure in the report.
> Thanks
Book question: Professional SQL Server Reporting Services
working my way through the WROX book: Professional SQL Server Reporting
Services by Turley et. al. Is this the best forum to ask questions about the
book in general and issues with walk-through examples? If it is, I am having
problems with the example that concludes on page 112. This involves
cascading parameters.
Everything works on the dataset definitions. If I run the Stores_BY_City
dataset and select AZ/Phoenix I do indeed see the 3 stores in Phoenix (437,
473, and 475). When I preview the report the parameter drop down lists work
as expected. However, the reporting fields in the preview are blank. The
labels show fine. Any suggestion on how to debug? Thank you, BobBob
Please send me you RDL file so I can see what's going on.
(nospam@.scout-master..com (fix the addess))
Paul Turley
"Robert Schuldenfrei" <RobertSchuldenfrei@.discussions.microsoft.com> wrote in message news:<1D76AEFA-7FA7-431B-9433-8D334D438FB8@.microsoft.com>...
> I am fairly new to SQL Server and very new to Reporting Services. I am
> working my way through the WROX book: Professional SQL Server Reporting
> Services by Turley et. al. Is this the best forum to ask questions about the
> book in general and issues with walk-through examples? If it is, I am having
> problems with the example that concludes on page 112. This involves
> cascading parameters.
> Everything works on the dataset definitions. If I run the Stores_BY_City
> dataset and select AZ/Phoenix I do indeed see the 3 stores in Phoenix (437,
> 473, and 475). When I preview the report the parameter drop down lists work
> as expected. However, the reporting fields in the preview are blank. The
> labels show fine. Any suggestion on how to debug? Thank you, Bob
Tuesday, March 20, 2012
book
It seems that there are only two books on SSIS
The Rational Guide to Scripting SQL Server 2005 - BETA preview
Professional SQL Server 2005 Integration Services by wrox
Has anyone read these or any other ones out there?
Any thoughts on which to get?
I am very new to SSIS.
Thanks
hi,
I don't believe it. Only two?
I'd like to acquire Wrox book. I had one about .Net and it was awesome
|||I refer you to your previous post in which you asked the same question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=425223&SiteID=1
-Jamie
|||Hi, Just thought the other post was getting old.
Problem solved.
Thanks
|||i have both books and find each to be helpful.|||fmardani wrote:
It seems that there are only two books on SSIS
The Rational Guide to Scripting SQL Server 2005 - BETA preview
Professional SQL Server 2005 Integration Services by wrox
Has anyone read these or any other ones out there?
Any thoughts on which to get?
I am very new to SSIS.
Thanks
What is the difference between the two?
Isn't the one with the relational guide... title for the beta? if so isn't it different to the final release version?
Thanks
|||As is stated in the other thread (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=425223&SiteID=1) there is another version coming out soon for RTM.
-Jamie